Is it possible to use an SQL Database without using MySQL or other database program?

Question

If so, where can I learn how to do so? Thanks

Answer 1

Yes!  First off, phpMyAdmin offers you the ability to write SQL into the database without using the gui tools.  Your other option would be to write a php or python script that inserts sql into the database.  This is done by companies like Myspace when you create an account to insert the user information, or by Google when it queries and returns search results.

There are many PHP tutorials that teach you how to do this, like the one below:

http://www.tizag.com/mysqlTutorial/

Answer 2

Of course you know the SQL database can not be accessed directly.

It MUST be interacted with (or accessed) with the use of a DBMS, (Database Management System) which accesses the database for you.

Here are some of the most popular DBMS:

MySQL

Oracle

Microsoft Access

IBM DB2

PostgresSQL

Sybase Adaptive Server

If you're using phpMyAdmin and MySQL, you're accessing it about as directly as is possible.

Here's some pretty good info:

http://us2.php.net/mysql

Hope that help you

Xyso

.

Answer 3

Yes you can do this you would have to have access to a shell on the server or to the database port on the server. You would also have to to install an mysql client which come with mysql. Check there web page for more info. http://www.mysql.com/

Answer 4

It's a little misinterpretation here. SQL is NOT a database. It's a structured language use to manipulate the database (which commonly written in text, access, MySQL and SQL SERVER). In other hands, SQL Server and MySQL are literally different databases (which can be accessed using SQL Statements), so if an application uses MySQL, changing the database structure would mean designing again the application.