insert different language into mysql database
use “utf8_general_ci” in the collation while creating table
Category Archives: SQ L& MYsql
Different type of joins in mysql
Joins are used for joining two more tables. using joins we can fetch data from the two table in a database. Following are the different types of joins used in the mysql. 1.Inner join 2.Left join 3.Right join To test the joins in mysql please follow the following steps Create a table called jobtable. You… Read More »
Indexing in mysql database
My database name is testdata it has 3 fields ID,Name,City for increasing the speed of getting data using name field us the following method Query is like below Select * from testdata order by Name asc For creating indexing for the Name field create index Name_index on testdata (Name); Indexing will slow down the insert… Read More »
Total count of a table data in mysql without using COUNT
Count of total data with out using Count function select sum(1) as count from tablename; Count of total data using Count function select count(*) from tablename;
Supported range of DATE,DATETIME,TIMESTAMP in mysql
DATE- Supported range is ‘1000-01-01’ to ‘9999-12-31’ DATETIME-Supported range is ‘1000-01-01’ to ‘9999-12-31’ TIMESTAMP-Supported range is ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC
MDF,LDF,NDF in RDBMS
MDF-Primary Data file–holds the data and datafiles LDF-Log file–holds the transaction completed by database information NDF-Secondary Data file- holds only data file
Examples of RDBMS
Oracle Mysql Microsoft SQL Server Postgresql IBM Db2
“ISnull” field in Mysql database table showing as Zero for a single record. Why?
Present scenario:: In an already existing table we added a new field with data type tinyint with default as null Age- varchar-250 name-varchar-250 testid-tinyint-default-null-yes (newly added field) After creating the new field entire table data with testid as ‘NULL’ value. and once i did update on a particular record through query testid updated to ‘0’… Read More »
“ISnull” field in Mysql database table showing as Zero for a single record. Why?
“ISnull” field in Mysql database table showing as Zero for a single record. Why? “ISnull” field in Mysql database table showing as Zero for a single record. Why? Present scenario:: In an already existing table we added a new field with data type tinyint with default as null Age- varchar-250 name-varchar-250 testid-tinyint-default-null-yes (newly added field)… Read More »
Select Clause to find out the current timestamp?
See the Example Select * from mydoubts_data +———+————————-+——————–+ | EMPCODE | NAME | SALARAY CODE | +———+————————-+——————–+ | 787 | Vasanthan | K | | GORT | Shaji | S | | GKL | James | P | | IND | Abdul | ZO | | VIS | Sunil | F | +———+————————-+——————–+ For Example… Read More »