MariaDB [subconsultas]> show tables; +------------------------+ | Tables_in_subconsultas | +------------------------+ | articulo | | detalle | +------------------------+ 2 rows in set (0.001 sec) MariaDB [subconsultas]> select * from articulo; +--------+------------+----------+---------------+------------+ | codigo | articulo | cantidad | valorunitario | existencia | +--------+------------+----------+---------------+------------+ | 150 | nevera | 25 | 950000 | 0 | | 200 | televisor | 11 | 1200000 | 0 | | 250 | estufa | 30 | 750000 | 0 | | 300 | ventilador | 17 | 110000 | 0 | | 350 | lavadora | 13 | 980000 | 0 | +--------+------------+----------+---------------+------------+ 5 rows in set (0.001 sec) MariaDB [subconsultas]> select articulo,if(valorunitario>100000 and valorunitario<=950000, 'economico','Costoso') from articulo; +------------+---------------------------------------------------------------------------+ | articulo | if(valorunitario>100000 and valorunitario<=950000, 'economico','Costoso') | +------------+---------------------------------------------------------------------------+ | nevera | economico | | televisor | Costoso | | estufa | economico | | ventilador | economico | | lavadora | Costoso | +------------+---------------------------------------------------------------------------+ 5 rows in set (0.000 sec) MariaDB [subconsultas]> select articulo,if(valorunitario>100000 and valorunitario<=950000, 'economico','Costoso') valoracion from articulo; +------------+------------+ | articulo | valoracion | +------------+------------+ | nevera | economico | | televisor | Costoso | | estufa | economico | | ventilador | economico | | lavadora | Costoso | +------------+------------+ 5 rows in set (0.000 sec) MariaDB [subconsultas]> select * from articulo; +--------+------------+----------+---------------+------------+ | codigo | articulo | cantidad | valorunitario | existencia | +--------+------------+----------+---------------+------------+ | 150 | nevera | 25 | 950000 | 0 | | 200 | televisor | 11 | 1200000 | 0 | | 250 | estufa | 30 | 750000 | 0 | | 300 | ventilador | 17 | 110000 | 0 | | 350 | lavadora | 13 | 980000 | 0 | +--------+------------+----------+---------------+------------+ 5 rows in set (0.001 sec) MariaDB [subconsultas]> select articulo,if(valorunitario<=950000, 'Porcentaje de Aumento el 25%','Porcentaje de aumento del 40%') Incremento from articulo; +------------+-------------------------------+ | articulo | Incremento | +------------+-------------------------------+ | nevera | Porcentaje de Aumento el 25% | | televisor | Porcentaje de aumento del 40% | | estufa | Porcentaje de Aumento el 25% | | ventilador | Porcentaje de Aumento el 25% | | lavadora | Porcentaje de aumento del 40% | +------------+-------------------------------+ 5 rows in set (0.000 sec) MariaDB [subconsultas]> select case(weekday('2024-08-31')) when 0 then 'lunes' when 1 then 'martes' when 2 then 'miercoles' when 3 then 'jueves' when 4 then 'viernes' when 5 then 'sabado' when 6 then 'domingo' end; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | case(weekday('2024-08-31')) when 0 then 'lunes' when 1 then 'martes' when 2 then 'miercoles' when 3 then 'jueves' when 4 then 'viernes' when 5 then 'sabado' when 6 then 'domingo' end | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | sabado | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [subconsultas]> select case(weekday('2005-04-07')) when 0 then 'lunes' when 1 then 'martes' when 2 then 'miercoles' when 3 then 'jueves' when 4 then 'viernes' when 5 then 'sabado' when 6 then 'domingo' end; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | case(weekday('2005-04-07')) when 0 then 'lunes' when 1 then 'martes' when 2 then 'miercoles' when 3 then 'jueves' when 4 then 'viernes' when 5 then 'sabado' when 6 then 'domingo' end | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | jueves | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [subconsultas]> kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk -> ; 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 'kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk' at line 1 MariaDB [subconsultas]> MariaDB [subconsultas]> source C:/xampp/cadena.sql; Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.001 sec) Database changed Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (3.179 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 82 rows affected (1.139 sec) Records: 82 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.404 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [cadena]> tee c:/xampp/manejo_cadena.txt;