There is a structure of a table with an auto-increment ID.Last inserted id is 2145. What will be the next ID after following conditions?
- Delete from tablename?
- Delete from tablename where ID=”2145″
- truncate table tablename
2146, 2146, 1
Links
Categories
- PHP Questions
(50)
- Regular level (24)
- Advanced level (15)
- Expert level (9)
- Regular level
- MySql Questions (7)
- Regular level (4)
- Advanced level (2)
- Expert level (1)
- Regular level
- CMS Questions (11)
- Drupal (10)
- Drupal
- Framework questions (4)
- cakephp (4)
- cakephp
- PHP Questions
List of questions- pdf
Tags
arrays array_combine array_walk array_walk_recursive by-reference cakephp cakephp interview clientside cms cookies document drupal echo existence explode form framework get header hijacking include Interview interviews Iteration ob_start oop php PHP Questions php security post print redirect Regex register request resultset serverside sessions sort SP's split sql injections sql joins Strings variables
-
0 comments
23rd Feb 10
Bart
-
23rd Feb 10 Bart
What is the difference between inner join and outer join?
Simply, inner join gives both table’s common fields and outer join gives uncommon fields.
Inner join
SELECT CUSTOMERS.NAME, ORDERS.NAME
FROM CUSTOMERS
INNER JOIN ORDERS
ON CUSTOMERS.ID = ORDERS.CUSTOMER_IDOuter join
SELECT CUSTOMERS.NAME, ORDERS.NAME
FROM CUSTOMERS
LEFT JOIN ORDERS
ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID
