![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
qq_27449993
天理难容
展开
-
mysql删除为null的数据
DELETE FROM USER WHERE birthday IS NULL;原创 2018-12-21 11:18:28 · 9297 阅读 · 0 评论 -
mysql基础
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...原创 2018-12-24 14:13:23 · 112 阅读 · 0 评论 -
MySQL函数
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...原创 2018-12-24 14:20:17 · 163 阅读 · 0 评论 -
MySQL基础2
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 '出版...原创 2018-12-24 14:21:40 · 123 阅读 · 0 评论 -
MysQL inner join
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 ...原创 2018-12-24 17:43:15 · 4341 阅读 · 0 评论