mysql

MySQL BASICS
MySQL Create Database
MySQL Transactions
MySQL Alter Command
MySQL Indexes
MySQL Temporary Tables
MySQL Clone Tables
MySQL Database Info
MySQL Using Sequences
MySQL Handling Duplicates
MySQL SQL Injection
MySQL Database Export
MySQL Database Import
MySQL Vs SQL
Grant_ Revoke Privilege
MySQL Regexps
MySQL NULL Values
MySQL Drop Database
MySQL Select Database
MySQL Datatypes
MySQL Create Tables
MySQL Drop Tables
MySQL Insert Query
MySQL Select Query
MySQL Where Clause
MySQL Update Query
MySQL Delete Query
MySQL Like Clause
MySQL Sorting Results
MySQL Using Join
MySQL TRIGGERS

MySQL - Introduction
MySQL Introduction
MySQL Installation
MySQL Installation
MySQL Administration
MySQL Administration
MySQL PHP Syntax
MySQL Connection

DATABASE INFO

MySQL - Database Info

Obtaining and Using MySQL Metadata :

There are three types of information, which you would like to have from MySQL.

Information about the result of queries − This includes the number of records affected by any SELECT, UPDATE or DELETE statement.

Information about the tables and databases − This includes information pertaining to the structure of the tables and the databases.

Information about the MySQL server − This includes the status of the database server, version number, etc.

It is very easy to get all this information at the MySQL prompt, but while using PERL or PHP APIs, we need to call various APIs explicitly to obtain all this information.

Getting Server Metadata :

There are a few important commands in MySQL which can be executed either at the MySQL prompt or by using any script like PHP to get various important information about the database server.

S.no	Command	Description
1	SELECT VERSION( )	Server version string
2	SELECT DATABASE( )	Current database name (empty if none)
3	SELECT USER( )	Current username
4	SHOW STATUS	Server status indicators
5	SHOW VARIABLES	Server configuration variables

MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials

Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials

how to use range in golang

posted on 2022-05-03 08:28:11 - Go lang Tutorials

find variable type in golang

posted on 2022-05-03 05:24:55 - Go lang Tutorials

for loops in golang

posted on 2022-05-03 04:27:40 - Go lang Tutorials