SQL
Public
SQL information for any DMBS. MySQL, PostgreSQL, Oracle, Access, SQL Server, MSSQL
Recent Activity
Items
-
Conditions on Count or Sum in MySQL | Code SpatterConditions on Count or Sum in MySQL
Greg
added
16 months ago
-
Tips for MySQL to PostgreSQL SwitchIf you've decided to move a few tables from MySQL to PostgreSQL, these few tips might help.
Greg
added
17 months ago
-
MySQL v PostgreSQL: Which have you used and why?Interesting discussion of developers experiences and comparisons.
Greg
added
18 months ago
-
How To Use Triggers to Track Changes in MySQL | Code SpatterSetting constraints and rules in the database is better than writing special code to handle the same task since it will prevent another developer from writing a
Greg
added
19 months ago
-
Mr. Rosenblatt: The Blog » Insert where not existsIf you want to insert values into a MySQL table, but only if those values don’t already exist, and you don’t want to use a primary key on the table (and deal with the resulting error suppression ), here’s an elegant one-query method of doing so. INSERT INTO [table name] SELECT '[value1]', ...
Greg
added
19 months ago
Comments
Members
Active
-
Started Apr. 30, 2008
-
Rules of this twine
This Twine has open membership.
Comments are allowed.
Members may ,add items ,invite people
Twine is about discovering, collecting and sharing the content that interests you. Learn More
Join Twine