[root@kvm3 ~]# mycli -S /var/lib/mysql/mysql.sock -uroot -p123qwe mariadb 10.3.11-MariaDB mycli 1.20.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - Lewis Peckover
mariadb root@localhost:(none)> use dyw; You are now connected to database "dyw" as user "root" Time: 0.001s
mariadb root@localhost:dyw> insert into tbl (title,author,submission_date) value s("PHP","david",NOW()); (1146, "Table 'dyw.tbl' doesn't exist")
mariadb root@localhost:dyw> create table tbl(id int not null auto_increment, tit le varchar(100) not null, author varchar(40) not nul l,submission_date date, primary key(id)); Query OK, 0 rows affected Time: 0.091s
mariadb root@localhost:dyw> insert into tbl (title,author,submission_date) value s("PHP","david",NOW()); Query OK, 1 row affected Time: 0.006s
mariadb root@localhost:dyw> insert into tbl (title,author,submission_date) value s("MariaDB","dywang","2020-01-01"); Query OK, 1 row affected Time: 0.004s
mariadb root@localhost:dyw> insert into tbl (title,author,submission_date) value s("Linux","linux","2020-01-11"); Query OK, 1 row affected Time: 0.004s