MySQL的基本语句

MySQL的基本语句 简单易懂很实用，--1、连接到master数据库上 use master; --2、删除数据库dwl drop database dwl; --3、建立数据库dwl create database dwl on primary (name = 'dwl_data',filename = 'e:\database\dwl_data.mdf',size = 3mb,filegrowth = 2mb), (name = 'dwl_data1',filename = 'e:\database\dwl_data1.ndf',size = 3mb,filegrowth = 2mb) log on (name = 'dwl_log',filename = 'e:\database\dwl_log.ldf',size = 3mb,filegrowth = 2mb), (name = 'dwl_log1',filename = 'e:\database\dwl_log1.ldf',size = 3mb,filegrowth = 2mb) ---4、查询数据库的内容 sp_helpdb dwl ---5、增加数据库中数据文件的大小 alter database dwl modify file (name = dwl_data,filename = 'd:\database\dwl_data.mdf',size = 5mb,maxsize = 15mb);