kode mysql Error 1064 (42000)

You have an error in your sql syntax; check the manual that corresponds to your mysql server version

This is my Stored procedure :

CREATE PROCEDURE ProG[]
  BEGIN
    SELECT * FROM `hs_hr_employee_leave_quota`;
  END

But I get this error:

#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 3

What does the mistake signify? Why is line number two problematic?

Aug 14 in Database by Kithuzzz
• 9,040 points • 219 views

No answer to this question. Be the first to respond.

Your answer

Related Questions In Database

All categories
Apache Kafka [84]
Apache Spark [596]
Azure [131]
Big Data Hadoop [1,907]
Blockchain [1,673]
C# [122]
C++ [268]
Career Counselling [1,060]
Cloud Computing [3,356]
Cyber Security & Ethical Hacking [145]
Data Analytics [1,266]
Database [813]
Data Science [75]
DevOps & Agile [3,500]
Digital Marketing [111]
Events & Trending Topics [28]
IoT [Internet of Things] [387]
Java [1,133]
Kotlin [3]
Linux Administration [384]
Machine Learning [337]
MicroStrategy [6]
PMP [423]
Power BI [516]
Python [3,141]
RPA [650]
SalesForce [92]
Selenium [1,569]
Software Testing [56]
Tableau [608]
Talend [73]
TypeSript [124]
Web Development [2,970]
Ask us Anything! [66]
Others [909]

Join the world's most active Tech Community!

Welcome back to the World's most active Tech Community!

Subscribe to our Newsletter, and get personalized recommendations.

Already have an account? Sign in.

How do I fix MySQL syntax error?

There are five methods you can try to fix the MySQL 1064 error when you encounter it, depending on its most likely cause:.

Correct mistyped commands..

Replace obsolete commands..

Designate reserved words..

Add missing data..

Transfer WordPress databases in compatibility mode..

What are errors in MySQL?

Lost connection to MySQL server Network conditions should be checked if this is a frequent error. If an error message like “Lost connection to MySQL server” appears while querying the database, it is certain that the error has occurred because of network connection issues.

How can I tell what version of MySQL is installed on Windows?

Windows users can employ PowerShell or the command prompt and Linux and MacOS have the Terminal. To check the version your MySQL is running, type and execute mysql -V [note the uppercase V] in the command line.

What is the current version of MySQL?

MySQL

Screenshot of the default MySQL command-line banner and prompt
Initial release	23 May 1995
Stable release	8.0.30 / 6 July 2022
Repository	github.com/mysql/mysql-server
Written in	C, C++

MySQL - Wikipediaen.wikipedia.org › wiki › MySQLnull