CREATE TABLE sch (
id INT(10) PRIMARY KEY NOT NULL UNIQUE,
NAME VARCHAR(50) NOT NULL,
glass VARCHAR(50) NOT NULL
);
INSERT INTO sch VALUES
( 1,'xiaoming','glass 1'),
( 2,'xiaojun','glass 2');
2、创建一个可以统计表格内记录条数的存储函数 ,函数名为count_sch()
mysql> CREATE FUNCTION count_sch()
-> RETURNS int
-> BEGIN
-> DECLARE c INT DEFAULT 0;
-> SELECT COUNT(*) INTO c FROM sch;
-> RETURN c;
-> END $
Query OK, 0 rows affected (0.00 sec)
mysql> \d ;
mysql> select count_sch();
+-------------+
| count_sch() |
+-------------+
| 2 |
+-------------+
1 row in set (0.00 sec)