Wiki

Articles tagged with "mysql", sorted by date (updated)X
Displaying 1-5 of 5 result(s).

mysql performance tip

Updated about a month ago by sirin kTips2 comments – viewed 10,143 times – ( +2 / -2 ) – version 1.1
When we are doing an insert of huge no.of rows into an SQL table ,Normally we will try to write separate insert quries this may lead us to a long duration of execution time and we can increase the speed of executing SQL quries by adding all the rows into a single insert query.
tags: mysql

Importing CSV file to mysql table using "LOAD DATA" command.

Updated about a month ago by sirin kTips6 comments – viewed 48,604 times – ( +7 / -1 ) – version 1.1
hi, Here i am giving you some simple step to import huge data from a csv file to your mysql table.this is useful when you have a very huge data to import from csv format.
tags: csv, mysql, import

How to use nested DB transactions (MySQL 5+, PostgreSQL)

Updated about a year ago by BoazHow-tos6 comments – viewed 43,421 times – ( +47 / -1 ) – version 1.1
Original source code and idea are from: PHP, PDO & Nested Transactions.

Speedup unit tests by moving MySql data to memory (in Ubuntu)

Updated 4 years ago by François GannazTips0 comments – viewed 14,071 times – ( +1 / -2 ) – version 1.1
Speedup unit tests by moving MySql data to memory [Ubuntu]
tags: mysql, unit test

Windows Web Development With AMPPS, NetBeans and XDebug

Updated 5 years ago by macinvilleTutorials1 comment – viewed 26,340 times – ( +4 / -1 ) – version 1.1
This article will discuss how to setup your web development environment with the following specifications: