Chaitanya Lakshmi
  • About Me
  • Job Duties
  • Knowledge Blog
  • Applications
  • Contact Us
    • Linked In
    • Facebook
  • About Me
  • Job Duties
  • Knowledge Blog
  • Applications
  • Contact Us
    • Linked In
    • Facebook

How do I connect to mySQL from PHP?

4/10/2012

0 Comments

 
<?php 
$db = mysql_connect("HOST", "USERNAME", "PASSWORD"); 
mysql_select_db("DATABASE_NAME",$db); 
?> 
0 Comments

Explain the difference between BOOL, TINYINT and BIT

4/8/2012

0 Comments

 
  • BIT data type can store up to 8 bytes from My SQL version 5.0.3
  • BIT data type can be used only for binary data
MySQL BOOL, TINYINT and BIT - September 30, 2009 at 18:00 pm by Vidya SagarExplain the difference between BOOL, TINYINT and BIT in MySQL.BOOL: Used to store Boolean values, 0 being false and 1 being true. MySQL sets them as TINYINT type.
TINYINT: The range of this data type is -128 - +127 or 0 – 256 and occupies 1 byte.
BIT: Bit uses 8 bytes and stores only binary data.

0 Comments

What is the difference between CHAR_LENGTH and LENGTH?

4/8/2012

0 Comments

 
CHAR_LENGTH includes leading and trailing blanks and the string-termination character LENGTH excludes trailing blanks and the string-termination character. It does not exclude leading blanks.

MySQL CHAR_LENGTH and LENGTH - September 30, 2009 at 18:00 pm by Vidya SagarWhat is the difference between CHAR_LENGTH and LENGTH in MySQL?CHAR_LENGTH, as the name suggests, returns the number of characters / character count. The LENGTH returns the number of bytes / bytes count. To count the Latin characters, both lengths are the same. To count Unicode and other encodings, the lengths are different.

0 Comments

What are the limitations of mysql in Comparison of Oracle?

4/8/2012

0 Comments

 
  • Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
  • Large Database size is supported more in Oracle in contrast to MySql.
MySQL vs. Oracle.
  • Unlike oracle, mysql data types can store invalid dates and don’t support time zones.
  • Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
  • Large Database size is supported more in Oracle in contrast to MySql.
  • Replication in oracle is two way while one way in mysql.
0 Comments

What is Query Cache in MySQL?

4/8/2012

0 Comments

 
Query Cache in MySQL is used in scenarios when the same queries need to be executed on the same data set. These queries also return the same result. Query cache is most useful when there are tables that are not expected to change very often. It is important to note that the query cache does not return old data. If the tables are modified, any important entries in the query cache are flushed.
0 Comments

Explain about MySQL and its features

4/8/2012

0 Comments

 
MySQL is a relational database management system which is an open source database.

Features:

  • Because of its unique storage engine architecture MySQL performance is very high. 
  • Supports large number of embedded applications which makes MySql very flexible.
  • Use of Triggers, Stored procedures and views which allows the developer to give a higher productivity.
  • Allows transactions to be rolled back, commit and crash recovery. 
0 Comments

Explain the difference between FLOAT, DOUBLE and REAL

2/17/2012

0 Comments

 
FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.
0 Comments

Explain the difference between BOOL, TINYINT and BIT

2/17/2012

0 Comments

 
Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data.
0 Comments

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2/17/2012

0 Comments

 
It stops incrementing. It does not overflow to 0 to prevent data losses, but further inserts are going to produce an error, since the key has been used already.
0 Comments

What is SERIAL data type in MySQL?

2/17/2012

0 Comments

 
BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT
0 Comments
<<Previous

    Archives

    April 2012
    March 2012
    February 2012

    Categor

    All
    Ajax
    Api
    Cross Site Scripting
    Css
    Curl
    Design Patterns
    Drupal
    Exception Handling
    Htaccess
    Html
    Javascript
    Jquery
    Json
    Linux
    Mysql
    Oops
    Php
    Regular Expressions
    Web 2.0
    Webservices
    Wordpress
    Xhtml

    RSS Feed

Powered by Create your own unique website with customizable templates.