Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Tmux Getting Start (Linux)

- Monitoring Linux System 7 command-line tool (Linux)

- Linux operating system, the internal and external security overview (Linux)

- The principle Httpclient4.4 (HttpClient Interface) (Programming)

- Linux / UNIX: Use the dd command to create a 1GB size binary (Linux)

- Linux firewall to prevent external network attacks (Linux)

- A custom implementation of the Android sidebar (Programming)

- Fedora 19/20 and Debian Jessie / Sid users to install FFmpeg 2.3.2 (Linux)

- Android Custom View step (Programming)

- Linux Getting Started tutorial: How to backup Linux systems (Linux)

- Oracle database with test data insertion speed (Database)

- CentOS minimal network is unavailable resolved (Linux)

- Recover accidentally deleted Nginx logs (Server)

- Nine tips to protect the security of Linux desktop (Linux)

- Linux Beginner Guide: Installing packages on Ubuntu and Fedora (Linux)

- Linux System Getting Started Learning: complete installation on Debian or Ubuntu kernel source (Linux)

- A list of the basics of Python, Ganso, Dictionary (Programming)

- Install and configure GO 1.2.1 under CentOS 6.5 (Linux)

- The difference between vi and nano (Linux)

- Iptables Instructions (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:      
 
- Linux linux system security (Linux)
- MySQL to NoSQL avatar (Database)
- Archive log file size and redo log file size relationship (Database)
- New features of Java 9 HTTP2 and REPL (Programming)
- Oracle 11g How dataguard master repository to Oracle single instance data recovery (Database)
- Tune in high resolution to 1280x800 in Fedora 14 (Linux)
- C ++ containers (Programming)
- CentOS7 + Redis Live Installation and Configuration (Linux)
- Ubuntu 14.04 compile and install Apache (Server)
- Install Oracle database error process of [INS-35172] (Database)
- Linux Thread Synchronization (Programming)
- Android start automatically and add and delete a desktop shortcut (Programming)
- Android memory optimization of the optimal load Bitmap (Linux)
- Exploring the Android Listview display confusion (Programming)
- Graphics of Java Tools (Programming)
- Based on OpenSSL for HTTPS service configuration (Server)
- Use calcurse schedule appointments and to-do in the Linux terminal (Linux)
- Create several practical points of high security PHP site (Linux)
- Briefly explain the invasion of the four-level denial of service attack DoS Linux server (Linux)
- Spring Data study notes -Helloworld (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.