Scribd
Upload
75 views9 pages

SQL Syntax Troubleshooting Guide

The document shows the steps someone took to set up a MySQL database called 07_practica_nadia. They created tables called PERSONA, CATEGORIA, and USUARIO. They had issues with the table creations and corrected the syntax errors. They were then able to insert data into the USUARIO table and query the table to see the inserted rows.

Uploaded by

cardenasjimeneznadiaisabel53
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
75 views9 pages

SQL Syntax Troubleshooting Guide

The document shows the steps someone took to set up a MySQL database called 07_practica_nadia. They created tables called PERSONA, CATEGORIA, and USUARIO. They had issues with the table creations and corrected the syntax errors. They were then able to insert data into the USUARIO table and query the table to see the inserted rows.

Uploaded by

cardenasjimeneznadiaisabel53
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 9

Microsoft Windows [Versión 10.0.22631.

3085]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\nadia>cd C:\xampp\mysql\binC:\xampp\mysql\bin
El nombre de archivo, el nombre de directorio o la sintaxis de la etiqueta del
volumen no son correctos.
C:\Users\nadia>C:\xampp\mysql\bin
"C:\xampp\mysql\bin" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.

C:\Users\nadia>cd C:\xampp\mysql\bin

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.4.32-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database 07_practica_nadia;


Query OK, 1 row affected (1.589 sec)

MariaDB [(none)]> use 07_practica_nadia;


Database changed
MariaDB [07_practica_nadia]> create table PERSONA;
ERROR 1113 (42000): A table must have at least 1 column
MariaDB [07_practica_nadia]> create table PERSONA
-> (idp int,
-> app varchard(30),
-> amp varchar(30),
-> edadp int,
-> unique(idp));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '(30),
amp varchar(30),
edadp int,
unique(idp))' at line 3
MariaDB [07_practica_nadia]> create table PERSONA
-> (idp int,
-> app varchar(30),
-> amp varchar(30),
-> edadp int,
-> unique (idp));
Query OK, 0 rows affected (1.853 sec)

MariaDB [07_practica_nadia]> show tables;


+-----------------------------+
| Tables_in_07_practica_nadia |
+-----------------------------+
| persona |
+-----------------------------+
1 row in set (0.001 sec)

MariaDB [07_practica_nadia]> describe table PERSONA;


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'table
PERSONA' at line 1
MariaDB [07_practica_nadia]> show table persona;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'persona' at line 1
MariaDB [07_practica_nadia]> describe PERSONA;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| idp | int(11) | YES | UNI | NULL | |
| app | varchar(30) | YES | | NULL | |
| amp | varchar(30) | YES | | NULL | |
| edadp | int(11) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
4 rows in set (0.731 sec)

MariaDB [07_practica_nadia]> create table CATEGORIA


-> idc int,
-> nombrec varchar(30),
-> descripcion varchar(200),
-> auto_increment (idc));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'int,
nombrec varchar(30),
descripcion varchar(200),
auto_increment (idc))' at line 2
MariaDB [07_practica_nadia]> create table CATEGORIA
-> idc int,
-> nombrec varchar(30),
-> descripcion varchar(200),
-> primary key P1(idc));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'int,
nombrec varchar(30),
descripcion varchar(200),
primary key P1(idc))' at line 2
MariaDB [07_practica_nadia]> create table CATEGORIA
-> idc int auto_increment,
-> nombrec varchar(30),
-> descripcion varchar(200),
-> primary Key P1 (idc));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'int
auto_increment,
nombrec varchar(30),
descripcion varchar(200),
primary Ke...' at line 2
MariaDB [07_practica_nadia]> create table CATEGORIA
-> idc int auto_increment,
-> nombre varchar(30),
-> descripcion varchar(50),
-> primary key P1(idc));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'int
auto_increment,
nombre varchar(30),
descripcion varchar(50),
primary key ...' at line 2
MariaDB [07_practica_nadia]> create table CATEGORIA
-> (idc int auto_increment,
-> nombre varchar(30),
-> descripcion varchar(50),
-> primary key P1(idc));
Query OK, 0 rows affected, 1 warning (1.995 sec)

MariaDB [07_practica_nadia]> create table USUARIO


-> (idu int,
-> emailu varchar(30),
-> nombreu varchar(30),
-> telefonou varchar(30),
-> passwordu varchar(30),
-> tipo_usuario enum('admin','DBA','usuario'),
-> primary key(emailu));
Query OK, 0 rows affected (0.699 sec)

MariaDB [07_practica_nadia]> describe USUARIO


-> ;
+--------------+-------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------------------------+------+-----+---------+-------+
| idu | int(11) | YES | | NULL | |
| emailu | varchar(30) | NO | PRI | NULL | |
| nombreu | varchar(30) | YES | | NULL | |
| telefonou | varchar(30) | YES | | NULL | |
| passwordu | varchar(30) | YES | | NULL | |
| tipo_usuario | enum('admin','DBA','usuario') | YES | | NULL | |
+--------------+-------------------------------+------+-----+---------+-------+
6 rows in set (0.210 sec)

