qq_43535970的博客

Mysql及Oracle数据库导出数据表结构废话不多说，直接上代码MySQLselect distinctcolumn_comment AS "字段名称",column_name AS "名称",DATA_TYPE AS "字段数据类型",case IS_NULLABLE when "YES" then "否" ELSE "是" END "必填",ifnull(CHARACTER_MAXIMUM_LENGTH,0) "值域",column_comment AS "备注"from inf

Oracle数据库，增删改查，建表，删表1、建表--新建学生表create table Student( Id number primary key , Name varchar(20) not null, sex varchar(2) not null)comment on table Student is '学生信息'comment on column Student.id is 'ID';comment on column Student.name is '姓名';co