Advertisement
Guest User

Untitled

a guest
Nov 26th, 2014
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. IdRows | CategoriesName | UpperLevelName
  2. --------------------------------------------
  3. 1 | SomeName |
  4.  
  5. IdRows | CategoriesName | UpperLevelName
  6. --------------------------------------------
  7. 2 | SomeNameNext | SomeName
  8.  
  9. INSERT INTO categories (
  10. CategoriesName,
  11. UpperLevelName
  12. )
  13. VALUES (
  14. ?,
  15. (SELECT CategoriesName FROM categories WHERE IdRows = ?)
  16. )
  17.  
  18. INSERT INTO categories (CategoriesName, UpperLevelName)
  19. SELECT ?, CategoriesName FROM categories WHERE IdRows = ?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement