LeonLatex Posted September 3, 2022 Share Posted September 3, 2022 Where is the error? CREATE TABLE '122387_leon'.'article'( 'id' INT NOT NULL AUTO_INCREMENT, 'articletext' TEXT NULL, 'articledate' DATE NULL, PRIMARY KEY ('id')); 122387_leon is the DB name. Since i am logged into the DB via MySQL Workbench & Navicat i have tried with and without 122387_leon. But still I get an 1064 error. What is wrong? Quote Link to comment Share on other sites More sharing options...
Barand Posted September 3, 2022 Share Posted September 3, 2022 Use backticks and not single quotes for identifiers, or omit them - they are only necessary if the identifier contains special charaters or is a reserved word.. Quotes are for string literals. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.