A MySQL database contains one or more tables, each of which contains records or rows. Within these rows are various columns or fields that contain the data itself.
Featured Post
What is the purpose of the php.ini file?
The PHP configuration file, php.ini , is the final and most immediate way to affect PHP's functionality. The php.ini file is read ea...
What does SQL in MySQL stand for?
The SQL in MySQL stands for Structured Query Language. This language is also used in other databases such as Oracle and Microsoft SQL Server. One can use commands such as the following to send requests from a database:
SELECT title FROM publications WHERE author = ' J. K. Rowling’;
Note that SQL is not case sensitive. However, it is a good practice to write
the SQL keywords in CAPS and other names and variables in a small case.
What do you mean by ‘databases’?
A database is a structured collection of data stored in a computer system and organized in a way to be quickly searched. With databases, information can be rapidly retrieved.
Subscribe to:
Posts (Atom)
Popular Posts
-
You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum sala...
-
Answer: select * from emp where hiredate < (’01-jan-81’);