练手的mysql_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