1、SET SQL_SAFE_UPDATES=0; 经常update的时候报错,Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect. 加入这一条命令就解决了
2、lower('LEW'); 有时候需要将字符串变为小写,这一个命令就解决了
3、给有数据的table加入新的一列并自增, ALTER TABLE `ta`
ADD COLUMN `id` INT(11) NOT NULL AUTO_INCREMENT ,
ADD PRIMARY KEY (`id`);