MySql database Introduction

 MySql : Database Management System

A Database is a collection of data stored in a format that can easily by accessed.

There are two types of Database : Relational(RDBMS) and NoSQL

Relational : Relational Database (RDBMS)

RDBMS use SQL (Structured Query Language).

There are many RDBMS in the World : Oracle, MySQL, MS SQL Server, PostgreSQL.


NoSQL : NoSQL is not a Table-based Database.

NoSQL databases are document based.

MongoDB, Redis, Cassandra etc.


Advantages of MySQL : 

=> Cross Platform (That means we can MySQL code on any platform or OS like Windows, McOS, Linux).

=> Used with multiple languages(PHP, NodeJS, Python, C#).

=> MySQL software is Open Source(means free of Cost).

=> MySQL is RDBMS(Relational Database Management System).

=> The MySQL Database Server is fast, reliable, scalable(means we can use MySQL Database with Smallest 

as well as Biggest Websites) and easy to use.

=> MySQL Server works in client/server or embedded systems.


Popular Websites Using MySQL : 

=> Facebook

=> Twitter

=> Google

=> Wikipedia

=> Youtube

=> Flickr

=> Pinterest


Content Management System Using MySQL :

=> Wordpress

=> Joomla

=> Drupal

=> Magento

=> phpBB

=> TYPO3

=> MODx


Create Table Systax : 

CREATE TABLE table_name (

column1 datatype, column2 datatype, column3 datatype, ...

);


Datatypes in MySQL : 

3 Type of Category in Datatypes : 

1.String

2.Numeric

3.Date and Time


To Create Table SQL Command : 

CREATE TABLE personal(id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50), birth_date DATE, phone VARCHAR(12),

gender VARCHAR(1));


To Insert Data in Tables with SQL :

INSERT INTO table_name(column1, column2,...) VALUES(value1, value2,...);


To Insert Multiple Row Data in Tables with SQL : 

INSERT INTO table_name(column1, column2,...) VALUES(value1, value2,...), (value1, value2,...), (value1, value2,...);


List of Constraints(Restrictions) in MySQL : NOT NULL, UNIQUE, DEFAULT, CHECK, FOREIGN KEY, PRIMARY KEY

SQL Syntax as shown below : 

CREATE TABLE table_name(id INT NOT NULL UNIQUE, name VARCHAR(50) NOT NULL, age INT NOT NULL CHECK(age>=18),

gender VARCHAR(10) NOT NULL, phone VARCHAR(10) NOT NULL UNIQUE, city VARCHAR(10) NOT NULL DEFAULT "Agra");

Comments

Post a Comment

Popular posts from this blog

Second GET API Calling with Bloc simple Example in Flutter

Image
  import "package:api_with_bloc/Fourth_Get_API_call_using_Bloc/bloc/users_bloc.dart" ; import "package:api_with_bloc/Fourth_Get_API_call_using_Bloc/bloc/users_bloc_states.dart" ; import "package:flutter/material.dart" ; import "package:flutter_bloc/flutter_bloc.dart" ; void main () { runApp ( const MyApp () ) ; } class MyApp extends StatelessWidget { const MyApp ( { super .key } ) ; @override Widget build ( BuildContext context ) { return BlocProvider < UsersBloc >( create: ( context ) => UsersBloc () , child: MaterialApp ( title: "HomePage" , debugShowCheckedModeBanner: false, theme: ThemeData ( appBarTheme: const AppBarTheme ( backgroundColor: Colors. grey , centerTitle: true, ) , ) , home: const HomePageFourth () , ) , ) ; } } class HomePageFourth extends StatelessWidget { const HomePageFourth ( { super ....
Read more

Stack Container Scrollable Card widget UI with Custom Widget

Image
  import "package:flutter/material.dart" ; void main () { runApp( const MyApp ()) ; } class MyApp extends StatelessWidget { const MyApp({ super .key}) ; @override Widget build (BuildContext context) { return MaterialApp ( title: "Card Container Stack" , debugShowCheckedModeBanner: false, theme: ThemeData ( appBarTheme: const AppBarTheme ( backgroundColor: Colors. grey , centerTitle: true, ) , ) , home: const CardContainerStack () , ) ; } } class CardContainerStack extends StatelessWidget { const CardContainerStack({ super .key}) ; @override Widget build (BuildContext context) { return Scaffold ( appBar: AppBar ( title: const Text ( "Scrollable Containers" , style: TextStyle (fontWeight: FontWeight. bold ) , ) , ) , body: SingleChildScrollView ( child: Center ( child: Column ( mainA...
Read more

Pagination with Bloc Pattern in Flutter

Image
  import "package:flutter/material.dart" ; import "package:flutter_bloc/flutter_bloc.dart" ; import "package:pagination_practice/Pagination_with_Bloc/Bloc/bloc.dart" ; import "package:pagination_practice/Pagination_with_Bloc/Bloc/event.dart" ; import "package:pagination_practice/Pagination_with_Bloc/Bloc/state.dart" ; import "package:pagination_practice/Pagination_with_Bloc/post_repo.dart" ; void main () { runApp ( const MyApp () ) ; } class MyApp extends StatelessWidget { const MyApp ( { super .key } ) ; @override Widget build ( BuildContext context ) { return RepositoryProvider < PostRepo >( create: ( context ) => PostRepo () , child: BlocProvider < PostBloc > ( create: ( context ) => PostBloc ( context.read < PostRepo > () ) ..add ( FetchPostsEvent () ) , child: MaterialApp ( title: "Pagination" , debugShowCheckedModeBa...
Read more