Y2S1-Database_Design/SQL/individual_inserts/9 - AudioGenre.Table.sql

15 lines
1.5 KiB
MySQL
Raw Permalink Normal View History

2020-06-07 21:29:59 +00:00
<EFBFBD><EFBFBD>USE [MediaLibrary]
GO
SET IDENTITY_INSERT [dbo].[AudioGenre] ON
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (1, N'Blues')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (2, N'Country')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (3, N'Electronic')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (4, N'Folk')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (5, N'Hip Hop')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (6, N'Jazz')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (7, N'Pop')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (8, N'R%B')
INSERT [dbo].[AudioGenre] ([GenreID], [GenreName]) VALUES (9, N'Rock')
SET IDENTITY_INSERT [dbo].[AudioGenre] OFF