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
   241   242   243   244   245   246   247   248   249   250   251