database

MySQL Recap, Stored Procedures

SQL

Structured query language

show databases;

use dbname;

show tables;

desc users;
-- use a db
use testdb;

-- use a delimter
delimiter $$

create procedure HelloWorld()
begin
select "Hello WOlrd!";
end$$

delimiter ;

drop procedure HelloWorld;

call HelloWorld();
Subscribe to RSS - database