Mysql Select Last inserted row

Asked Jun 22 '17 at 16:27

Active Jun 22 '17 at 16:35

Viewed 90 times

I'm creating a stored procedure using phpmyadmin for mysql 5.5.55 .

INSERT INTO drama_ (value1,value2,value3,value4,value5,value6)
VALUES (val1,val2,0,0,0,0);

SELECT LAST_INSERT_ID();

but i'm getting a syntax error in SELECT LAST_INSERT_ID();

EDIT :

You have an error your SQL syntax: check the manual that corresponds to your MYSQL server version for the right syntax to use near 'SELECT LAST_INSERT_ID()' at line 4

edited Jun 22 '17 at 16:35

Barmar

741,623
53
500
612

asked Jun 22 '17 at 16:27

aurelia Lo bianco

Could you post the error message? – Darshan Mehta Jun 22 '17 at 16:29
You probably forgot to use a `DELIMITER` statement before defining the procedure. – Barmar Jun 22 '17 at 16:29
@Barmar i'm using phpmyadmin GUI to create my statement wich gives you an interface where you select your parameters , note that the first statement works perfectly – aurelia Lo bianco Jun 22 '17 at 16:31
@DarshanMehta You have an error ... – aurelia Lo bianco Jun 22 '17 at 16:31
There's nothing wrong with the syntax of the second statement. So the problem must be with how you're defining the stored procedure. – Barmar Jun 22 '17 at 16:31
@aureliaLobianco Post the whole error message in the question. We need to see the "near" part of it. – Barmar Jun 22 '17 at 16:32
See https://stackoverflow.com/questions/2846516/how-to-write-a-stored-procedure-using-phpmyadmin-and-how-to-use-it-through-php. You need to change the Delimiter field in the SQL tab of PhpMyAdmin. – Barmar Jun 22 '17 at 16:34
@Barmar that didnt works since i'm not using the SQL tab to create my stored proc – aurelia Lo bianco Jun 22 '17 at 16:40
Are you using the "Routines" tab, as in [this answer](https://stackoverflow.com/a/20869749/1491895)? – Barmar Jun 22 '17 at 16:42
@Barmar Yes sir – aurelia Lo bianco Jun 22 '17 at 16:44
I suggest you use the SQL tab, it sounds like a PhpMyAdmin issue. I don't use it, so I don't know the solution. – Barmar Jun 22 '17 at 16:47

Mysql Select Last inserted row

0 Answers0