wanted help in mysql, some tutorial?

[danvictor2041]

wanted help in mysql, some tutorial?

 

[Dead-i]

The official website is helpful for learning MySQL:
http://www.mysql.com/

Here is a little beginners tutorial for MySQL if you want to know the main commands.
MySQL has many databases which you can create within cPanel, and inside those databases there are tables.
In these table there are different columns, and you can insert records/rows by running the INSERT command.

To view all the records in a table named 'mytable', run:

SELECT * FROM mytable;

You can also use the WHERE statement to search for a specific record. In this example, it shows all rows where (in the fullname column) the cell is 'deadi':

SELECT * FROM mytable WHERE fullname='deadi';

The WHERE statement also works with different operators: > and < and !=. This example uses < which means 'is less than'.

SELECT * FROM mytable WHERE age < '30';

The INSERT command allows you to insert a new record into the table. This command inserts a row where the 1st column is '2', the 2nd column is 'deadi' and the 3rd column is '25'.

INSERT INTO mytable VALUES(2, 'deadi', '25');

You don't need to wrap numbers in 's.

The DELETE command deletes a cell; the syntax is similar to SELECT:

DELETE FROM mytable WHERE fullname='deadi';

Hopefully that's enough to get you started

 

[elle_hon0831]

http://www.developphp.com look this site, many tutorials u can learned many things in that..... php, mysql, javascript or html.