Chapter 18, MySQL and SQLite Database Administrations

  1. To store the data in rows and columns, and perform the different operations easily and faster.
  2. In the database, CRUD means (Create, Read, Update, Delete).
  3. Yes, here's an example:
MySQLdb.connect('remote_ip', 'username', 'password', 'databasename')
  1. Yes.
  2. DDL stands for Data Definition Language. It is used to define data structures. For example, with SQL, it would be instructions such as create table, alter table. DML stands for Data Manipulation Language. It is used to manipulate the data itself. For example, with SQL, it would be instructions such as insert, update, and delete.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset