procedure Archives

MySQL procedure not working with both select and delete

November 26, 2022 by Magenaut

I created a procedure to get a vehicle id from the vehicle table using vehicle number input, then delete the booking record for that vehicle id, and at last to delete the entry in the vehicle table… But when creating the procedure I get an error at line 7 saying Error Code: 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 '' at line 7
Please help me to identify the issue…
Thanks in advance

insert into after CTE, mySql

November 26, 2022 by Magenaut

I’m writing a procedure, using with to generate a table, then make an insert passing the fields of this table as a value, but mysql is returning a syntax error in the insert, does anyone have any idea what it is?

I don’t know what’s wrong with my MYSQL procedure

November 25, 2022 by Magenaut

to try to create a procedure in MYSQL workbench but I’m not succeeding ..

comparison of 2 dates in multiple records

November 24, 2022 by Magenaut

I have the following table that I would like to compare

Searching a column containing CSV data in a MySQL table for existence of input values

November 19, 2022 by Magenaut

I have a table say, ITEM, in MySQL that stores data as follows:

Creating a procedure in mySql with parameters

November 18, 2022 by Magenaut

I am trying to make a stored procedure using mySQL. This procedure will validate a username and a password. I’m currently running mySQL 5.0.32 so it should be possible to create procedures.

How can I include a procedure in my Eloquent ORM laravel select?

September 24, 2022 by Magenaut

How can I include a procedure in my Eloquent ORM select laravel?