how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is time based sql injection?
Is t sql a programming language?
Are dml statements autocommit?
What is the difference between sql and mysql?
Why is partition used in sql?
Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?
table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.
what is the sql query to display current date? : Sql dba
what is pragma ?
Why do we go for stored procedures?
what is self join and what is the requirement of self join? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)