Finding last inserted autoincrement id value

Suppose you have table like
User Table with fields id(auto increment) and name
address table with field id(auto increment), address, user_id(foreign key)
when u inserted one row in user table then u want the last inserted id value in user table to insert it into address table in the field user_id for that corresponding user address entry
use mysql [...]

Read Full Post »

Import or Export A Database

This section deals with mysqldump which is a tool to import and export MySQL databases.
It can be used to back up a database or to move database information from one server to another.
1. Export A MySQL Database
This example shows you how to export a database. It is a good idea to export your data [...]

Read Full Post »

Importing and Exporting data from csv/txt file to table

Importing
The example below imports data from .txt file into table testtable.
temp.txt file is a tab separated file:
“1 string”      100
“2 string”      102
“3 string”      104
“4 string”      106
testtable structure

CREATE TABLE testtable
(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
text varchar(45) NOT NULL,
price integer not null);
 
query = “LOAD DATA INFILE ‘”+filename+
    “‘ INTO TABLE testtable (text,price);”; 
 
If you want to [...]

Read Full Post »