Li Wu:
Heng Learn to think together, honouring teachers save Thanksgiving. Leaf See root three return to one, rivers the same oneness.
Meekness Conscience Lord, willing to do without regrets to the most bitter. Reading exercises to keep the body and mind, sincere advice and the line and cherish.
Data,
data, Lingen on the data. You must be cautious about operating the database. Give the most bitter code here, and take a look at it, to have your own judgment. Meet the choice, or ashamed to ask.
mysql:5.5
Os:windows7 x64
Delete a table's code and effects
Mysql>show tables;+--------------------+|Tables_in_newbases|+--------------------+|Student|+--------------------+1Rowinch Set(0.00sec) MySQL> Drop Tablestudent; Query OK,0Rows Affected (0.07sec) MySQL>Show tables; EmptySet(0.00sec) MySQL>
Remove code and effects from multiple tables
Mysql>show tables;+--------------------+|Tables_in_newbases|+--------------------+|Myt1||Myt2|+--------------------+2Rowsinch Set(0.00sec) MySQL> Drop Tablemyt1,myt2; Query OK,0Rows Affected (0.10sec) MySQL>Show tables; EmptySet(0.00sec) MySQL>
MySQL, relational database management system, excellent, worth learning.
Learning resources: Itcast and Itheima video library + Pure Heart.
If you have public resources, can share to me, with your resources to learn also can.
Blog post is to watch the video, into thinking written. It's good that the teacher speaks well. Blog bad, is to give the most bitter not serious.
mysql5.5 Base DROP Table ... Delete a table or multiple tables