MySQL 第一課

最新推荐文章于 2024-09-14 08:15:15 发布

starluck

最新推荐文章于 2024-09-14 08:15:15 发布

阅读量582

点赞数

分类专栏： MySQL 文章标签： mysql database object date null table

本文链接：https://blog.csdn.net/starluck/article/details/3713104

版权

MySQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

 
   MySQL                                                     MSSQL
  show Tables                               select * from sysobjects where xtype = 'U'
 describe tableName                     select * from syscolumns where id = object_ID(TableName)
 show index from  tablename         select * from sysindex where id = object_ID(tableName)
   AUTO_INCREMENT              identity 
   now()                                        getdate()
  current_date()                            getdate()
   version()                                    @@Version
  START TRANSACTION         begin Transaction
 Commit                                      Commit
  row_count()                               @@RowCount
 

MYSQL 支持事務點

SAVEPOINT identifier

ROLLBACK [WORK] TO SAVEPOINT identifier

RELEASE SAVEPOINT identifier

drop database if exists school; //如果存在SCHOOL则删除 
create database school; //建立库SCHOOL 
use school; //打开库SCHOOL 
create table teacher //建立表TEACHER 
( 
id int(3) auto_increment not null primary key, 
name char(10) not null, 
address varchar(50) default '深圳', 
year date 
);