Mysql 学习-表建立及查看的示例和字符函数的使用 

 1 SELECT LEFT('SOMETHIN',5);
 2 SELECT right('KISS GOODBYE',4);
 3 SELECT LOWER('BEAUTIFUL'),lcase('WELL');
 4 select upper('black'),ucase('Black');
 5 
 6 use sakila;
 7 create table Book
 8 (
 9 bookid int not null,
10 bookname varchar(255) not null,
11 authors varchar(255) not null,
12 info varchar(255) null,
13 comment varchar(255) null,
14 year_publication year,
15 index (year_publication)
16 );
17 show create table book;

 

posted @ 2016-05-28 11:59  cyh5272  阅读(179)  评论(0)    收藏  举报