How To Learn MySQL ? How to learn MySQL ?

Hi Guys,I want to learn to use MySQL in my site. I'm told that it is already installed. But I don't know how to use it.I've installed PHP Triad in my machine and with MySQL.Please hyperlink to a website containg articles on these.Bye,Bigyan

well, go like this:think about what needs to be stored in your database. think about good names for the tables, for example: users, and the fields (ie: username, id, password, rights, emailadress,...)then you make that table with phpmyadmin, which can be found in your c-panel and is quite easy.accessing and modifying data can be done with the php functions that start with mysql_, just go to php.net and search for mysql. you'll find all the info & examples you'll needoff course, you have to know sql. because the php function mysql_query will only do what it's instructed to do by the given sql queryfor example: select * from users where username="bigyan"will give you an mysql_result object with all the info of that user.then you have to fetch that info, but the howto of that can be found on php.netso what you'll need is:-phpmyadmin-http://forums.xisto.com/no_longer_exists/ a short sql tutorial. all you need to know is: insert, update and select.

mySQL is simple, all you need is phpmyadmin, and you're set. after using myadmin for a few monthes, i was writiing out scripts, and dropping them myself into the tables. i would highly suggest using PHPnuke to learn all of the above (mySQL, HTML, PHP) mySQL is probably the most simple language out there.

I have e-books about MySQL. Tell me if you want them. Or is this illegal?hehehe

I have e-books about MySQL. Tell me if you want them. Or is this illegal?hehehe

<{POST_SNAPBACK}>

Just all you need is either phpmysqladmin or Thick mysql admin, you will be provided with your database host address along with port,user name password and default database name. Use Mysql Admin to connect to your database with these informaion.

Cheers

Arunkumar.H.G

Just run a search on google for 'MySQL Tutorials' and just pick a site that gives a short introduction of MySQL and it's basic syntax and functions... After you know some MySQL, look for MySQL PHP Tutorials so you would know the basic PHP functions used to communicate with MySQL: or better yet, read the PHP Manual. It has all of PHP's built in functions for communicating with MySQL. .::Cheers::.

Hey mhykhh,Plz do send me the ebooks that u have. I am really desperate to put up a database on web. It'll make my web-design much simpler !!Bye,Bigyan

You know, if you go to the library and check out a couple of books on PHP and MySQL books... such as "PHP & MySQL For Dummies", you might learn quite a bit as well, without spending too much time on it.At least, that's how I'm learning it. And don't discount friends and acquaintances, as well. They can be very helpful if you know the right people.

Bigyan:

there are many concept you need to understand before using mysql. here the links for my previous comment on this topic:

http://forums.xisto.com/topic/80979-topic/?findpost=

hope it will help.

Hi all,
This might not seem related to php or this post in general but certainly for anyone dabbling in mysql and .net - either to develop software or asp.net web apps - this site is extremely useful and handy as a reference: https://www.connectionstrings.com/ - the site contains one of the most comprehensive and well covered lists of the database conneciton strings used by vb/c#/asp.net to connect to any of the relational databases. The page lists connections strings for over 22 different databases - including MSSQL, MySQL, Oracle, IBM DB2, Interbase, Sybase, Informix, Access ... the list goes on. Just when you feel really messed up about the right connection string and are about to pull half of your hair off - give this site a shot..
Cheers