hive sql语法大全,mysql内连接和外连接的区别
1 .自我增值设置MySQL:idintprimarykeyauto _ increment SQL server:idintprimarykeyidentity (1,1 )/identity (1,1 ) :是1还是1 sp_help表名或sp_columns表名3 .检查前几个MySQL。 select*fromstudentlimit10; SQL服务器: select top 10 * from student; 4 .更改当前时间MySQL:now(SQLserver:getdate )5.字段的数据类型MySQL:altertabletest2modifyidbigint; SQL server:altertableempaltercolumn [ id ] bigint6.处理枚举字段MySQL:sexe num (‘female’) not null default‘male’SQL server sqlserver:SELECT name,database_id,create_date FROM sys.databases; select * fromsysobjectswherextype=‘u’;