Page 246 - PYTHON-12
P. 246
7. Powerful Language: All SQL operations are performed at a prescribed and fixed level, i.e.,
one SELECT command can retrieve data from multiple rows and one MODIFY command
can edit multiple rows at a time. These features make SQL a very powerful language as
compared to other languages where one command can process only a single record at a
time.
8. Reliable: SQL provides a high level of well-defined set of commands that provides the
desirable results without any ambiguity.
9. Freedom of Data Abstraction: SQL provides a greater degree of abstraction freedom
compared to any other procedural language.
10. Complete Language for a Database: Apart from being a strong query processing
language, it can also be used to create, insert, delete and control access to data in
databases.
12.11.1 Starting the MySQL Database
MySQL is an open-source database system. You can download and install it directly from the
internet. After installing, you need to start working with MySQL by following the given steps:
Alternatively, (for Windows 7 and above)
Start ® Apps by name
® MySQL Command Line Client
Computer Science with Python–XII 12.16 Fig. 12.16: Steps to Start MySQL