Is semicolon necessary in MySQL?

Question

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'. 12 июн. 2016 г.

What does the semicolon do in MySQL?

A MySQL client program such as MySQL Workbench or mysql program uses the delimiter ( ; ) to separate statements and executes each statement separately. However, a stored procedure consists of multiple statements separated by a semicolon (;).

What is the alternative of semicolon in MySQL?

By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server. To redefine the mysql delimiter, use the delimiter command.

Do you need semicolon for postgresql?

Depends on the DBMS and version number. Semicolons are often optional at the end of a single statement. But if you are going to execute a script with more than one statement, they need to be terminated by a semicolon.

Do spaces matter in MySQL?

As with any other language, your choice of spacing for any indentation in MySQL should be consistent. Many developers choose to use 4-space or 2-space indentation. You will also find fewer cases of indentation in MySQL, but we have provided expected course guidelines for formatting MySQL code here.

Expert · Answer