浅试mysql:(1)、数据库知识点_MySQL

   1:  指定用户登录名Ben:

   2:  mysql -u ben

   3:  给出用户名、主机、端口、和口令：

   4:  mysql -u ben -p -h myserver -p 9999

   1:  SELECT DISTINCT title FROM new

   1:  SELECT id,title FROM new LIMIT 3 

   1:  SELECT id,title FROM new LIMIT 1 OFFSET 3

   2:  SELECT id,title FROM new LIMIT 3,1

   3:  效果一样

   1:  SELECT new.id,new.title FROM new

   2:  当然表也可使用完全限定如：Mydata.new

   1:   SHOW DATABASES;

   1:   CREATE DATABASE MYSQLDATA;

   1:  CREATE TABLE product (pro_id INT,pro_price FLOAT,pro_name VARCHAR(20));

   1:  DESCRIBE product

   1:  INSERT INTO product VALUES(15.00,'pen')

   2:  #插入多行

   3:  INSERT INTO product (pro_price,pro_name) VALUES(12.00,' toothpaste'),

   4:  (18.00,'belt'),(15.00,'basin'),(52.30,'pot')

   1:  INSERT INTO product (pro_price,pro_name) VALUES(1.00,'SoftDrink'),(2.00,'矿泉水')

   1:  mysql>drop TABLE MYTABLE;

   1:  DELETE FROM new

   1:  UPDATE product SET pro_price=50.00 WHERE pro_name='pot'

   1:  SELECT pro_price,pro_name FROM product ORDER BY pro_price DESC LIMIT 1