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