AmitDiwan has Published 7250 Answers

AmitDiwan has Published 7250 Answers

Springboot + JSP + Spring Security: Failed to configure a DataSource. How to configure DataSource in MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 16:40:27

To configure a DataSource in Springboot, you can define DataSource into application.properties.The application.properties is as follows for Springboot −spring.datasource.username=yourUserName spring.datasource.password=yourPassword spring.datasource.url=yourDatabaseUrl spring.datasource.driver-class-name=yourDriverClassNameThe project structure is as follows −ExampleTo understand the above concept, let us create a controller class with spring boot. The Java code is as follows −package com.demo.controller; import ... Read More

Set default value to a JSON type column in MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 16:33:21

To set default value, use the DEFAULT constraint as in the below syntax −alter table yourTableName modify column yourColumnName JSON NOT NULL DEFAULT ( JSON_OBJECT() );Let us create a table −mysql> create table demo24 −> ( −> employee_information text −> ) −> ; Query OK, 0 rows affected (1.43 sec)Here ... Read More

MySQL query to fetch the maximum cumulative value

MySQL MySQLi Database

Published on 19-Nov-2020 16:31:15

For this, use aggregate function COUNT(*) along with subquery. GROUP BY is also used.Let us create a table −mysql> create table demo23 −> ( −> id int not null auto_increment primary key, −> value1 int, −> value2 int −> ); Query OK, 0 rows affected (1.65 sec)Insert some records into ... Read More

Insert the data into Table C IF The data is not in Table B while Comparing to Table A in MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 16:06:23

For this, use left join on table A and B. Let us create the first table −mysql> create table demo20 −> ( −> id int, −> name varchar(20) −> ); Query OK, 0 rows affected (1.87 sec)Insert some records into the table with the help of insert command −mysql> insert ... Read More

How to use quotes correctly while using LIKE with search variable in MySQL in Java?

MySQL MySQLi Database Java

Published on 19-Nov-2020 16:01:49

Following is the correct syntax to use LIKE with search variable −String sqlQuery; sqlQuery = "select *from yourTableName where yourColumnName like '%" +yourSearchVariableName + "%'";Let us create a table −mysql> create table demo19 −> ( −> id int not null auto_increment primary key, −> name varchar(50) −> ); Query OK, ... Read More

Sort in a string mixed with numbers in MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 15:59:14

Use ORDER BY with some cases. Let us create a table −mysql> create table demo18 −> ( −> value text −> ); Query OK, 0 rows affected (1.18 sec)Insert some records into the table with the help of insert command −mysql> insert into demo18 values('John Smith'); Query OK, 1 row ... Read More

Combine SELECT & SHOW command results in MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 15:56:32

To combine SELECT and SHOW command results into one, use the below query −select @anyVariableName1 as anyAliasName1, @anyVariableName1 as anyAliasName2, ......N;To combine the SELECT and SHOW, first create and initialize the first variable. Following is the query −mysql> set @first_name='John'; Query OK, 0 rows affected (0.00 sec)To combine the SELECT ... Read More

Regex to find string and next character in a comma separated list - MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 15:54:20

To search in a comma separated list, use MySQL find_in_set(). The usage of Regex for this purpose isn’t required here. The syntax is as follows −select *from yourTableName where find_in_set(anyValue, yourColumnName);Let us create a table −mysql> create table demo17 −> ( −> id int not null auto_increment primary key, −> ... Read More

How can I extract minute from time in BigQuery in MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 15:52:09

Extract using extract() method along with cast(). Following is the syntax −select extract(minute from cast(yourColumnName as time)) as anyAliasName from yourTableName;Let us create a table −mysql> create table demo15 −> ( −> value time −> ); Query OK, 0 rows affected (2.11 sec)Insert some records into the table with the ... Read More

Need help in deleting duplicate columns from a table in MySQL?

MySQL MySQLi Database

Published on 19-Nov-2020 15:49:17

To delete duplicate columns, use DELETE with INNER JOIN. Following is the syntax −delete tbl1 from yourTableName anyAliasName1 inner join yourTableName anyAliasName2 where yourCondition1 and yourCondition2Let us create a table −mysql> create table demo14 −> ( −> id int not null auto_increment primary key, −> name varchar(30) −> ); Query ... Read More

1 2 3 4 5 6 7 ... 725 Next

Advertisements