Cov txheej txheem:

Kuv yuav tawm tswv yim li cas hauv MySQL workbench?
Kuv yuav tawm tswv yim li cas hauv MySQL workbench?

Video: Kuv yuav tawm tswv yim li cas hauv MySQL workbench?

Video: Kuv yuav tawm tswv yim li cas hauv MySQL workbench?
Video: Python! Hiding Password Inputs 2024, Tej zaum
Anonim

MySQL txhawb nqa peb hom lus:

  1. Los ntawm '--' mus rau qhov kawg ntawm kab. Ob chav dash- tawm tswv yim style yuav tsum muaj tsawg kawg yog whitespace lossis tswj tus cwj pwm (chaw, tab, kab tshiab, thiab lwm yam) tom qab dash thib ob.
  2. Los ntawm '#' mus rau qhov kawg ntawm kab. Xaiv.
  3. C-style tawm tswv yim /**/ tuaj yeem hla ntau kab.

Ib yam li ntawd, kuv yuav tawm tswv yim li cas hauv MySQL cov lus nug?

Hauv MySQL , a tawm tswv yim pib nrog -- cim zoo ib yam li ib tawm tswv yim pib nrog # cim. Thaum siv lub cim - lub tawm tswv yim yuav tsum yog qhov kawg ntawm kab hauv koj daim ntawv SQL nrog ib kab tawg tom qab nws. Txoj kev no ntawm tawm tswv yim tuaj yeem hla ib kab hauv koj SQL nkaus xwb thiab yuav tsum yog qhov kawg ntawm kab.

Ib yam li ntawd, /* txhais li cas hauv SQL? /* txhais tau tias pib ntawm ntau kab lus. Piv txwv li: /* CREATE PROC A_SAMPLE_PROC BEGIN AS xaiv * Los ntawm A_SAMPLE_TABLE END */ thaum -- txhais tau tias ib kab lus. Keyboard shortcut rau kev tawm tswv yim hauv MS SQL ntawv Server Studio yog Ctrl + K, Ctrl + C.

Kuj kom paub, dab tsi yog tus cwj pwm tawm tswv yim hauv SQL?

Txoj kev tawm tswv yim no yuav tsum nyob rau ntawm kab kawg thiab nyob rau hauv ib kab. A tawm tswv yim hauv SQL ntawv uas pib nrog /* cim thiab xaus nrog */ thiab tuaj yeem hla ntau kab hauv koj SQL ntawv.

Kuv yuav kho lub rooj hauv MySQL workbench li cas?

Koj tuaj yeem ntxiv lossis hloov kho cov kab los yog indexes ntawm a rooj , hloov lub cav, ntxiv cov yuam sij txawv teb chaws, lossis hloov tus rooj npe. Nkag mus rau qhov MySQL Table Editor , right-click a rooj npe hauv thaj chaw Navigator ntawm sidebar nrog Schemas thib ob tab xaiv thiab nyem Hloov Table.

Pom zoo: