sql

MySQL Command Notes

greenteabiscuit

Reishi Mitani

Posted on September 12, 2020

MySQL Command Notes

To select,

select * from app_item WHERE name="great";
Enter fullscreen mode Exit fullscreen mode

To create,

INSERT INTO app_item (restaurant_memo, restaurant_name, created_by_id, updated_by_id, image) VALUES ("great", "great", 3, 3, "images/restaurant_posts/peperonchino.jpg");
Enter fullscreen mode Exit fullscreen mode

To delete,

DELETE FROM app_item WHERE id = 24;
Enter fullscreen mode Exit fullscreen mode
💖 💪 🙅 🚩
greenteabiscuit
Reishi Mitani

Posted on September 12, 2020

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related