Create a MYSQL table and insert data in it.

Create a MYSQL table name color_codes with rows - id,name,colors,category,subcategory,brand_url,brand_picture,info id should be auto incremented. For every category mentioned on this page like abnany etc you need to extract the data and enter it into the table. Name: it should be the brand or the team name colors: it should be like #00000 (if there are multiple colors then #000000;#11111 put them together with a semicolon) brand_url: search google if the brand website is not mentioned. Put the offical website of the brand or team here. brand_picture: Every offical website will have a logo. find the link to it and add it here. Info: Write a little about brand. 50 words max. When was it found. who founded it etc. Category and SubCategory: This is where you have to apply your mind. Figure out which comes under what category. (Example: For IPL teams, Category could be Cricket and SubCategory would be IPL).