Welcome To Snipplr


Everyone's Recent Snippets Tagged mysql



Some other alter syntax examples at the URL, which beats the pants off the MySQL manual for some reason.
0 508 posted 14 years ago by tclancy
Quick little snippet for changing the ordering of a field in a MYSQL database.
1 663 posted 14 years ago by Zync
1 490 posted 14 years ago by ginoplusio
This will create a list grouped by the sorted field, which is an inner join on a category field.
0 395 posted 14 years ago by fostersolutions
2 445 posted 14 years ago by czapata
0 430 posted 14 years ago by iTony
Here is a working example on how to sort data in a grid.
1 589 posted 14 years ago by assaado
1 379 posted 14 years ago by assaado
0 504 posted 14 years ago by vasilije
1 301 posted 14 years ago by ericserrat
make a query and retrieve the first record, if error occurs show it and the query.
0 348 posted 14 years ago by ginoplusio
retrieve only one value from the query
0 473 posted 14 years ago by ginoplusio
0 696 posted 14 years ago by Wardy
0 523 posted 14 years ago by sebus
0 476 posted 14 years ago by therobot
0 459 posted 14 years ago by hdanniel
2 419 posted 14 years ago by joeymarchy
0 471 posted 14 years ago by sebus
1 596 posted 14 years ago by ghwilson4456
Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.
1 421 posted 14 years ago by simplistik
0 353 posted 14 years ago by tgunr
Replace all mysql_query() calls in your project to debug_mysql_query() to see all mysql queries in Firebug console.
1 650 posted 14 years ago by stancell
3 526 posted 14 years ago by antpaw
Simplified form to extract data through MySQL
0 404 posted 14 years ago by LondonWeb