个人日记-数据库简单操作
来源:互联网 发布:乡村爱情 知乎 编辑:程序博客网 时间:2024/06/06 02:24
use mldn; //使用数据库
//创建数据库表
CREATE TABLE mytab(
id INTAUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30)NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL,
birthday DATE NOT NULL
)
DROP TABLE mytab;
//查看您数据库
DESC mytab;
show databases;
show tables;
CREATE TABLE user(
id INTAUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30)NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL,
birthday DATE NOT NULL
)
INSERT INTO user(name,password,age,sex,birthday) VALUES ('赵强','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('卞银燕','zhaoqiang',28,'女','1989-12-12');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('张三','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('李四','zhaoqiang',28,'女','1989-12-12');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('王五','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('赵启','zhaoqiang',28,'女','1989-12-12');
DELETE FROM user WHERE id=3 ;
UPDATE user SET name='MLDN',age=5,birthday='2000-08-27' WHERE id=4 ;
SELECT name,birthday FROM user ;
SELECT * FROM user WHERE name LIKE '%赵%' OR password LIKE '%m%' ;
SELECT * FROM user WHERE name LIKE '%m%' OR password LIKE '%m%' LIMIT 10,5 ;
//创建数据库表
CREATE TABLE mytab(
id INTAUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30)NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL,
birthday DATE NOT NULL
)
DROP TABLE mytab;
//查看您数据库
DESC mytab;
show databases;
show tables;
CREATE TABLE user(
id INTAUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30)NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL,
birthday DATE NOT NULL
)
INSERT INTO user(name,password,age,sex,birthday) VALUES ('赵强','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('卞银燕','zhaoqiang',28,'女','1989-12-12');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('张三','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('李四','zhaoqiang',28,'女','1989-12-12');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('王五','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('赵启','zhaoqiang',28,'女','1989-12-12');
DELETE FROM user WHERE id=3 ;
UPDATE user SET name='MLDN',age=5,birthday='2000-08-27' WHERE id=4 ;
SELECT name,birthday FROM user ;
SELECT * FROM user WHERE name LIKE '%赵%' OR password LIKE '%m%' ;
SELECT * FROM user WHERE name LIKE '%m%' OR password LIKE '%m%' LIMIT 10,5 ;
0 0
- 个人日记-数据库简单操作
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 个人日记
- 【个人日记】
- 个人日记
- 个人日记
- 简单的数据库操作:
- Mysql数据库简单操作
- swift简介
- 读《50 Android Hacks》笔记整理Hack 24~Hack 30
- 线段树变形 568,1012
- iOS开发-Launch Image和Launch Screen
- Java程序员应当知道的10个面向对象设计原则
- 个人日记-数据库简单操作
- 高速USB 2.0的CMSIS-DAP调试器:CMSIS-DAP正确打开方式(3月18日更新速度和稳定性)
- stm32之GPIO
- P1059 积木城堡
- c函数va_list可变参数原理
- free 命令结果完全剖析
- AM3359 U-Boot
- jquery插件源码function加!是什么意思?
- 数据结构实验之查找二:平衡二叉树