1。准备CentOS7与CentOS5的基础配置 2.在两台虚拟机中配置yum。 3.在CentOS7中安装httpd与php，在另一台虚拟机中安装mysqlyum install mysql-server -y service mysqld restart 重启mysql 重启成功 4.将许愿墙网页放入CentOS7的/var/www/html 5.输入 mysql 进入数据库进行管理 6.输入create user ‘kbz‘@‘192.168.100.104‘ identified by ‘146397‘; 给192.168.100.140创建用户，PS。创建的用户只能...
系统结构环境准备$cat /etc/issue Ubuntu 14.04.4 LTS \n \l$uname -r 4.2.0-27-generic[Both] $grep ‘10\|20‘ /etc/hosts 172.16.9.10 eva.suzf.net eva 172.16.9.20 cali.suzf.net calissh互信eva ssh-keygen -t rsa -P ‘‘ ssh-copy-id -i .ssh/id_rsa.pub calicali ssh-keygen -t rsa -P ‘‘ ssh-copy-id -i .ssh/id_rsa.pub evaSelinuxUbuntu 默认没有 安装，跳过sudo service iptables stopCorosync 安装与配置...
对于mysql的复制相同表结构方法，有create table as 和create table like 两种，区别是什么呢？代码如下:create table t2 as select * from t1 where 1=2;as创建出来的t2表（新表）缺少t1表（源表）的索引信息，只有表结构相同，没有索引。代码如下:create table t2 like t1 ;like 创建出来的新表包含源表的完整表结构和索引信息二者的用途：as用来创建相同表结构并复制源表数据like用来创建完整表结构和全部索引oracle支持as，也是...
2017-04-03 19:52:21 7fce976e27e0 InnoDB: Error: unable to create temporary file; errno: 132017-04-03 19:52:21 7918 [ERROR] Plugin ‘InnoDB‘ init function returned error.2017-04-03 19:52:21 7918 [ERROR] Plugin ‘InnoDB‘ registration as a STORAGE ENGINE failed.2017-04-03 19:52:21 7918 [ERROR] Unknown/unsupported storage engine: InnoDB2017-04-03 19:52:21 7918 [ERROR] Aborting2017-04-03 19:52:21 79...
MySQL外键创建条件: 1.两个表必须是InnoDB数据引擎2.外键表的外键字段必须是主键3.字段类型必须一致 创建表时创建外键: create table tbl_client(userName varchar(255) not null, address varchar(255), createDate timestamp not null default now(), createUserName varchar(255), foreign key(createUserName) references tbl_user(userName));Mysql错误问题:ERROR 1005 (HY000): Cant create table crm_1.tbl_client (errno:...
*** Welcome... Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement. /* view databases */ mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | leave_info_system | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.03 sec) /* create new database *...
参考表结构CREATE TABLE `t_baby` ( `baby_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `nickname` varchar(64) DEFAULT NULL, `avatar` varchar(64) DEFAULT ‘‘, `sex` int(2) unsigned NOT NULL DEFAULT ‘0‘ COMMENT ‘0：未知；\\n 1：男；\\n 2：女。‘, `birthday` datetime NOT NULL, `creater` varchar(16) DEFAULT ‘‘, `create_time` timestamp NOT NULL DEFA...
对于MySQL的复制相同表结构方法，有create table as 和create table like 两种，区别是什么呢？ create table t2 as select * from t1 where 1=2;或者 limit 0; as创建出来的t2表（新表）缺少t1表（源表）的索引信息，只有表结构相同，没有索引。 create table t2 like t1 ; like 创建出来的新表包含源表的完整表结构和索引信息。 二者的用途：as用来创建相同表结构并复制源表数据。like用来创建完整表结构和全部索引。 oracle支持...
CREATE TABLE A LIKE B 此种方式在将表B复制到A时候会将表B完整的字段结构和索引复制到表A中来。 CREATE TABLE A AS SELECT x,x,x,xx FROM B LIMIT 0 此种方式只会将表B的字段结构复制到表A中来，但不会复制表B中的索引到表A中来。这种方式比较灵活可以在复制原表表结构的同时指定要复制哪些字段，并且自身复制表也可以根据需要增加字段结构。 两种方式在复制表的时候均不会复制权限对表的设置。比如说原本对表B做了权限设置，...
出处：http://blog.itpub.net/15498/viewspace-2136006/ 由于数据库的升级，今天在执行从MySQL 5.6导出来的SQL文件时报错:mysql> source cms_user.sqlQuery OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected, 1 warning (0.04 sec)ERROR 1067 (42000): Invalid default value for ‘CREATE_TIME‘ERROR 1146 (42S02): Table ‘ixinnuo_zxpt.cms_user‘ doesn‘t exist因为MySQL 5.6以后timestamp设定默认值规则改变，...
mysql> create table t2(2 -> name varchar(9) default ‘hello‘3 -> );4 Query OK, 0 rows affected (0.08 sec)5 6 mysql> desc t2;7 +-------+------------+------+-----+---------+-------+8 | Field | Type | Null | Key | Default | Extra |9 +-------+------------+------+-----+---------+-------+ 10 | name | varchar(9) | YES | | hello | | 11 +-------+------------+------+-----+------...
create table myT1(-> `null` int-> ); Query OK, 0 rows affected (0.08 sec)mysql> desc myt1; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | null | int(11) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql，关系型数据库管理系统...
create database database; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘datab ase‘ at line 1mysql> create database @@@@; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘@@@@‘at lin...
show create database newbases; +----------+-------------------------------------------------------------------+| Database | Create Database |+----------+-------------------------------------------------------------------+| newbases | CREATE DATABASE `newbases` /*!40100 DEFAULT CHARACTER SET utf8 */ |+----------+-------------------------------------...
show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | newbases | | performance_schema | | test | +--------------------+ 5 rows in set (0.00 sec)mysql> create database if not exists newbases; Query OK, 1 row affected, 1 warning (0.00 sec)mysql> show databases; +--------------------+ | Database ...