ezSQL is an open source PHP database class that I wrote a while back. It’s used on over 100k websites and is the backbone of many open source projects such as WordPress. The class makes it ridiculously easy to use mySQL, Oracle8, SQLite (PHP), within your PHP script. Includes lots of examples making it very …
Tag Archives: MySQL
PHP-MySql: Select previous row and next row from current ID
During the dark age, the simplest way to get previous row from current ID was using this query:
MySQL group by day, month or year using a timestamp column
In Ruby on Rails, created_at and updated_at columns are MySQL timestamp columns. GROUP BY is pretty useless on a timestamp column, unless you are trying to group rows that were added at the same second. I needed to group by just the date, so in order to do this I had to manipulate the …
Continue reading “MySQL group by day, month or year using a timestamp column”
sqlite error codes
here are the error codes for sqlite, straight from their site: The error codes for SQLite version 3 are unchanged from version 2. They are as follows:
MySQL if exist update else insert
I whant to write single sql for this: if not exists (table colum value=something) insert new row else update table colum value i know that MSSQL has this method, but how to do this in mysql?
Database Management Solutions by SQL Maestro Group
SQL Maestro Group offers complete database admin, development and management tools for all the most popular DBMS providing the highest performance, scalability and reliability to meet the requirements of today’s database applications.