Timestamp is a data type in MySQL and works for different time zone. It is also used for date and time purpose To understand the concept, we need to create a table. Creating a table mysql> CREATE table TimeStampDemo -> ( -> MyDataTime ... Read More

The shortcoming of mysql_real_escape_string is as follows − It has main shortcoming in the modern API while we are making prepared statement. This has another shortcoming for every possible attack when you will typecast. Let us see the typecast syntax in MySQL − (TypeCast)mysql_real_escape_string($_REQUEST['anyColumnName'])); In the above syntax, ... Read More

Yes, we can include a number for column name in MySQL. We need to use the symbol backtick, which is as follows ( ` `) To understand, we will make a table with the help of CREATE command. Let us create a table − mysql> CREATE table ... Read More

To understand whether a column exist or not, we have the following approaches − With the help of DESC command Using SHOW command Firstly, we will create a table with columns − mysql> CREATE table ColumnExistDemo -> ( -> UniqueId int, ... Read More

The 1046 error occurs if you forget to select any database before creating a table. Let us see how and why this error occurs. We will try to create a table without selecting a database − mysql> CREATE table MyTable1 -> ( -> ... Read More

Firstly, we need to create a table to understand the limit clause (as we want for SQL server).We will create a table with the help of CREATE command. Creating a table mysql> CREATE table limitDemo -> ( -> id int, ... Read More

To open root access from all hosts, we need to change the database to “mysql” with the help of USE command. The syntax of USE command is as follows − USE anyDatabasename; Now, I will use predefined database ‘mysql’, which is as follows − mysql> use mysql; ... Read More

We can achieve this with the help of SHOW command. Firstly, I will use my database with the help of USE command − mysql> USE business; Database changed We are in the “business” database now. After that, we can check that how many tables are available for this ... Read More

To add 5 hours in current time, we will use now() function from MySQL. The syntax is as follows − SELECT date_add(now(), interval some integer value hour); Now, I am applying the above query to add 5 hours to current time. The query is as follows − ... Read More

Both are engine types. Here is the query by which we can get to know which engine type and tables are being used. Firstly, we will choose the database with the help of USE command − mysql> USE business; Database changed Here is the query through which we ... Read More

Firstly, we will check which MySQL version is currently being used with the help of version() function − The query is as follows − mysql> SELECT version(); The following is the output +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in ... Read More

It is very difficult to say whether to prefer one large table or multiple small tables. It depends − On the application we are using. On database normalization However, there are many key points, through which we can say that multiple small tables are good in that situation. ... Read More

We can allow multiple transactions with the help of START command and SAVEPOINT. Let us create a table with the help of CREATE command. Creating a table mysql> CREATE table transactionDemo -> ( -> id int auto_increment, -> primary key(id) ... Read More

The main difference between localhost and 127.0.0.1 is that there is a need of look up table. In localhost, we need to look up a table somewhere. The address 127.0.0.1 can be converted into an IP address directly with the help of intelligent software. In this, there is no need ... Read More

Stored Procedure In MySQL, a stored procedure can be called with the help of call statement. A stored procedure returns more than one value. A stored procedure returns 0 by default. It cannot be used in SQL query and is based on precompile. Function A function can be called inside ... Read More