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 536 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 784 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 853 posted 16 years ago by thecrumb

SQL Get Columns and Comments (Oracle)

Get all my columns and comments.

0 581 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 616 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 689 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 4506 posted 16 years ago by engel

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

Courtesy of Jesse.

2 794 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 5109 posted 16 years ago by peteypablonz

SQL Ordering multiple SELECT statements in a UNION

0 762 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 732 posted 16 years ago by jachin