Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Java rewrite the hashcode method (Programming)

- Ubuntu 14.04 LTS installed Hadoop 1.2.1 (distributed cluster mode) (Server)

- DIY security of Linux platform (Linux)

- Detailed use Zabbix monitoring Nginx (Server)

- Linux account related documents Interpretation (Linux)

- Use Tails 1.4 Linux system to protect the privacy and anonymity (Linux)

- Four Methods of Self - Learning Linux (Linux)

- How to add two-factor authentication for Linux systems SSH (Linux)

- Ten correct use Redis skills (Database)

- Oracle rebuild index script (Database)

- RHEL (RedHat) 6.3 using EPEL Yum source (Linux)

- Linux, set and view environment variables (Linux)

- Chrome plug-in management, online-offline installation, part of the plug presentations (Linux)

- zBackup: A versatile tool to remove duplicate backup (Linux)

- installation process of Matlab 2012a under Ubuntu 14.04 (Linux)

- PyCharm new Python file name and the name of the module will import the same problem might arise (Programming)

- Ubuntu 14.10 splash screen brightness settings (Linux)

- iptables using summary (Linux)

- Ora-14450: attempt to access ah transactional temptable already in use (Database)

- To help you easily protect the Linux System (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:      
 
- VNC configuration detailed analysis under Linux (Linux)
- Workaround CentOS error message during compilation PHP5 common (Linux)
- How to configure MongoDB replica set (Database)
- Linux Open coredump (Linux)
- How to upgrade to Ubuntu 14.04 Ubuntu 14.10 (Linux)
- Ubuntu How to install Pacman (Linux)
- Android determine the device network connection status, and determine the connection (Programming)
- Linux6.1 / 6.5 dual-NIC Binding (Linux)
- To install Jetty server configuration in detail (Server)
- LAN in Ubuntu shared folders to Windows (Linux)
- Linux server operating system security configuration (Linux)
- Linux Command Tutorial: cat command to view the contents of the file (Linux)
- Android Sets the system screen brightness (Programming)
- How to install new fonts on Ubuntu 14.04 and 14.10 (Linux)
- Nagios (centreon) monitoring Linux Log (Server)
- Four IDS intrusion detection tool under Linux environment (Linux)
- Installation image conversion tool on your Ubuntu Converseen 0.8.1 (Linux)
- Install RAID 6 (Striping double distributed parity) (Linux)
- Tmux Crash Course: Tips and adjustment (Linux)
- Ubuntu security settings and tools (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.