×
Home
Jobs
Tools
Coding Ground
Current Affairs
UPSC Notes
Online Tutors
Whiteboard
Tutorix
Login
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
Q/A
Library
eBooks
Courses
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
Seetha
has Published
110
Answers
How can we distinguish between MySQL CROSS JOIN and INNER JOIN?
MySQL
MySQLi
Database
seetha
Published on 20-Feb-2018 11:44:13
We can distinguish between MySQL CROSS JOIN and INNER JOIN only on the basis of join-predicate i.e. the condition specified. While writing the query for INNER JOIN we need to specify the condition but in contrast, we do not need to specify the condition while writing a query for CROSS ...
Read More
What is the similarity between prepared statements and MySQL user variables?
MySQL
MySQLi
Database
seetha
Published on 20-Feb-2018 10:58:00
As we know that MySQL user variables are specific to client connection within which they are used and exist only for the duration of that connection. When a connection ends, all its user variables are lost. Similarly, the prepared statements also exist only for the duration of the session in ...
Read More
How can we transfer information between MySQL and data files through command line?
MySQL
MySQLi
Database
seetha
Published on 20-Feb-2018 09:43:20
Transferring the information between MySQL and data files mean importing data from data files into our database or exporting data from our database into files. MySQL is having two commands that can be used to import or export data between MySQL and data files through the command line −mysqlimport Actually, mysqlimport ...
Read More
How can we MySQL LOAD DATA INFILE statement with ‘ENCLOSED BY’ option to import data from text file into MySQL table?
MySQL
MySQLi
Database
seetha
Published on 20-Feb-2018 07:32:17
Sometimes the input text files have the text fields enclosed by double quotes and to import data from such kind of files we need to use the ‘ENCLOSED BY’ option with LOAD DATA INFILE statement. We are considering the following example to make it understand −ExampleFollowings are the comma-separated values ...
Read More
How MySQL handles the empty and null values for enumerations?
MySQL
MySQLi
Database
seetha
Published on 20-Feb-2018 06:17:14
MySQL accepts empty values for enumeration only if SQL mode is not set as TRADITIONAL, STRICT_TRANS_TABLES or STRICT_ALL_TABLES. Otherwise, MySQL would not accept empty values and throws an error. As we know that each enumeration value is having an index value, the empty value would have 0 index value.Examplemysql> SET ...
Read More
How can we change MySQL AUTO_INCREMENT starting number?
MySQL
MySQLi
Database
seetha
Published on 19-Feb-2018 13:24:17
MySQL AUTO_INCREMENT value starts from 1 but we can change it with the help of following two ways −With the help of ALTER TABLE query We can use ALTER TABLE query to change the staring value of AUTO_INCREMENT as follows −ALTER TABLE table_name AUTO_INCREMENT = value;ExampleSuppose we have created a ...
Read More
What MySQL will return on adding microseconds in the timestamp value for converting it into an integer?
MySQL
MySQLi
Database
seetha
Published on 19-Feb-2018 11:23:02
As we know that the value of timestamp can be converted to a number of seconds with the help of UNIX_TIMESTAMP() function. MySQL would ignore the microseconds added to the value of timestamp because the value of UNIX_TIMESTAMP is only 10digits long.Examplemysql> SELECT UNIX_TIMESTAMP('2017-10-22 04:05:36')AS 'Total Number of Seconds'; +-------------------------+ ...
Read More
What are the different ways in MySQL to add ‘half year interval’ in date?
MySQL
MySQLi
Database
seetha
Published on 19-Feb-2018 10:35:40
We can add ‘half year interval’ in date ith the following ways −(A) By adding interval of 6 Monthsmysql> Select '2017-06-20' + INTERVAL 6 Month AS 'After Half Year Interval'; +--------------------------+ | After Half Year Interval | +--------------------------+ | 2017-12-20 | +--------------------------+ 1 row ...
Read More
How will addition, subtraction, multiplication and division operator work with date values stored in MySQL table?
MySQL
MySQLi
Database
seetha
Published on 19-Feb-2018 07:20:23
When we try to do such kind of operations with date values stored in the table then MySQL is assuming the date values as the number and perform the arithmetic.Suppose we have a table named ‘example’ having a date value in ‘orderdate’ column then following arithmetic operation will clarify the ...
Read More
Why we cannot use MySQL DATE data type along with time value?
MySQL
MySQLi
Database
seetha
Published on 19-Feb-2018 06:04:36
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. Hence, we can say that we cannot use DATE data type along with time value.As we can see in the following example MySQL returns only date value ...
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