Intern Preparation QA May 25

QA INTERN
quality assurance
One requirement is familiar with SQL.
In case they may ask me questions about SQL.
Simple MySQL command:
1. create: create table test (id INT primary key,name VARCHAR(30) unique,phone VARCHAR(12));
2. insert: insert (id,name,phone) values(10,'yifei',888-888-2432);
3. drop: drop table test;
4. select: select id,name from test where id=10;
5. create procedure:mysql> delimiter //

mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
-> BEGIN
-> SELECT COUNT(*) INTO param1 FROM t;
-> END//
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

mysql> CALL simpleproc(@a);