Interested to Buy Any Domain ? << Click Here >> for more details...
table a has records 1,1,1,1
table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
- 0 Answers
- 1329 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do I copy an entire mysql database?
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
Where is mysql password stored?
What is the maximum number of records in mysql table?
Which storage engines support transactions in MySQL?
how to Return total number of rows.
Is mysql deprecated?
How to create a new table by selecting rows from another table in mysql?
How to do login in mysql with unix shell.
What is dbms in mysql?
How do I view a mysql database?
The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id
-
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)
