SQL question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
claudia
Forum Newbie
Posts: 3
Joined: Tue Mar 09, 2004 11:49 am

SQL question

Post by claudia »

This may be a dumb question but does anyone know how to log into an existing SQL database and make changes. I am proficient in PHP and MySQL, I usually just telnet into the server I am working on and access the MySQL database that way. Is it done the same way for SQL or is there certain software that I need to use?
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

If you're using PHP 4.* the mysql functions are inbuilt (or bundled).
Have a look at: http://uk2.php.net/mysql

Should be a piece of cake for you :)

For general maintainance, I'd suggest http://www.phpmyadmin.net (PHPMyAdmin) - a very powerful mysql admin tool.[/url]
claudia
Forum Newbie
Posts: 3
Joined: Tue Mar 09, 2004 11:49 am

Post by claudia »

I am not using PHP. I am using ASP. All the ASP is completed as well as the SQL database on the SQL server. I just need to remotely connect to the SQL server to access the database and make some updates to the database itself. I just don't know how to connect to the actual database itself directly. Can I just telnet into the server or do I need certain Microsoft specific software being that the database is SQL.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Hmm...not sure where to find a good ASP forum out there, but I am sure someone there would definitely know the answer.
claudia
Forum Newbie
Posts: 3
Joined: Tue Mar 09, 2004 11:49 am

Post by claudia »

THANKS! I'll look around.
Post Reply