Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Database Articles
Page 545 of 546
Why is it not recommended to use the mixture of quoted as well as unquoted values in MySQL IN() function’s list?
Actually, MySQL has different comparison rules for quoted values such as strings and unquoted values such as numbers. On mixing the quoted and unquoted values in IN() function list may lead to the inconsistent result set. For example, we must not write the query with IN() function like below − Select Salary from employee where ID IN(1,’a’,2,3,’c’) Instead of this the better way to write the above query is as follows − Select Salary from employee where ID IN(‘1’,’a’,’2’,’3’,’c’)
Read MoreHow can I update MySQL table after quoting the values of a column with a single quote?
As we know that with the help of QUOTE() function we can put the values of a column in single quotes. By using QUOTE() function with UPDATE clause we can update the table having quoted values. We need to give column name as the parameter of QUOTE() function. Following example will update the table ‘examination_btech’ after putting the values of column ‘Course’ in single quotes. Example mysql> UPDATE examination_btech SET Course = QUOTE(Course); Query OK, 10 rows affected (0.05 sec) mysql> Select * from examination_btech; +--------+----------+----------+ | RollNo | Name | Course ...
Read MoreHow changes, made in the current transaction, can be permanently eliminated from MySQL database?
We can use ROLLBACK command to eliminate the changes, made in a current transaction, permanently from MySQL database. Suppose if we run some DML statements and it updates some data objects, then ROLLBACK command will eliminate these updates permanently from the database. Example Suppose we have the following data in table ‘marks’ and we applied the transaction and ROLLBACK command as follows − mysql> SELECT * FROM Marks; +------+---------+---------+-------+ | Id | Name | Subject | Marks | +------+---------+---------+-------+ | 1 | Aarav | Maths | ...
Read MoreHow can we count a number of unique values in a column in MySQL table?
By using DISTINCT keyword along with column name as the argument of COUNT() function we can count the number of unique values in a column. The syntax is as follows − SELECT COUNT(DISTINCT Col_name) FROM table_name; Example Suppose we have the following table mysql> Select * from tender; +----------+--------------+--------------+-------+ | clientid | client_Fname | Client_Lname | value | +----------+--------------+--------------+-------+ | 100 | Mohan | Kumar | 60000 | | 101 | Sohan ...
Read MoreHow OLD and NEW keywords enable us to access columns in row affected by\\na trigger?
As we know that in trigger definition, we can refer to columns of the row being inserted, updated or deleted. Following are the ways OLD and NEW keywords enable us to access columns − We must have to prefix the column name with a qualifier of OLD to refer to a value from the original row. We must have to prefix the column name with a qualifier of NEW to refer to a value in the new row. Now, the use of OLD and NEW must be done appropriately because the triggering event Determines which of them are ...
Read MoreHow can we create a MySQL view with GROUP BY clause?
We can use GROUP BY to group values from a column, and, if we want, we can perform calculations on that column. You can use COUNT, SUM, AVG, etc., functions on the grouped column. To understand GROUP BY clause with views we are creating a view named ‘Info’ using the base table ‘Student_info’ having the following data − mysql> Select * from Student_info; +------+---------+------------+------------+ | id | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History ...
Read MoreChanging Data Element of a column and showing description in Transaction SE16N
You probably need to activate the change. Other option is by deleting the description and enter the wrong character in data element name.This will make the system show an error message since that element does not exist.Correct the DDIC element spelling. The system now considers this a big enough change to the pull in an correct description of the element.
Read MoreDynamically creating parameters from table entries in SAP system
Note that parameter statement compiles into selection screen at compile team so it is not possible to declare dynamic parameters as proposed by you. Other approach would be that you could load dynpro and change the screen dynamically. You have to activate and then run the report that calls the changed screen. This same approach is used in T-code SE16 to generate a selection screen from a table.
Read MoreStoring configuration so that it doesn’t transfer to database in SAP system
I don’t think it can be automated so that configuration is not copied to the database. Try checking SAP Transport and Change Management detail, it could be possible by making some changes in Transport configuration.
Read MoreCondition Variables within Sub-Query in SAP
One line answer - Sub-Queries are not allowed. But if you need to handle your scenario, then you can do the following: Encapsulate your entire query into a stored procedure and then use the stored procedure. Create a view. The view is created to handle either your main query or sub-query. Create a table level variable and store the end results of view in it and then go ahead and fetch the value of table variable in the main query.
Read More