Some useful updates on the practical side of database management added to the MySQL and PostgreSQL pages of the NTC Hosting Encyclopedia
Further to our previous post about some important aspects of database management, we’ll now go into details about working with two of today’s most widely used database systems on the net. There is a lot to say about MySQL – the open-source database component of the LAMP platform, which has been on the top of the popular database types list for years due to its unequalled performance levels, and PostgreSQL – the more recent member of the SQL databases family, which has been gaining good credits laely for its superior data integrity features.
Although we have already talked to you about those database types in the Databases Terminology section of our NTCHosting Encyclopedia – the practical aspect of using them still needs some important clarification. For that purpose, we added some illustrative examples to their special articles with the sole purpose of expanding your knowledge of what MySQL and PostgreSQL databases refer to.
What is new about the MySQL databases article? A whole new section with easy-to-apply examples has been added. Here you can see in details what commands should be used to create a MySQL tables, to insert data into a MySQL table, to select data from a MySQL table (3 examples), to update data in a MySQL database, or to delete data from a MySQL database, etc. In addition, you will see an example of how a MySQL table (with its field, type, collation, attributes, null, default, extra categories) looks like in the PHPMyAdmin interface. All that new information will give you a good basis for starting to work with MySQL.
Similar updates have been applied to the PostgreSQL databases article. The newly added block of exemplary commands for efficient PostgreSQL management can serve as a valuable reference for all users new to this type of SQL databases. The examples feature useful commands that you can use to create PostgreSQL tables, insert data into a PostgreSQL table, select data from a PostgreSQL table (3 examples), update/delete data in a PostgreSQL database, delete a PostgreSQL table, etc. In line with the data administration updates to the PostgreSQL article we also added some new details to the article reviewing the phpPgAdmin database manager to bring some more light on the range of options you have to control PostgreSQL databases.
MySQL and PostgreSQL databases are powerful means of storing and handling various data on dynamic websites. To make full use of their flexible functionalities, users resort to the PHP programming language. With the help of specific PHP-written scripts, they make direct connections with the MySQL or PgSQL databases, whichever of both database types underlie their sites. In the newly updated PHP scripting language article you will find a useful example of a basic PHP-scripted string of queries for MySQL database manipulation, including Connecting and selecting database, Performing SQL query, Printing Result, Free resultset, and Closing connection.
Tags: database management, MySQL, mysql database, MySQL databases, MySQL table, PHP programming language, PHPMyAdmin, phpPgAdmin, PostgreSQL, PostgreSQL databases, PostgreSQL table