《MySQL数据库应用》--实验训练1：在MySQL中创建数据库和表

【实验1-2】创建“汽车用品网上商城系统”数据库mysqlshowdatabases;hDatabaseinformation_schemamysqlperformance_schemastudenttest5rowsinset

0.00secmysqlcreatedatabaseshopping;QueryOK1rowaffected

0.00secmysqlshowdatabases;Databaseinformation_schemamysqlperformance_schemashoppingstudenttest6rowsinset

0.00sec【实验1-3］在Shopping数据库下，参见

3.5节，创建表3-4〜表371的八个表【实验1-4】使用SHOW、DESCRIBE语句查看表Tables_in_shopping►autopartscategoryclientclientkindcommentorderorder_has_autopartsshoppingcart【实验1-5】使用ALTERTABLE.RENAMETABLE语句管理表|hysqlaltertableqwerenameasd;QueryOK0rowsaffected

0.01secmysqlshowtables;1++Tables_in_shopping++asdautopartscategoryclientclientkindcommentorder_has_autopartsshoppingcart|8rowsinset

0.00sec【实验1-6】使用DROPTABLE语句删除表，也可以使用MySQLWorkbench删除表mysqlshowtables;

1.ITables_in_shopping++asdautopartscategoryclientclientkindcommentorder_has_autopartsorderashoppingcart++9rowsinset

0.00secmysqldroptableasd;QueryOK0rowsaffected

0.00secmysqlshowtables;++ITables_in_shopping++autopartscategoryclientclientkindcommentorder_has_autopartsorderashoppingcart++8rowsinset

0.00sec【实验1-7】连接、断开MySQL服务器，启动、停止MySQL服务器*无标题©shoppingmysql-查询-NavicatPremiumLTERTABLEasdcopyRENAMEOrdera;打开数据库新期据库…命令列介面…却SQL文件…数据传揄励新管理组颜色打开设置位置…刷新息…信息柢况状态【实验1・8】使用SHOWDATABASE、USEDATABASE.DROPDATABASE语句管理网上商城系统Shopping数据库■mysqlshowdatabases;|+；+.Database1++.information_schema|.mysqlI.performance_schema.shopping.student.test.++.6rowsinset

0.00secmysqldropdatabasetest;QueryOK0rowsaffected

0.00sec名建长度不是nullApidint1100PApnametinytext00image_link1varchar500□image_link2varchar500□image_link3varchar500□Introductiointext00□is_salebit10□old_priceint110□Priceint110□Weightint110□is_generalbit10□virtual_inventoryint2550□►Inventoryint2550□productive_yeardatetime00□shelve_atedatetime00□hot_productint110□SecondClass_scidint2550□Brandtinytext00□]Category_IDint1100QNamechar5000Describetext00□Category_CJDint2550□名型长度不是nullcid■HHint1100Imagevarchar500□Cnamechar5000Passwordchar1000phone_numbervarchar2000Emailvarchar500□Createdmedatetime00□Ckindint110□名艇长度4M不是nullKid■HBint1100Namevarchar5000名型不是nullCommentjdint1100Commentstinytext00□Autoparts_apidint25500Client_cidint110□名型长度不是nullOid■HIint1100Statuschar2000order_datedatetime000Client_cidint2550□goods_pricedecimal520carriage_pricedecimal520total_pricedecimal520total_weightint110□DistributionType_dpidvarchar500□courier_numbervarchar500□ReDistributionType_dpidvarchar500□return_courier_numbervarchar500□is_carriage_freeblob00□has_paiedblob00□is_arayacakblob00□Namevarchar5000Telephonevarchar5000Arrivetimedate00□Address_aidtext000pay.typevarchar5000returnpricedecimal52□名长度不是nullQAutopatrs_apidint1100Order_oidint110□deal_pricedecimal520Numberint1100return_numberint110□Timedatetime00□名港长度_|J救点不是nullAutopartsapid■BHint25500Client_c!dint2550□Numberint1100add_timedatetime000服秀（本地）MySQL名称描述状忑启动英型登录为IntelJRPROSeVWirelessS...This...正在…手动本地系统到此®»InternetConnectionSharin...为家…手动（W…本地系统隹导比服努山分寺;比3B身IPHelper侧.正在…自动本地系统♦:「rJ必flRR©IP转换配胃服努配置…手动（11发…本地系统《IPsecPolicyAgentInter...手动（依发...河编・务工:KtmRmforDistributedTra...协调…手动（触发…网络服务Link-LayerTopologyDisco...曲...手动本地服务LocalSessionManager©

3...正在...自动本地系统MessagingServked16810支持...手动（依发…本地系统£.MicrosoftR诊断中心标准...麻.手动本地系统MicrosoftAccountSign-in...却手动触发…本地系统G MicrosoftDefenderAntivir...用助...正在…手动本地取务£MicrosoftDefenderAntivir...帮助…正在…自动本地系统£MicrosoftEdgeElevationS...Keep.”手动本地系统《MicrosoftiSCSIInitiatorSer...ea...手动本地系统工MicrosoftPassport为用…正在…手动（总发…本地系统MicrosoftPassportContainerot...正在…手动（履发…本地狼务GMicrosoftSoftwareShado..«...手动本咻统AMicrosoftStorageSpacesS...Mkr...手动网络服务《MicrosoftStore安装公务为M...正在…手动本地系统CMicrosoftUpdateHealthS...Main...祟用本地系统$.MicrosoftWindewsSMS路...根据…手动（触发-本地税务MySQL.本地系统

1.NetTcpPortSharingServic自碎〉本地服务£Netiogon停止（）本地系统LNetworkConnectedDevic.西停（U）发..本地服务NetworkConnectionBroke恢效（M）本地系统工.NetworkConnections改新启动（E）本地系统0NetworkConnectivityAssis所有任务（K）生…本地系统JNetworkListServiceSil*，a本地服务£NetworkLocationAwareneWlWnr网络服务CNetworkSetupService发…本地系统£NetworkStoreInterfaceSe叫助（H）本地服务OpenSSHAuthenticationr•z4rMM%r本地系统*岫京炫。