SQL, SYNTAX.

[Chikwado]

Some one check this: I am completely new to sql, Now, where do I have to type following code? Not in the Notepad.

SELECT*FROM Customers;

And what exactly does the above code do? Although I have not create table but have create mysql username and password, I can login to phpmyadmin using the following address:

http://localhost/phpmyadmin

some one help please. Edited February 25, 2015 by Chikwado

[thescientist]

If you have phpMyAdmin, then you need to start making tables so you can run queries on them. Following the SQL tutorials all the way through will show all the basic commands. Try that first.

[justsomeguy]

phpMyAdmin also has a SQL tab where you can type and execute SQL queries.

[Chikwado]

Exactly, Now how do you locate that tab?

Edited February 25, 2015 by Chikwado

[justsomeguy]

I prefer to use my eyes. I'm not sure what you're asking.

[thescientist]

there's even a demo on the phpmyadmin site

http://demo.phpmyadmin.net/master-config/#PMAURL-0:index.php?db=&table=&server=2&target=&lang=en&collation_connection=utf8mb4_unicode_ci&token=9960badedb9d13689215dbd182f32e57

 

Second tab is SQL