MySQL
Raiting:
2

Difference Between SQL and MySQL


Sql means structured query language, which is the standard language for accessing and manipulating databases. mysql is a database management system like sql Server, oracle, informix, postgres, etc. mysql is an rdms (relational database management system).

When considering data management utilities, the two most popular options are mysql and sql server. Both effectively keep data organized and easily available through the user interface. Both techniques have the concept of a schema for data storage (i.e. table storage).

To better understand the differences in mysql and sql server, mysql is more inclined to select data so you can display, update and save again. mysql is weak in terms of inserting and deleting data. But it's a good choice for data storage and data reference.

Here are some specific technical differences between mysql and sql servers, when it comes to the ANSI sql standard: functions like stored procedures, triggers, views and cursors become part of the mysql database server in mysql 5.0 version 5.0 and you still won't find a rich set of functions and features in terms of development. For more depth analysys click sql vs mysql.
Naymor 10 april 2020, 15:50
Vote for this post
Bring it to the Main Page
 

Comments

Leave a Reply

B
I
U
S
Help
Avaible tags
  • <b>...</b>highlighting important text on the page in bold
  • <i>..</i>highlighting important text on the page in italic
  • <u>...</u>allocated with tag <u> text shownas underlined
  • <s>...</s>allocated with tag <s> text shown as strikethrough
  • <sup>...</sup>, <sub>...</sub>text in the tag <sup> appears as a superscript, <sub> - subscript
  • <blockquote>...</blockquote>For  highlight citation, use the tag <blockquote>
  • <code lang="lang">...</code>highlighting the program code (supported by bash, cpp, cs, css, xml, html, java, javascript, lisp, lua, php, perl, python, ruby, sql, scala, text)
  • <a href="http://...">...</a>link, specify the desired Internet address in the href attribute
  • <img src="http://..." alt="text" />specify the full path of image in the src attribute