...
View MoreThis is enabled by default, but you can disable it in one of a couple ways. First, verify which mode(s) MYSQL is running with: $ mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';" You'll need to replace root with whatever username has superuser permissions on your server (but, it's usually just root). You'll also be prompted for the password. This will print out something like this (but much prettier): sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_D ...
View MoreALTER TABLE t_dataDROP PRIMARY KEY,ADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,ADD PRIMARY KEY (id); if not a primary key ALTER TABLE t_dataADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,ADD PRIMARY KEY (id); ...
View More
