# mysql -v -v -v -u yourusername company_contact # mysqladmin create company_contact # mysqlshow company_contact # mysqldump -v company_contact # mysqlaccess company_contact # INT = 4 Byte = FFFFFFFF = 4294967295 # MEDIUMINT = 3 Byte = FFFFFF = 16777215 # SMALLINT = 2 Byte = FFFF = 65535 # TINYINT = 1 Byte = FF = 255 # all _id fields are numbers in tables # names ARE case sensitive! # show tables; select * from Contact_Table; +------------+------------------+------------------+-------------------+--------------------+-------------------+-----------------------+-----------------+ | contact_id | contact_fullname | contact_password | contact_company | contact_inceptdate | contact_lastvisit | contact_visit_counter | contact_message | +------------+------------------+------------------+-------------------+--------------------+-------------------+-----------------------+-----------------+ | 1 | electronicarts | owkIRCavqSY8I | Electronic Arts | 2000-06-22 | 0000-00-00 | 0 | | | 2 | daevid | MYsnuETIkjyzU | WildTangent, Inc. | 2000-06-22 | 0000-00-00 | 0 | | | 3 | esri | aW7ol14Z1YDdc | ESRI | 2000-06-22 | 0000-00-00 | 0 | | | 4 | infospace | xFaQIMF16lFwU | InfoSpace | 2000-06-22 | 0000-00-00 | 0 | | | 5 | leviathon | WX/K6LOdqU3aQ | Leviathon | 2000-06-22 | 0000-00-00 | 0 | | | 6 | lowearthorbit | 3nqCnV3DNPWLg | Low Earth Orbit | 2000-06-22 | 0000-00-00 | 0 | | | 7 | markbarrett | itl97XKcfWIoM | Mark Barrett | 2000-06-22 | 0000-00-00 | 0 | | | 8 | microsoft | Mue9qOVHe6PnQ | Microsoft | 2000-06-22 | 0000-00-00 | 0 | | | 9 | microstandard | 7ZCs.RzRNgGcw | MicroStandard | 2000-06-22 | 0000-00-00 | 0 | | | 10 | popcom | e4YZMVRUyi5Ek | Pop.com | 2000-06-22 | 0000-00-00 | 0 | | | 11 | preference | nkqwTdNiVFxrk | Preference | 2000-06-22 | 0000-00-00 | 0 | | | 12 | radiointercast | iC8ejs3mOKS4Q | Radio Intercast | 2000-06-22 | 0000-00-00 | 0 | | | 13 | zcom | cZMY75hVUYKmU | Z.com | 2000-06-22 | 0000-00-00 | 0 | | +------------+------------------+------------------+-------------------+--------------------+-------------------+-----------------------+-----------------+ 13 rows in set (0.00 sec) ###drop table Contact_Table; CREATE TABLE Contact_Table ( contact_id mediumint(10) DEFAULT '0' NOT NULL auto_increment, contact_fullname varchar(30) DEFAULT '0' NOT NULL, contact_password varchar(20) DEFAULT '0' NOT NULL, contact_company varchar(50) DEFAULT '0' NOT NULL, contact_inceptdate date DEFAULT '0000-00-00' NOT NULL, contact_lastvisit date DEFAULT '0000-00-00' NOT NULL, contact_visit_counter mediumint(5) DEFAULT '0' NOT NULL, contact_message tinyblob NOT NULL, PRIMARY KEY (contact_id), KEY contact_password (contact_password), KEY contact_fullname (contact_fullname) ); insert into Contact_Table values (null,'electronicarts','owkIRCavqSY8I','Electronic Arts','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'esri','aW7ol14Z1YDdc','ESRI','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'infospace','xFaQIMF16lFwU','InfoSpace','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'leviathon','WX/K6LOdqU3aQ','Leviathon','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'lowearthorbit','3nqCnV3DNPWLg','Low Earth Orbit','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'markbarrett','itl97XKcfWIoM','Mark Barrett','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'microsoft','Mue9qOVHe6PnQ','Microsoft','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'microstandard','7ZCs.RzRNgGcw','MicroStandard','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'popcom','e4YZMVRUyi5Ek','Pop.com','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'preference','nkqwTdNiVFxrk','Preference','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'radiointercast','iC8ejs3mOKS4Q','Radio Intercast','2000-06-22','0000-00-00',0,''); insert into Contact_Table values (null,'zcom','cZMY75hVUYKmU','Z.com','2000-06-22','0000-00-00',0,''); ##insert into Contact_Table values (null,'$contact_fullname','$contact_password','$contact_company',null,0); update Contact_Table set contact_company = "WildTangent" where contact_company like '%angent%'; ##update contact_Table set contact_name = 'run' WHERE contact_name like 'run()'; ##delete from contact_Table where contact_id = 10; +---------+-----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | demo_id | demo_name | demo_url | +---------+-----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 9 | Solitaire | http://www.WildTangent.com/demos/private/solitaire | | 5 | SabreWing | http://www.WildTangent.com/demos/private/sabrewing | | 7 | Mercenaries | http://www.wildtangent.com/demos/private/mercenaries | | 15 | CD Jewel Case | http://www.WildTangent.com/demos/private/cd_jewel_case/ | | 4 | Maptastic! | http://www.WildTangent.com/demos/private/maptastic/ | | 16 | Gem Master | javascript:window.open( 'http://www.WildTangent.com/demos/private/GemMaster/Gems.html', null,'status=no,toolbar=no,menubar=no,width=800,height=600,top=0,left=0,scrollbars=no,resizable=no,location=no', false ); | | 12 | USA Greetings | http://www.wildtangent.com/demos/private/usa_greetings/ | | 14 | Spades (Work in progress - UNOPTIMIZED) | http://www.WildTangent.com/demos/private/spades/ | | 13 | Monster Truck | http://www.WildTangent.com/demos/private/mtruck/ | | 11 | McDonalds | http://www.WildTangent.com/demos/private/mcd/ | +---------+-----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 10 rows in set (0.00 sec) CREATE TABLE Demo_Table ( demo_id TINYINT(2) NOT NULL AUTO_INCREMENT PRIMARY KEY, demo_name VARCHAR(50) NOT NULL, demo_url VARCHAR(255) NOT NULL ); ##delete from Demo_Table where demo_id > 0; insert into Demo_Table values (null,'Flower Card','http://www.WildTangent.com/demos/WildPlayer/FlowerCard/index.html'); insert into Demo_Table values (null,'Puzzle Card','http://www.WildTangent.com/demos/WildPlayer/PuzzleCard/index.html'); insert into Demo_Table values (null,'Robot Card','http://www.WildTangent.com/demos/WildPlayer/RobotCard/'); insert into Demo_Table values (null,'Maptastic!','http://www.WildTangent.com/demos/private/maptastic/'); insert into Demo_Table values (null,'SabreWing','http://www.WildTangent.com/demos/private/sabrewing'); insert into Demo_Table values (null,'WalkThru','http://www.wildtangent.com/demos/private/walkthru'); insert into Demo_Table values (null,'Mercenaries','http://www.wildtangent.com/demos/private/mercenaries'); insert into Demo_Table values (null,'Greeting Card Generator','http://www.WildTangent.com/demos/private/greeting_cards'); insert into Demo_Table values (null,'Solitaire','http://www.WildTangent.com/demos/private/solitaire'); insert into Demo_Table values (null,'Gothello','http://www.WildTangent.com/demos/WildPlayer/Gothello/index-gothic.htm'); insert into Demo_Table values (null,'McDonalds','http://www.WildTangent.com/demos/private/mcd/'); insert into Demo_Table values (null,'CD Jewel Case','http://www.WildTangent.com/demos/private/cd_jewel_case/'); insert into Demo_Table values (null,'Gem Master','http://www.WildTangent.com/demos/private/GemMaster/'); insert into Demo_Table values (null,'Memory Sequence','http://www.WildTangent.com/demos/private/MemorySequence/'); select * from Demo_Table order by demo_id; update Demo_Table set demo_url = "http://www.WildTangent.com/demos/private/GemMaster/" where demo_id = 16; update Demo_Table set demo_url = "javascript:window.open( 'http://www.WildTangent.com/demos/private/GemMaster/Gems.html', null,'status=no,toolbar=no,menubar=no,width=800,height=600,top=0,left=0,scrollbars=no,resizable=no,location=no', false );" where demo_id = 16; ###drop table Permissions_Table; CREATE TABLE Permissions_Table ( contact_table_id SMALLINT(5) NOT NULL, demo_table_id TINYINT(2) NOT NULL, INDEX (contact_table_id), INDEX (demo_table_id) ); insert into Permissions_Table values (1,1); insert into Permissions_Table values (1,2); insert into Permissions_Table values (1,4); insert into Permissions_Table values (1,5); ##select * from Permissions_Table where contact_table_id = 10; ##delete from Permissions_Table where contact_table_id = 10; ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// select * from Client_Table; select artist_name, cd_title from Client_Table, Artist_Table where Client_Table.cd_artist_id = Artist_Table.artist_id; select ucase(artist_name), ucase('hello') from Artist_Table; SELECT cd_upc,category_name,artist_name,cd_title,cd_price,label_name FROM Category_Table,Artist_Table,Client_Table,Label_Table WHERE Client_Table.cd_artist_id = Artist_Table.artist_id and Client_Table.cd_label_id = Label_Table.label_id and Client_Table.cd_category_id = Category_Table.category_id and Client_Table.cd_label_id = 7; delete from Category_Table where category_id = 9; insert into Client_Table values (0, 'cd_title',cd_artist_id,'cd_label',cd_label_id,'cd_upc', cd_status_id,cd_category_id,cd_price, null,cd_code,cd_desc,cd_image ); update Client_Table set cd_image = 'witherblisterburnpeel.jpg' where upc = '28'; update Client_Table set date = null where date = 000000; ALTER TABLE Client_Table CHANGE column cd_price cd_price FLOAT(6,2) NOT NULL; ALTER TABLE Client_Table ADD column cd_image VARCHAR(50); ALTER TABLE Client_Table ADD INDEX index_title (cd_title); SELECT upc,cd_title,artist_name,cd_price,cd_frizbcode,category_name,date,cd_status_id,status_id,status_name FROM Artist_Table,Client_Table,Category_Table,Label_Table,Status_Table WHERE artist_id = cd_artist_id AND category_id = cd_category_id AND cd_status_id = status_id AND label_id = cd_label_id ORDER BY date DESC,artist_name,cd_title LIMIT 1,10; select concat(substring(date,1,2),"/",substring(date,3,2),"/",substring(date,5,2)) from Client_Table; drop table Client_Table; LOAD DATA INFILE '/home/frizb/HTML/private/cris.tsv' REPLACE INTO TABLE Client_Table FIELDS OPTIONALLY ENCLOSED BY '"'; select * from Client_Table where artist_title like "front%"; ALTER TABLE Client_Table DROP column pin; ALTER TABLE Client_Table DROP column category; select * from Client_Table where artist_title like "front%";