SQL (Structured Query Language) is the most popular database language in use today. SQL is used to create database queries that take the form of commands. SQL queries enable you to select, insert, update and determine the location of data, among other tasks. MySQL and Microsoft® SQL Server™ utilize the SQL language.
MySQL is an open source relational database management system that utilizes the SQL database language. It is a multi-user, multi-threaded database server that provides speed, robustness and ease of use. PalmHost’s MySQL databases (supported on UNIX platforms) are hosted on a dedicated MySQL server to ensure better database processing and faster performance.
MS SQL refers to Microsoft® SQL Server™. Microsoft SQL Server is a complete database and data analysis software package.
PalmHost’s UNIX platforms support MySQL.
When you create your database, you will specify the database
name username and password. To access your
MySQL database, you can use PHP or Perl (DBI or the Mysql.pm module). You can also
access your database via the command line using SSH.
PalmHost will help you connect to your database and assist you in troubleshooting database issues. We do not, however, assist you with building your databases.