Mysql 语法记忆
-
select ecity from ydt where LENGTH(ecity)>12;
查询长度小于**的信息 -
update ydt set ecity = substring_index(ecity, ’ ', 1);
更新表中内容
(concat,replace,substring, substring_index)
update ydt set ecity = replace(ecity, ‘-’, ’ ');
sql异常
Every derived table must have its own alias
在做多表查询,或者查询的时候产生新的表的时候会出现这个错误:Every derived table must have its own alias(每一个派生出来的表都必须有一个自己的别名)