sscasc@tumkur might be the single client using mysql on your local machineoften referred to as "local hostwithout any network connection at allthe requests to the database server can also be made from program that acts on behalf of user making requests from web page we can connect to the database server from php program using php built-in functions to make requests to the mysql database server the database database is collection of related data elementsusually corresponding to specific application the databases are listed as "mysql,"northwind,"phpmyadmin,and "test the tables each database consists of two-dimensional tables in facta relational database stores all of its data in tables all operations are performed on the tablewhich can then produce other tablesand so on during designing database first we create tables and relate these tables to one another in some way for examplea typical database for an organization might consist of tables for customersordersand products and all these tables are related to one another the records and fields table has name and consists of set of rows and columns it resembles spread-sheet where each rowalso called record each table in database contains zero or more records the vertical columnsalso called fields or attributes and has names all rows from the same table have the same set of columns remembera relational database manipulates only tables and the result of all operations are also tables you can view the database itself as set of tables you can also perform number of other operations on tables and also between two tables by treating them as setsyou can join information from two tablesmake cartesian products of the tablesget the intersection between two tablesadd one table to anotherand so on sql allows you to "talkto database data type can be numbera charactera datea time stampand so on the terms "rowand "recordare often interchangeableas are "columnand "field the primary key and indexes primary key is unique identifier for each record these identifiers are unique in the world of database tableswe call the unique identifier primary key although it is good idea to have primary keynot every table has one the primary key is determined when the table is created the database schema database design is science and requires understanding how the relational model is implemented the term database schemawhich refers to the structure of the database it describes the design of the database similar to template or blueprintit describes all the tablesand their layoutbut does not contain the actual data in the database connecting to the database sp_python programming