Interested to Buy Any Domain ? << Click Here >> for more details...
what's the difference between SQL & MY-SQl...?
And what we learn from these ....?
- 2 Answers
- 7791 Views
- Broadridge, I also Faced
- E-Mail Answers
Answer Posted / krishna
In simple terms:
SQL is a common database computer language designed for the retrieval and management of data in relational database management systems (RDBMS) -- basically a standard interactive and programming language for querying and modifying data and managing databases. Very standard for uses ranging from the simplest Microsoft Access applications, up to complex multi-server distributed Oracle applications.
MySQL is a multithreaded, multi-user SQL database management system (DBMS) providing multi-user access to a number of databases. MySQL is commonly the back engine database for a great many applications, and often the database of choice for web-based applications.
Comparing the two is a little like comparing the English language to Tom Clancey's last book, one uses the other -- but from there the differences are many.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to change server name in sql server?
Write a SQL query to make a column as unique?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is buffer cash and log cache in sql server?
Define normalisation?
What is a transact-sql statement batch in ms sql server?
What is a result set object returned by mssql_query()?
What are group functions in query statements in ms sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
define and explain the differences between clustered and non-clustered indexes.
Describe in brief databases and sql server databases architecture.
What is lock escalation and what is its purpose?
How to edit table in sql server 2017?
What is the main difference between ‘between’ and ‘in’ condition operators?
