Generate the SQL necessary to create triggers that use the sequences listed above. NOTE: This particular script assumes that the tables all start with â€˜tblâ€™. It may need to be modified to work with different naming conventions.

0 546 posted 16 years ago by thecrumb

SQL Generate the SQL necessary to create sequences for every table (Oracle)

Generate the SQL necessary to create sequences for every table. NOTE: This doesnâ€™t create sequences. The results need to be copied and run as a script.

0 789 posted 16 years ago by thecrumb

SQL Get a list of all the user tables (Oracle)

Get a list of all the user tables.

0 859 posted 16 years ago by thecrumb

SQL Get Columns and Comments (Oracle)

Get all my columns and comments.

0 585 posted 16 years ago by thecrumb

SQL Add a Constant Value to a RecordSet

Noob stuff, but I always end up looking this up.

0 622 posted 16 years ago by rengber

SQL Move inactive Joomla 1.0 modules to the bottom of the modules list

Small query to help you relocate those modules you are not using anyways.

2 695 posted 16 years ago by torkil

PHP Prevent SQL Injection

Pass a user-inputted variable to this function in order to prevent SQL injection. Example: mysql_query("INSERT INTO table VALUES('" . sql_sanitize($_POST["variable") . "')"); Instead of: mysql_query("INSERT INTO table VALUES('" . $_POST["var...

34 4562 posted 16 years ago by engel

Ruby Ruby One-liner for Restoring One Table from a Huge SQL Dump

Courtesy of Jesse.

2 806 posted 16 years ago by ches

PHP clean user input data ( GET, POST, COOKIE )

Created for my own purposes, thought I'd share though ;) copy paste at the top of your file and it does the magic :)

31 5169 posted 16 years ago by peteypablonz

SQL Ordering multiple SELECT statements in a UNION

0 773 posted 16 years ago by andyhartleeds

SQL Reset auto increment on a table

If you are deleting all the rows in a table and you also want to reset the values that will get used by auto increment, this is how to do it.

0 739 posted 16 years ago by jachin