Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> create function create_stmt(tbl varchar(255), partition int unsigned)
- -> returns varchar(500)
- -> comment 'Generate a CREATE TABLE statement for the given table
- '> and partition number.'
- -> return concat(
- -> 'create table if not exists ', tbl, partition, ' like ', tbl);
- ERROR 1607 (HY000): Cannot create stored routine `create_stmt`. Check warnings
- mysql> show warnings;
- +---------+------+------------------------------------------------------------+
- | Level | Code | Message |
- +---------+------+------------------------------------------------------------+
- | Warning | 1265 | Data truncated for column 'comment' at row 1 |
- | Error | 1607 | Cannot create stored routine `create_stmt`. Check warnings |
- +---------+------+------------------------------------------------------------+
- 2 rows in set (0.00 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement