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;
转载于:https://www.cnblogs.com/RedCoffeeGod/p/5537109.html
