SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE IF EXISTS `Vendors`; CREATE TABLE `Vendors` (`vend_id` CHAR (10) NOT NULL , `vend_name` CHAR (50) NOT NULL , `vend_address` CHAR (50) NOT NULL , `vend_city` CHAR(50) NULL , `vend_state` CHAR(5) NULL , `vend_zip` CHAR(10) NULL , `vend_country` CHAR(50) NULL ); INSERT INTO `Vendors`VALUES ("BRS01","Bears R Us","123 Main Steet","Bear Town","MI","44444","USA"), ("BRE02","Bear Emporium","500 Park Steet","Anytown","OH","44333","USA"), ("DLL01","Doll House Inc.","555 High Steet","Dollsville","CA","99999","USA"), ("FRB01","Furball Inc.","1000 5th Avenus","New York","NY","11111","USA"), ("FNG01","Fun and Games","42 Galaxy Road","London",NULL,"N16 6PS","England"), ("JTS01","Jouets et ours","1 Rue Amusement","Paris",NULL,"45678","France") ; SELECT "`Vendors` Table Content:" FROM `Vendors` WHERE 1 = 0; SELECT RTRIM(CONCAT(`vend_country`, ' ', COALESCE(`vend_state`, ''))) AS `Country_State` FROM `Vendors` ORDER BY `vend_country`;