MariaDB [07_practica_nadia]> insert into USUARIO (20, "juan@gmail.com", "Juan",


"(55)53203044", "123abc", "Admin");
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 11
Current database: 07_practica_nadia

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '20,
"juan@gmail.com", "Juan", "(55)53203044", "123abc", "Admin")' at line 1
MariaDB [07_practica_nadia]> insert into usuario
-> (20,
-> "juan@gmail.com",
-> "Juan",
-> "(55)53203044",
-> "123abc",
-> "Admin");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '20,
"juan@gmail.com",
"Juan",
"(55)53203044",
"123abc",
"Admin")' at line 2
MariaDB [07_practica_nadia]> insert into USUARIO
-> (20,
-> "juan@gmail.com",
-> "Juan",;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '20,
"juan@gmail.com",
"Juan",' at line 2
MariaDB [07_practica_nadia]> insert into USUARIO
-> ( 20 int,
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '20
int,
)' at line 2
MariaDB [07_practica_nadia]> insert into USUARIO
-> (20,
-> 'juan@gmail.com',
-> 'Juan');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '20,
'juan@gmail.com',
'Juan')' at line 2
MariaDB [07_practica_nadia]> insert into USUARIO value
-> (20,
-> "juan@gmail.com",
-> "Juan",
-> "(55)53203044",
-> "123abc",
-> "Admin");
Query OK, 1 row affected (0.480 sec)

MariaDB [07_practica_nadia]> select * now usuario;


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'now
usuario' at line 1
MariaDB [07_practica_nadia]> select * name usuario;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'name
usuario' at line 1
MariaDB [07_practica_nadia]> select * usuario;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'usuario' at line 1
MariaDB [07_practica_nadia]> insert into usuario value
-> (21,
-> "pedro@gmail.com",
-> "pedro",
-> "(55)33203044",
-> "123abc",
-> 2);
Query OK, 1 row affected (1.546 sec)

