Is it possible to update a table value with out using update
command?. if yes what is the reason, if no what is the
reason?.
- 1 Answers
- 3009 Views
- I also Faced
- E-Mail Answers
Answer / bhawana
NO,it is impossible to update the table without using update
command,Because update command is used only for update the table
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain the different types of constraints?
How do I optimize a selected query in mysql?
Explain the difference between mysql and mysql interfaces in php?
What are the objects can be created using CREATE statement?
What is the difference between float and double?
What is deterministic in mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
What are the differences between mysql vs sql server?
What is 'mysqldump'?
How do stored procedures work?
How to drop an existing index in mysql?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
