allanop Posted September 26, 2006 Share Posted September 26, 2006 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? Link to comment Share on other sites More sharing options...
justsomeguy Posted September 26, 2006 Share Posted September 26, 2006 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. Link to comment Share on other sites More sharing options...
Ruud Hermans Posted September 30, 2006 Share Posted September 30, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now