Let\u2019s assume that you are working for a audio store and need to create a database to hold details about all the types of devices in the store. You are told that there are nine families of devices\u2014Amplifier, minidisc, DVD, C-casette, Turntable, DAT, DCC, Turner, and DAB\u2014so you\u2019ll need a column for that. Then each device has been given a name, so that\u2019s another column, and you also want to keep track of their ages, which is another. Of course, you will probably need more columns later, perhaps to hold voltage requirements, and other details, but for now that\u2019s enough to get going. A unique identifier is also needed for each device, so you also decide to create a column for that called id.<\/p>\n\n\n\n
The code you might use to create a MySQL table to hold this
data, with the main query assignment in bold text.<\/p>\n\n\n\n
Creating a table called devices<\/a><\/p>\n\n\n\n As you can see, the MySQL query looks just like what you would type directly at the command line, except without the trailing semicolon.<\/p>\n","protected":false},"excerpt":{"rendered":" Let\u2019s assume that you are working for a audio store and need to create a database to hold details about all the types of devices in the store. You are told that there are nine families of devices\u2014Amplifier, minidisc, DVD, C-casette, Turntable, DAT, DCC, Turner, and DAB\u2014so you\u2019ll need a column for that. Then each … Continue reading Creating a Table<\/span>