search

ashi509 / Learning_Every_Thing

0 stars 0 forks source link

MySQL database connectivity. #6

Open ashi509 opened 1 year ago

ashi509 commented 1 year ago

There are two way to connect the MySQL database.

First is application.property

add the configuration

spring.datasource.url="Jdbc:mysql://localhost:3306/db_name" spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name="com.mysql.cj.jdbc.Driver"

JPA

spring.jpa.properties.hibernate.dialect="org.hibernate.dialect.MySQL8Dialect" spring.hiberbnate.ddl-auto=update

Second one is application.yml file

spring: datasource: url: jdbc:mysql://localhost:3306/prop_accel username: root password: root driver: class-name: com.mysql.cj.jdbc.Driver jpa: properties: hibernate: dialect: org.hibernate.dialect.MySQL8Dialect hibernate: ddl-auto: update

ashi509 commented 1 year ago

MySQL Queries.

mysql -u root -p opening for cmd

show databases;

//show all databases.

create database db_name;

// create new database;

use db_name;

// use database

create table table_name(id int (12),name varchar(120),city varchar(120));

// create table in database

show table ;

// check table create or not

desc table_name;

// for checking table attribute

insert into table_name(id,name , city) value(1,"Ashis","Ftp");

// insert data in database

select * from table_name;

// All data recieved of given table_name

select id from table_name;

// Recieved the id column;

select name, city from table_name;

// Recieved the name, city full column;

Select *from table_name where name=?;

// Get Specific name row data;

delete from student where id=?,

// Given id table will be delete.

drop table_name;

// For deleting table

Drop database databaseName;

//For deleting database.

Truncate table Table_name

//for deleting only table data not tables.

alter table current_table_name rename new_Table_name

// for rename table name

Alias

select id as "Id",name as"Name";

// Get rename

alter table table_name add country varchar(160);

// add new colunm

update table_name set country ="India" where id=1;

//insert new column data

select * from table_name where id in(1,2,3,4,5,6,7,8)

// get data given id number

select * from table_name where id>1And id<19;

//from 1 to 19 get data id;

ashi509 commented 1 year ago

MySQL Queries.

mysql -u root -p opening for cmd

show databases;

//show all databases.

create database db_name;

// create new database;

use db_name;

// use database

create table table_name(id int (12),name varchar(120),city varchar(120));

// create table in database

show table ;

// check table create or not

desc table_name;

// for checking table attribute

insert into table_name(id,name , city) value(1,"Ashis","Ftp");

// insert data in database

select * from table_name;

// All data recieved of given table_name

select id from table_name;

// Recieved the id column;

select name, city from table_name;

// Recieved the name, city full column;

Select *from table_name where name=?;

// Get Specific name row data;

delete from student where id=?,

// Given id table will be delete.

drop table_name;

// For deleting table

Drop database databaseName;

//For deleting database.

Truncate table Table_name

//for deleting only table data not tables.

alter table current_table_name rename new_Table_name

// for rename table name

Alias

select id as "Id",name as"Name";

// Get rename

alter table table_name add country varchar(160);

// add new colunm

update table_name set country ="India" where id=1;

//insert new column data

select * from table_name where id in(1,2,3,4,5,6,7,8)

// get data given id number

select * from table_name where id>1And id<19;

//from 1 to 19 get data id;