mysql 有没有自带的 实例表，用作练习

MySQL没有自带供练习用的表。我们可以自行创建或导入数据表进行练习，这其实是很方便的。

例如下面几行代码就完成了数据库和数据表的创建并插入7行数据：

create database test

use test

create table orderproduct(orderid char(11) primary key,productid varchar(255))

insert into orderproduct values

(20161116001,'D0020'),

(20161116035,'E0055'),

(20161101048,'A0035'),

(20161005321,'B0049'),

(20160901515,'C0038'),

(20160814525,'C0038,A0035,E0055'),

(20160714510,'D0020,B0049')

mysql库。存储用户等信息

information_schema。存储表、锁等性能信息

test。mysql自建测试库

performance_schema。互斥锁等信息（5.6之前需要手动开启，从5.6开始默认开启）

columns_privColumn

privilegesdbDatabase

privilegeseventEventsfuncUser

defined

functionsgeneral_logGeneral

loghelp_categoryhelp

categorieshelp_keywordhelp

keywordshelp_relationkeyword-topic

relationhelp_topichelp

topicshostHost

privileges

Merged

with

database

privilegesndb_binlog_indexpluginMySQL

pluginsprocStored

Proceduresprocs_privProcedure

privilegesserversMySQL

Foreign

Servers

tableslow_logSlow

logtables_privTable

privilegestime_zoneTime

zonestime_zone_leap_secondLeap

seconds

information

for

time

zonestime_zone_nameTime

zone

namestime_zone_transitionTime

zone

transitionstime_zone_transition_typeTime

zone

transition

typesuserUsers

and

global

privileges

对我有用[0]丢个板砖[0]引用举报管理TOPhuazb4815(huazb4815)等

级：

---