Closed

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).

Skills: HTML, MySQL, PHP, Web Scraping, Website Design

See more: how to create table in mysql command line, script to insert data into sql table, insert into select mysql, mysql create table, insert into table sql server, create employee table in mysql, create table and insert data sql, mysql insert, create mysql table form data, mysql table insert post form, create mysql table form post, fcmspro create mysql table, create mysql table text file mls, php mysql table insert form, mysql script insert data bash, create mysql table xml, php mysql table insert delete script, create web table click data, create mysql table csv, fpdf create mysql table

About the Employer:
( 0 reviews ) Pune, India

Project ID: #19639429

15 freelancers are bidding on average ₹2631 for this job

fattahaabdul

I can make a database for you. I have 8+ years of experience in MYSQL. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. i am online. Please reply.

₹3000 INR in 2 days
(145 Reviews)
8.0
hamzzaamalik

Sir I have vast experience in databases,We can discuss more in chat about the details,u can view my profile and complete on time. I am a full time freelancer,working for more than 2 years [login to view URL] clients from differe More

₹1300 INR in 1 day
(49 Reviews)
5.5
kkc1985612

Hi, I looked at your description carefully and I am very interested in providing my skills in hopes of working with you. I have ample experience in web scraping. -scrap any website using selenium, beautifulSoup, reques More

₹1500 INR in 2 days
(48 Reviews)
5.6
Deepakkumawat

Hello, I have good experience in PHP and MySQL. please ping me for further discussion Waiting for your time Thanks

₹2250 INR in 1 day
(16 Reviews)
4.5
dilshadbukhari

I am working in different platforms. (.NET Development, PHP (Core php, Codeigniter, Laravel, Opencart, WordPress), Android Development, Graphic Designing, Front-End Responsive Design) My Vision : To achieve 100% Clie More

₹1300 INR in 1 day
(26 Reviews)
4.5
softtronicstech

I can help you. Im a certified DB developer with partime freelancing. Here are my old freelance profiles https://www.freelancer.com/u/softtronicstech(10 projects) [login to view URL] (5 projects) [login to view URL] More

₹1050 INR in 7 days
(7 Reviews)
3.4
andrescoslop

The employer will give me access to a MySQL database. Inside that I will create a new table and insert some data in it. The rows will be id,name,colors,category,subcategory,brand_url,brand_picture,info The detail More

₹21111 INR in 20 days
(2 Reviews)
3.2
TopDesigner315

Hello.I am web developer of JinCowBoy company. I have checked your project specification. I am interesting on your project as I have experienced with database. I can implement your project with fully and complete More

₹800 INR in 1 day
(1 Review)
2.5
tusharaggarwal02

Hi, I have gone through your requirements carefully and interested in the job. I have 5+ years of experience in web designing and development wherein I have worked upon HTML, CSS, BootStrap, JavaScript, Jquery, PHP, More

₹1050 INR in 1 day
(6 Reviews)
2.2
NitinSharmabot

I 'm a Full-stack developer and Ethical Hacker Working +5 years in programming field. I love programming. My passion is to solve the programming issue. Technology Summary : ---Programming/Languages: PHP, Python, JavaSc More

₹600 INR in 1 day
(3 Reviews)
1.8
ibfisiru

I can accomplish this task in 1 day, to the letter of how you have explained in your description. I have both MYSQL and database management skills required to be an asset to your situation.

₹1250 INR in 1 day
(0 Reviews)
0.0
iprabhanshu17

Hello, I have a strong experience in MySql & Database and I am pretty much familiar with this kind of stuff and programs so I think I could be a better fit for this task. Please ping me message

₹1050 INR in 2 days
(0 Reviews)
0.0
aayu411

I will try to give best from my side as I have worked on various PHP projects . I assure you that there will be no complains from you side and you will like my work.

₹1300 INR in 1 day
(0 Reviews)
0.0
databasedba

Dear Hiring Manager, I am an Oracle Certified Database Professional (OCP). I have complete masters in computer science. I am a database professional with 15 years’ experience. My background includes Sql, MySQL, Pl Sql, More

₹1050 INR in 7 days
(0 Reviews)
0.0
mfarooooooq

I would like to complete your project at minimum budget.

₹850 INR in 1 day
(0 Reviews)
0.0