Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Untitled Prezi

No description
by

anthony gomez

on 5 February 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Untitled Prezi

MySQL es un sistema de gestión de bases de datos relacional, multihilo y multiusuario
PHPmyAdmin es un manejador
de base de datos SQL

Gavetas / Tablas
Folders / Campos
Papeles / Data
Archivero / Databse
Query
Respuesta
- Analizando QUERY

- Generando respuesta

- Enviando respuesta
Como crear una base de datos y su contenido
SQL DML and DDL
DML
SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
DDL
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
SI SABES INGLES PUEDES
MANEJAR FACILMENTE MySQL
MAGIC WORDS

INSERT, SELECT, UPDATE, DELETE
INSERT
INSERT INTO table_nameVALUES (value1, value2, value3,...)
Sintaxis
INSERT
SELECT
Sintaxis
SELECT column_name(s)
FROM table_name
SELECT
SELECT DISTINCT
Sintaxis
SELECT DISTINCT column_name(s)
FROM table_name
SELECT DISTINCT
SELECT WHERE
Sintaxis
SELECT column_name(s)
FROM table_name
WHERE column_name operator value
SELECT WHERE
Operators
= Equal
<> Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE Search for a pattern
IN To specify multiple possible values for a column
SELECT AND & OR
Sintaxis
SELECT AND
SINTAXIS
SELECT * FROM table_name WHERE column_name(s)= value
AND column_name(s)= value
SELECT AND
SELECT OR
SINTAXIS
SELECT * FROM table_name WHERE column_name(s)= value
OR column_name(s)= value
SELECT AND
Sintaxis
SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC
SELECT ORDER BY ASC || DESC
SINTAXIS
SELECT * FROM Persons ORDER BY LastName ASC
SELECT ORDER BY ASC
SINTAXIS
SELECT * FROM Persons ORDER BY LastName ASC
SELECT ORDER BY DESC
SELECT ORDER BY ASC || DESC
SELECT ORDER BY ASC
SELECT ORDER BY DESC
UPDATE
UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value
UPDATE
DELETE
DELETE FROM table_name
WHERE some_column=some_value
DELETE
MUCHAS GRACIAS POR SU ATENCION
Full transcript