Basic MySQL question from a begginer.

[Havharo]

Hi everyone,

 

This is my first post, so please forgive me if this question showed up earlier. I'm a beginner when it comes to PHP.

I have a very basic question. When creating a database through the mysql console, I'm in a moment where I'm done typing all the necessary information for my table and I have a problem with exiting to a new command line.

Basically when I press shift + enter I'm in a new line, but not in a command line.

I'm sorry for asking so basic question, but this is really frustrating and I cant find answer on my question online.

 

Thank you kindly in advance for the help

Regards
 

[Barand]

Have you entered a semicolon ( ; ) to terminate the query statement?

Edited February 6, 2014 by Barand

[Havharo]

You have my humble thanks, that was it (facepalm)

[Havharo]

Hello again ,

actually today I was trying to create a database with the following code:

CREATE TABLE `test`.`users` (
`id` INT NOT NULL auto_increment ,
`name` VARCHAR( 20 ) NOT NULL ,
`password` VARCHAR( 20 ) NOT NULL ,
`email` VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( `id` )
)  

(I've got it from this website: http://forum.codecall.net/topic/44787-creating-loginregistration-forms-with-php/ )

 

When I'm typing the semicolon ( ; ) after the last parenthesis, console is taking me to a new line.
Yesterday I've checked it only on one line of code, and it worked. Today when I came back to the exercise, I'm still having the problem. 

Could You please answer what I'm doing wrong?

 

Thank you kindly in advance



 

[Barand]

The query should be executed when you press ENTER after the semicolon EG

mysql> use test;
Database changed
mysql> CREATE TABLE `users` (
    -> `id` INT NOT NULL auto_increment ,
    -> `name` VARCHAR( 20 ) NOT NULL ,
    -> `password` VARCHAR( 20 ) NOT NULL ,
    -> `email` VARCHAR( 20 ) NOT NULL ,
    -> PRIMARY KEY ( `id` )
    -> );
Query OK, 0 rows affected (0.11 sec)

[Havharo]

Hi, thank you for the help. At this moment it works, but I'm getting error 1064(42000). Is it possible that the syntax above is wrong for mySQL ver 5.6.12? 

[Barand]

I can't see anything obvious. What was the full error message?

[Havharo]

I'm getting the following error:

"ERROR 1064 (42000): 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 ' 'users'(
'id' INT NOT NULL auto_increment ,
'name' VARCHAR( 20 ) NOT NULL,

'pas' at line 1 "

 

[Barand]

Your column names are enclose in single quotes in that last post and in backticks (correct) in your earlier one. Which is it?

Edited February 8, 2014 by Barand

[Havharo]

I've used backticks and it's ok now. Thank you kindly for your help