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, 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. 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
Archived
This topic is now archived and is closed to further replies.