· 6 years ago · Jul 05, 2019, 05:00 AM
1Error
2consulta SQL:
3
4
5--
6-- Table structure for table `alumno`
7--
8
9DROP TABLE IF EXISTS `alumno`
10MySQL ha dicho: Documentación
11
12#1046 - Base de datos no seleccionada
13
14-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
15--
16-- Host: 127.0.0.1 Database: cphpmysql
17-- ------------------------------------------------------
18-- Server version 5.7.18-log
19
20/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
21/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
22/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
23/*!40101 SET NAMES utf8 */;
24/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
25/*!40103 SET TIME_ZONE='+00:00' */;
26/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
27/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
28/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
29/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
30
31--
32-- Table structure for table `alumno`
33--
34
35DROP TABLE IF EXISTS `alumno`;
36/*!40101 SET @saved_cs_client = @@character_set_client */;
37/*!40101 SET character_set_client = utf8 */;
38CREATE TABLE `alumno` (
39 `id` int(11) NOT NULL AUTO_INCREMENT,
40 `nombres` varchar(255) DEFAULT NULL,
41 `apellidos` varchar(255) DEFAULT NULL,
42 `estado` varchar(1) DEFAULT NULL,
43 PRIMARY KEY (`id`)
44) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
45/*!40101 SET character_set_client = @saved_cs_client */;
46
47--
48-- Dumping data for table `alumno`
49--
50
51LOCK TABLES `alumno` WRITE;
52/*!40000 ALTER TABLE `alumno` DISABLE KEYS */;
53INSERT INTO `alumno` VALUES (1,'Elivar Oswaldo','Largo Rios','1'),(5,'Juan','Vargas','1');
54/*!40000 ALTER TABLE `alumno` ENABLE KEYS */;
55UNLOCK TABLES;
56/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
57
58/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
59/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
60/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
61/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
62/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
63/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
64/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
65
66-- Dump completed on 2017-12-11 22:53:21