Bab 22 Membuat Database dan Tabel

Bab 22 Membuat Database dan Tabel Membuat Database CREATE DATABASE database_name Program24-1.php Membuat Tabel CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, ....... ) Program24-2.php Tipe Data di MySQL Numeric Data Types Description int(size) smallint(size) tinyint(size) mediumint(size) bigint(size) Integers terus saja. Maksimum jumlah digit dapat ditentukan dalam parameter ukuran decimal(size,d) double(size,d) float(size,d) Hold numbers with fractions. The maximum number of digits can be specified in the size parameter. The maximum number of digits to the right of the decimal is specified in the d parameter Textual Data Types Description char(size) Holds a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis varchar(size) Holds a variable length string (can contain letters, numbers, and special characters). The maximum size is specified in parenthesis tinytext Holds a variable string with a maximum length of 255 characters text blob Holds a variable string with a maximum length of 65535 characters mediumtext mediumblob Holds a variable string with a maximum length of 16777215 characters longtext longblob Holds a variable string with a maximum length of 4294967295 characters Date Data Types Description date(yyyy-mm-dd) datetime(yyyy-mm-dd hh:mm:ss) timestamp(yyyymmddhhmmss) time(hh:mm:ss) Holds date and/or time Misc. Data Types Description enum(value1,value2,ect) ENUM is short for ENUMERATED list. Can store one of up to 65535 values listed within the ( ) brackets. If a value is inserted that is not in the list, a blank value will be inserted set SET is similar to ENUM. However, SET can have up to 64 list items and can store more than one choice Primary Keys dan Auto Increment Fields $sql = "CREATE TABLE Person ( personID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(personID), FirstName varchar(15), LastName varchar(15), Age int )"; mysql_query($sql,$con);