DEV Community

Reishi Mitani
Reishi Mitani

Posted on

MySQL Command Notes

#sql

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)

Read next

marrouchi profile image

How I used an OpenSource LLM in Wordpress

Med Marrouchi -

094459 profile image

Back to the future: Writing 6502 assembler with Amazon Q Developer

Ricardo Sueiras -

nozibul_islam_113b1d5334f profile image

list of the most common JavaScript string methods

Nozibul Islam -

jaloplo profile image

4 Key Lessons Learned from Using Microsoft 365 Copilot Effectively

Jaime López -