MySQL stores given relation data in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive...
Html Table is used to present structured data in the web pages. Html table was very popular in previous days but with the more dynamic applications and div usage it loss some of its popularity. In this tutorial we will look basic table features. Define Html Table Table definition might be...
Windows operating system have a lot of third party tools used to get detailed system information like operating system, version, boot time, processor etc. We will look simple single command systeminfo to get detailed system information. List Information We will just issue the systeminfo command to get information about the computer.
1 | $ systeminfo |
...
MySQL database is very popular database server used by a lot of small and big companies. In this tutorial we will look the basics of MySQL server like creating database and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How...
One of the most important task of a database administrator is backing up and restoring databases. MySQL is a popular database server and provides tool named mysqldump for backup and restore operations. We will look different usage types of mysqldump in this tutorial. Syntax
1 2 3 4 5 | mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR mysqldump [OPTIONS] --all-databases [OPTIONS] |
Help
1 | $ mysqldump --help |
Connect Remote Database Server...
Mariadb is an open source database forked from another popular open source database MySQL. MariaDB developers are original developers of the MySQL. After Oracle get management of the MySQL project they become unhappy with the management of the Oracle and started MariaDB project. Latest available version for MariaDB was 10.1.18...
