`
yeelor
  • 浏览: 416188 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论

LOAD DATA INFILE Syntax

 
阅读更多

http://dev.mysql.com/doc/refman/5.6/en/load-data.html

 

http://www.linuxidc.com/Linux/2011-06/36947.htm

 

大的文本保存的数据库格式的导入load data infile 'D:/file.txt' into table user fields terminated by ' # ' lines terminated by '\r\n' (user_id,user_pwd,user_mail) set user_from =1,add_time=1;

 

 

 

LOAD DATA LOCAL INFILE 'd:/t_data.txt' INTO TABLE t FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (user_id,brand,type,date);

分享到:
评论

相关推荐

    Fast Data Processing with Spark 2, 3rd Edition.pdf

    You will also learn how to use the Spark shell, how to load data before finding out how to build and run your own Spark applications. Discover how to manipulate your RDD and get stuck into a range of ...

    BURNINTEST--硬件检测工具

    in a log file. - Updated license management, in an attempt to remove a rare crash on startup. Release 5.3 build 1012.0002 WIN32 release 31 October 2007 - New build of Rebooter (64-bit Windows ...

    Using Perl For Web Programming.pdf

    %INC<file-name>,<file-load-status> G CONTENTS http://docs.rinet.ru:8080/Using_Perl5_in_Web/ (8 of 24) [2/17/2007 1:22:35 PM] %SIG, G @ARGV G @INC G From Here... G Chapter 14 Operators ! G != G ...

    BDE SQL Express Tools v1.0.1

    14/Dec/2005- Data for card view added- Data/Column/Table Information able to print now- Able to load/save your script now- Some minor bugs fixedVer 1.0.0Features:-SQL Editor through BDE.-SQL syntax ...

    FastReport.v4.15 for.Delphi.BCB.Full.Source企业版含ClientServer中文修正版支持D4-XE5

    + [enterprise] added property "Xml" - "Extension" in server configuration - allow select between ".xml" and ".xls" extension for output file + [enterprise] added property "Html" - "URLTarget" in ...

    BDE SQL Express Tools v1.0.2

    ---------BDE SQL Express Tools v1.0.0Date : 13/Dec/2005Features:-SQL Editor through BDE.-SQL syntax highlighter-Multiple windows for SQL Editor-Increamental search in any grids-Data/Column information...

    ARM® Compiler v5.06 for µVision® armasm User Guide

    4.14 Load and store multiple register instructions in ARM and Thumb 4.15 Stack implementation using LDM and STM 4.16 Stack operations for nested subroutines 4.17 Block copy with LDM and STM 4.18 ...

    UE(官方下载)

    A question we often see is "I have a lot of blank lines in my file and I don't want to go through and manually delete them. Is there an easier way to do this?" The answer is: yes! Configure FTP Set up...

    S7A驱动720版本

    S7A驱动,7.20版本, Version history S7A OPC server and FIX driver for Siemens S7/S5 communication ... - Error in MIX Read function could cause blocking of data blocks...

    acpi控制笔记本风扇转速

    Optimized the Load ASL operator in the case where the source operand is an operation region. Simply map the operation region memory, instead of performing a bytewise read. (Region must be of type ...

    plsqldev13.0.0.1882x32主程序+ v12中文包+keygen

    With the new Load Tester tool you can perform stress tests and concurrency tests for your Oracle data and programs. This allows you to find performance issues and locking issues with multi-user ...

    WPTools.v6.29.1.Pro

    * IMPORTANT: Please edit file WPINC.INC to * activate WPREPORTER, WPSPELL, wPDF, TBX * and GraphicEx / PNGImage support! * Delphi 2009 and later as inbuilt PNGImage *********************************...

    php.ini-development

    The syntax of the file is extremely simple. Whitespace and lines ; beginning with a semicolon are silently ignored (as you probably guessed). ; Section headers (e.g. [Foo]) are also silently ignored,...

    8-07-14_MegaCLI for linux_windows

    LSIP200232921 (DFCT) MegaCLI displays version for PD in unclear format and the data is not aligned correctly LSIP200232954 (DFCT) Need to Support all the MFC default values in the command AdpSettings...

    asp.net mvc

    Open the project file in a text editor (the file with the .csproj or .vbproj file extension) and find the ProjectTypeGuid element. As the value of that element, replace the GUID {603c0e0b-db56-11dc-be...

    Turbo C 2.00[DISK]

    answers to problems that aren't covered in this file or in the manuals. o If you are running INSTALL or TCINST on a laptop or any other system that uses an LCD or composite display, you should ...

    IOS5 Programming Cookbook

    - **Method Implementation**: Methods are implemented in the `.m` file corresponding to the class. Method implementations include the logic for performing tasks and interacting with properties. - **...

    编译好的x265,带y4m文件

    Syntax: x265 [options] infile [-o] outfile infile can be YUV or Y4M outfile is raw HEVC bitstream Executable Options: -h/--help Show this help text and exit -V/--version Show version info and exit ...

Global site tag (gtag.js) - Google Analytics