SQLize Online / PHPize Online  /  SQLtest Online

Create table `Customers` ( `cust_num` VARCHAR (3) NOT NULL , `cust_name` VARCHAR (20) NOT NULL , `cust_price` DOUBLE NOT NULL , `cust_id` VARCHAR (10) NOT NULL ); INSERT INTO `Customers` VALUES ("7", "JMUnion", 10, "1"), ("2", "Cucumber", 1000, "2"), ("3", "CornJo", 12, "3"), ("4", "Slave", 9999, "4"), ("1", "~pi", 3.49, "5") ; SELECT cust_name FROM `Customers` WHERE cust_name RLIKE "[JM%]"; Create table `Vendors` ( `vend_country` VARCHAR (10) NOT NULL , `vend_name` VARCHAR (20) NOT NULL , `vend_state` VARCHAR(15) NOT NULL , `cust_city` VARCHAR (10) NOT NULL ); INSERT INTO `Vendors` VALUES ("USA", "JMUnion", "10", "1"), ("SS", "Cucumber", "1000", "2"), ("USSR", "CornJo", "12", "3"), ("CHINA", "Slave", "9999", "4"), ("IRELAND", "~pi", "3.49", "5") ; SELECT vend_name || ' ' || vend_country FROM `Vendors` ORDER BY vend_name; SELECT RTRIM(vend_name) || ' ' || RTRIM(vend_country) AS vend FROM `Vendors` ORDER BY vend_name; SELECT RTRIM(vend_name) || ' ' || RTRIM(vend_country) AS vend FROM `Vendors` ORDER BY vend_name; Create table `OrderItems` ( `prod_id` VARCHAR (10) NOT NULL , `quantity` VARCHAR (20) NOT NULL , `item_price` VARCHAR(15) NOT NULL , `item_desc` VARCHAR (10) NOT NULL ); INSERT INTO `OrderItems` VALUES ("1", "100", "10", "item1"), ("2", "200", "1000", "item2"), ("3", "300", "12", "item3"), ("4", "400", "9999", "item4"), ("5", "900", "3.49", "item5") ; SELECT prod_id, quantity, item_price, (quantity * item_price) AS expanded_data FROM OrderItems;