SQL
MySQL Resources
MySQL is a free, open-source relational database that has been used in thousands of websites, lar...
PostgreSQL Resources
See Also: Who uses PostgreSQL at UCLA?PostgreSQL official website: http://www.postgresql.orgModif...
Why doesn't mysqlshow work for databases or tables with underscores in their names?
mysqlshow has a tricky feature that interprets SQL wildcard characters (*,?,%,_) as wildcards if ...
What is mysqlshow good for?
mysqlshow is a command-line tool included with standard MySQL distributions, similar to mysqladmi...
How can I search/replace strings in MySQL?
MySQL lets you replace all occurrences of a character or string of characters in a table with som...
Microsoft Access, OpenOffice and MySQL
Using ODBC it is possible to connect Microsoft Access (or OpenOffice) to a MySQL database. Access...
SQL joins
Please add other helpful links:SQL joins: a visual explanationhttp://www.codinghorror.com/blog/20...
Get rid of default annoyances in MySQL Workbench
By default, if you make any changes to table rows, there is an annoying 2-step confirmation dialo...
Who uses PostgreSQL at UCLA?
The purpose of this page is to create a directory of people who are using PostgreSQL and what adv...
Why NoSQL Matters
Useful survey of NoSQL (and SQL) technologies and a summary of the philosophy…http://blog.heroku....