Set-up Script

Here is a simple script to create the objects required for examples in this chapter (you'll also find it in the scripts directory of the dbfit-complete package):

create database dbfit;
grant all privileges on dbfit.* to dftest@localhost identified by 'dftest';
grant all privileges on dbfit.* to [email protected] identified by 'dftest';
grant all privileges on dbfit.* to dbfit_user@localhost identified by 'password';
grant all privileges on dbfit.* to [email protected] identified by 'password';
grant select on mysql.* to dbfit_user;
flush privileges;
use dbfit;
create table users(name varchar(50) unique, username varchar(50), userid int auto_increment primary key) type=InnoDB;
CREATE PROCEDURE ConcatenateStrings (IN firststring varchar(100), IN secondstring varchar(100), OUT concatenated varchar(200)) set concatenated = concat(firststring , concat( ' ' , secondstring ));
create procedure CalcLength(IN name varchar(100), OUT strlength int) set strlength =length(name);
CREATE FUNCTION ConcatenateF (firststring  VARCHAR(100), secondstring varchar(100)) RETURNS VARCHAR(200) RETURN CONCAT(firststring,' ',secondstring);
create procedure makeuser() insert into users (name,username) values ('user1','fromproc');
create procedure createuser(IN newname varchar(100), IN newusername varchar(100)) insert into users (name,username) values (newname, newusername);
create procedure Multiply(IN factor int, INOUT val int) set val =val*factor;

Next page: Query Parent page: Command reference