新建一个数据库:
-> create database redmine character set utf8;
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 'create database redmine character set utf8' at line 2
mysql> SHOW DATABASES
-> SHOW DATABASES;
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 'SHOW DATABASES' at line 2
myslq语法一直出错,此帖记录mysql语句,应该是
1、新建redmine语句
mysql> CREATE DATABASE redmine CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)
2、全部语句都要加;
大小写不区分,推翻第一条。如果有一条语句没有加;那么执行后面的语句就会默认;之前的全部执行(包括没有;的那条语句)