if statement in MySql - if condition in MYSql - if in MySql

 select IF(0 > 0, 'True', 'False') as message;

if exist drop and create database in MySql

 create DATABASE IF not EXISTS test2;

 drop DATABASE IF not EXISTS test2;

How to create new tab in My Sql

 Click on Create a new Sql Tab.    Below is the screenshot:-

What is called t1 and t2 in join

 Select * from table1 t1 inner join table t2 on t1.id = t2.id 

Here t1 and t2 are called alias.

How to create stored procedure in MySql and how to call stored procedure

 DELIMITER $$

CREATE PROCEDURE new_procedure_procedure_name()

BEGIN

    SELECT * 

    FROM test.new_table t1

    LEFT JOIN test1.table1 t2 ON t1.id = t2.id;

END $$

DELIMITER ;

===============================

CALL new_procedure_procedure_name();