SQL (error #1064)
#6

Quote:
Originally Posted by Krokett
Посмотреть сообщение
My guess would be: int is a reserved keyword thus he needed to add quotation marks to int.
That is exactly the problem. However, 'text' is a reserved word as well, that is why the error was right before the 'int'.

As a rule of thumb in MySQL:
Always add backticks to column names and table names and add single quotation marks (apostrophes) to string values.
Reply


Messages In This Thread
SQL (error #1064) - by DaniceMcHarley - 21.07.2015, 18:12
Re: SQL (error #1064) - by DaniceMcHarley - 21.07.2015, 22:01
Re: SQL (error #1064) - by Crystallize - 21.07.2015, 22:03
Re: SQL (error #1064) - by Krokett - 21.07.2015, 22:11
Re: SQL (error #1064) - by Evocator - 22.07.2015, 07:19
Re: SQL (error #1064) - by mamorunl - 22.07.2015, 08:18
Re: SQL (error #1064) - by DaniceMcHarley - 22.07.2015, 13:21

Forum Jump:


Users browsing this thread: 1 Guest(s)