Using CREATE TABLE statement in MySQL you can create a table into the database. The following example shows the statement in the simple form: CREATE TABLE Format: CREATE TABLE IF NOT EXISTS `tbl` ( tbl_id int(11) NOT NULL AUTO_INCREMENT, tbl_title varchar(100) DEFAULT NULL, post_date DATE DEFAULT NULL, update_date DATE DEFAULT NULL, PRIMARY KEY (tbl_id) ) […]
MySQL supports different data types while creating columns i.e. what type of value is using for the column or fixed/variable length etc. It has different types of data types i.e. Numeric: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE, BIT String: CHAR, VARCHAR, BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET […]
When you create a database you have to choose the storage engine for storing data into the database. MySQL supports various types of storage engines i.e. MyISAM, InnoDB, MERGE, MEMORY (HEAP), ARCHIVE, CSV, FEDERATED. Each storage engines has different performance of the database and has advantages or disadvantages. Here is the list of MySQL Storage […]
Database Manage in MySQL is a first priority to maintain a database. Here you will learn how you can manage database i.e. create a new database in MySQL, remove existing database etc. A database is nothing but a container of data that stores any kind of data. Here is how database manage: Creating Database CREATE […]
Want to store IP addresses in database and still using VARCHAR(15)? You can actually store IP addresses as integer values because using INT you go down to 4 bytes of space and have a fixed size field. As the range of a IP Addresses are 32 bit unsigned integer you can use your column as […]
First of all think whether you require a NULL field or not.If having an empty string value can make any sense then use it otherwise use NULL value for a specific reason. So, Put NOT NULL if required. NULL columns require additional space in the row and add complexity to your statement. Avoid it for […]
If you want to analyze the columns structures of a MySQL table and want to view the actual data in your table with certain suggestion then you can get help from PROCEDURE ANALYSE(). For example, if any data present in your table and plays a big role in any decision making then this is very […]
Using HTML5 required style you can validate your form and show error. But sometimes you need to give a style like keep the color red for error or green on success. Here’s how to use CSS3 required. Here is a sample example for required css: <!DOCTYPE html> <html> <head> <title>CSS3 styles</title> <style type=”text/css”> input[type=”checkbox”]:required:invalid + […]
For an old days we used JavaScript validation to validate any form in a website and this was until recently unthinkable. But as soon as the HTML5 came then the validation becomes very easy to maintain in any form. Here is some example of HTML5 Form Validation: The ‘required’ attributeThis simply checks whether the value […]
Website can not be completed without any style. So you apply CSS. When a browser reads a CSS style sheet, this formats the HTML document according to the information in the CSS style sheet. With 3 basic ways you can add CSS in your web pages:- 1) Link your webpage with an external file: <link […]