0
MSSQL is the abbreviation for the Server system Microsoft has.
Compared to MySQL, which is the SQL server system that is open source, maintained by the MySQL company (Now owned by Sun).
Wiki User
∙ 12y ago
Wiki User
∙ 10y agoMySQL server has more functions than the MS (Microsoft) SQL server. Both have the following database features and more: High-Availability Clustered Database, ANSI SQL, SubQueries, Joins, Cursors, Prepared Statements, Stored Procedures, Triggers, SQL and User-Defined Functions, Updateable Views, ACID Transactions with Commit, Rollback, Distributed Transactions, Row-level Locking, Snapshot/Consistent Repeatable Reads, Server-enforced Referential Integrity, Strong Data type support. However MySQL has the following that is not supported on MS SQL: it's available on two-dozen platforms (32 and 64 bit) including windows, Open Source, Pluggable Storage Engine Architecture, and a Unique Query Cache.
Add your answer:
Earn +20 pts
1 How do you upload a database directly on to a server 2 how do you download the database from a server Kindly tell me all possibilities as soon sa possible.?
1) there are a few databases, if you are using MYSQL or MSSQL or just a CV file 2) If it's a MSSQL just use the IMPORT and Export manger, if its MYSQL just use the MYSQL dump to a *.sql file Take in consideration that most dedicated server over the internet are not working on default port due to hacking. And there are many softwares in www.download.com to BACKUP MYSQL and MSSQL server. Anyways learn to ask a question.
Is mysql better than mssql?
Mysql is the most popular open source database server right now. It is used by large enteprise level companies and small, single websites.
How is MSSQL different from MySQL?
MSSQL has more professional features than MySQL and is used by most large companies who need a serious database setup. MySQL works great as a simple database, and is also open source, which allows you to modify its code to fit your needs.
What is difference between database and database management system?
A database is a collection of tables which store information. A Database Management System is an application/environment for creating, modifying and administering any number of individual databases. For example: MSSQL databases are typically managed using MS SQL Server Management Studio MySQL databases are commonly managed using PHPMyAdmin
What is MySQL shareware?
It's a very old name for the mysql server daemon.
Why do you keep getting this error Warning mysql connect function mysql-connect Can't connect to local MySQL server through socket 'tmpmysql sock' 2 in mntsdbwww2smut360 comhtdocsincc?
Make sure that the MySQL server is running.
Can you use mysql instead of sql as backend?
Assuming you have MySQL installed on your server then yes.
Is MySQL a server?
MySQL is an open source relational database management system based on SQL queries. It was developed by the Swedish company MySQL AB and is now a subsidiary of Oracle Corporation. Your could use a MySQL Client, for example dbForge Studio for MySQL, to install and connect to MySQL Server as a first steps to get started with MySQL.
What host do you use when your MySQL database is on a separate server to your PHP scripts?
For the host you need to put the IP address of the MySQL server instead of localhost.
What database does the WAmmp server refer to when it's used with PHP?
WAMP is an abbreviation of "Windows, Apache, MySQL, and PHP", so it uses MySQL database server.
What are the differences between sql and mysql?
SQL is short for Structured Query Language, and MySQL is a database management system, like SQL Server 2005, Oracle.An example would be other programming languages like BASIC and QBASIC where BASIC is the generic term for the BASIC programming language and QBASIC is Microsoft's version (quick BASIC) and TURBO BASIC was Borlands version.oracle supports the user defined datatypes,where as mysql not support all these types of datatypes, like user defined , and cursors like these stuff;;
What is the difference between mysql server and oracle server?
While these three products are very similar, there are some differences. MySQL does not have a GUI interface while the other two do, it is also the only open source product of the three. SQL Server only runs on Windows, while the other two run on a variety of operating systems. Language support differs among the three, with each having some unique language support.
