Page 1 of 1

PHPMYADMIN

PostPosted: 17. July 2018 18:25
by gitesh14
While creating table in the database the message appears like
Every time I find this error How can i resolve it.
#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 'UNSIGNED PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT' at line 2

Re: PHPMYADMIN

PostPosted: 19. July 2018 17:10
by Nobbie
Show us your full CREATE TABLE statement. You are probably using a reserved word for a column.

Re: PHPMYADMIN

PostPosted: 19. July 2018 21:08
by gitesh14
Error

SQL query:

CREATE TABLE employeeinfo(
emp_id VARCHAR(50) UNSIGNED PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date VARCHAR(50)
)

MySQL said: Documentation
#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 'UNSIGNED PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT' at line 2

Re: PHPMYADMIN

PostPosted: 19. July 2018 21:09
by gitesh14
As well as there are more issues like follows:

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.