Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Setting Lns firewall against ARP attacks (Linux)

- Java class HashSet (Programming)

- The traffic monitoring system: cacti (Linux)

- Storm basic framework for analysis (Programming)

- Memcached distributed caching (Server)

- Get the Linux device PCI ID method (Linux)

- Use Ansible to bulk manage remote servers (Server)

- Configuring a Linux operating system security management services (Linux)

- Nginx Load Balancing (standby) + Keepalived (Server)

- How to Install Node.js in CentOS 7 (Linux)

- Linux System Getting Started Learning: In RedHat Linux driver compiled Ixgbe (Linux)

- SecureCRT 7.0 Log Ubuntu 12.04 server via SSH service under Vmware (Server)

- Linux firewall iptables beginner tutorial (Linux)

- Ubuntu Control Panel to resolve network-manager icon display issue (Linux)

- SELinux security permissions HTTP + PHP service changes (Server)

- Linux System Getting Started Learning: Linux in the last command (Linux)

- ethtool command Detailed (Linux)

- Linux script commands - terminal recorder (Linux)

- CentOS / Linux install VNC Server (Linux)

- CentOS NAT iptables (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 to make a U disk to install Ubuntu (Linux)
- E: Sub-process / usr / bin / dpkg returned an error code (1) error solution (Linux)
- MongoDB3.0.x version of the user authorization profile (stand-alone environment) (Database)
- How to install and use the Snort in Ubuntu 15.04 (Linux)
- RedHat 6 xrdp use remote login interface (Linux)
- To install the Git and Github under Ubuntu (Linux)
- Zend Studio PHP syntax color scheme to export (Linux)
- See how --nand flash timing diagram of a read operation Comments (Programming)
- An Analysis of the C Algorithm for Calculating the Number of Days Between Date (Programming)
- Minimum period string problem (Programming)
- ASM Management - How to Rename diskgroup (Database)
- Nginx reverse proxy and self-signed https (Server)
- Oracle 11g RMAN virtual private directory (Database)
- Use the top command (Linux)
- GROUP BY extension (Database)
- Build your own CA services: OpenSSL command line CA Quick Guide (Server)
- OpenGL Superb Learning Notes - Vertex Shader example (Programming)
- MySQL 5.7 can not log in problem (Database)
- J2EE Example of Filter (Programming)
- Installation in lxml Python module (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.