Setting environment for using XAMPP for Windows.

DELL@DESKTOP-66GS6R9 c:\users\dell\documents\xampp

# mysql-uroot -p

"mysql-uroot" no se reconoce como un comando interno o externo,

programa o archivo por lotes ejecutable.

DELL@DESKTOP-66GS6R9 c:\users\dell\documents\xampp

# mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 12

Server version: 10.4.24-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 batabase gabinete_abogados_

-> ;

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 'batabase gabinete_abogados_' at
line 1

MariaDB [(none)]> create database gabinete_abogados;

ERROR 1007 (HY000): Can't create database 'gabinete_abogados'; database exists

MariaDB [(none)]> create database gabinete_abogados__

-> ;

Query OK, 1 row affected (0.002 sec)

MariaDB [(none)]> use gabinete_abogados__;

Database changed
MariaDB [gabinete_abogados__]> CREATE TABLE `clientes` (

-> - `DNI_cliente` int(11) NOT NULL,

-> -> `Nombre` varchar(20) DEFAULT NULL,

-> -> `Apellido` varchar(25) DEFAULT NULL,

-> -> `Dir` varchar(35) DEFAULT NULL,

-> -> `Correo` varchar(35) DEFAULT NULL,

-> -> `fecha_reg` date DEFAULT NULL,

-> -> `Hora` date DEFAULT NULL,

-> -> `id_periodo` int(20));

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 '-> `DNI_cliente` int(11) NOT NULL,

-> `Nombre` varchar(20) DEFAULT NU...' at line 2

MariaDB [gabinete_abogados__]> CREATE TABLE `clientes` (

-> -> `DNI_cliente` int(11) NOT NULL,

-> -> `Nombre` varchar(20) DEFAULT NULL,

-> -> `Apellido` varchar(25) DEFAULT NULL,

-> -> `Dir` varchar(35) DEFAULT NULL,

-> -> `Correo` varchar(35) DEFAULT NULL,

-> -> `fecha_reg` date DEFAULT NULL,

-> -> `Hora` date DEFAULT NULL,

-> -> `id_periodo` int(20)

-> );

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 '-> `DNI_cliente` int(11) NOT NULL,

-> `Nombre` varchar(20) DEFAULT NU...' at line 2

MariaDB [gabinete_abogados__]> CREATE TABLE clientes ( `DNI_cliente` int(11) NOT NULL,

`Nombre` varchar(20) DEFAULT NULL,

`Apellido` varchar(25) DEFAULT NULL,

`Dir` varchar(35) DEFAULT NULL,

`Correo` varchar(35) DEFAULT NULL,

`fecha_reg` date DEFAULT NULL,

`Hora` date DEFAULT NULL,

`id_periodo` int(20));

Query OK, 0 rows affected (0.241 sec)

MariaDB [gabinete_abogados__]> CREATE TABLE `expediente` (

`Num_exp` int(40) DEFAULT NULL,

`id_clie` int(8) DEFAULT NULL,

`id_proc` int(8) DEFAULT NULL,

`Estado` char(20) DEFAULT NULL);

Query OK, 0 rows affected (0.187 sec)

MariaDB [gabinete_abogados__]> CREATE TABLE `procurado` (

`DNI_proc` int(8) DEFAULT NULL,

`Nombre` varchar(20) DEFAULT NULL,

`Apellido` varchar(20) DEFAULT NULL,

`Dirreccion` varchar(35) DEFAULT NULL,

`Correo` varchar(35) DEFAULT NULL

);

Query OK, 0 rows affected (0.140 sec)

MariaDB [gabinete_abogados__]> insert into clientes values ('1233','luis','valenzuela','villa

45','[email protected]','2022-02-12','09:08:45','344');

Query OK, 1 row affected, 1 warning (0.027 sec)

MariaDB [gabinete_abogados__]> insert into clientes values ('1263','angel','santamaria','hidalgo

45','[email protected]','2013-05-01','07:07:34','454');

Query OK, 1 row affected, 1 warning (0.016 sec)

MariaDB [gabinete_abogados__]> insert into clientes values ('1253','alma','lopez','villareal
75','[email protected]','2015-03-08','01:00:10','644');

Query OK, 1 row affected, 1 warning (0.019 sec)

MariaDB [gabinete_abogados__]> insert into clientes values ('1253','alexis','garcia','santaclara

43','[email protected]','2075-05-05','06:05:11','444');

Query OK, 1 row affected (0.019 sec)

MariaDB [gabinete_abogados__]> insert into clientes values ('1885','eva','alvarez','valle

54','[email protected]','2011-03-09','03:20:09','484');

Query OK, 1 row affected, 1 warning (0.035 sec)

MariaDB [gabinete_abogados__]> insert into expediente values ('1233','4333','2333','terminado');

Query OK, 1 row affected (0.021 sec)

MariaDB [gabinete_abogados__]> insert into expediente values ('1253','1444','4545','terminado');

Query OK, 1 row affected (0.036 sec)

MariaDB [gabinete_abogados__]> insert into expediente values ('1263','4893','5333','terminado');

Query OK, 1 row affected (0.017 sec)

MariaDB [gabinete_abogados__]> insert into expediente values

('1578','6546','3456','empezando');

Query OK, 1 row affected (0.031 sec)

MariaDB [gabinete_abogados__]> insert into expediente values

('1885','2344','4223','empezando');

Query OK, 1 row affected (0.037 sec)

MariaDB [gabinete_abogados__]> insert into procurado values ('2333','daniel','alcaraz','palmira

64','[email protected]);
'> insert into procurado values ('2333','daniel','alcaraz','palmira 64','[email protected]');

'>

'>

'>

'>

'>

'> '

-> ');

'>