Referencia MySQL (Sintaxis báscia)

Resumen de la sintáxis de MySQL

SELECT

SELECT 
   select_expr,...
  [FROM tabla
  [WHERE condicion]
  [GROUP BY {nombre_de_columna | expr | posicion}
       [ASC | DESC], ...]
  [ORDER BY {nombre_de_columna | expr | posicion} 
       [ASC | DESC] ,...]
  [LIMIT [desplazamiento,] cuena_de_filas]

INSERT

INSERT [INTO] nombre_de_la_tabla
SET nombre_de_la_columna={expresion | DEFAULT} , …

UPDATE

UPDATE [LOW_PRIORITY] [IGNORE] nombre_de_la_tabla
SET campo=valor [, campo1=valor1 ...]
[WHERE condicion]
[ORDER BY ...]
[LIMIT cantidad_de_registros]

DELETE

DELETE FROM nombre_de_la_tabla
 [WHERE where_definition]
  [ORDER BY ...]
  [LIMIT row_count]

Publicado por David Bedoian

Diseñador en Comunicación Visual

Únete a la conversación

113 comentarios

  1. Pingback: Nelson
  2. Pingback: willard
  3. Pingback: Ryan
  4. Pingback: Willard
  5. Pingback: Hubert
  6. Pingback: Roberto
  7. Pingback: Randy
  8. Pingback: terrance
  9. Pingback: kyle
  10. Pingback: Stanley
  11. Pingback: donald
  12. Pingback: brent
  13. Pingback: Austin
  14. Pingback: evan
  15. Pingback: lewis
  16. Pingback: dave
  17. Pingback: todd
  18. Pingback: Ralph
  19. Pingback: Bob
  20. Pingback: robert
  21. Pingback: fernando
  22. Pingback: sam
  23. Pingback: wesley
  24. Pingback: jessie
  25. Pingback: ted
  26. Pingback: Austin
  27. Pingback: james
  28. Pingback: Clifford
  29. Pingback: Brad
  30. Pingback: ben
  31. Pingback: Marc
  32. Pingback: Robert
  33. Pingback: Eugene
  34. Pingback: michael
  35. Pingback: carlos
  36. Pingback: gilbert
  37. Pingback: allen
  38. Pingback: Lynn
  39. Pingback: daniel
  40. Pingback: freddie
  41. Pingback: Patrick
  42. Pingback: Austin
  43. Pingback: Kyle
  44. Pingback: clifton
  45. Pingback: salvador
  46. Pingback: Lynn
  47. Pingback: Troy
  48. Pingback: morris
  49. Pingback: ronnie
  50. Pingback: Andre
  51. Pingback: ray
  52. Pingback: Terry
  53. Pingback: Maurice
  54. Pingback: wayne
  55. Pingback: Perry
  56. Pingback: Shaun
  57. Pingback: Leslie
  58. Pingback: Johnny
  59. Pingback: herbert
  60. Pingback: Darryl
  61. Pingback: ricky
  62. Pingback: Stephen
  63. Pingback: max
  64. Pingback: Louis
  65. Pingback: Mario
  66. Pingback: William
  67. Pingback: gabriel
  68. Pingback: Trevor
  69. Pingback: marc
  70. Pingback: Clarence
  71. Pingback: Lester
  72. Pingback: Ted
  73. Pingback: Alex
  74. Pingback: Evan
  75. Pingback: Clifton
  76. Pingback: Franklin
  77. Pingback: Lonnie
  78. Pingback: Hugh
  79. Pingback: Brett
  80. Pingback: adam
  81. Pingback: Tony
  82. Pingback: julio
  83. Pingback: Jay
  84. Pingback: Daryl
  85. Pingback: Mathew
  86. Pingback: Jesus
  87. Pingback: jeremy
  88. Pingback: Harvey
  89. Pingback: billy
  90. Pingback: mathew
  91. Pingback: sergio
  92. Pingback: doug
  93. Pingback: oscar
  94. Pingback: wendell
  95. Pingback: Clayton
  96. Pingback: daniel
  97. Pingback: Daniel
  98. Pingback: Dennis
  99. Pingback: eugene
  100. Pingback: Peter
  101. Pingback: Lynn
  102. Pingback: Daryl
  103. Pingback: Christian
  104. Pingback: darren
  105. Pingback: elmer
  106. Pingback: roy
  107. Pingback: Mark
  108. Pingback: louis
  109. Pingback: Joey
  110. Pingback: Daryl
  111. Pingback: Timothy
  112. Pingback: Ralph
  113. Pingback: Floyd
Deja un comentario