SHARE
TWEET

Alevsk JDBC States Example

a guest Sep 18th, 2011 118 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DROP TABLE IF EXISTS `states`;
  2.  
  3. CREATE TABLE `states` (
  4.   `id_state` int(11) NOT NULL AUTO_INCREMENT,
  5.   `name` varchar(45) DEFAULT NULL,
  6.   PRIMARY KEY (`id_state`)
  7. ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
  8.  
  9.  
  10. INSERT INTO `states` (`id_state`,`name`)
  11. VALUES
  12.         (1,'Aguascalientes'),
  13.         (2,'Baja California'),
  14.         (3,'Baja California Sur'),
  15.         (4,'Campeche'),
  16.         (5,'Chiapas'),
  17.         (6,'Chihuahua'),
  18.         (7,'Coahuila de Zaragoza'),
  19.         (8,'Colima'),
  20.         (9,'Distrito Federal'),
  21.         (10,'Durango'),
  22.         (11,'Guanajuato'),
  23.         (12,'Guerrero'),
  24.         (13,'Hidalgo'),
  25.         (14,'Jalisco'),
  26.         (15,'M√©xico'),
  27.         (16,'Michoac√°n de Ocampo'),
  28.         (17,'Morelos'),
  29.         (18,'Nayarit'),
  30.         (19,'Nuevo Le√≥n'),
  31.         (20,'Oaxaca'),
  32.         (21,'Puebla'),
  33.         (22,'Quer√©taro'),
  34.         (23,'Quintana Roo'),
  35.         (24,'San Luis Potos√≠'),
  36.         (25,'Sinaloa'),
  37.         (26,'Sonora'),
  38.         (27,'Tabasco'),
  39.         (28,'Tamaulipas'),
  40.         (29,'Tlaxcala'),
  41.         (30,'Veracruz de Ignacio de la Llave'),
  42.         (31,'Yucat√°n'),
  43.         (32,'Zacatecas');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top