Re: Incorrect use of DEFAULT NULL?

[Peter Brawley]

> insert into log set timestamp=1483766635, user_id=114, machine_id=60, usage=0;

Another error in your Create Table code. `Usage` is a reserved word. When reserved words are used as database object identifiers, they have to be surrounded by backticks (`). Bad practice. Change the name of that column to an unreserved word.

Notice too an advantage of Insert...Set symtax over Insert...Values(...) syntax: it exposes such errors so they can be corrected early.



Edited 1 time(s). Last edit at 03/29/2018 11:32AM by Peter Brawley.