Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Android Studio utility plug organize, create sharp artifact (Programming)

- VirtualBox installation enhancements let the mouse move and share CentOS 6.4 (Linux)

- Oracle 11g RMAN virtual private directory (Database)

- Four levels to deal with Linux server attacks (Linux)

- Binary search is really easy as you think you do (Programming)

- Linux GCC 5.1.0 compiler installation (Linux)

- How to install the client sqlplus under linux (Database)

- Terminal Linux command prints - echo (Linux)

- Rails 4.1.6 start being given Could not find a JavaScript runtime (Linux)

- Linux operating system security management skills (Linux)

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

- FastDFS installation and deployment (Server)

- How to install or upgrade to the Linux kernel in Ubuntu 4.2 (Linux)

- MySQL5.7.10 installation documentation (Database)

- LVS + Keepalived the DR mode (Server)

- Sqoop data export import command (Database)

- MySQL Server Time Synchronization Problem (Database)

- About MongoDB query method according to fuzzy field (Database)

- Apache Mina framework Practice (Programming)

- Linux - EXT2 file system is described in detail (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 wifi-linux AP signal strength detection (Linux)
- Compile and install Memcached can not find GCC (Programming)
- Create a project using Android Studio LinearLayout (Programming)
- mysqldump implement database logical backup (Database)
- Ubuntu install Avast antivirus software (Programming)
- Job achieve automation in Ubuntu 14.04 - Using Cron (Linux)
- sqlplus connect to Oracle (Database)
- File compression and packaging commands under Linux (Linux)
- Linux Change ssh port and disable remote root login at (Linux)
- Retro terminal in Linux (Linux)
- Use Ganglia to monitor your cluster (Server)
- C language binary tree counts words (Programming)
- Comparison of one-time transaction and CTE insert data (Database)
- Oracle 12c of the auto-increment Identity Columns (Database)
- AngularJS - Getting Started with Routing (Programming)
- MongoDB upgrade to 2.6 (Database)
- Linux and hardware (Linux)
- Redis is installed in Ubuntu 14.04 (Database)
- The Java way to stop a thread of execution (Programming)
- Use SocketServer write a sockets program (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.