随笔分类 -  Mysql

摘要：一、基础1、说明：创建数据库CREATE DATABASE database-name2、说明：删除数据库drop database dbname3、说明：备份sql server---创建 备份数据的deviceUSE masterEXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'--- 开始 备份BACKUP DATABASE pubs TO testBack4、说明：创建新表create table tabname(col1 type1 [not 阅读全文

摘要：表中添加字段　mysql> alter table leaf add leaf_pri int(5);Query OK, 4 rows affected (0.06 sec)Records: 4 Duplicates: 0 Warnings: 0mysql> select * from leaf;+---------+-----------+----------+----------+----------+------------+----------+| leaf_id | leaf_name | leaf_age | leaf_sal | leaf_sex | leaf_bir 阅读全文

摘要：启动mysql运行到安装目录C:\Program Files\MySQL\MySQL Server 5.6\bin>输入mysqld.exe –install得到结果Service successfully installed输入net start mysql //启动mysqlnet stop mysql //关闭mysql用户成功登录Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 8Server version: 5.6.10 MySQL Community Ser 阅读全文