What does the semicolon do in MySQL?

Why semicolon is used in MySQL?

mysql determines where your statement ends by looking for the terminating semicolon, not by looking for the end of the input line. (In other words, mysql accepts free-format input: it collects input lines but does not execute them until it sees the semicolon.)

Is semicolon needed in MySQL?

If you're writing single statements in, say, PHP and then sending them to MySQL for processing, the semicolon is optional. You ask if it "might have possible negative effects maybe during server high load, caching etc." The answer to that is 'No'.

What is semicolon used for in SQL?

Some database systems require a semicolon at the end of each SQL statement. Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

How do I insert a semicolon in MySQL?

PHP + Mysql : How to insert data having , " ' (Semicolon, Single + Double Quotation Marks)1Use something like PDO and bind variables. ... 2use escape string before insert into database... ... 3You can use addslashes() to handle single and double quotation marks for inserting into the DB.