Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.1-alpha-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
+----------------------+
| version()            |
+----------------------+
| 5.0.1-alpha-standard |
+----------------------+
1 row in set (0.00 sec)

mysql> drop database if exists temp;
Query OK, 0 rows affected (0.01 sec)

mysql> create database temp;
Query OK, 1 row affected (0.00 sec)

mysql> use temp;
Database changed
mysql> drop table if exists ttemp;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> create table ttemp (id int not null auto_increment, name varchar (40) not null default '', primary key(id));
Query OK, 0 rows affected (0.01 sec)

mysql> drop procedure if exists tttemp;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> delimiter //
mysql> create procedure tttemp (in sName varchar (40))
    -> begin
    -> insert into ttemp (name) values (sName);
    -> end ;
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call tttemp ('bds');
Query OK, 1 row affected (0.00 sec)

mysql> select * from ttemp;
+----+------+
| id | name |
+----+------+
|  1 | bds  |
+----+------+
1 row in set (0.00 sec)

mysql> 

mysql> source script.sql
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version 
for the right syntax to use near 'end ;
//
delimiter ;
call tttemp ('bds');
select * from ttemp' at line 1
mysql>