華府江山 http://203.72.56.8/phpBB3/ |
|
Create Table,Insert Data,Update Data,Delete Data http://203.72.56.8/phpBB3/viewtopic.php?f=42&t=684 |
第 1 頁 (共 1 頁) |
發表人: | alex [ 2011年 10月 16日, 14:31 ] |
文章主題 : | Create Table,Insert Data,Update Data,Delete Data |
Create Table: <?php // Connects to your Database mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error()); mysql_select_db("Database_Name") or die(mysql_error()); mysql_query("CREATE TABLE tablename ( name VARCHAR(30), age INT, car VARCHAR(30))"); Print "Your table has been created"; ?> ========================================== Insert Data: <?php // Connects to your Database mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error()); mysql_select_db("Database_Name") or die(mysql_error()); mysql_query("INSERT INTO tablename VALUES ( 'Bill', 29, 'Ford' ), ( 'Mike', 16, 'Beetle' ), ( 'Alisa', 36, 'Van' )"); Print "Your table has been populated"; ?> =========================================== Update Data: <?php $con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); mysql_query("UPDATE Persons SET Age = '36' WHERE FirstName = 'Peter' AND LastName = 'Griffin'"); mysql_close($con); ?> ========================================= Delete Data: <?php $id=$_POST['id']; $db="newdb"; $link = mysql_connect("localhost", "root", ""); if (! $link) die("Couldn't connect to MySQL"); mysql_select_db($db , $link) or die("Couldn't open $db: ".mysql_error()); mysql_query("DELETE FROM birthdays WHERE id=$id"); mysql_close($link); ?> ======================================== |
發表人: | alex [ 2011年 11月 4日, 11:01 ] |
文章主題 : | Re: Create Table,Insert Data,Update Data,Delete Data |
CREATE TABLE guestbook (entryno SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(30),Email VARCHAR(30), Comment VARCHAR(30), Datetime DATETIME); |
發表人: | alex [ 2011年 11月 4日, 11:04 ] |
文章主題 : | Re: Create Table,Insert Data,Update Data,Delete Data |
mysql> CREATE TABLE names (contact_id SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName CHAR(20), LastName CHAR(20), BirthDate DATE); mysql> CREATE TABLE address(contact_id SMALLINT NOT NULL PRIMARY KEY, StreetAddress CHAR(50), City CHAR(20), State CHAR(20), Zip CHAR(15), Country CHAR(20)); mysql> CREATE TABLE telephones (contact_id SMALLINT NOT NULL PRIMARY KEY, TelephoneHome CHAR(20), TelephoneWork(20)); mysql> CREATE TABLE email (contact_id SMALLINT NOT NULL PRIMARY KEY, Email CHAR(20)); mysql> CREATE TABLE company_details (contact_id SMALLINT NOT NULL PRIMARY KEY, CompanyName CHAR(25), Designation CHAR(15)); |
發表人: | alex [ 2011年 11月 4日, 11:27 ] |
文章主題 : | Re: Create Table,Insert Data,Update Data,Delete Data |
# MySQL dump 8.2 # # Host: localhost Database: contacts #-------------------------------------------------------- # Server version 3.22.34-shareware-debug # # Table structure for table 'address' # CREATE TABLE address ( contact_id smallint(6) DEFAULT '0' NOT NULL, StreetAddress char(50), City char(20), State char(20), Zip char(10), Country char(20), PRIMARY KEY (contact_id) ); # # Dumping data for table 'address' # INSERT INTO address VALUES (1,'300 Yamila Ave.','Los Angeles','CA','300012','USA'); INSERT INTO address VALUES (2,'4000 Nikki St.','Boca Raton','FL','500034','USA'); INSERT INTO address VALUES (3,'404 Tia Blvd.','New York','NY','10011','USA'); # # Table structure for table 'company_details' # CREATE TABLE company_details ( contact_id smallint(6) DEFAULT '0' NOT NULL, CompanyName char(25), Designation char(20), PRIMARY KEY (contact_id) ); # # Dumping data for table 'company_details' # INSERT INTO company_details VALUES (1,'Xerox','New Business Manager'); INSERT INTO company_details VALUES (2,'Cabletron','Customer Support Eng'); INSERT INTO company_details VALUES (3,'Apple','Sales Manager'); # # Table structure for table 'email' # CREATE TABLE email ( contact_id smallint(6) DEFAULT '0' NOT NULL, Email char(20), PRIMARY KEY (contact_id) ); # # Dumping data for table 'email' # INSERT INTO email VALUES (1,'yamila@yamila.com'); INSERT INTO email VALUES (2,'nikki@nikki.com'); INSERT INTO email VALUES (3,'tia@tia.com'); # # Table structure for table 'names' # CREATE TABLE names ( contact_id smallint(6) DEFAULT '0' NOT NULL auto_increment, FirstName char(20), LastName char(20), BirthDate date, PRIMARY KEY (contact_id) ); # # Dumping data for table 'names' # INSERT INTO names VALUES (3,'Tia','Carrera','1975-09-18'); INSERT INTO names VALUES (2,'Nikki','Taylor','1972-03-04'); INSERT INTO names VALUES (1,'Yamila','Diaz','1974-10-13'); # # Table structure for table 'telephones' # CREATE TABLE telephones ( contact_id smallint(6) DEFAULT '0' NOT NULL, TelephoneHome char(20), TelephoneWork char(20), PRIMARY KEY (contact_id) ); # # Dumping data for table 'telephones' # INSERT INTO telephones VALUES (1,'333-50000','333-60000'); INSERT INTO telephones VALUES (2,'444-70000','444-80000'); INSERT INTO telephones VALUES (3,'555-30000','555-40000'); |
第 1 頁 (共 1 頁) | 所有顯示的時間為 UTC + 8 小時 |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |