mysql小白练手

mysql小白训练素材，建库建表，增删改查，多敲多练。


mysql> show databases;
mysql> create database python3 charset=utf8;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
mysql> use python3;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> create table students( id int auto_increment primary key not null, name varchar(10) not null, gender bit default 1, birthday datetime);
Query OK, 0 rows affected (0.06 sec)

mysql> show tables;

mysql> desc students;
mysql> alter table students add isdelete bit default 0;
mysql> show create table students;
mysql> rename table students to stu;
mysql> insert into students values(0,'郭靖',1,'1990-1-1',0);
mysql> select * from students;
mysql> insert into students(name) values('黄蓉');
mysql> insert into students(name,gender) values('小龙女',0);
mysql> insert into students(name) values('杨过'),('雕'),('张三丰');
mysql> update students set birthday='1992-0-2' where id=4;
mysql> delete from students where id =5;
mysql> update students set isdelete=1 where id=6;
备份数据库：
[root@zjf ~]# mysqldump -uroot -p python3 > bak.sql
恢复：
[root@zjf ~]# mysql -uroot -p zfl < bak.sql

转载于:https://blog.51cto.com/jingfeng/2092630