DEV Community

Reishi Mitani
Reishi Mitani

Posted on

1 1

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

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay