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

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

Pagination First Practical in Flutter

Image
  import "package:dio/dio.dart" ; import "package:flutter/material.dart" ; import "package:flutter_spinkit/flutter_spinkit.dart" ; import "package:pagination_practice/Pagination/Model/productModel.dart" ; void main () { runApp ( const MyApp () ) ; } class MyApp extends StatelessWidget { const MyApp ( { super .key } ) ; @override Widget build ( BuildContext context ) { return MaterialApp ( title: "HomePage" , debugShowCheckedModeBanner: false, theme: ThemeData ( appBarTheme: const AppBarTheme ( backgroundColor: Colors. grey , centerTitle: true, ) , ) , home: const HomePage () , ) ; } } class HomePage extends StatefulWidget { const HomePage ( { super .key } ) ; @override State < HomePage > createState () { return HomePageState () ; } } class HomePageState extends State < HomePage > { final ScrollController scrollController = Scrol...
Read more

ExpansionPanel with ExpansionPanelList with Complete Collapse Operation in Flutter

Image
  import "package:flutter/material.dart" ; import "package:sdreatech_learning_widget/All_widgets_Ui/customWidget.dart" ; void main () { runApp ( const MyApp () ) ; } class MyApp extends StatelessWidget { const MyApp ( { super .key } ) ; @override Widget build ( BuildContext context ) { return MaterialApp ( title: "ExpansionPanel" , debugShowCheckedModeBanner: false, theme: ThemeData ( appBarTheme: const AppBarTheme ( backgroundColor: Colors. grey , centerTitle: true, ) , ) , home: const ExpansionPanelListPracticalCollapseTask () , ) ; } } class ExpansionPanelListPracticalCollapseTask extends StatefulWidget { const ExpansionPanelListPracticalCollapseTask ( { super .key } ) ; @override State < ExpansionPanelListPracticalCollapseTask > createState () => _ExpansionPanelListPracticalCollapseTaskState () ; } class _ExpansionPanelListPracticalCollapseTaskState...
Read more