mysql小白练手
mysql小白训练素材，建库建表，增删改查，多敲多练。mysql> show databases;
mysql> create database python3
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(> Query OK, 0 rows affected (0.06 sec)
mysql> show tables;
mysql> desc students;
mysql>> 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>
mysql> delete from students where>
mysql> update students set isdelete=1 where> 备份数据库：
# mysqldump -uroot -p python3 > bak.sql
恢复：
# mysql -uroot -p zfl < bak.sql
页:
[1]