EePCSc5L

1mysqlDB_Account 	<-	SqMySQL.Account( "localhost", "", "", "sample_test", 3306 );
2db					<-	mysqlDB_Account.Connect( );
3
4SqCore.On( ).ScriptLoaded.Connect( function ( ) {
5	db.Execute( "CREATE TABLE IF NOT EXISTS test_table ( ID NUMERIC, Text VARCHAR(32) )" );
6	db.Execute( "INSERT INTO test_table ( ID, Text ) VALUES ( 0, 'This is a test.' )" );
7	
8	local
9		query				=	db.Query( "SELECT Text FROM test_table WHERE ID = 0" );
10	
11	query.Next( );
12	print( query.FieldsArray );
13	print( query.FieldsArray[ 0 ].String );
14	
15	print( query.FieldsTable );
16} );