Welcome To Snipplr


Everyone's Recent Snippets Tagged sql



0 523 posted 16 years ago by eszpee
1 771 posted 16 years ago by zingo
0 515 posted 16 years ago by Caliban
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 515 posted 16 years ago by thecrumb
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 761 posted 16 years ago by thecrumb
Get a list of all the user tables.
0 820 posted 16 years ago by thecrumb
Get all my columns and comments.
0 560 posted 16 years ago by thecrumb
Noob stuff, but I always end up looking this up.
0 592 posted 16 years ago by rengber
Small query to help you relocate those modules you are not using anyways.
2 665 posted 16 years ago by torkil
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 4325 posted 16 years ago by engel
Courtesy of Jesse.
2 765 posted 16 years ago by ches
Created for my own purposes, thought I'd share though ;) copy paste at the top of your file and it does the magic :)
31 4939 posted 16 years ago by peteypablonz
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 703 posted 16 years ago by jachin
You can generate a simple bar chart of the values by executing this command...
0 726 posted 16 years ago by zingo
2 462 posted 16 years ago by hyperwhat
0 537 posted 16 years ago by rengber
0 510 posted 16 years ago by lfbarbieri
0 550 posted 17 years ago by ryanprel
1 693 posted 17 years ago by drwitt
1 576 posted 17 years ago by nicolaspar
Building a SELECT with conditional WHERE parts, given from form-get parameters.
1 518 posted 17 years ago by assbach