MySQL INSERT Query How To Add Data To Database Table

Forums Index
» MYSQL Forums
» » MySQL INSERT query how to add data to database table

MySQL INSERT Query How To Add Data To Database Table
Post Description:
Post Tags: mysql, insert, query, how, to, add, data, to, database, table, mysql database, support, help, answers, questions, help
This Post Has Been Viewed 943 Times Since Tue Feb 19, 2008 8:47 pm Posted By hostman with 0 replies

MySQL INSERT Query How To Add Data To Database Table

to add information into a mysql database table, its called INSERT

this is an example:

lets say i have a web form and i want to add a user to the user table i would send this sql query,
the user submits this information:
username = eric
password = mypass

so this is how i would insert this information into my database

PHP CODE:

$sql = "INSERT INTO table (username, password) VALUES ('eric','mypass')"

another way to send this mysql query would be like this:

PHP CODE:

$sql = "INSERT INTO table SET username = 'eric', password ='mypass'"

Leave Your Comments

Share
URL:

You can use this HTML code to put it on your website to show your friends this wallpaper. Use this code on your profile like myspace, friendster, Facebook or others. Just Copy and Paste it in your HTML on your websites

Fourms BBCODE:

BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on your Posts and Replies on your forums

Comments and replies About MySQL INSERT Query How To Add Data To Database Table

(0) Comments