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

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. You completed some nice points there. I did a search on the issue and found most folks will consent with your blog. Hunter Bilotta

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

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

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

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

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

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

  8. 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.

  9. 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.

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

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

  12. 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

  13. 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

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

  15. i like this good article

  16. 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

發表迴響