mysql table bug
#1

Code:
[10:55:09] CMySQLHandler::Query(DELETE FROM `vehiclesdata` WHERE `vID` = 1) - An error has occured. (Error ID: 1146, Table 'test.vehiclesdata' doesn't exist)
Corectly are write, that delete from `vehiclesdata`
but why i've got this error
An error has occured. (Error ID: 1146, Table 'test.vehiclesdata' doesn't exist)
Although in query are write that `vehiclesdata` not a 'test.vehiclesdata'
Reply
#2

Well, then it's probably not that query. What other queries do you have?
Reply
#3

one query (global) alright i try to change it
Reply
#4

table name is case sensitive. Make sure you have named it properly.

Or Run this Query

REPAIR TABLE vehiclesdata;


Quote:
Originally Posted by belhot1992
View Post
Test writing your query like this:
"DELETE FROM `vehiclesdata` WHERE `vID` = '1';"
You can directly access the INTEGER in SQL, only String with variable character requires ''.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)