MariaDB [07_practica_nadia]> select * show USUARIO;


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'show
USUARIO' at line 1
MariaDB [07_practica_nadia]> select * from USUARIO;
+------+-----------------+---------+--------------+-----------+--------------+
| idu | emailu | nombreu | telefonou | passwordu | tipo_usuario |
+------+-----------------+---------+--------------+-----------+--------------+
| 20 | juan@gmail.com | Juan | (55)53203044 | 123abc | admin |
| 21 | pedro@gmail.com | pedro | (55)33203044 | 123abc | DBA |
+------+-----------------+---------+--------------+-----------+--------------+
2 rows in set (0.001 sec)
MariaDB [07_practica_nadia]> insert into PERSONA value
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '' at
line 1
MariaDB [07_practica_nadia]> insert into PERSONA(app,amp,edad)
value("Juarez","Martinez", 20);
ERROR 1054 (42S22): Unknown column 'edad' in 'field list'
MariaDB [07_practica_nadia]> insert into persona (app,amp,edad) value
-> ("juarez",
-> "martinez",
-> 20);
ERROR 1054 (42S22): Unknown column 'edad' in 'field list'
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion)values
-> ("queso",
-> 1,
-> "producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion)value
-> ("queso",
-> 1,
-> "producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria(
-> nombrec,
-> descripcion)
-> value
-> ("queso",
-> 1,
-> "producto lacteo);
"> );
"> ");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria(
-> (nombrec,
-> descripcion);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'nombrec,
descripcion)' at line 2
MariaDB [07_practica_nadia]> insert into categoria (nombrec, descripcion)value
-> ("queso",
-> 1,
-> "producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria insert into categoria
-> (nombrec,
-> descripcion)
-> values
-> ("queso",
-> 1,
-> "prodcuto lacteo");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'insert
into categoria
(nombrec,
descripcion)
values
("queso",
1,
"prodcuto la...' at line 1
MariaDB [07_practica_nadia]> insert into categoria(nombrec, descripcion)values
-> ("queso",
-> 1,
-> "producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria values
-> ("queso",
-> 1,
-> "producto lacteo");
Query OK, 1 row affected, 1 warning (0.307 sec)

MariaDB [07_practica_nadia]> select * from categoria;


+-----+--------+-----------------+
| idc | nombre | descripcion |
+-----+--------+-----------------+
| 1 | 1 | producto lacteo |
+-----+--------+-----------------+
1 row in set (0.001 sec)

MariaDB [07_practica_nadia]> insert into categoria(nombrec, descripcion)values


-> ("queso",
-> 1,
-> "producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> delete from categoria;
Query OK, 1 row affected (0.442 sec)

MariaDB [07_practica_nadia]> insert into categoria (


-> nombrec,
-> descripcion);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '' at
line 3
MariaDB [07_practica_nadia]> insert into categoria
-> (nombrec,
-> descripcion);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '' at
line 3
MariaDB [07_practica_nadia]> insert into categoria (nombrec, descripcion) values
-> ("queso",
-> 1,
-> "producto lacteo",
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near ')' at
line 5
MariaDB [07_practica_nadia]> insert into categoria(nombrec, descripcion)value
-> ("queso",
-> 1,
-> "producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria(nombrec, descripcion); values
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '' at
line 1
-> insert into categoria(nombrec,descripcion)values
-> ("queso",
-> 1,
-> "productolacteo");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near 'insert
into categoria(nombrec,descripcion)values
("queso",
1,
"productolacteo")' at line 2
MariaDB [07_practica_nadia]> insert into
categoria(nombrec,descripcion)values("queso","producto lacteo");
ERROR 1054 (42S22): Unknown column 'nombrec' in 'field list'
MariaDB [07_practica_nadia]> insert into
categoria(nombrec,descripcion)values(1,"queso","producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion)values
-> 1,
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '1,' at
line 2
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion)values
-> (1,
-> "queso",
-> "productos lacteos");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion)values
-> ("queso",
-> "productos lacteos");
ERROR 1054 (42S22): Unknown column 'nombrec' in 'field list'
MariaDB [07_practica_nadia]> insert into
categoria(nombrec,descripcion)values("queso","producto lacteo");
ERROR 1054 (42S22): Unknown column 'nombrec' in 'field list'
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion)
values(1,"queso","producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion) value
-> ("queso",
-> "productos lacteos");
ERROR 1054 (42S22): Unknown column 'nombrec' in 'field list'
MariaDB [07_practica_nadia]> insert into categoria(nombrec,descripcion)values
-> (1,
-> "queso",
-> "productos lacteos");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into categoria
values(nombrec,descripcion)values(1,"queso","producto lacteo");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'values(1,"queso","producto lacteo")' at line 1
MariaDB [07_practica_nadia]> insert into
categoria(nombrec,descripcion)values(1,"queso","producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into
categoria(nombrec,descripcion)values("queso","producto lacteo");
ERROR 1054 (42S22): Unknown column 'nombrec' in 'field list'
MariaDB [07_practica_nadia]> insert into
categoria(nombrec,descripcion)values(1,"queso","producto lacteo");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [07_practica_nadia]> insert into
categoria(nombre,descripcion)values("queso","producto lacteo");
Query OK, 1 row affected (0.969 sec)

MariaDB [07_practica_nadia]> insert into


persona(app,amp,edadp)values("Juarez","Martinez", 20);
Query OK, 1 row affected (0.363 sec)

MariaDB [07_practica_nadia]> create table CATEGORIA2;


ERROR 1113 (42000): A table must have at least 1 column
MariaDB [07_practica_nadia]> create table CATEGORIA2
-> (idc int auto_increment=30,
-> nombre varchar(39),
-> descripcion varchar(200),
-> primary key pk20(idc));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near '=30,
nombre varchar(39),
descripcion varchar(200),
primary key pk20(idc))' at line 2
MariaDB [07_practica_nadia]> create table CATEGORIA2 (idc int auto_increment,nombre
varchar(30),descripcion(60),primary key pk20(idc));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'(60),primary key pk20(idc))' at line 1
MariaDB [07_practica_nadia]> create table CATEGORIA2 (idc int auto_increment,nombre
varchar(30),descripcion varchar(60),primary key pk20(idc));
Query OK, 0 rows affected, 1 warning (9.826 sec)

MariaDB [07_practica_nadia]>
MariaDB [07_practica_nadia]> describe categoria2;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| idc | int(11) | NO | PRI | NULL | auto_increment |
| nombre | varchar(30) | YES | | NULL | |
| descripcion | varchar(60) | YES | | NULL | |
+-------------+-------------+------+-----+---------+----------------+
3 rows in set (0.273 sec)

MariaDB [07_practica_nadia]> insert into


categoria(nombre,descripcion)values("leche","producto");
Query OK, 1 row affected (0.228 sec)

MariaDB [07_practica_nadia]> alter table categoria2 auto_increment=30;


Query OK, 0 rows affected (0.180 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [07_practica_nadia]> select * from usuario;


+------+-----------------+---------+--------------+-----------+--------------+
| idu | emailu | nombreu | telefonou | passwordu | tipo_usuario |
+------+-----------------+---------+--------------+-----------+--------------+
| 20 | juan@gmail.com | Juan | (55)53203044 | 123abc | admin |
| 21 | pedro@gmail.com | pedro | (55)33203044 | 123abc | DBA |
+------+-----------------+---------+--------------+-----------+--------------+
2 rows in set (0.001 sec)

MariaDB [07_practica_nadia]> select * from persona;


+------+--------+----------+-------+
| idp | app | amp | edadp |
+------+--------+----------+-------+
| NULL | Juarez | Martinez | 20 |
+------+--------+----------+-------+
1 row in set (0.001 sec)

MariaDB [07_practica_nadia]> select * from categoria;


+-----+--------+-----------------+
| idc | nombre | descripcion |
+-----+--------+-----------------+
| 2 | queso | producto lacteo |
| 3 | leche | producto |
+-----+--------+-----------------+
2 rows in set (0.001 sec)

MariaDB [07_practica_nadia]> select * from categoria2;


Empty set (0.001 sec)

MariaDB [07_practica_nadia]>

You might also like