XAMPP, SQL BASIC COMMANDS

 Microsoft Windows [Version 10.0.19042.867]

(c) 2020 Microsoft Corporation. All rights reserved.


C:\Users\darul Haram>../..

'..' is not recognized as an internal or external command,

operable program or batch file.


C:\Users\darul Haram>cd../..


C:\>xampp

'xampp' is not recognized as an internal or external command,

operable program or batch file.


C:\>cd xampp


C:\xampp>cd mysql


C:\xampp\mysql>cd bin


C:\xampp\mysql\bin>../

'..' is not recognized as an internal or external command,

operable program or batch file.


C:\xampp\mysql\bin>cd .//


C:\xampp\mysql\bin>cd ../


C:\xampp\mysql> -u root -p -h localhost

'-u' is not recognized as an internal or external command,

operable program or batch file.


C:\xampp\mysql>cd bin


C:\xampp\mysql\bin>cd mysql

The system cannot find the path specified.


C:\xampp\mysql\bin>mysql -u root -p -h localhost

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 8

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)]> show database

    -> Bye

Ctrl-C -- exit!


C:\xampp\mysql\bin>mysql -u root -p -h localhost

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 9

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)]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| phpmyadmin         |

| test               |

+--------------------+

5 rows in set (0.015 sec)


MariaDB [(none)]>  create database Ar-rahman

    -> create database Ar-rahman;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-rahman

create database Ar-rahman' at line 1

MariaDB [(none)]> create database Ar-rahman;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-rahman' at line 1

MariaDB [(none)]> crate database Arrahman;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'crate database Arrahman' at line 1

MariaDB [(none)]> create database Arrahman;

Query OK, 1 row affected (0.008 sec)


MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| arrahman           |

| information_schema |

| mysql              |

| performance_schema |

| phpmyadmin         |

| test               |

+--------------------+

6 rows in set (0.002 sec)


MariaDB [(none)]> drop database Arrahman;

Query OK, 0 rows affected (0.006 sec)


MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| almerciful         |

| information_schema |

| mysql              |

| performance_schema |

| phpmyadmin         |

| test               |

+--------------------+

6 rows in set (0.001 sec)


MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| phpmyadmin         |

| test               |

+--------------------+

5 rows in set (0.002 sec)


MariaDB [(none)]> create database Arrahman;

Query OK, 1 row affected (0.002 sec)


MariaDB [(none)]> use Arrahman;

Database changed

MariaDB [Arrahman]>

MariaDB [Arrahman]> select database();

+------------+

| database() |

+------------+

| arrahman   |

+------------+

1 row in set (0.001 sec)


MariaDB [Arrahman]>

Comments

Post a Comment

Popular posts from this blog

The Minion Game Hackerrank Solution

Image
  Kevin and Stuart want to play the ' The Minion Game '. Game Rules Both players are given the same string,  . Both players have to make substrings using the letters of the string  . Stuart has to make words starting with  consonants . Kevin has to make words starting with  vowels . The game ends when both players have made all possible substrings. Scoring A player gets  +1  point for each occurrence of the substring in the string  . For Example : String   =  BANANA Kevin's vowel beginning word =  ANA Here,  ANA  occurs twice in  BANANA . Hence, Kevin will get  2  Points. For better understanding, see the image below: Your task is to determine the winner of the game and their score. Function Description Complete the  minion_game  in the editor below. minion_game  has the following parameters: string string:  the string to analyze Prints string:  the winner's name and score, sepa...
Read more

Arrays - DS | HackerRank Solutions

  An   array   is a type of data structure that stores elements of the same type in a contiguous block of memory. In an array,   , of size   , each memory location has some unique index,     (where   ), that can be referenced as     or   . Reverse an array of integers. Note:  If you've already solved our C++ domain's  Arrays Introduction  challenge, you may want to skip this. Example Return  . Function Description Complete the function  reverseArray  in the editor below. reverseArray  has the following parameter(s): int A[n] : the array to reverse Returns int[n] : the reversed array Input Format The first line contains an integer,  , the number of integers in  . The second line contains   space-separated integers that make up  . Constraints Sample Input 1 Copy Download Array: arr 1 4 3 2 4 1 4 3 2 Sample Output 1 2 3 4 1 ## Solutions:1-- import  math impor...
Read more