2 The licence of this script is GPL
6 I thank all the people of Nucleus JP forum
7 who discussed this project. Especially, I
8 thank kosugiatkips, mekyo, and nakahara21
9 for ideas of some part of code.
10 I also thank Jon Jensen for his generous
11 acceptance for using his PHP code in the
12 earlier version of this library.
14 The features that are supported by this library but not
15 generally by SQLite are as follows:
17 CREATE TABLE IF NOT EXISTS, auto_increment,
18 DROP TABLE IF EXISTS, ALTER TABLE,
20 INSERT INTO ... SET xx=xx, xx=xx,
21 REPLACE INTO ... SET xx=xx, xx=xx,
22 SHOW KEYS FROM, SHOW INDEX FROM,
23 SHOW FIELDS FROM, SHOW COLUMNS FROM,
24 CREATE TABLE ... KEYS xxx (xxx,xxx)
25 SHOW TABLES LIKE, TRUNCATE TABLE
29 Following functions are available in SQL query.
31 CONCAT, IF, IFNULL, NULLIF, SUBSTRING,
33 replace, UNIX_TIMESTAMP, REGEXP, DAYOFMONTH, MONTH, YEAR,
34 ADDDATE, DATE_ADD, SUBDATE, DATE_SUB, FIND_IN_SET,
35 CURDATE, CURRENT_DATE, CURTIME, CURRENT_TIME, CURRENT_TIMESTAMP,
36 LOCALTIME, LOCALTIMESTAMP, SYSDATE, DATE_FORMAT, TIME_FORMAT,
37 DAYNAME, DAYOFWEEK, DAYOFYEAR, EXTRACT, FROM_DAYS, FROM_UNIXTIME,
38 HOUR, MINUTE, MONTH, MONTHNAME, PERIOD_ADD, PERIOD_DIFF, QUARTER,
39 SECOND, SEC_TO_TIME, SECOND, WEEK, WEEKDAY, YEAR, YEARWEEK,
40 FORMAT, INET_ATON, INET_NTOA, MD5,
41 ACOS, ASIN, ATAN, CEIL, CEILING, COS, COT, CRC32, DEGREES,
42 EXP, FLOOR, GREATEST, MAX, LEAST, MIN, ln, log, log2, log10,
43 MOD, PI, POW, POWER, RADIANS, RAND, SIGN, SIN, SQRT, TAN,
44 ASCII, BIN, BIT_LENGTH, CHAR, CHAR_LENGTH, CONCAT_WS,
45 CONV, ELT, EXPORT_SET, FIELD, HEX, INSERT, LOCATE,
46 INSTR, LCASE, LOWER, LEFT, LENGTH, OCTET_LENGTH,
47 LOAD_FILE, LPAD, LTRIM, MAKE_SET, MID, SUBSTRING,
48 OCT, ORD, QUOTE, REPEAT, REVERSE, RIGHT, RPAD,
49 RTRIM, SOUNDEX, SPACE, SUBSTRING_INDEX, TRIM,
55 -This is the first established version and
56 exactly the same as ver 0.7.8b.
59 -Execute "PRAGMA short_column_names=1" first.
60 -Avoid executing outside php file in some very specfic environment.
61 -Avoid executing multiple queries using ";" as delimer.
62 -Add check routine for the installed SQLite
65 -Use SQLite_Functions class
66 -'PRAGMA synchronous = off;' when installing
69 - ALTER TABLE syntaxes updated, bugs fixed
72 - ALTER TABLE almost completery re-written
73 - DESC 'table' 'field' supported
74 - The function 'php' is unregestered from SQL query.
77 - Support RENAME TABLE
78 - Some tunings are done to improve the speed.
81 - Debug of CREATE TABLE routine.
82 - NP_SQLite: trim the query when 'Copy' is used.