mysql建表的时候出错,就是设置编码的那一行错了。不知道为什么#MySQL-Front5.1(Build1.5)/*!40101SET@OLD_SQL_MODE=@@SQL_MODE*/;/*!40101SETSQL_MODE='STRICT_TRANS_TABLES,NO_AUTO...
mysql 建表的时候出错,就是设置编码的那一行错了。不知道为什么 # MySQL-Front 5.1 (Build 1.5) /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; # Host: localhost Database: supermarket # ------------------------------------------------------ # Server version 5.0.17-nt DROP DATABASE IF EXISTS `supermarket`; CREATE DATABASE `supermarket` /*!40100 DEFAULT CHARACTER SET gb2312 */; USE `supermarket`; # # Source for table employee # CREATE TABLE `employee` ( `eid` varchar(6) NOT NULL, `ename` varchar(20) NOT NULL, `job` varchar(20) NOT NULL, `sal` float(7,2) unsigned NOT NULL default '0.00', `pwd` varchar(10) NOT NULL, PRIMARY KEY (`eid`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
展开