Differences

This shows you the differences between two versions of the page.

--- docs:mysql:loading_csv_files [2007/10/13 23:59] – created billh
+++ docs:mysql:loading_csv_files [2008/08/03 00:25] (current) – external edit 127.0.0.1
@@ Line 10: / Line 10: @@
   `zip_id` int(11) NOT NULL auto_increment,
   `zip` varchar(5) default NULL,
-  `zipabbr` varchar(2) default NULL,
+  `state` varchar(2) default NULL,
   `lat` varchar(10) default NULL,
   `lon` varchar(10) default NULL,
   `city` varchar(50) default NULL,
-  `state` varchar(50) default NULL,
+  `statename` varchar(50) default NULL,
   PRIMARY KEY  (`zip_id`)
 );
@@ Line 23: / Line 23: @@
 LINES TERMINATED BY '\n'
 IGNORE 1 LINES
-(zip, zipabbr, lat, lon, city, state);
+(zip, state, lat, lon, city, statename);
 </code>
@@ Line 39: / Line 39: @@
 "35020", "AL", " 33.405559", " -86.95141", "Bessemer", "Alabama"
 </code>
+===== set =====
+User variables in the SET clause can be used in several ways. The following example uses the first input column directly for the value of t1.column1, and assigns the second input column to a user variable that is subjected to a division operation before being used for the value of t1.column2:
+<code>
+LOAD DATA INFILE 'file.txt'
+  INTO TABLE t1
+  (column1, @var1)
+  SET column2 = @var1/100;
+</code>
+===== External Links =====
+  * http://dev.mysql.com/doc/refman/5.0/en/load-data.html