Jump to content
Killersites Community
Sign in to follow this  
fahim

Creating a Mysql database

Recommended Posts

Hi all!

I wish to learn mysql database as it is a must to have working knowledge of database in case of database driven web sites. As a beginner everything is a matter of confusion to me. I searched online to know about how to create a database. I saw different ways. But which is the best way to create a Mysql database? What ways(PhpMyadmin, CLI etc) the professional mysql developer naturally use to create databases in their work? Hope to be helped.

Thanks in advance.

Share this post


Link to post
Share on other sites

MySQL is often used with PHP and you can't test PHP on your computer unless you upload everything to your server or unless you install Apache server and PhpMyAdmin on your computer to test locally. I use WampServer http://www.wampserver.com/en/ but you can also use XAMPP, both for Windows PCs. Both give you MySQL and PhpMyAdmin so that you can test locally. PhpMyAdmin will give you access to MySQL.

 

Use a tutorial like http://www.w3schools.com/php/default.asp or http://www.tizag.com/phpT/index.php for PHP and http://dev.mysql.com/doc/refman/5.0/en/tutorial.html for MySQL

Share this post


Link to post
Share on other sites

I am already able to make web application with basic php and trying to grasp OOP in it. I would like to learn about database web application by Mysql along with php. Simply I use phpmyadmin to test my simple application in local server(it is WAMP). But I wish to learn about how professional developers create their database application in web servers generally in their daily job. Which way(phpmyadmin, CLI etc) they use to create their databases?

Thanks.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×