mysql
alpha_long
creator
展开
-
MYSQL添加序号列
select (@i:=@i+1) as rank,t.* from tablename as t,(select @i:=0) as it原创 2019-11-13 17:28:26 · 1486 阅读 · 0 评论 -
MYSQL errorCode1045 state 28000
1.密码帐号都是对的,错在配置文件里出现了空格。原创 2019-03-21 10:31:32 · 4608 阅读 · 0 评论 -
[Err] 1327 - Undeclared variable
mysql执行select * into tablename from table2;Undeclared variable错误不能创建表导致,将sql语句改为create table tablename (select * from table2);原创 2019-04-28 12:36:15 · 4370 阅读 · 0 评论