Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Systemd on RHEL7 (Linux)

- MySQL view (Database)

- How to Debian Linux the default Python version switch to alternative version (Linux)

- Linux System Getting Started tutorial: Ubuntu desktop using the command line to change the system proxy settings (Linux)

- Linux system security reinforcement (Linux)

- How Bluetooth turned off by default in Ubuntu 14.04 (Linux)

- Python 3 for instructions encoded string conversion (Programming)

- Sqoop data export import command (Database)

- Eclipse-ee Tomcat browser can not start Tomcat, and Web project service deployment (Server)

- Through eight skills to let you become a super Linux end-user (Linux)

- how to quickly find a file on Linux system (Linux)

- Linux kernel to achieve soft RPS network to receive soft interrupt load balancing to distribute (Linux)

- The basic principle of pointers in C ++ (Programming)

- Oracle database import and export (Database)

- How to Install Apache on Linux servers (Server)

- Oracle 11g forget approach SYS and SYSTEM password (Database)

- AngularJS notes --- Data Binding (Programming)

- Linux kernel source code analysis (Linux)

- CentOS7 management of systemd (Linux)

- Linux System Getting Started Learning: install software packages on Ubuntu and Fedora (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:      
 
- How LUKS encrypted disk / partition to perform remote incremental backup (Linux)
- Single-node Hadoop environment to build (Server)
- MySQL Error Code Complete (Database)
- Make command tutorial (Linux)
- Ubuntu derivative version of the user and how to install SmartGit / HG 6.0.0 (Linux)
- Sort sql MySQL 5.6 upgrade slow Cause Analysis (Database)
- Use Git in Eclipse (Linux)
- RHEL5.x RHEL6.x replace CentOS yum source (Linux)
- Linux / Unix desktops interesting: Christmas tree on the terminal (Linux)
- CentOS 7.0 running Docker kernel error solution (Server)
- Compiled version of Android Opus audio codec library method (Programming)
- 11.2.04 Oracle RAC directory crfclust.bdb file is too large, Bug 20186278 (Database)
- Installation of network monitoring ntopng under CentOS 6.4 (Linux)
- Linux console password solution (Programming)
- Oracle to start to solve the error ORA-27102 (Database)
- Switching Virtual Machine + Ubuntu graphical interface and terminal interface (Linux)
- CentOS 6 rapid deployment of Java applications (Linux)
- Clojure programming languages: take full advantage of the Clojure plug-in Eclipse (Programming)
- 10 tips daily Docker (Server)
- To install GCC development environment under SUSE11 (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.