NOMBRE DEL COMANDO
|
DESCRIPCION
|
SINTAXIS
|
EJEMPLO
|
PANTALLA
|
INSERT
INTO VALUES
|
Inserta
un registro ala tabla.
|
INSERT INTO
[table name] (Host,User,
Password) VALUES('%',
'user',PASSWORD
'password'));
|
mysql> insert into
biblioteca values(123,'hola_
amor
',987,'reymo',40
,2005);
|
+-------------+------+-------------+-------------+------------+
| código| titulo| isbn |
editorial | no_paguinas | edicion|
+--------+------------------+------+-------------+-------------+-----
| 123 | hola_amor | 987 | reymo| 40 | 0000-00-00 |
|
NOMBRE DEL COMANDO
|
DESCRIPCION
|
SINTAXIS
|
EJEMPLO
|
PANTALLA
|
Use
|
Seleccionar una base de datos de el servidor.
|
use [db name];
|
use victor;
|
mysql> use victor;
Database changed
|
create database
|
Crear nueva base de datos en servidor.
|
create database [databasename];
|
create database omar;
|
mysql> create database omar;
Query OK, 1 row affected (0.06 sec)
+--------------------+
| Database |
+--------------------+
| omar |
+--------------------+
|
describe
|
Mostrar caracteristicas de una tabla.
|
describe [table name];
|
describe alumnos;
|
mysql> describe alumnos;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| expediente | int(10) | NO | PRI | NULL | |
| nombre | varchar(50) | YES | | NULL | |
| localidad | varchar(50) | YES | | NULL | |
| fecha_nac | date | YES | | NULL | |
| direccion | varchar(50) | YES | | NULL | |
| curso | int(2) | YES | | NULL | |
| nivel | varchar(10) | YES | | NULL | |
| faltas | int(3) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
|
SELECT * FROM
|
Mostrar todos los datos de una tabla.
|
SELECT * FROM [table name];
|
select * from usuario;
|
mysql> select * from usuario;
-------------+----------+---------------+
| codigo |nombre| telefono | calle| numero | colonia|ciudad | codigo_postal |
+------------+--------+--------------+-----------+--------------
| 1234 | aldo_limon | 57939705 | dalias|10 | villa_flores | coacalco | 55717 |
|2348 | victor_limon | 98765432 | hidalgo| 9 | felipe|
coacalco | 55213 |
| 4356 | moises_limon | 34216728 | benito_juarez | 18 | las_manzanas | naucalpan | 45328 |
|
show columns from
|
Regresa la informacion de las columnas en una tabla.
|
show columns from [table name];
|
show columns from usuario;
|
mysql> show columns from usuario;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| codigo | int(20) | NO | PRI | NULL | |
| nombre | varchar(20) | YES | | NULL | |
| telefono | int(10) | YES | | NULL | |
| calle | varchar(20) | YES | | NULL | |
| numero | int(10) | YES | | NULL | |
| colonia | varchar(20) | YES | | NULL | |
| ciudad | varchar(20) | YES | | NULL | |
| codigo_postal | int(10) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
|
NOMBRE DEL COMANDO
|
DESCRIPCION
|
SINTAXIS
|
EJEMPLO
|
PANTALLA
|
|
SHOW DATABASES
|
Mostrar las bases de
datos en el servidor.
|
show databases;
|
show databases;
|
mysql> show databases;
+---------------------+
| Database |
+---------------------+
| productos1 |
+---------------------+
|
|
Show tables
|
Mostrar todas las tablas de
una base de datos.
|
show tables;
|
show tables;
|
mysql> show tables;
+------------------+
| Tables_in_victor |
+------------------+
| alumnos |
| biblioteca |
| depart |
| emple |
| usuario |
+------------------+
|
|
show columns from
|
Regresa la informacion
de las columnas en una tabla.
|
show columns from [table name];
|
show columns from alumnos;
|
mysql> show columns from alumnos;
+------------+-------------+------+-----+---------+-------+
| Field |
Type | Null | Key | Default |
Extra |
+------------+-------------+------+-----+---------+-------+
|
expediente | int(10) | NO | PRI | NUL | |
|
nombre | varchar(50) | YES | | NULL| |
| localidad
| varchar(50) | YES | | NULL | |
| fecha_nac
| date | YES |
| NULL| |
| direccion
| varchar(50) | YES | | NULL| |
| curso
| int(2) | YES | |
NULL | |
| nivel
| varchar(10) | YES | |
NULl | |
| faltas
| int(3) |
YES| | NULL|
|
+------------+-------------+------+-----+---------+-------+
|
|
Drop database
|
Borrar una base de datos.
|
drop database [databasename];
|
drop database emple;
|
mysql> drop database emple;
Query OK, 2 rows affected (0.10 sec)
|
|
Drop table
|
Borrar una tabla
|
drop table [table
name];
|
drop table emple;
|
mysql> drop table emple;
Query OK, 0 rows affected (0.04 sec)
|
|
DELETE from “ ” where
|
Borra una fila de una tabla.
|
DELETE from [table name] where [field name] =
'whatever';
|
delete from usuario where
colonia='san_felipe';
|
mysql> delete from usuario where
colonia='san_felipe';
|
No hay comentarios:
Publicar un comentario