Login   Register  
PHP Classes
elePHPant
Icontem

File: test.csv

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Wayne Philip  >  SQL Bulk Importer  >  test.csv  >  Download  
File: test.csv
Role: Auxiliary data
Content type: text/plain
Description: Example Import File
Class: SQL Bulk Importer
Execute MySQL queries read from files
Author: By
Last change:
Date: 3 years ago
Size: 5,238 bytes
 

Contents

Class file image Download
CREATE TABLE IF NOT EXISTS t_id_patients (id int(11) NOT NULL, patient_no varchar(25) NOT NULL, patient_name varchar(50) NOT NULL, sts tinyint(4) NOT NULL, PRIMARY KEY  (id));


DELETE FROM t_id_patients WHERE (id <2000);

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1', '896508471-0', '1');




INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('6', '896582086-0', '1');




INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('11', '896061322-0', '1');





INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('17', '896390209-0', '1');






INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('24', '896096369-1', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('27', '896648192-0', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('28', '896607402-12', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('29', '896349691-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('31', '896651428-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('33', '896236544-0', '1');



INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('39', '896683230-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1318', '896307859-0', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1323', '896617025-1', '1');





INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1329', '896311848-1', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1332', '896284166-0', '1');




INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1337', '896727025-1', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1338', '896329445-0', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1341', '896729362-1', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1344', '896282643-5', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1347', '896698289-0', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1348', '896392376-0', '1');







INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1356', '896749843-0', '1');









INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1366', '896354571-0', '1');




INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1371', '896481603-1', '1');






INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1378', '896700437-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1380', '896186105-12', '1');






INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1387', '896410595-0', '1');






INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1394', '896337200-0', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1397', '896379671-0', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1400', '896704602-0', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1403', '896666093-12', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1404', '896283003-2', '1');




INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1409', '896364917-0', '1');





INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1415', '896535789-0', '1');




INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1420', '896644650-0', '1');



INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1424', '896687635-0', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1425', '896727025-0', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1426', '896284468-0', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1427', '896396525-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1429', '896723895-11', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1430', '896535789-1', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1432', '896006970-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1434', '896653803-0', '1');



INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1438', '896282643-5', '1');
INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1439', '896698289-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1441', '896379671-12', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1443', '896743810-1', '1');






INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1450', '896587916-0', '1');




INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1455', '896756238-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1457', '896321282-0', '1');


INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1460', '896728072-0', '1');

INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1462', '896450759-0', '1');





INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1468', '896582086-0', '1');



INSERT INTO  t_id_patients (id, patient_no, sts) VALUES ('1472', '896415708-0', '1');


UPDATE t_id_patients set patient_name = "UnKnown"