×
Home
Jobs
Tools
Coding Ground
Current Affairs
UPSC Notes
Online Tutors
Whiteboard
Net Meeting
Tutorix
Login
Packages
Categories
Java
JSP
iOS
HTML
Android
Python
C Programming
C++ Programming
C#
PHP
CSS
Javascript
jQuery
SAP
SAP HANA
Data Structure
RDBMS
MySQL
Mathematics
8085 Microprocessor
Operating System
Digital Electronics
Analysis of Algorithms
Mobile Development
Front End
Web Development
Selenium
MongoDB
Computer Network
General Topics
Library
Videos
Q/A
eBooks
Login
Library
Videos
eBooks
Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Selected Reading
UPSC IAS Exams Notes
Developer's Best Practices
Questions and Answers
Effective Resume Writing
HR Interview Questions
Computer Glossary
Who is Who
Ankitha Reddy
has Published
102
Answers
What is MySQL LOAD DATA statement?
MySQL
MySQLi
Database
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Ankitha Reddy
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
Print
Add Notes
Bookmark this page
Report Error
Suggestions
Save
Close
Dashboard
Logout