错误 1604 - MySQL 语法错误 [英] Error 1604 - Wrong Syntax MySQL

问题描述

每当我尝试在创建的表(用户 ID)中创建和插入数据时，都会出现错误代码 1064(语法错误).

Whenever I try to create and insert data into the created table (userid), the error code 1064 comes out (wrong syntax).

CREATE TABLE userid
(
LogIN int NOT NULL,
username varchar(40) NOT NULL,
pass varchar(40) NOT NULL,
PRIMARY KEY LogIN,
);

INSERT INTO userid (username, pass)
VALUE (kimminseo, lukekms);

谁能帮帮我?谢谢.

推荐答案

您的字符串值缺少引号:

You're missing quotes around your string values:

INSERT INTO userid (username, pass)
VALUE ('kimminseo', 'lukekms');

这篇关于错误 1604 - MySQL 语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！