phpMyAdmin

Hello Forumz
Sorry to ask i its stupid but dont know. Is phpMyAdmin used to create tables and edit tables in a mysql database? I it is then I might have got a saver! I donno how to hand-code in MySQL.

Thanks

You can use it to do that yes... You'll never learn to hand code MySQL as it is a database. You need to learn SQL which for what you are doing will be rather easy. Yes, SQL is a very complicated language, but like all languages it does have an easy base.

Examples:

Code: Select all

SELECT * FROM tableName

This will return everything in that table and display it. (in an SQL editor)

Code: Select all

SELECT * FROM tableName WHERE fieldName = value

This lets you "query" the database and find the row(s) that contain the value specified in a certain field

Ok so u mean that to use phpMyAdmin good i have to learn some SQL, right? I think if phpMyAdmin can do everything then I don't need to learn SQL coz I don't think i'm yet to design such a site that will need a sql database. or this will come back later in my design field.
Thanks

Actually, SQL is not as hard to learn as you think....Granted I built and deleted a million databases and had so many failed imports and exports I stopped counting, but slowly but surely I am having better luck...which I quess means, I am learning. PHPAdmin does have a tab for SQL which allows you to write sql statements to use on your database. I practise my sql statements and more often than not they actually do what I want...which is very very exciting.

Yea I was clicking everywhere and there is a place I saw that im supposed to type and sql statement. Ok now I cant go any way round I have to learn it. I tried phpMyAdmin some time before and I couldn't create a single table even by guesing all the fields. it bored me but now I got some interest

Umm. Just to make sure you're not mixed up: phpMyAdmin is NOT SQL. phpMyAdmin is a control panel written in PHP for mySQL databases. It is a control panel, not a programming language...

And you can create tables, databases and do all sorts of stuff with PHPMyAdmin without going near any SQL.

Pete.

As c010depunkk says phpmyadmin is imo the easiest way to alter,add,and on occasions drop entire databases but only in mysql. you dont need to know much about mysql language to use it either.

mmh I think I got that much clear. thanks guys