Jump to content

Recommended Posts

Hello, I am hoping to get some help updating a new database with some information, and then creating a PHP script that will query the database using simple SELECT.

 

I understand query syntax (for the most part), but what I don't get is how to setup the database.  I have a website that is hosted by a webhosting company that supports MySQL.  I created a database, named it, and created 2 users.  One has all privileges, and one has only SELECT privileges.  I have an excel spreadsheet that has two tabs.  I would like each tab to be its own table.  The first tab has a unique field I want to use as the Primary Key.  Same thing for the Second tab.

 

My question is, how do I get all of this info into the db I created?  The company has cpanel, and from there I can go to "MySQL Databases" which just shows me my dbs, "MySQL Database Wizard" which just sets it up and sets up a user, "MyphpAdmin" which looks like where I need to be?, and "Remote MySQL" which I don't what it does.

 

What's the first step in setting this up?  I started to go into MyphpAdmin and create a table and specified the number of fields, but then it asked a billion questions about each field: Field  Type Length/Values  Collation  Attributes  Null  Default2  Extra, and then there are 3 checkboxes for Primary, Index and Unique.

 

There is also a separate tab called import.  Do I need to set this table up before I can import that data?

 

Thanks for any help you give guys,

Link to comment
https://forums.phpfreaks.com/topic/177695-import-excel-db-to-mysql/
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.