Friday, 1 October 2021

SQL DELETE Statement sql videos in Telugu 22

 https://youtu.be/s8e2cxkpHJw

-------------------------------------------------
source vlr/createemp1.sql


Setting environment for using XAMPP for Windows.
# mysql -h localhost -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.4.18-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> USE vlrinst;
Database changed
MariaDB [vlrinst]> show tables;
+-------------------+
| Tables_in_vlrinst |
+-------------------+
| emp               |
| emp1              |
+-------------------+
2 rows in set (0.000 sec)

MariaDB [vlrinst]> drop table emp1;
Query OK, 0 rows affected (0.152 sec)

MariaDB [vlrinst]> show tables;
+-------------------+
| Tables_in_vlrinst |
+-------------------+
| emp               |
+-------------------+
1 row in set (0.001 sec)

MariaDB [vlrinst]> source emp.sql;
ERROR: Failed to open file 'emp.sql', error: 2
MariaDB [vlrinst]> source vlr/emp.sql;
Query OK, 0 rows affected (0.280 sec)

MariaDB [vlrinst]> show tables;
+-------------------+
| Tables_in_vlrinst |
+-------------------+
| emp               |
| emp1              |
+-------------------+
2 rows in set (0.001 sec)

MariaDB [vlrinst]>

No comments:

Post a Comment

Note: only a member of this blog may post a comment.