Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL bulk insert data script     - Debian users to install FFmpeg 2.2.2 (Linux)

- ASM Management - How to Rename diskgroup (Database)

- floating IP in OpenStack neutron (Server)

- CentOS / Linux install VNC Server (Linux)

- Git delete files (Linux)

- SecureCRT remote connection Ubuntu fails to solve the case (Linux)

- Correlation Analysis: FP-Growth algorithm (Programming)

- Linux Telnet access Windows 7 configuration procedure (Linux)

- Linux installed and tested the deployment of Kafka distributed cluster (Server)

- Raspberry Pi 2 to install the latest version of the FPC and Lazarus 1.5 (Linux)

- Three binary tree traversal (recursive, non-recursive traversal and Morris) (Programming)

- Linux rights management (Linux)

- Ubuntu under VirtualBox virtual machine serial port settings (Linux)

- Shell Programming points to note about the function (Programming)

- Build Python3.4 + PyQt5.3.2 + Eric 6.0 development platform Ubuntu 14.04 (Server)

- Piostat - Monitoring and Statistics Linux process (Linux)

- Linux console password solution (Programming)

- How to configure Proftpd server on Fedora 22 (Server)

- RHEL7 system making use of OpenStack mirror (Linux)

- Help you enhance Python programming languages 27 (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:      
 
- Java thread pool: ExecutorService, Executors (Programming)
- How to install Git on CentOS 7 (Linux)
- Error code: 2013 Lost connection to MySQL server during query (Database)
- VPS xen openvz kvm (Server)
- Linux permissions Detailed (Linux)
- Ubuntu install the camera driver (Linux)
- Summary Linux bond of multi-interface load balancing (Linux)
- To use Android RecyclerView (Programming)
- shell script: the number of characters in the text to print no more than 6 words (Programming)
- exp / imp Export Import version of the problem and the ORA-6550 error (Database)
- Linux linux system security (Linux)
- Oracle JDK installation under Ubuntu Linux (Linux)
- Oracle database physical file backup / restore (Database)
- AngularJS (Programming)
- Partition contrast manifestations under Windows and Linux (Linux)
- View processes and threads under Linux (Linux)
- GDB remote connections RX Probe online debug program (Programming)
- linux smartd [FAILED] appears at startup (Linux)
- Ubuntu modify locale problem solving (Linux)
- Why learn Java EE (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.