Jump to content

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.

Link to comment
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

Link to comment
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?


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...