mariadb root@localhost:dyw> create temporary table sales(product varchar(20) not null,price decimal(7,2) not null default 0.00); Query OK, 0 rows affected Time: 0.003s
mariadb root@localhost:dyw> show tables; +----------------+ | Tables_in_dyw | +----------------+ | animals | | clone1_animals | | clone_animals | | dcount | | employees | | indextab | | tbl | +----------------+ 7 rows in set Time: 0.021s
mariadb root@localhost:dyw> insert into sales(product,price) values('computer',2 0000); Query OK, 1 row affected Time: 0.004s
mariadb root@localhost:dyw> select * from sales; +----------+----------+ | product | price | +----------+----------+ | computer | 20000.00 | +----------+----------+ 1 row in set Time: 0.062s
mariadb root@localhost:dyw> quit; Goodbye!
[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 - Steve Robbins
mariadb root@localhost:(none)> use dyw; You are now connected to database "dyw" as user "root" Time: 0.001s mariadb root@localhost:dyw> select * from sales; (1146, "Table 'dyw.sales' doesn't exist")