[Pdns-users] [Ext] Re: Trying to find a simple "how to" - pdnsutil secure-zone version

[Brian Candler]

On 09/04/2019 19:03, Edward Lewis wrote:
> MariaDB [(none)]> CREATE TABLE domains (
>      ->   id                    INT AUTO_INCREMENT,
>      ->   name                  VARCHAR(255) NOT NULL,
>      ->   master                VARCHAR(128) DEFAULT NULL,
>      ->   last_check            INT DEFAULT NULL,
>      ->   type                  VARCHAR(6) NOT NULL,
>      ->   notified_serial       INT UNSIGNED DEFAULT NULL,
>      ->   account               VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL,
>      ->   PRIMARY KEY (id)
>      -> ) Engine=InnoDB CHARACTER SET 'latin1';
> ERROR 1046 (3D000): No database selected
>
> ...It seems I'm missing some sort of a SELECT statement...

You first need to create a database (e.g. "create database pdns;") and 
then select it ("use pdns;")