Reserved Keywords in Mysql 5

posted by birbal in May 20th, 2008

in MySQL

Was pondering why a simple insert statement wasnt working on a table called release. Googled for it and got the following from mysql docs.

Reserved Words in MySQL 5.0

`ADD`	`ALL`	`ALTER`
`ANALYZE`	`AND`	`AS`
`ASC`	`ASENSITIVE`	`BEFORE`
`BETWEEN`	`BIGINT`	`BINARY`
`BLOB`	`BOTH`	`BY`
`CALL`	`CASCADE`	`CASE`
`CHANGE`	`CHAR`	`CHARACTER`
`CHECK`	`COLLATE`	`COLUMN`
`COLUMNS`^[a]	`CONDITION`	`CONNECTION`^[b]
`CONSTRAINT`	`CONTINUE`	`CONVERT`
`CREATE`	`CROSS`	`CURRENT_DATE`
`CURRENT_TIME`	`CURRENT_TIMESTAMP`	`CURRENT_USER`
`CURSOR`	`DATABASE`	`DATABASES`
`DAY_HOUR`	`DAY_MICROSECOND`	`DAY_MINUTE`
`DAY_SECOND`	`DEC`	`DECIMAL`
`DECLARE`	`DEFAULT`	`DELAYED`
`DELETE`	`DESC`	`DESCRIBE`
`DETERMINISTIC`	`DISTINCT`	`DISTINCTROW`
`DIV`	`DOUBLE`	`DROP`
`DUAL`	`EACH`	`ELSE`
`ELSEIF`	`ENCLOSED`	`ESCAPED`
`EXISTS`	`EXIT`	`EXPLAIN`
`FALSE`	`FETCH`	`FIELDS`^[c]
`FLOAT`	`FLOAT4`	`FLOAT8`
`FOR`	`FORCE`	`FOREIGN`
`FROM`	`FULLTEXT`	`GOTO`^[d]
`GRANT`	`GROUP`	`HAVING`
`HIGH_PRIORITY`	`HOUR_MICROSECOND`	`HOUR_MINUTE`
`HOUR_SECOND`	`IF`	`IGNORE`
`IN`	`INDEX`	`INFILE`
`INNER`	`INOUT`	`INSENSITIVE`
`INSERT`	`INT`	`INT1`
`INT2`	`INT3`	`INT4`
`INT8`	`INTEGER`	`INTERVAL`
`INTO`	`IS`	`ITERATE`
`JOIN`	`KEY`	`KEYS`
`KILL`	`LABEL`^[e]	`LEADING`
`LEAVE`	`LEFT`	`LIKE`
`LIMIT`	`LINES`	`LOAD`
`LOCALTIME`	`LOCALTIMESTAMP`	`LOCK`
`LONG`	`LONGBLOB`	`LONGTEXT`
`LOOP`	`LOW_PRIORITY`	`MATCH`
`MEDIUMBLOB`	`MEDIUMINT`	`MEDIUMTEXT`
`MIDDLEINT`	`MINUTE_MICROSECOND`	`MINUTE_SECOND`
`MOD`	`MODIFIES`	`NATURAL`
`NOT`	`NO_WRITE_TO_BINLOG`	`NULL`
`NUMERIC`	`ON`	`OPTIMIZE`
`OPTION`	`OPTIONALLY`	`OR`
`ORDER`	`OUT`	`OUTER`
`OUTFILE`	`PRECISION`	`PRIMARY`
`PRIVILEGES`^[f]	`PROCEDURE`	`PURGE`
`READ`	`READS`	`REAL`
`REFERENCES`	`REGEXP`	`RELEASE`^[g]
`RENAME`	`REPEAT`	`REPLACE`
`REQUIRE`	`RESTRICT`	`RETURN`
`REVOKE`	`RIGHT`	`RLIKE`
`SCHEMA`	`SCHEMAS`	`SECOND_MICROSECOND`
`SELECT`	`SENSITIVE`	`SEPARATOR`
`SET`	`SHOW`	`SMALLINT`
`SONAME`	`SPATIAL`	`SPECIFIC`
`SQL`	`SQLEXCEPTION`	`SQLSTATE`
`SQLWARNING`	`SQL_BIG_RESULT`	`SQL_CALC_FOUND_ROWS`
`SQL_SMALL_RESULT`	`SSL`	`STARTING`
`STRAIGHT_JOIN`	`TABLE`	`TABLES`^[h]
`TERMINATED`	`THEN`	`TINYBLOB`
`TINYINT`	`TINYTEXT`	`TO`
`TRAILING`	`TRIGGER`	`TRUE`
`UNDO`	`UNION`	`UNIQUE`
`UNLOCK`	`UNSIGNED`	`UPDATE`
`UPGRADE`^[i]	`USAGE`	`USE`
`USING`	`UTC_DATE`	`UTC_TIME`
`UTC_TIMESTAMP`	`VALUES`	`VARBINARY`
`VARCHAR`	`VARCHARACTER`	`VARYING`
`WHEN`	`WHERE`	`WHILE`
`WITH`	`WRITE`	`XOR`
`YEAR_MONTH`	`ZEROFILL`
^[a]`COLUMNS` not reserved in: 5.0.56, 5.0.3-5.0.56 ^[b]`CONNECTION` not reserved in: 5.0.56, 5.0.38-5.0.56 ^[c]`FIELDS` not reserved in: 5.0.56, 5.0.3-5.0.56 ^[d]`GOTO` not reserved in: 5.0.56, 5.0.21-5.0.56 ^[e]`LABEL` not reserved in: 5.0.2-5.0.6, 5.0.21-5.0.56 ^[f]`PRIVILEGES` not reserved in: 5.0.56, 5.0.3-5.0.56 ^[g]`RELEASE` not reserved in: 5.0.2 ^[h]`TABLES` not reserved in: 5.0.56, 5.0.3-5.0.56 ^[i]`UPGRADE` not reserved in: 5.0.2-5.0.18, 5.0.26-5.0.56

Google AppEngine + YUI Mashup

posted by birbal in April 9th, 2008

in LAMP, PHP, YUI

Hi Friends.

Here is a complete Google AppEngine + YUI Mashup for ye All

Download the zip file (lamp.zip) and update on ur own Google App Engine Domain.

demo here

Google AppEngine Released

posted by birbal in April 8th, 2008

in LAMP

Google App Engine enables you to build web applications on the same scalable systems that power Google applications.

http://code.google.com/appengine/

Demo is up http://lamp.appspot.com

Wordpress Reloaded

posted by birbal in March 30th, 2008

in LAMP

WordPress 2.5 has been released.

The culmination of six months of work by the WordPress community, people just like you. The improvements in 2.5 are numerous, and almost entirely a result of your feedback: multi-file uploading, one-click plugin upgrades, built-in galleries, customizable dashboard, salted passwords and cookie encryption, media library, a WYSIWYG that doesn’t mess with your code, concurrent post editing protection, full-screen writing, and search that covers posts and pages.

Offical Blog

Job Posting: Gijima.com Seeks PHP Developer (Richardbay KZN)