Sunday, 15 March 2015

mysql - SQL syntax error in phpmyadmin -



mysql - SQL syntax error in phpmyadmin -

sorry asking noob qeustion. beginner php, phpmyadmin , mysql. creating little cms school assignment , tried piece of sql code in phpmyadmin:

insert subjects ( menu_name, position, visible ) values ( '{test item}', {4}, {1} )

but doesn't work. tells me:

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax utilize near '4}, {1} )' @ line 4.

could please explain me doing wrong. give thanks guys in advance.

(plus apologize if have lot of grammar mistakes in text. english language isn't great.)

why adding braces? should work:

insert subjects ( menu_name, position, visible ) values ( 'test item', 4, 1 )

mysql sql phpmyadmin

No comments:

Post a Comment