/*
* This file contains example SQL queries to help development of the DBC module.
*/
/* Table creation */
CREATE TABLE `someTable` (
`Frame` int(4) PRIMARY KEY,
`Scalar` float,
`Vector` varchar(32),
`String` char(255)
);
/* Retrieve a list tables in the database */
SHOW TABLES; /* MySQL */
SELECT * FROM INFORMATION_SCHEMA.TABLES; /* SQL Server, Oracle */
/* Retrieve a list of columns for the specified table */
DESC sometable;
/* Inserting a record */
INSERT INTO `someTable` (`Frame`, `Scalar`, `Vector`, `String`) VALUES ('5', '3.14159', '0.5 0.6 0.7', 'This is a test string');
/* Retrieving records */
SELECT * FROM `someTable`;
/* Deletion of a table */
DROP TABLE IF EXISTS `someTable`;