Mysql Date and Time Data TypesMySQL provides types for date and time and combination of date and time. In addition, MySQL also provide timestamp data type for tracking last change on a record. If you just want to store the year without date and month, you can use YEAR data type. Here is the table which showing MySQL date and ty…
Mysql String Data TypesIn MySQL, string can hold anything from plain text to binary data such as images and files. String can be compared and searched based on pattern matching by using LIKE clause or regular expression. The table below shows you the string data types in MySQL: String Types Description CHARA fixed-length…
MySQL Numeric Data TypesYou can find all SQL standard numeric types in MySQL including exact number data type and approximate numeric data types including integer, fixed-point and floating point. In addtion, MySQL also supports BIT data type for storing bit field values. Numeric types can be signed or unsigned except BIT …
Understanding MySQL Table TypesMySQL supports various of table types or storage engines to allow you to optimize your database. The table types are available in MySQL are: ISAM MyISAM InnoDB BerkeleyDB (BDB) MERGE HEAP The most important feature to make all the table types above distinction is transaction-safe or not. Only InnoD…
Delete the unused database in mysqlDROP DATABASE IF EXISTS mydb; After executing the statement, MySQL will returns you a message to notify the new database dropped successfully or not. DISPLAY …
how to Select the database in mysqlIf you want to CREATE, INSERT, UPDATE, ALTER or DELETE a table, you need to select a database. Thus, you need to call the common use in order to use the database. SYNTAX USE mydb; Our Database mydb selected: DISPLAY …
ho to Create A Database in mysqlWe need a database, and in order to create a database you need to use the following syntax. CREATE A NEW DATABASE NAME CALLED MYDB CREATE DATABASE IF NOT EXISTS mydb; After executing the statement, MySQL will returns you a message to notify the new database created successfully or not. Showing all …
Start mysqlThis section helps you to get familiar with basic MySQL including managing MySQL database and manipulating data using various SQL statements such as INSERT, DELETE, UPDATE and SELECT. To run mysql on command prompt follow the below steps: Click your wamp server icon>MySQL>MySQL Console Or You can f…
A Simple Contact Us Forms Using PHPIn this tutorial i will show you, how to make a simple and clean contact us form using Php and Css, a simple contact us form with name, email, website, subject and message fields… Lets Start First of all create a new php document, then we have to design the html, copy and paste the below code in yo…
CRUD with PHP and MySQLIn this tutorial we learn create, read, and update data Using PHP and MySQL. The programmers called it CRUD. CRUD means CREATE, READ, UPDATE and DELETE. Now we will focus on how to create new database record with PHP and MySQL. It is much better if you’ll create a separate file for connecting PHP t…
