数据查询入门I

---

数据查询入门

---

/*CREATE TABLE student(name VARCHAR(20),birthday VARCHAR(20)    )
SELECT * FROM student
SELECT UPPER('name')
SELECT UPPER('asdasd')
SELECT name ,birthday FROM student LIMIT 10,5
UPDATE student SET name=UPPER(name)*/
-- UPDATE student set name=UPPER(NAME)
SELECT * ,SUBSTRING(birthday , 7,8) FROM student
SELECT REPLACE(name,'ASDSZ','天使比尔') FROM student