无法识别的关键字。(Unrecognized keyword. (near “str_to_date” at position 158))
这是我的创建表语句
CREATE TABLE EVENTREQUEST (EVENTNO VARCHAR(8) NOT NULL, DATEHELD DATE NOT NULL, DATEREQ DATE NOT NULL, CUSTNO VARCHAR(8) NOT NULL, FACNO VARCHAR(8) NOT NULL, DATEAUTH DATE NOT NULL, STATUS VARCHAR(30) NOT NULL, ESTCOST DECIMAL(12,2) NOT NULL, ESTAUDIENCE VARCHAR(10) NOT NULL, BUDNO VARCHAR(8) NOT NULL, CONSTRAINT PK_EVENTREQUEST PRIMARY KEY (EVENTNO) CONSTRAINT FKCustNo FOREIGN KEY (CustNo) REFERENCES Customer (CustNo), CONSTRAINT FKEmpNo FOREIGN KEY (FACNO) REFERENCES facility (FACNO) ) ;
我的插入语句
Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E100',str_to_date('25,OCT,13','%d,%b,%y'),str_to_date('06,JUN,13','%d,%b,%y'),'C100','F100',str_to_date('08,JUN,13','%d,%b,%y'),'Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E101',str_to_date('26,OCT,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C100','F100',null,'Pending',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E103',str_to_date('21,SEP,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C100','F100',str_to_date('01,AUG,13','%d,%b,%y'),'Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E102',str_to_date('14,SEP,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C100','F100',str_to_date('31,JUL,13','%d,%b,%y'),'Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E104',str_to_date('03,DEC,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C101','F101',str_to_date('31,JUL,13','%d,%b,%y'),'Approved',2000,12000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E105',str_to_date('05,DEC,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C101','F101',str_to_date('01,AUG,13','%d,%b,%y'),'Approved',2000,10000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E106',str_to_date('12,DEC,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C101','F101',str_to_date('31,JUL,13','%d,%b,%y'),'Approved',2000,10000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E107',str_to_date('23,NOV,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C105','F100',str_to_date('31,JUL,13','%d,%b,%y'),'Denied',10000,5000,null);
我怎么解决这个问题?
im trying to create a table and insert values after creating it but im getting a lot of errors
and this is my create table statement
CREATE TABLE EVENTREQUEST (EVENTNO VARCHAR(8) NOT NULL, DATEHELD DATE NOT NULL, DATEREQ DATE NOT NULL, CUSTNO VARCHAR(8) NOT NULL, FACNO VARCHAR(8) NOT NULL, DATEAUTH DATE NOT NULL, STATUS VARCHAR(30) NOT NULL, ESTCOST DECIMAL(12,2) NOT NULL, ESTAUDIENCE VARCHAR(10) NOT NULL, BUDNO VARCHAR(8) NOT NULL, CONSTRAINT PK_EVENTREQUEST PRIMARY KEY (EVENTNO) CONSTRAINT FKCustNo FOREIGN KEY (CustNo) REFERENCES Customer (CustNo), CONSTRAINT FKEmpNo FOREIGN KEY (FACNO) REFERENCES facility (FACNO) ) ;
my insert statements
Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E100',str_to_date('25,OCT,13','%d,%b,%y'),str_to_date('06,JUN,13','%d,%b,%y'),'C100','F100',str_to_date('08,JUN,13','%d,%b,%y'),'Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E101',str_to_date('26,OCT,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C100','F100',null,'Pending',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E103',str_to_date('21,SEP,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C100','F100',str_to_date('01,AUG,13','%d,%b,%y'),'Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E102',str_to_date('14,SEP,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C100','F100',str_to_date('31,JUL,13','%d,%b,%y'),'Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E104',str_to_date('03,DEC,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C101','F101',str_to_date('31,JUL,13','%d,%b,%y'),'Approved',2000,12000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E105',str_to_date('05,DEC,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C101','F101',str_to_date('01,AUG,13','%d,%b,%y'),'Approved',2000,10000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E106',str_to_date('12,DEC,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C101','F101',str_to_date('31,JUL,13','%d,%b,%y'),'Approved',2000,10000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E107',str_to_date('23,NOV,13','%d,%b,%y'),str_to_date('28,JUL,13','%d,%b,%y'),'C105','F100',str_to_date('31,JUL,13','%d,%b,%y'),'Denied',10000,5000,null);
how can i resolved this?
原文:https://stackoverflow.com/questions/42985097
最满意答案
我以前为两个不同的数据库创建了两个连接。 一个是大学项目,我不想触及。
错误的MySQL实例正在运行,这意味着我无法看到模式。 所以我必须从右下角的图标开始正确的服务。
I had previously created two connections for two different databases. One was for a university project which I didn't want touched.
The wrong MySQL instance was running, which meant I couldn't see the schemas. So I had to start the correct service from the bottom right icon.
相关问答
更多-
怎么使用mysql work bench[2023-10-27]
在CMD窗口中转到你的安装目录下面的bin目录中键入mysql -u root(如果安装时候没有密码就会出现“mysql>”这样的提示符,在这可以输入数据库的命令) -
为什么work bench 执行不了mysql delete语句[2021-12-12]
导致这个问题的原因是Workbench数据库程序有问题。一般在数据库中创建查询时,不要用Workbench数据库,因为这个数据库程序在Win7等操作系统下容易出现问题,最好在Access 2010软件下创建数据库。 MySQL是查询语句,最好用Access 2010来操作。 查询是用来操作数据库中的记录对象,利用它可以按照预先定义的不同条件从数据表或其它查询中筛选出需要操作的字段,并可以把它们集中起来,形成动态数据集。用户可以浏览、查询、打印,甚至修改这个动态数据集中的数据。 通过查询,可以查找和检索满足指 ... -
mysql和mysql bench 是甚么[2021-10-25]
mysql是1个oracle公司的非常广泛使用的数据库MySQLWorkbench是mysql数据库的1个管理工具 -
有什么数据库专业书籍介绍?[2022-05-19]
mysql -
您需要在Frappe Bench上设置example.com 。 然后通过添加CNAME将www.example.com指向example.com来设置DNS。 您可以在用于托管域名的服务站点上执行此操作。 You need to setup just example.com on your Frappe Bench. Then setup your DNS by adding a CNAME to point www.example.com to example.com. You can do this ...
-
无法使用MySQL Work Bench连接到Azure MySQL(Unable to Connect to Azure MySQL using MySQL Work Bench)[2023-11-20]
我正在使用'Bitnami'和'Bitnami'自带的用户名和密码! Bitnami的默认密码是'bitnami',用户名是'root' I was using 'Bitnami' and 'Bitnami' comes with their own username and password! The default password for Bitnami is 'bitnami' and user name is 'root' -
我以前为两个不同的数据库创建了两个连接。 一个是大学项目,我不想触及。 错误的MySQL实例正在运行,这意味着我无法看到模式。 所以我必须从右下角的图标开始正确的服务。 I had previously created two connections for two different databases. One was for a university project which I didn't want touched. The wrong MySQL instance was running, w ...
-
如何在mysql工作台上放大/缩小或增加字体大小(How to do zoom in/out or increase font size in mysql work bench)[2023-10-10]
在编辑器的底部,您是否看到标记为“100%”的下拉列表。 尝试更改字体大小。 At the bottom of the editor, do you see the drop down labeled "100%". Try that to change the font size. -
我找到了解决方案。 我必须这样写我的请求: SELECT my_db.my_table .... for mysqlslap使用我自己的db I found the solution. I have to write my requests like this: SELECT my_db.my_table .... for mysqlslap use my own db
-
Mysql查询在C#中不起作用,但在MySql Work Bench中起作用(Mysql query not working in C# but does in MySql Work Bench)[2022-05-03]
string sqlGetFolders = "Select FolderName, FolderPath From folder, users Where folder.ID = users.ID and folder.ID = @uID"; 您的@uID参数不应该在引号中。 添加参数后,将自动添加引号。 string sqlGetFolders = "Select FolderName, FolderPath From folder, users Where folder.ID = users.ID ...