bound4h Posted October 14, 2009 Share Posted October 14, 2009 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, Quote Link to comment https://forums.phpfreaks.com/topic/177695-import-excel-db-to-mysql/ Share on other sites More sharing options...
fenway Posted October 17, 2009 Share Posted October 17, 2009 If you're using mysql 5, there a CSV engine type. Quote Link to comment https://forums.phpfreaks.com/topic/177695-import-excel-db-to-mysql/#findComment-938837 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.