CODEWITHSUNDEEP
mysqlsql-insertrds
mwild
mwild

Reputation: 1665

SQL Insert statement not working - RDS

I am running a mysql database on an RDS instance.

My table schema is:

Table: users, Columns:

_id - int(11) AI PK
username - varchar(50) UNIQUE
email - varchar(100) UNIQUE

Im then using the following SQL statement to attempt to enter a new record

INSERT INTO usrdb.users (username, email)
VALUES ("admin", "[email protected]")

This statement just times out (30 seconds) repeatedly.

I know from experience that a simple insert statement shouldn't take anywhere near this length of time.

Upvotes: 1

Views: 1090

Answers (2)

Khaled Ouertani
Khaled Ouertani

Reputation: 316

This query example should work :

 INSERT INTO `table`(`col1`, `col2`) VALUES ('varchar','varchar')

Check if there is a duplicate Exception raised.

Upvotes: 0

Dominic Mazur
Dominic Mazur

Reputation: 46

Gotta change the double quotes to single quotes :) https://www.tutorialspoint.com/sql/sql-insert-query.htm

Upvotes: 2

Related Questions