sql

[allanop]

i am a beginner to use a sql language, i do not know where i can start or where i can put a commands line. is it in DOS, what drive?

[justsomeguy]

You enter SQL commands in the SQL server software, whatever software you are using. MySQL is free and includes a command line utility. You can download it from mysql.org, there is also plenty of documentation and help on that site about how to use it.

[Ruud Hermans]

If you decide to learn MySQL I can recommend the book MySQL written by Paul DuBois witch also go's in deeper about the PHP, and DBI API from Perl.Anyway after you downloaded MySQL from www.mysql.com you can connect to the database using:

C:\>mysql -h (location) -u (user) -p (password)

short if my database would be on my own computer and I would use the default username witch is root it would look like:

C:\>mysql -hlocalhost -uroot -p

After this command you will be asked for the password witch is blank if you did not set no password.More documentation about MySQL can be found at their website.Ruud Hermans