Overview On Databases

Overview On Databases What is a Database? : A database is a systematic collection of data. Databases support storage and manipulation of data. Databases make data management easy. They do so through the use of tables. For example, a university database might contain information about the following: •    Entities such as students, faculty, courses, and […]

MySQL Interview Questions -4

MySQL Interview Questions -4 Q.How To Shutdown MySQL Server? If you want to shutdown your MySQL server, you can run the “mysqladmin” program in a command window as shown in the following tutorial: >cd mysqlin >mysqladmin shutdown Q.How To Extract a Unit Value from a Date and Time? If you want to extract a specific […]

MySQL Interview Questions -3

MySQL Interview Questions -3 Q.Explain some of the uses of MYSQL? Mysql is widely used for web applications. This acts as a database component for many languages such as BAMP, WAMP, LAMP and MAMP. PHP and ruby added to popularity to the language. PHP and MYSQL are very much used for managing database and web […]

MySQL Interview Questions -2

MySQL Interview Questions -2 Q.What Is MySQL? MySQL is an open source database management system developed by MySQL AB. Q.What Is Column? A column defines one piece of data stored in all rows of the table. Q.What Is CSV? CSV (Comma Separated Values) is a file format used to store database table contents, where one […]

MySQL Interview Questions -1

MySQL Interview Questions -1 Q.How do you find out which auto increment was assigned on the last insert? SELECT LAST_INSERT_ID() will return the last value assigned by the auto_increment function. Note that you don’t have to specify the table name. Q.What does + mean in REGEXP? At least one character. Appendix G. Regular Expressions from […]