Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Golang use Oracle database on Ubuntu 14.04 (Linux)

- AWK principles and commands and file input (Linux)

- Scope of variables in C # (Programming)

- Java Network Programming Internet address lookup (Programming)

- How to deploy Python Web application: Heroku deployment process complete records (Server)

- Node.js developers must know four JavaScript concepts (Programming)

- JavaScript in this usage (Programming)

- PHP CURL get cookies simulated login (Database)

- Linux environment RabbitMQ installation and monitoring of plug-in installation (Linux)

- Security: Unix operating system intrusion tracking Strikes Back (Linux)

- CentOS 5.8 (64) Python 2.7.5 installation error resolved (Linux)

- Several SQL Server data migration / Export Import Practice (Database)

- Cacti installation deployment under CentOS 6.6 (Server)

- OpenGL ES 3.0 vertex buffer (Programming)

- command-line tool for send e-mail (Linux)

- RedHat yum configuration and the prompt (Linux)

- Ubuntu install Scala 2.10.x version (Linux)

- Struts2 study notes -Valuestack (value stack) and OGNL expression (Programming)

- MySQL view (Database)

- The YUM package management under Linux (Linux)

 
         
  MySQL bulk insert data script
     
  Add Date : 2018-11-21      
         
         
         
  MySQL bulk insert data script

#! / Bin / bash
i = 1;
MAX_INSERT_ROW_COUNT = $ 1;
while [$ i -le $ MAX_INSERT_ROW_COUNT]
do
     mysql -uroot -proot dbname -e "insert into tablename (name, age, createTime) values ( 'HELLO $ i', $ i% 99, NOW ());"
     d = $ (date +% M-% d \% H :% m :% S)
     echo "INSERT HELLO $ i @@ $ d"
     i = $ (($ i + 1))
     sleep 0.05
done

exit 0

New forms can be
create table afs_test (
name varchar () 32,
age int (32),
createTime datetime

Insertion of thousands of data ./jiaoben.sh 100000
     
         
         
         
  More:      
 
- Tomcat configuration memory and remote debug port (Server)
- CentOS yum source deployment (Linux)
- Quick paging ROW_NUMBER conducted (Database)
- DOM event handlers add notes (Programming)
- Shell Programming Regular Expressions (Programming)
- Python basis: os module on the file / directory using methods commonly used functions (Programming)
- Oracle 11g RAC installation considerations Miscellany (Database)
- Java synchronization mechanism used in locking Thought (Programming)
- Linux network security probing tools Hping2 (Linux)
- JavaScript notes --Objects (Programming)
- CentOS7 installation GAMIT and GMT (Linux)
- Linux Man Page Installation (Linux)
- Virtual Judge environment to build and configure under Ubuntu (Server)
- PostgreSQL Source Customization: Online global read only (Database)
- Rely on IP chain established Linux firewall (Linux)
- Change all child files and subdirectories in the owner permissions Ubuntu (Linux)
- AngularJS (Programming)
- Java developers question (Programming)
- UNIX how to restrict users by IP Telnet (Linux)
- Ubuntu 14.04 LTS installed Hadoop 1.2.1 (distributed cluster mode) (Server)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.