紀錄工作經驗、相關知識,解決技術相關問題。

MySQL

MySQL 新增、查詢、修改、刪除 | 基本語法

MySQL

MySQL

MySQL 最常用到的基本語法為新增、查詢、修改、刪除,這邊簡單做整理。

MySQL 基本指令 | 基本語法

MySQL 新增 | INSERT INTO

INSERT INTO TableName (Column1, Column2,..., ColumnN) VALUES (Value1, Value2,..., ValueN);

MySQL 修改 | UPDATE

UPDATE TableName SET Column1 = Value1, Column2 = Value2, ... , ColumnN = ValueN WHERE Column1 = Value1;

MySQL 查詢 | SELECT

SELECT * FROM TableName

或者

SELECT Column1, Column2, ... , ColumnN FROM TableName

MySQL 刪除| DELETE

DELETE FROM TableName WHERE Column1 = Value1;

16 留言

  1. This piece of writing provides clear idea designed for the new visitors of blogging, that genuinely how to do blogging and site-building. Daile Dalt Hester

  2. i like this good article

  3. Pretty! This has been a really wonderful article. Many thanks for providing this information. Natalie Monro Cuttler

  4. Great post, I think website owners should acquire a lot from this blog its real user genial. So much wonderful info on here :D. Joela Bartlet Trometer

  5. Hi, this weekend is good in favor of me, because this occasion i am reading this enormous educational article here at my home. Devin Vasily Baggett

  6. Hi there, after reading this awesome article i am also delighted to share my knowledge here with mates. Stevana Ange Mariellen

  7. What a data of un-ambiguity and preserveness of precious familiarity about unpredicted feelings. Lea Dwain Adolf

  8. whoah this weblog is wonderful i love reading your articles.
    Stay up the good work! You know, a lot of persons are hunting around for this
    information, you could aid them greatly.

  9. Admiring the dedication you put into your site and detailed information you offer.

    It’s nice to come across a blog every once in a while
    that isn’t the same outdated rehashed information. Excellent read!
    I’ve bookmarked your site and I’m including your RSS feeds
    to my Google account.

  10. You completed some nice points there. I did a search on the issue and found most folks will consent with your blog. Hunter Bilotta

  11. I used to be recommended this website by way of my cousin. I’m

  12. Spot on with this write-up, I absolutely believe that this site

  13. Having read this I believed it was rather informative. I appreciate you taking the time and energy to put this content together. Kyle Ciulla

  14. I really like it when folks get together and share ideas. Keenan Scroger

  15. Having read this I believed it was rather informative. I appreciate you taking the time and energy to put this content together. Kyle Ciulla

  16. You completed some nice points there. I did a search on the issue and found most folks will consent with your blog. Hunter Bilotta

發表迴響