Translate

Friday 17 September 2021

What is sql and who can learn in telugu 04

 https://youtu.be/h-01cFFRwCg

---------------

etting environment for using XAMPP for Windows.
enkat@VENKAT-PC c:\xampp
 mysql -h localhost -u root
elcome to the MariaDB monitor.  Commands end with ; or \g.
our MariaDB connection id is 2
erver version: 10.1.37-MariaDB mariadb.org binary distribution

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

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

ariaDB [(none)]> select *
   -> ;
RROR 1096 (HY000): No tables used
ariaDB [(none)]> SHOW DATABASES;
--------------------+
 Database           |
--------------------+
 gamming            |
 hotel              |
 information_schema |
 mysql              |
 nalini             |
 performance_schema |
 phpmyadmin         |
 sreenu             |
 telugumovies       |
 test               |
 training           |
--------------------+
1 rows in set (0.01 sec)

ariaDB [(none)]> CREATE DATABASE TESTDB;
uery OK, 1 row affected (0.00 sec)

ariaDB [(none)]> SHOW DATABASES;
--------------------+
 Database           |
--------------------+
 gamming            |
 hotel              |
 information_schema |
 mysql              |
 nalini             |
 performance_schema |
 phpmyadmin         |
 sreenu             |
 telugumovies       |
 test               |
 testdb             |
 training           |
--------------------+
2 rows in set (0.00 sec)

ariaDB [(none)]>





































No comments:

Post a Comment

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