Ankitha Reddy has Published 102 Answers

Ankitha Reddy has Published 102 Answers

What is MySQL LOAD DATA statement?

MySQL MySQLi Database

Published on 21-Feb-2018 17:17:26

LOAD DATAThis statement is used for importing the data from data files into our database. It reads data records directly from a file and inserts them into a table. Its syntax would be as follows −SyntaxLOAD DATA LOCAL INFILE '[path/][file_name]' INTO TABLE [table_name ];Here, a path is the address of ... Read More

How MySQL WHILE loop statement can be used in stored procedure?

MySQL MySQLi Database

Published on 21-Feb-2018 12:56:33

As we know that MySQL provides us loop statements that allow us to execute a block of SQL code repeatedly based on a condition. WHILE loop statement is one of such kind of loop statements. Its syntax is as follows −WHILE expression DO statements END WHILEActually, the WHILE loop checks ... Read More

How can I check how much time MySQL query, without printing it on the console, is taking?

MySQL MySQLi Database

Published on 21-Feb-2018 11:24:39

To check this we need to have the profiling information which indicates resource usage for the statements executed during the course of the current session. Profiling information can get by SHOW PROFILE and SHOW PROFILES statement. Before running these statements, the profiling session variable must be set to 1 as ... Read More

How can I fetch the value of REPLACE() function in the column name of our choice?

MySQL MySQLi Database

Published on 20-Feb-2018 21:49:51

For fetching the values of REPLACE() function in our choice column name, we need to use the keyword ‘AS’ with REPLACE() function. Example mysql> Select Name, REPLACE(Name, 'G', 'S') AS Name_Changed from student Where Subject = 'Computers'; +--------+--------------+ | Name | Name_Changed | +--------+--------------+ | Gaurav | ... Read More

How can we create user accounts in MySQL database server?

MySQL MySQLi Database

Published on 20-Feb-2018 17:32:40

As we know that, MySQL database server is having the user table in MySQL database which is used to store the user accounts so by using MySQL database we can create user accounts in MySQL database server. There must be two things while creating the new user account, one is ... Read More

How can we export all the data from MySQL table into a text file?

MySQL MySQLi Database

Published on 20-Feb-2018 12:44:24

It can be done with the help of SELECT … INTO OUTFILE statement. We are illustrating it with the help of the following example − Example Suppose we are having following data from table ‘Student_info’: mysql> Select * from Student_info; +------+---------+------------+------------+ | id | Name ... Read More

How MySQL evaluates if I store date along with time value in a column having DATE data type?

MySQL MySQLi Database

Published on 19-Feb-2018 16:29:39

As we know that the default format for MySQL DATE data type is “YYYY-MM-DD” and in this format, there is no possibility to store the time value. But still, if we store date along with time value in a column having DATE data type then MySQL will show a warning ... Read More

What happens if the output of MySQL TIMEDIFF() function surpass the range value of TIME field?

MySQL MySQLi Database

Published on 19-Feb-2018 15:49:36

As we know that the range of TIME field in MySQL is ‘-838:59:59’ to ‘838:59:59’. Now, if TIMEDIFF() function’s output surpasses this range then MySQL will return either ‘-838:59:59’ or ‘838:59:59’ depends upon the values of the argument. Example mysql> Select TIMEDIFF('2017-09-01 03:05:45', '2017-10-22 03:05:45')AS 'Out of Range TIME ... Read More

How is it possible to store date such as February 30 in a MySQL date column?

MySQL MySQLi Database

Published on 19-Feb-2018 12:51:12

Suppose we want to store the date such as February 30 in a MySQL table then we must have to first set ALLOW_INVALID_DATES mode enabled.For example, I am trying to add, without enabling ALLOW_INVALID_DATES mode, such kind of date in a table then MySQL will give an error as follows ... Read More

How MySQL behaves if I use INTERVAL keyword with an invalid date?

MySQL MySQLi Database

Published on 19-Feb-2018 11:57:44

Actually, the behavior of MySQL depends upon the allow_invalid_dates mode. If this mode is enabled then MySQL will accept the invalid date and it would perform the date arithmetic as it performs with a valid date. Otherwise, if this mode is inactive then it will not accept the invalid date ... Read More

Previous 1 ... 3 4 5 6 7 8 9 ... 11 Next

Advertisements