青阳的博客

DELETE FROM USER WHERE birthday IS NULL; 

CREATE DATABASE dt55_mysql CHARACTER SET utf8;USE dt55_mysql;CREATE TABLE students( id INT, stuName VARCHAR(40), age INT, weight FLOAT);#同时往students表中插入3条数据记录 INSERT INTO st...

DROP TABLE book;#给表中的某一字段添加注释：使用comment属性，comment关键字跟在字段的最后面CREATE TABLE Book(    B_ID INT COMMENT '图书编号',    B_NAME VARCHAR(20) COMMENT '图书名称',    P_ID INT(20) COMMENT '出版社编号',    B_AUTHOR VA...

CREATE TABLE publisher(    P_ID BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '出版社编号',    P_NAME VARCHAR(20) NOT NULL UNIQUE COMMENT '出版社名称',    p_LINKMAN VARCHAR(20) NOT NULL COMMENT '出版...

CREATE DATABASE dt55_homework CHARACTER SET utf8;USE dt55_homework;CREATE TABLE publisher(    P_ID BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '出版社编号',    P_NAME VARCHAR(20) UNIQUE NOT ...