The syntax for Hyperstage SQL commands is exactly the same as the syntax for MySQL commands. For more information, see SQL Statement Syntax in the MySQL 5.x Reference Manual.

There are special considerations when using the following commands with Hyperstage. All other SQL commands can be used with Hyperstage as they are with the standard MySQL.

Using MySQL Commands With WebFOCUS Hyperstage
MySQL Command	More Information
CREATE TABLE, DROP TABLE	Creating and Dropping Tables.
SHOW TABLE STATUS, SHOW FULL COLUMNS	Viewing Table Information and Viewing Compression Ratio Statistics.
INSERT, UPDATE, DELETE	Data Manipulation Statements.
LOAD DATA INFILE	Importing and Exporting Data in WebFOCUS Hyperstage.
SELECT	Running Queries in WebFOCUS Hyperstage.
VIEW	Creating VIEWs in WebFOCUS Hyperstage.