For this, use UPPER() on MySQL column. Let us first create a table −mysql> create table DemoTable627 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName varchar(100)); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable627(FirstName) values(UPPER('John')); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('Sam')); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('Mike')); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('Carol')); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable627(FirstName) values(UPPER('dAVID')); Query OK, 1 row affected (0.70 ... Read More

For this, use the concept of ZEROFILL. It pads the displayed value of the field with zeros up to the display width set in the column definitionLet us first create a table −mysql> create table DemoTable626 (Value int(5) zerofill); Query OK, 0 rows affected (0.71 sec)Insert some records in the table using insert command −mysql> insert into DemoTable626 values(9); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable626 values(12); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable626 values(567); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable626 values(3478); Query OK, 1 row affected ... Read More

Let us first create a table −mysql> create table DemoTable625 (    StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar(100), StudentScore int ); Query OK, 0 rows affected (1.01 sec)Insert some records in the table using insert command −mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('John', 98); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('Chris', 39); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('Bob', 41); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) values('David', 40); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable625(StudentFirstName, StudentScore) ... Read More

For this, you can use time_format() and time_diff(). To find the time difference, you need to use the time_diff() method. Let us first create a table −mysql> create table DemoTable624 (PunchIn datetime, PunchOut datetime); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable624 values('2019-07-14 12:10:00', '2019-07-14 12:50:00'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable624 values('2019-07-14 11:00:00', '2019-07-14 11:30:00'); Query OK, 1 row affected (0.34 sec)Display all records from the table using select statement −mysql> select *from DemoTable624;This will produce the following output −+---------------------+---------------------+ | PunchIn   ... Read More

Let us first create a table −mysql> create table DemoTable623 (FirstName varchar(100), LastName varchar(100), Age int); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable623 values('John', 'Smith', 23); Query OK, 1 row affected (0.66 sec) mysql> insert into DemoTable623 values('Adam', 'smith', 23); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable623 values('Chris', 'Brown', 24); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable623 values('Robert', 'brown', 21); Query OK, 1 row affected (0.22 sec)Display all records from the table using select statement −mysql> select *from DemoTable623;This will ... Read More

Let us first create a table −mysql> create table DemoTable622 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value1 int, Value2 int); Query OK, 0 rows affected (1.08 sec)Insert some records in the table using insert command −mysql> insert into DemoTable622(Value1, Value2) values(1000, 1000); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable622(Value1, Value2) values(2000, 3000); Query OK, 1 row affected (1.04 sec)Display all records from the table using select statement −mysql> select *from DemoTable622;This will produce the following output −+----+--------+--------+ | Id | Value1 | Value2 | +----+--------+--------+ | 1 | 1000 | 1000 ... Read More

Let us first create a table −mysql> create table DemoTable621 (UserName varchar(100), UserEmailId varchar(100), UserLastPost datetime); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable621 values('John', 'John@gmail.com', '2019-04-10 11:01:10'); Query OK, 1 row affected (0.47 sec) mysql> insert into DemoTable621 values('John', 'John@gmail.com', '2019-07-14 13:07:10'); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> select *from DemoTable621;This will produce the following output −+----------+----------------+---------------------+ | UserName | UserEmailId    | UserLastPost | +----------+----------------+---------------------+ | John     | ... Read More

For this, you can use INFORMATION_SCHEMA. Following is the syntax −select my_schema.SCHEMA_NAME, group_concat(tbl.TABLE_NAME) from information_schema.SCHEMATA my_schema left join information_schema.TABLES tbl on my_schema.SCHEMA_NAME=tbl.TABLE_SCHEMA group by my_schema.SCHEMA_NAME;Let us implement the above syntax in order to show all databases in MySQL and for each database −mysql> select my_schema.SCHEMA_NAME, group_concat(tbl.TABLE_NAME)    from information_schema.SCHEMATA my_schema    left join information_schema.TABLES tbl on my_schema.SCHEMA_NAME=tbl.TABLE_SCHEMA group by my_schema.SCHEMA_NAME;This will produce the following output −+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | SCHEMA_NAME               | group_concat(tbl.TABLE_NAME)                                               ... Read More

Let’s say we installed MySQL version is 8.0 on our Windows OS. The bin directory is present at the following location −C:\Program Files\MySQL\MySQL Server 8.0\binLet us check the location. The screenshot is as follows −These are the drives −Go to C: drive and click Program Files −Now, click “MySQL” and open the folder −After that, click the current MySQL version folder. For us, it is MySQL Server 8.0 −Inside the folder, you can easily locate the bin folder as shown in the following screenshot −

For this, you can use INSERT INTO….SELECT statement. Let us first create a table −mysql> create table DemoTabe1 (Marks int); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTabe1 values(68); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTabe1 values(89); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTabe1 values(99); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTabe1 values(39); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTabe1 values(49); Query OK, 1 row affected (0.12 sec)Display all records from the table ... Read More