Skip to content

Commit 1d6d027

Browse files
author
Lin Ma
committed
Practice checking
1 parent cc1d99f commit 1d6d027

File tree

2 files changed

+21
-0
lines changed

2 files changed

+21
-0
lines changed

README.md

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,6 @@
11
python
22
======
33
学习Python时的代码
4+
5+
LearnPython
6+
20150826

Untitled.sql

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,18 @@
1+
SELECT * FROM Customers
2+
WHERE City LIKE '[bsp]%'
3+
4+
SELECT Contactname, Address From test.Customers
5+
6+
CREATE TABLE CustomersTemp
7+
(CustomerID int(2) primary key not null AUTO_INCREMENT,
8+
CustomerName character(36),
9+
ContactName character(200),
10+
Addresss character(47),
11+
City character(26),
12+
Postalcode character(14),
13+
Country charater(11));
14+
15+
LOAD DATA LOCAL INFILE '/Users/linma/Documents/cw/W/MySQL/Customers.tsv'
16+
into table test.CustomersTemp
17+
fields terminated by '\t'
18+
ignore 1 rows;

0 commit comments

Comments
 (0)