Advertisements
Advertisements
प्रश्न
Which of the following executes the SQL command to perform some action?
विकल्प
execute()
key()
cursor()
run()
उत्तर
execute()
APPEARS IN
संबंधित प्रश्न
The most commonly used statement in SQL is ______
Which of the following clause avoid the duplicate?
Which method is used to fetch all rows from the database table?
Mention the difference between fetchone() and fetchmany().
What is the use of the Where Clause?
Give a python statement Using the where clause.
Consider the following table Supplier and item. Write a python script for the following Question?
| SUPPLIER | ||||
| Suppno | Name | City | Icode | SuppQty |
| S001 | Prasad | Delhi | 1008 | 100 |
| S002 | Anu | Bangalore | 1010 | 200 |
| S003 | Shahid | Bangalore | 1008 | 175 |
| S004 | Akila | Hydrabad | 1005 | 195 |
| S005 | Girish | Hydrabad | 1003 | 25 |
| S006 | Shylaja | Chennai | 1008 | 180 |
| S007 | Lavanya | Mumbai | 1005 | 325 |
Increment the SuppQty of Akila by 40
Write a Python script to create a table called ITEM with the following specifications.
Add one record to the table.
Name of the database:- ABC
Name of the table:- Item
Column name and specification:-
| Icode | :- | integer and act as primary key |
| Item Name | :- | The character with a length of 25 |
| Rate | :- | Integer |
| Record to be added | :- | 1008, Monitor, 15000 |
Write the Python script to display all the records of the following table using fetchmany().
| Icode | ItemName | Rate |
| 1003 | Scanner | 10500 |
| 1004 | Speaker | 3000 |
| 1005 | Printer | 8000 |
| 1008 | Monitor | 15000 |
| 1010 | Mouse | 700 |
The hat is the use of the HAVING clause. Give an example python script.
