Need Help With Creating a Database with Records I Have

Discussion in 'Databases' started by 5starpix, Jan 26, 2012.

  1. #1
    Hey guys,

    Looking for a little helping relating to "databases".

    I have some information that I would like to make a database out of.

    The information is basically business listings such as the following

    Business Name: XYZ Canada Inc
    Business Industry: Broadcasting
    Business Telephone #: 1-514-XXX-XXXX

    I have about 1500 records in total.

    How could I create a database with this? Where should I start and using what?

    Any help is appreciated.

    Thanks,
     
    5starpix, Jan 26, 2012 IP
  2. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Hi,
    What will the purpose of the database be? You can use any database for this purpose. The most popular one is MySql since its free and decently scalable. This will be if you are looking to develop or expose the data through the web.
    If the data is present in the format provided you might need to do a regex to get the individual values and then insert them. This requires a bit of coding skills. If you can get the data in the form of excel, you can export as csv and directly use that to create the website.

    Hope this helps you
     
    iama_gamer, Jan 27, 2012 IP
  3. 5starpix

    5starpix Notable Member

    Messages:
    6,380
    Likes Received:
    83
    Best Answers:
    0
    Trophy Points:
    235
    #3
    I do know a bit of coding. I coded this very simple "data form" which connects to a MySQL database.

    When you go to the form and type the data out and press submit, it would save the data to the database. This seems like its a lot of work.

    You mentioned using an excel sheet. If I had all the information in an excel sheet, would I be able to automatically transfer all that into a MySQL database?

    Thanks
     
    5starpix, Jan 27, 2012 IP
  4. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #4
    Well you can export the data from excel as csv and use tools like those present on phpMyAdmin to import it into the database. Even without such tools the code to do this is pretty simple and straightforward.

    You need to specific the string enclosing as single quotes to make things easier.
     
    iama_gamer, Jan 27, 2012 IP
  5. ezprint2008

    ezprint2008 Well-Known Member

    Messages:
    611
    Likes Received:
    15
    Best Answers:
    2
    Trophy Points:
    140
    Digital Goods:
    1
    #5
    If you know coding , and can handle the basic SQL commands, then adding stuff to a 'database' should be easy. Try SQL or also referred to as My/Sql and the coding language PHP. If you're not using Windows 7 and have the chance to get XP (even though it's older version Windows) it works perfect with PHPMy/Admin its an offline version of a database that you can code on your computer and then download the database that you have offline and upload it online for a perfect transition. You will need 3 things. 1. PHP/SQ: coding understanding lots of help, tutorials online. 2. phpmyadmin (free) 3. WAMP (which sets up an offline server on your computer and comes complete with APache latest version , possibly phpadmin etc. Its as easy as opening the download for getting WAMP set up. Easiest open-source solution on the Internet in my opinion/experience.
     
    ezprint2008, Feb 5, 2012 IP
  6. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #6
    I would suggest MySql workbench. WOrks both online and offline. PhpMyAdmin does have some additional features but MySql workbench doesnt need PHP or such running.
     
    iama_gamer, Feb 5, 2012 IP