Welcome To Snipplr


Everyone's Recent MySQL Snippets Tagged table



« Prev 1 Next »
You have a schedule table (period, day, subject, room) with a primary key period,day to avoid duplicate bookings. You wish to display the schedule as periods, subjects and rooms in rows, and days of the week in columns.
0 670 posted 11 years ago by cahyadsn
Most popular languages on the web table (in order of popularity). Handy for auto complete fields and such.
0 1206 posted 12 years ago by Synnoid
Can add columns to a table checking before if there
0 776 posted 13 years ago by jatubio
the following code can be used to create a table with a dynamic name
0 626 posted 13 years ago by gtaking
0 639 posted 13 years ago by Jamie
How to add an auto-incremented column to an existing table without ex- and reimporting.
0 791 posted 14 years ago by simondiercks
General MySQL engine related commands
0 562 posted 14 years ago by sukantahazra
0 945 posted 14 years ago by CuDDL
« Prev 1 Next »