MySql 091217

fang.zhang

  Normal
  0
  
  7.8 磅
  0
  2
  
  false
  false
  false
  
   
   
   
   
   
   
   
   
   
   
   
   
  
  MicrosoftInternetExplorer4



st1\:*{behavior:url(#ieooui) }
/* Style Definitions */
table.MsoNormalTable
        {mso-style-name:普通表格;
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-parent:"";
        mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
        mso-para-margin:0cm;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Times New Roman";
        mso-ansi-language:#0400;
        mso-fareast-language:#0400;
        mso-bidi-language:#0400;}
table.MsoTableGrid
        {mso-style-name:网格型;
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        border:solid windowtext 1.0pt;
        mso-border-alt:solid windowtext .5pt;
        mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
        mso-border-insideh:.5pt solid windowtext;
        mso-border-insidev:.5pt solid windowtext;
        mso-para-margin:0cm;
        mso-para-margin-bottom:.0001pt;
        text-align:justify;
        text-justify:inter-ideograph;
        mso-pagination:none;
        font-size:10.0pt;
        font-family:"Times New Roman";
        mso-ansi-language:#0400;
        mso-fareast-language:#0400;
        mso-bidi-language:#0400;}
MySql 091217
@ http://zcatt.cublog.cn
1.   
Connect and Disconnect
mysql
-h host -u user -p
mysql
-u user -p


  
  h
  
  
  Hostname or IP
  


  
  u
  
  
  user name
  


  
  p
  
  
  password
  


select version(), current_date;
select now();
select user();
2.
Creating DB
show
databases;

create
databases dbname;

use
dbname

show
tables;

CREATE
TABLE pet (name VARCHAR(20), owner VARCHAR(20),
species VARCHAR(20), sex
CHAR(1), birth DATE, death DATE);

DESC
pet;

LOAD
DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet
LINES TERMINATED BY '\r\n';

INSERT
INTO pet
VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL);


DELETE FROM pet;
LOAD DATA LOCAL INFILE
'pet.txt' INTO TABLE pet;

UPDATE pet SET birth = '1989-08-31'
WHERE name = 'Bowser';

3.
Select sentence
SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy;

SELECT
name, birth FROM pet ORDER BY birth;

SELECT
name, species, birth FROM pet
ORDER BY species, birth DESC;

SELECT
* FROM pet WHERE name LIKE 'b%';

SELECT
* FROM pet WHERE name LIKE '_____';

SELECT
* FROM pet WHERE name REGEXP 'fy$';

SELECT
* FROM pet WHERE name REGEXP '^.....$';

SELECT
owner, COUNT(*) FROM pet GROUP BY owner;

SELECT
p1.name, p1.sex, p2.name, p2.sex, p1.species
FROM pet AS p1 INNER JOIN pet AS p2
ON p1.species = p2.species AND p1.sex = 'f'
AND p2.sex = 'm';


4.
Get info
SELECT
DATABASE();

SHOW
TABLES;

DESCRIBE
pet;


5.
Batch Mode
mysql>
source filename;





               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/8866/showart_2123873.html