Which MySQL datatype use for store an IP address?

Which MySQL datatype use for store an IP address?

If you want to store IP address in mysql database then don’t mistake to use varchar datatype because you can use INT UNSIGNED 4(BYTE) datatype. using integer datatype you can save more space in database. when you fire insert query

How to import CSV file using mysql

How to import CSV file using mysql

In this post we have learn how to import CSV file using LOAD DATA INFILE statement. this is a very simple example for a import file to the database. Here we have provide a full sysntax for LOAD DATA INFILE

How to remove special characters by mysql custom function.

How to remove special characters by mysql custom function.

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove special characters from table field value. this function through you can also remove special characters from string

How to get current year rows using MySql Query PHP?

How to get current year rows using MySql Query PHP?

If you require to get all the records of current year using mysql query. for example you have one table “items” and columns are id, title, description, created_at and update_at, Now you want to get all records of this year.

How to add 1 day to the date column in MySQL?

How to add 1 day to the date column in MySQL?

In this example, i will show you mysql add 1 day to timestamp. step by step explain how to add days in date in mysql. i explained simply about how to add 7 days to current date in mysql. This

Node JS Mysql Connection Example

Node JS Mysql Connection Example

Hello, This is a short guide on node js mysql connection example. you will learn how to connect mysql database in node js. we will help you to give example of how to use mysql in node js. step by

How to Export Mysql Database using Command Line in Ubuntu?

How to Export Mysql Database using Command Line in Ubuntu?

Now, let’s see post of how to export mysql database using command line in ubuntu. i explained simply about how to export mysql database using command line. you can see importing mysql database using command line. you can understand a