快捷導(dǎo)航

MYSQL單表操作學(xué)習(xí)之DDL、DML及DQL語句示例

更新時間：2024年03月29日 10:23:12 作者：嚕嚕不困o

DML、DDL、DCL和DQL是數(shù)據(jù)庫中常用的四種語言,分別用于數(shù)據(jù)操作、數(shù)據(jù)定義、數(shù)據(jù)控制和數(shù)據(jù)查詢,下面這篇文章主要給大家介紹了關(guān)于MYSQL單表操作學(xué)習(xí)之DDL、DML及DQL語句的相關(guān)資料,需要的朋友可以參考下

1、創(chuàng)建數(shù)據(jù)表——DLL語句

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '編號',
  `ceateDate` datetime DEFAULT NULL COMMENT '創(chuàng)建時間',
  `userName` varchar(20) COLLATE utf8_icelandic_ci DEFAULT NULL COMMENT '姓名',
  `pwd` varchar(36) COLLATE utf8_icelandic_ci DEFAULT NULL COMMENT '密碼',
  `phone` varchar(11) COLLATE utf8_icelandic_ci DEFAULT NULL COMMENT '手機(jī)號',
  `age` tinyint(3) DEFAULT NULL COMMENT '年齡',
  `sex` char(2) COLLATE utf8_icelandic_ci DEFAULT NULL COMMENT '性別',
  `introduce` varchar(255) COLLATE utf8_icelandic_ci DEFAULT NULL COMMENT '簡介',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_icelandic_ci;

2、插入數(shù)據(jù)——DML語句

insert into student values (0,'2022-02-02 10:10:10','葫蘆娃爺爺','123123','1234567690',69,
'男','葫蘆娃爺爺，在穿山甲的幫助下找到了葫蘆籽');
insert into student values (0,'2022-02-02 10:10:10','蛇精','123123','1234566890',66,
'女','那個壞女人，綁架了葫蘆娃');
insert into student values (0,'2022-02-02 10:10:10','蜈蚣精','123123','1234567860',67,
'男','那個壞男人，綁架了葫蘆娃們');
insert into student values (0,'2022-02-02 10:10:10','一娃','123123','1634567890',23,
'男','金剛娃');
insert into student values (0,'2022-02-02 10:10:10','二娃','123123','1236567890',26,
'男','水娃');
insert into student values (0,'2022-02-02 10:10:10','三娃','123123','1234567896',24,
'男','拿個破葫蘆');

insert into student (userName,age,introduce) VALUES('山神',25,'孕育了葫蘆娃兄弟')
select * from student

3、編輯語句——DQL

SELECT userName as '用戶名',age 年齡,sex'性 別',introduce'簡介' from student
where pwd is not 123123;
SELECT distinct sex '性別類型' from student;
SELECT * from student order by userName desc;
SELECT * from student limit 5,3;