1、默认约束区别：mysql里面DEFAULT关键字后面是不用加括号的--sqlserverCREATE TABLE emp(id INT DEFAULT(12))--mysqlCREATE TABLE emp(id INT DEFAULT 12)2、设置自增列区别很大，不过好像mysql的自增列不能设置步...
1、变量赋值MYsql：SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shopMSsql：SELECT @min_price=MIN(price),@max_price=MAX(price) FROM shop2、一次写入多行mysql插入多行支持这样写 insert into ta...
mssql中：
delete from test where id=1 与 delete test where id=1是一样的
mysql中：
只能用delete from test where id =1
否则：
You have an error in your SQL syntax; check the manual that corres...
