Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Linux file compression and file system packaged with instructions (Linux)

- Android basics summary article (Programming)

- Nodejs nano library to handle couchdb: need a timeout (Database)

- Monitoring network traffic with Iptraf in Linux environment (Linux)

- Java rewrite equals method (Programming)

- Linux environment variable settings and save places (Linux)

- Flask installation environment (Linux)

- Bash environment is automatically install and initialize oh-my-zsh & autojump zsh (Linux)

- Linux, modify the hostname (Linux)

- Depth understanding of C language (Programming)

- AngularJS - Custom instructions (Programming)

- jQuery get value drop-down list and select text (Programming)

- How to extend / remove swap partitions (Linux)

- 11G ASM disk group does not automatically handle MOUNT (Database)

- Multi-core CPU, multi-threading and parallel computation (Linux)

- Use Nginx as a load balancer (Server)

- Git Advanced Tutorial (Linux)

- a virtual machine created migrated to host RHEL6.4 on Ubuntu 14.04 (Linux)

- C # DateTime structure common method (Programming)

- Linux configuration Samba server (Server)

 
         
  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:      
 
- Programmer editor Vim (Linux)
- History and Statistics tuptime use tools to view Linux server system boot time (Server)
- Oracle Linux 5.5 (64bit) Install Oracle 11gR2 RAC detailed tutorial (Database)
- Linux, Chrome browser font settings beautification (Linux)
- Docker: Mirroring and container operations (Server)
- Kafka + Log4j log implement centralized management (Server)
- Linux install deploy Ansible (Linux)
- CentOS 6.5 using Virtualenv under development environment to build Python3 (Linux)
- The array of C language (Programming)
- libreadline.so.6: can not open shared object file problem solution (Linux)
- Linux System Getting Started Learning: The Linux command line burn ISO or NRG image to DVD (Linux)
- RedHat Linux 6 desktop installation (Linux)
- C ++ precision performance test function (Programming)
- Initialization and starting process of Linux (Linux)
- Linux system performance monitoring with Nmon (Linux)
- Permissions and attributes of files and directories under Linux (Linux)
- CentOS 6.4 dial-up Raiders (Linux)
- MySQL uses mysqld_multi to deploy stand-alone multi-instance detail procedures (Database)
- Install OpenGL development environment in Fedora and Ubuntu (Linux)
- Debian 7.7 Installation and Configuration (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.