Hi!
I'm new to SQL.
I was trying to create a new database called database1 in MySQL workbench environment.
This version of MySQL is
127.*.*.*:****
When I typed the query as,
CREATE SCHEMA `database1` ;
and clicked execute the selected scrip or portion.......
But it keeps displaying error 1064
What could be the reason for this?
did you look up error 1064 to see what it means?
Yeah it is something regarding my query and says "`" depends on the version or something like that.
Error 1064 in MySQL is a syntax error. It means that there is an issue with the syntax of the SQL statement you provided. In this case, it seems like there is nothing wrong with the syntax of your CREATE SCHEMA statement.
The possible reason for the error could be the version of MySQL you are using. The CREATE SCHEMA statement was introduced in MySQL 5.0. If you are using an older version of MySQL, it is possible that the CREATE SCHEMA statement is not recognized.
To confirm the version of MySQL you are using, you can execute the following query:
SELECT VERSION();
This query will return the version number of MySQL. If the version is indeed older than 5.0, you may need to use a different statement to create the database.
In older versions of MySQL, you can use the CREATE DATABASE statement instead of CREATE SCHEMA. Here's an example:
CREATE DATABASE database1;
Try executing this statement in your MySQL workbench environment, and it should create a new database named "database1" without any syntax errors.
I hope this helps! Let me know if you have any further questions.