Skip to content

Instantly share code, notes, and snippets.

@codesections

codesections/Core DB query

Last active November 26, 2018 14:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save codesections/caad4b92b76851a14fa35c461d5dc34e to your computer and use it in GitHub Desktop.
Save codesections/caad4b92b76851a14fa35c461d5dc34e to your computer and use it in GitHub Desktop.
Download ZIP
A database query for MariaDB
Raw
Core DB query
SELECT * from myTable WHERE listingId = 9000008;
Results
=======
+-----------+----------+----------------------------------------------------------------+---------+-----------------------------------------------------------------+
| listingId | id | alt | photoId | title |
+-----------+----------+----------------------------------------------------------------+---------+-----------------------------------------------------------------+
| 9000008 | 90883922 | Numquam adipisci et ea illo commodi. | 517 | Soluta laudantium harum veritatis totam at sint. |
| 9000008 | 90883923 | Quia recusandae culpa numquam nihil officiis. | 454 | Tenetur aspernatur quo quidem. |
| 9000008 | 90883924 | Est consequatur ut magnam. | 221 | Voluptas non facilis eveniet eius aperiam. |
| 9000008 | 90883925 | Beatae reiciendis ea. | 216 | Repudiandae eveniet eum eos ducimus molestiae. |
| 9000008 | 90883926 | Aperiam officia velit libero. | 592 | In nihil accusamus et deleniti. |
| 9000008 | 90883927 | Aut explicabo sint excepturi in quas inventore necessitatibus. | 253 | Nesciunt dicta possimus incidunt. |
| 9000008 | 90883928 | Voluptate quos ratione a voluptatem dolores ea. | 7 | Saepe corporis aut ut repellendus incidunt sed nisi blanditiis. |
| 9000008 | 90883929 | Voluptatum ducimus accusamus pariatur aut et. | 164 | Aut consequatur porro repellat repudiandae rerum. |
+-----------+----------+----------------------------------------------------------------+---------+-----------------------------------------------------------------+
8 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment