Shulou(Shulou.com)06/01 Report--

In the mysql service I built by myself, I made 1064 mistakes in creating tables with create table, tried to find various solutions online, and finally tried to solve them by myself. Some of the solutions are confused, after all, I do not have a very clear understanding of the database knowledge. No more nonsense, let's take a look at my solution process.

The original purpose of creating your own table: to try from scratch

Set names utf8set foreign_key_checks=0drop table if exists `own_ roombursement` Create table `own_ roombursement` (`id` int (10) not null AUTO_INCREMENT, `end_ time`date not null default, `travel_ time` int (3) not null default, `place_ name` char (30) default comment 'place name', `project_ name` char (30) default comment 'project name', `venue_ name` char (30) default comment 'venue name', `personnel_ name` char (30) default comment 'personnel' `travel_ expense` float (7) default comment 'accommodation', `taxi_ Fare` float (7) not null default comment 'taxi', `travel_ allowance` float (7) not null default comment 'travel allowance', `road_ expense` float (7) not null default comment 'travel expenses', `subsidy`float (7) not null default comment 'total reimbursement', primary key (`id`) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 BEGIN;INSERT INTO `own_ exercise bursement` VALUES ('1th,' 2018-08-22nd, '2018-08-31,' 10', 'Jingdezhen, Jiangxi','xx Project', 'xxxx Sports Center', 'Wang Sicong', '1830', '195.8', '750,' 738, '3513.8'); COMMIT;SET FOREIGN_KEY_CHECKS = 1

In the implementation has been reporting 1064 errors, so that I am puzzled, but also foolishly think that it is really a version problem, but also specially found the relevant version instructions (under the English version of the face confused), the scoundrel directly simple rough search on the Internet to create mysql to report 1064 errors, really see a lot of solutions, but none of them are applicable.

[SQL] set names utf8set foreign_key_checks=0drop table if exists `own_ roombursement`; [Err] 1064-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 'set foreign_key_checks=0drop table if exists `own_' at line 2

ODR version:

1. To view tables, columns, and indexes in create table statements, backslash symbols can be used or not, but cannot be written as' single quotation marks. Otherwise, the execution will report a 1064 error.

two。 Do not use the reserved word of mysql

I made a mistake because I didn't understand default. After getting rid of default, it was successful.

Set names utf8;set foreign_key_checks = 0 drop table if exists `own_ roombursement` Create table `own_ roombursement` (`id` int (10) not null AUTO_INCREMENT, `end_ time`date not null, `travel_ time` int (3) not null, `place_ name` char (30) NOT NULL comment 'place name', `project_ name` char (30) NOT NULL comment 'project name', `venue_ name` char (30) NOT NULL comment 'venue name', `personnel_ name` char (30) NOT NULL comment 'personnel' `travel_ expense` float (7) comment 'accommodation', `taxi_ Fare` float (7) not null comment 'taxi', `travel_ allowance` float (7) not null comment 'travel allowance', `road_ expense` float (7) not null comment 'travel expenses', `subsidy`float (7) not null comment 'total reimbursement', primary key (`id`) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 SET FOREIGN_KEY_CHECKS = 1

Reason:

Default modifier

You can use the DEFAULT modifier to set a default value for the field.

If no DEFAULT modifier is specified in a field, MySQL automatically sets the default value based on whether the field is NULL or NOT NULL.

If the specified field can be NULL, MySQL sets the default value to NULL for it.

If it is a NOT NULL field, MySQL inserts 0 for numeric types and empty strings for string types

The timestamp type inserts the current date and time, and the ENUM type inserts the first entry of the enumeration group.

If you want to use the default modifier when creating a table, don't forget to add a default value after default.

For example:

CREATE TABLE `websites` (`id`websites` (11) NOT NULL AUTO_INCREMENT, `name` char (20) NOT NULL DEFAULT''COMMENT' site name', `url`varchar (255) NOT NULL DEFAULT'', `alexa`int (11) NOT NULL DEFAULT'0' COMMENT 'Alexa ranking', `roomy`char (10) NOT NULL DEFAULT''COMMENT' country', PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.