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 497 posted 14 years ago by tclancy
Quick little snippet for changing the ordering of a field in a MYSQL database.
1 639 posted 14 years ago by Zync
1 474 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 382 posted 14 years ago by fostersolutions
2 434 posted 14 years ago by czapata
0 415 posted 14 years ago by iTony
Here is a working example on how to sort data in a grid.
1 575 posted 14 years ago by assaado
1 367 posted 14 years ago by assaado
0 487 posted 14 years ago by vasilije
1 291 posted 14 years ago by ericserrat
make a query and retrieve the first record, if error occurs show it and the query.
0 337 posted 14 years ago by ginoplusio
retrieve only one value from the query
0 461 posted 14 years ago by ginoplusio
0 672 posted 14 years ago by Wardy
0 501 posted 14 years ago by sebus
0 464 posted 14 years ago by therobot
0 447 posted 14 years ago by hdanniel
2 405 posted 14 years ago by joeymarchy
0 459 posted 14 years ago by sebus
1 567 posted 14 years ago by ghwilson4456
Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.
1 403 posted 14 years ago by simplistik
0 334 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 624 posted 14 years ago by stancell
3 514 posted 14 years ago by antpaw
Simplified form to extract data through MySQL
0 394 posted 14 years ago by LondonWeb