Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Installing PHP Memcache extension under Linux (Server)

- Linux command binlog by filtering out the complete SQL statement (Database)

- Linux configuration startup mount: fstab file (Linux)

- Linux NIC driver and version information (Linux)

- Xmanager Remote Desktop login CentOS 6.5 (Linux)

- Ubuntu and Derivatives users install the latest KKEdit 0.0.31 (Linux)

- TNS-03505 name could not be resolved (Database)

- Linux data redirection (Linux)

- About Leetcode on Binary Tree Algorithm summary (Programming)

- How to install Docker and basic usage on Ubuntu 15.04 (Server)

- Install Rubinius testing Ubuntu 14.04 native threads (Linux)

- Java keyword final, static (Programming)

- Docker in the development and practice of IFTTT (Server)

- Moosefs Distributed File System Configuration (Server)

- WebLogic administrator account and reset the password (Database)

- Oracle set and remove columns unavailable (Database)

- Linux security-related basics (Linux)

- Linux cron job (crontab) Examples (Linux)

- Use SocketServer write a sockets program (Programming)

- Stucts2 values on the page and how the attribute values corresponding to the Action (Programming)

 
         
  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:      
 
- File upload via AngularJS and ASP.NET MVC5 (Programming)
- XenServer Virtual Machine Installation --- first ISO image file storage expansion (Linux)
- MySQL & NoSQL - Memcached widget (Database)
- 10 practical Java programming technology (Programming)
- Gentoo: startx appeared Failed to load module Problem Solving (Linux)
- Oracle 11g 10g induced into error (Database)
- Install Ubuntu 14.04 and Windows 8 / 8.1 dual-boot in UEFI mode (Linux)
- Source Analysis: Java object memory allocation (Programming)
- Thinking in Java study notes - initialization and cleanup (Programming)
- Linux find command usage practices (Linux)
- Static member variable modified (Programming)
- Linux Apache server configure to protect system security (Linux)
- Java data structures - order linear form of table ArrayList (Programming)
- Using nmcli commands to manage network in RedHat / CentOS 7.x (Linux)
- Django how to generate content in non-HTML formats (Programming)
- Differences Shell scripting languages and compiled languages (Programming)
- To install MySQL 5.6 binary packages under CentOS 6.4 64bit (Database)
- ssh using scp: / directory: Permission denied (Server)
- Install Java on RHEL6 (Linux)
- How to build a container cluster (Server)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.