Friday, 17 June 2016

Reserved word in column name - insert into MySQL

I have a MySQL database with the word "group" in one of the column names.
I can't change this database and column's name; it's not mine.



Table users, columns: id, name, password, group, and other.
I need to insert a record into this table. I tried INSERT INTO users (name, group) VALUES ('John', '9'), but it's not working because of "group".



Can you help me, how to insert a record into this table, please?

No comments:

Post a Comment

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...