Enter password: *****

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

Your MySQL connection id is 18
Server version: 8.0.36 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective
owners.

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

mysql> create database electronicvehicle;

Query OK, 1 row affected (0.01 sec)

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| electronicvehicle |
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
7 rows in set (0.02 sec)

mysql> create database electricvehicle;

Query OK, 1 row affected (0.00 sec)

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| electricvehicle |
| electronicvehicle |
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
8 rows in set (0.00 sec)

mysql> use electricvehicle;

Database changed
mysql> create table scooterinfo()
-> ^C
mysql> create table scooterinfo(
-> company_name varchar(30),
-> model_name varchar(20),
-> price_integer,
-> chargingtime_minute integer,
-> mileage integer
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ',
chargingtime_minute integer,
mileage integer
)' at line 4
mysql> create table scooterinfo(
-> company_name varchar(30),
-> model_name varchar(20),
-> price integer,
-> chargingtime_minute integer,
-> mileage integer
-> );
Query OK, 0 rows affected (0.03 sec)

mysql> show tables;

+---------------------------+
| Tables_in_electricvehicle |
+---------------------------+
| scooterinfo |
+---------------------------+
1 row in set (0.02 sec)

mysql> desc scooterinfo;

+---------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+-------------+------+-----+---------+-------+
| company_name | varchar(30) | YES | | NULL | |
| model_name | varchar(20) | YES | | NULL | |
| price | int | YES | | NULL | |
| chargingtime_minute | int | YES | | NULL | |
| mileage | int | YES | | NULL | |
+---------------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> select*from scooterinfo;

Empty set (0.01 sec)

mysql> select*from scooterinfo;

+--------------+------------+-------+---------------------+---------+
| company_name | model_name | price | chargingtime_minute | mileage |
+--------------+------------+-------+---------------------+---------+
| ABC | abc | 120 | 5 | 100 |
+--------------+------------+-------+---------------------+---------+
1 row in set (0.00 sec)

mysql> select*from scooterinfo;

+--------------+------------+-------+---------------------+---------+
| company_name | model_name | price | chargingtime_minute | mileage |
+--------------+------------+-------+---------------------+---------+
| ABC | abc | 120 | 5 | 100 |
+--------------+------------+-------+---------------------+---------+
1 row in set (0.00 sec)

mysql> select*from scooterinfo;

+--------------+------------+-------+---------------------+---------+
| company_name | model_name | price | chargingtime_minute | mileage |
+--------------+------------+-------+---------------------+---------+
| ABC | abc | 15000 | 5 | 100 |
+--------------+------------+-------+---------------------+---------+
1 row in set (0.00 sec)

mysql> select*from scooterinfo;

Empty set (0.00 sec)

mysql> select*from scooterinfo;

+--------------+------------+-------+---------------------+---------+
| company_name | model_name | price | chargingtime_minute | mileage |
+--------------+------------+-------+---------------------+---------+
| QWERTY | abc | 15000 | 122 | 100 |
| ASDF | asdf | 12000 | 55 | 101 |
+--------------+------------+-------+---------------------+---------+
2 rows in set (0.00 sec)

mysql> select*from scooterinfo;

+--------------+------------+-------+---------------------+---------+
| company_name | model_name | price | chargingtime_minute | mileage |
+--------------+------------+-------+---------------------+---------+
| QWERTY | abc | 15000 | 122 | 100 |
| ASDF | asdf | 20000 | 55 | 101 |
+--------------+------------+-------+---------------------+---------+
2 rows in set (0.00 sec)

mysql> select*from scooterinfo;

+--------------+------------+-------+---------------------+---------+
| company_name | model_name | price | chargingtime_minute | mileage |
+--------------+------------+-------+---------------------+---------+
| QWERTY | abc | 15000 | 122 | 100 |
| ASDF | asdf | 20000 | 55 | 101 |
+--------------+------------+-------+---------------------+---------+
2 rows in set (0.00 sec)

mysql> select*from scooterinfo;

+--------------+------------+-------+---------------------+---------+
| company_name | model_name | price | chargingtime_minute | mileage |
+--------------+------------+-------+---------------------+---------+
| QWERTY | abc | 15000 | 122 | 100 |
+--------------+------------+-------+---------------------+---------+
1 row in set (0.00 sec)

mysql>