Using the MAC address table type

The MAC table type allows us to look up and query various bits of information about the network connection and network setup of our local machine.

Getting ready

The MAC table type works only in Windows. So, this recipe requires the Windows OS.

How to do it...

1. Launch the mysql command-line client application and connect to the test database on our MariaDB server. If the test database does not exist, create it first.

2. Run the following CREATE TABLE statement to create a MAC table:

   CREATE TABLE host (
     hostname varchar(132) flag=1,
     domain   varchar(132) flag=2,
     ipaddr   char(16)     flag=15,
     gateway  char(16)     flag=17,
     dhcp     char(16)     flag=18,
     leaseexp datetime     flag=23
   ) ENGINE=CONNECT TABLE_TYPE=MAC;
   

3. Run the following SELECT statement to query the information about our current network settings:

   SELECT * FROM host;
   

How it works...

Information on our network cards and their current settings is actually pretty easy to get, so the MAC table type...