Skip to main content

MySQL Data Types and Properties

MySQL Data Types and Properties

Have a look at the following line of code from the post Storing and Retrieving Data from MySQL Database.

name varchar( 50 ) ,
phnum varchar( 20 )

As I told you we have to declare the column data types while creating tables depending on the values we want to store. MySQL has wide variety of data types, out of which I’m stating some of the important ones below:

  1. CHAR: For storing character and string data, faster than VARCHAR.

  2. VARCHAR: For storing character and string data. Slower but efficient in storing variable length string as only the needed memory is used no matter how much we allocate.

  3. INT: For storing regular integers. Same as INTEGER, other related data types are TINYINT, SMALLINT, MEDIUMINT, BIGINT.

  4. FLOAT: For storing floating point values, it is 4 bytes long. There is also a DOUBLE which is 8 bytes long.

  5. DATE: For storing YYYY-MM-DD date values.

Besides data types we can also assign column fields some properties to change the way they store data. These are some of the useful ones:

  1. NOT NULL: This specifies that a particular field cannot be empty. When inserting data you must provide data for this field or else MySQL generates error. It is used to make sure value for certain column is always provided.

  2. AUTO_INCREMENT: This property can be used with integer field to automatically make MySQL insert serial numbers to each row inserted.

  3. PRIMARY KEY: primary key is very important property of a table. It helps MySQL speed up query processing. Usually, serial number column field is defined as a primary key but it can be any field which is unique for each row.

The following SQL code illustrates how the above properties are used:

name varchar( 20 ) NOT NULL

It is a good idea to always have an extra column for each table. This column should be defined as both AUTO_INCREMENT and PRIMARY KEY.

Previous Articles:

Popular posts from this blog

Fix For Toshiba Satellite "RTC Battery is Low" Error (with Pictures)

RTC Battery is Low Error on a Toshiba Satellite laptop "RTC Battery is Low..." An error message flashing while you try to boot your laptop is enough to panic many people. But worry not! "RTC Battery" stands for Real-Time Clock battery which almost all laptops and PCs have on their motherboard to power the clock and sometimes to also keep the CMOS settings from getting erased while the system is switched off.  It is not uncommon for these batteries to last for years before requiring a replacement as the clock consumes very less power. And contrary to what some people tell you - they are not rechargeable or getting charged while your computer or laptop is running. In this article, we'll learn everything about RTC batteries and how to fix the error on your Toshiba Satellite laptop. What is an RTC Battery? RTC or CMOS batteries are small coin-shaped lithium batteries with a 3-volts output. Most laptops use

The Best Way(s) to Comment out PHP/HTML Code

PHP supports various styles of comments. Please check the following example: <?php // Single line comment code (); # Single line Comment code2 (); /* Multi Line comment code(); The code inside doesn't run */ // /* This doesn NOT start a multi-line comment block /* Multi line comment block The following line still ends the multi-line comment block //*/ The " # " comment style, though, is rarely used. Do note, in the example, that anything (even a multi-block comment /* ) after a " // " or " # " is a comment, and /* */ around any single-line comment overrides it. This information will come in handy when we learn about some neat tricks next. Comment out PHP Code Blocks Check the following code <?php //* Toggle line if ( 1 ) {      // } else {      // } //*/ //* Toggle line if ( 2 ) {      // } else {      // } //*/ Now see how easy it is to toggle a part of PHP code by just removing or adding a single " / " from th

Introduction to Operator Overloading in C++

a1 = a2 + a3; The above operation is valid, as you know if a1, a2 and a3 are instances of in-built Data Types . But what if those are, say objects of a Class ; is the operation valid? Yes, it is, if you overload the ‘+’ Operator in the class, to which a1, a2 and a3 belong. Operator overloading is used to give special meaning to the commonly used operators (such as +, -, * etc.) with respect to a class. By overloading operators, we can control or define how an operator should operate on data with respect to a class. Operators are overloaded in C++ by creating operator functions either as a member or a s a Friend Function of a class. Since creating member operator functions are easier, we’ll be using that method in this article. As I said operator functions are declared using the following general form: ret-type operator#(arg-list); and then defining it as a normal member function. Here, ret-type is commonly the name of the class itself as the ope