PHP Classes

File: step7.sql

Recommend this page to a friend!
  Classes of Neil Francis   SQLite PDO   step7.sql   Download  
File: step7.sql
Role: Auxiliary data
Content type: text/plain
Description: sqlite 3 database sample
Class: SQLite PDO
Retrieve SQLite database data using PDO
Author: By
Last change:
Date: 15 years ago
Size: 755 bytes
 

Contents

Class file image Download
DROP TABLE IF EXISTS "currval"; CREATE TABLE "currval" ("currid" INTEGER PRIMARY KEY NOT NULL ,"currname" VARCHAR NOT NULL ,"currval" VARCHAR NOT NULL ,"currvolume" VARCHAR NOT NULL , "currspread" VARCHAR NOT NULL DEFAULT ''); INSERT INTO "currval" VALUES(1,'GBP/USD','1.0000','10000','4'); INSERT INTO "currval" VALUES(2,'EUR/USD','1.0000','10000','3'); INSERT INTO "currval" VALUES(3,'USD/CAD','1.0000','10000','5'); INSERT INTO "currval" VALUES(4,'USD/CHF','1.0000','10000','5'); INSERT INTO "currval" VALUES(5,'AUD/USD','1.0000','10000','5'); INSERT INTO "currval" VALUES(6,'USD/JPY','1.0000','100','5'); INSERT INTO "currval" VALUES(7,'NZD/USD','1.0000','10000','4'); DROP TABLE IF EXISTS "sqlite_sequence"; CREATE TABLE sqlite_sequence(name,seq);