PHPMYADMIN

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

PHPMYADMIN

Postby gitesh14 » 17. July 2018 18:25

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
gitesh14
 
Posts: 3
Joined: 17. July 2018 18:05
Location: bangalore
XAMPP version: 3.2.2
Operating System: windows 7

Re: PHPMYADMIN

Postby Nobbie » 19. July 2018 17:10

Show us your full CREATE TABLE statement. You are probably using a reserved word for a column.
Nobbie
 
Posts: 13165
Joined: 09. March 2008 13:04

Re: PHPMYADMIN

Postby gitesh14 » 19. July 2018 21:08

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
gitesh14
 
Posts: 3
Joined: 17. July 2018 18:05
Location: bangalore
XAMPP version: 3.2.2
Operating System: windows 7

Re: PHPMYADMIN

Postby gitesh14 » 19. July 2018 21:09

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.
gitesh14
 
Posts: 3
Joined: 17. July 2018 18:05
Location: bangalore
XAMPP version: 3.2.2
Operating System: windows 7


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 34 guests