LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-21-2023, 04:56 AM   #1
Al99
LQ Newbie
 
Registered: Nov 2020
Posts: 22

Rep: Reputation: Disabled
mysql workbench ERROR 1064


Hi I created a new schema in mysql workbench and set it to default but when I click on create table I get the following error:

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `new_schema`.`new_table` (
);

ERROR 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 ')' at line 2
SQL Statement:
CREATE TABLE `new_schema`.`new_table` (
)

why am I getting this error?

is mysql properly installed?

how can I fix it?

thanks.
 
Old 12-21-2023, 05:08 AM   #2
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 3,475

Rep: Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553Reputation: 1553
Quote:
Originally Posted by Al99 View Post
Hi I created a new schema in mysql workbench and set it to default but when I click on create table I get the following error:

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `new_schema`.`new_table` (
);

ERROR 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 ')' at line 2
SQL Statement:
CREATE TABLE `new_schema`.`new_table` (
)

why am I getting this error?
You've no field definitions in your () brackets.

Quote:
Originally Posted by Al99 View Post
is mysql properly installed?
Probably

Quote:
Originally Posted by Al99 View Post
how can I fix it?
Learn the CREATE TABLE syntax.

Last edited by TenTenths; 12-21-2023 at 05:10 AM.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Error 1064 (42000) when restoring kitek Linux - Server 2 03-25-2012 09:15 PM
1064 ERROR in MYSQL dhiman.manish23 Linux - Networking 1 01-03-2011 07:54 AM
MySQL Error Code 1064 - MySQL Administrator a_m0d Linux - Server 6 02-27-2009 04:02 AM
error 1064 mysql Tredo Linux - Security 4 12-02-2004 05:24 PM
MySQL error 1064 tangle Linux - General 2 11-16-2004 01:17 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:28 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration