Archive for ◊ 2010 ◊

contacts

    photo of amanda {$surname} amanda bromley
    Jellifish Internet Services Ltd

    , , ST6 4AT
    Map of Jellifish Internet Services Ltd
    GEO: ,
    Yahoo Map - Live Map
    Amanda mobile:07932 717718 Paula mobile: 078122 01801 Office: 01782 258843 Home: 01538 752064
    photo of martyn {$surname} martyn deane
    Tactix Consultancy Limited

    , ,
    07515 053777
    Map of Tactix Consultancy Limited
    GEO: ,
    Yahoo Map - Live Map
    Jennifer (ref)
    photo of Shabbar {$surname} Shabbar Abbas
    virtual design

    ISLAMABAD
    PAKISTAN , ,
    0343 5149816
    Map of virtual design
    GEO: ,
    Yahoo Map - Live Map

Category: Apache  | Comments off
Mysql common queries

To view database tables details:

How change tables database engine:

How read and import csv file data:

LOAD DATA
LOCAL INFILE ‘C:/uk.csv’
INTO TABLE myTable
FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ (
id,
tableField1,
tableField2,
tableField3
);
SHOW WARNINGS;

How insert data using select query in mysql:

INSERT INTO new_table (date,record_id,data_field)
SELECT date, record_id, data_field FROM old_table
ON DUPLICATE KEY UPDATE date=old_table.data, data_field=old_table.data_field;

Category: All Tutorials  | Leave a Comment
How to install Mysql server

Step:1 Download latest Mysql from:
http://dev.mysql.com/downloads/mysql/5.1.html#win32 (Windows Essentials (x86))

Step:2 Then run installer.

Category: All Tutorials  | Leave a Comment
MYSQL Server Tutorial

Some MYSQL tutorials are folloing below:

Category: MYSQL  | Leave a Comment
                         Freelance reliable, timely services within your budget.
       ©2009 - www.999solutions.com | Freelance Web Solutions, Services and Consultancy