I am a starter in MySQL Database. I find it very usual and most databases I tried works just the same like MySQL database but I want to clearly know how does really a database works?
In programming world, database is an important factor in creating any kind of software or website. SQL (Structured Query Language) is a programming language that is used to query the stored information in database. When you type
Select * from table where name=’Harry’
The database will interpret this query and looks for the table that has the data named as “Harry”. To display it, you need to incorporate SQL code with another programming code such as PHP or Java. All the information that you have stored in the database will be simply managed using your system’s virtual memory.
If you want to know other database platform aside from MySQL, you might want to try MSSQL. This is the short version for Microsoft SQL server. Like MySQL, it can store any type of data but unlike it, MSSQL is not for free.
Hi there,
now a days relational databases are prevalent. By relational we mean, these databases keep their data in the forms of tables that have rows and columns of data and a key field which is used to identify the specific rows or columns. MySql is a relational database. In order to get data out from the database, we need to give specific instructions which comprise a specific language called SQL or structured query language. An example is “Select * from table_A where age > 25” this query will look in table table_A and bring out all the rows where age filed value is greater than 25. Similarly there is a whole plethora of statements that are used to manipulate data in a database. Some very common industry databases are Oracle, MS SQL Server, Sybase, DB2 etc.
Additional Information: If you are running DOS program in XP, It will probably works in 32-bit version of windows 7. Caution: Do not run DOS program in a 64-bit version of windows 7. It will never happen to work on 64-bit version of windows 7. To create Virtual (VM) inside Windows you will need to have Software. Many IT Specialists, have tried VMware Player because it is possible to run a lot different OS inside Windows. Whereas, if you would like to run DOS programs try DOSBox, a free program that will give you DOS VM. About MySQL, One thing you need to know is the independent attribute. MySQL is very independent in a way that it will survive without having an extra attention to Oracle does, MySQL won’t give it a dumb. The MySQL inventor Michael “Monty”Widenius, have created offshoots of the database’s code base. This will include the forking trend that even Oracle ending the new MySQL features to the open-source community. This won’t be a problem for customer’s because of their wide options. Furthermore, MySQL is the best website support for Linux, Apache, MySQL and PHP.
