Advertisement
Guest User

benchmarks for conditional existance -- sql

a guest
Jun 22nd, 2011
671
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.18 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.3.9
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jun 22, 2011 at 01:53 PM
  7. -- Server version: 5.5.8
  8. -- PHP Version: 5.3.5
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `test`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Table structure for table `bar`
  20. --
  21.  
  22. CREATE TABLE IF NOT EXISTS `bar` (
  23.   `a` int(10) unsigned NOT NULL AUTO_INCREMENT,
  24.   PRIMARY KEY (`a`)
  25. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  26.  
  27. --
  28. -- Dumping data for table `bar`
  29. --
  30.  
  31.  
  32. -- --------------------------------------------------------
  33.  
  34. --
  35. -- Table structure for table `bat`
  36. --
  37.  
  38. CREATE TABLE IF NOT EXISTS `bat` (
  39.   `f` int(11) NOT NULL AUTO_INCREMENT,
  40.   PRIMARY KEY (`f`)
  41. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  42.  
  43. --
  44. -- Dumping data for table `bat`
  45. --
  46.  
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. --
  51. -- Table structure for table `baz`
  52. --
  53.  
  54. CREATE TABLE IF NOT EXISTS `baz` (
  55.   `f` int(11) NOT NULL AUTO_INCREMENT,
  56.   PRIMARY KEY (`f`)
  57. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  58.  
  59. --
  60. -- Dumping data for table `baz`
  61. --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement