1<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 2<html xmlns="https://www.w3.org/1999/xhtml" lang="ja"> 3 <head> 4 <meta http-equiv="Content-Language" content="Japanese" /> 5 <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> 6 <meta name="author" content="Kojo Sugita" /> 7 <meta name="description" content="SQLã®éå¼ãæ§æéã§ã" /> 8 <meta name="keywords" content="SQL,æ§æ,ãªãã¡ã¬ã³ã¹" /> 9 10
10<script type="text/javascript" src="./js/jquery.js"></script>
10 11
11<script type="text/javascript" src="./js/stripe-table.js"></script>
11 12
12<script type="text/javascript" src="./js/jquery.page-scroller.js"></script>
12 13 14 15 <link href="./css/style.css" rel="stylesheet" type="text/css" media="screen" /> 16 <link rel="SHORTCUT ICON" href="./images/favicon.ico" /> 17 18 <title>éå¼ãSQLæ§æé</title> 19 20
20<script type="text/javascript"> 21 window.google_analytics_uacct = "UA-5663763-10"; 22 </script>
22 23 24 25<!-- Yandex.Metrika counter -->
26<script type="text/javascript" >
vendor: 300 bytes, lines 26-31
26 27 (function(m,e,t,r,i,k,a){m[i]=m[i]||function(){(m[i].a=m[i].a||[]).push(arguments)}; 28 m[i].l=1*new Date();k=e.createElement(t),a=e.getElementsByTagName(t)[0],k.async=1,k.src=r,a.parentNode.insertBefore(k,a)}) 29 (window, document, "script", "https://mc.yandex.ru/metrika/tag.js", "ym"); 30 31 ym(
3182784752
vendor: 123 bytes, lines 31-36
31, "init", { 32 clickmap:true, 33 trackLinks:true, 34 accurateTrackBounce:true, 35 webvisor:true 36 });
37</script>
37 38<noscript><div><img src="https://mc.yandex.ru/watch/82784752" style="position:absolute; left:-9999px;" alt="" /></div></noscript> 39<!-- /Yandex.Metrika counter --> 40 41 42
42<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-8714413967545663" 43 crossorigin="anonymous"></script>
43 44
44<script charset="utf-8" async src="https://elpushnot.com/pjs/AYG0EFxBT.js"></script>
44 45 </head> 46 47 48 <body> 49 <div id="wrapper"> 50 <div id="header"> 51 <div id="block-header"> 52 <div id="logo"> 53 <h1><a href="https://www.sql-reference.com/">éå¼ãSQLæ§æé</a></h1> 54 </div> 55 56 <div id="menu"> 57 <ul> 58 <li><a href="https://www.sql-reference.com/"><span>Home</span></a></li> 59 <li><a href="./about.html"><span>About Us</span></a></li> 60 <li><a href="./sitemap.html"><span>Site map</span></a></li> 61 </ul> 62 </div> 63 64 <div class="clr"></div> 65 66 </div> 67 </div> 68 69 <div id="image-area"></div> 70 71 <div class="top-sponser"> 72 <div class="top-sponser-resize"> 73 </div> 74 </div> 75 76 <!-- <div class="clr"></div> --> 77 <div id="body"> 78 <div id="body-resize"> 79 80 <div id="topic-path"> 81 <p> â« Home</p> 82 </div> <!-- topic-path end --> 83 84 <h2>éå¼ãSQLæ§æé</h2> 85 <div id="left-index"> 86 87<!-- ads_poster_begin -->
88<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
88 89<ins class="adsbygoogle" 90 style="display:block; text-align:center;" 91 data-ad-layout="in-article" 92 data-ad-format="fluid" 93 data-ad-client="ca-pub-1969129162258194" 94 data-ad-slot="6686600497"></ins>
95<script> 96 (adsbygoogle = window.adsbygoogle || []).push({}); 97</script>
97 98<!-- ads_poster_end --> 99 100 <p> 101 éå¼ãSQLæ§æéã¯ãããããã¨ããï¼ãã®æ¹æ³ã調ã¹ãããSQLã®éå¼ãã®ãªãã¡ã¬ã³ã¹ã§ãï¼<br /> 102 ãã¹ã¦ã®é ç®ã«ãµã³ãã«ãç¨æãã¦ããã¾ãã®ã§ãããããã°åèã«ãã¦ãã ããï¼<br /> 103 <!-- ãªãæ¬ãµã¤ããæ³å®ããDBMSã¯ä»¥ä¸ã®5種é¡ã§ãï¼ --> 104 ãã©ã¦ã¶ã®æ¤ç´¢æ©è½(Ctrl + F)ã使ç¨ããã¨å¹ççã«SQLã調ã¹ããã¨ãã§ãã¾ãï¼ 105 <br /><br /> 106 <b>æ¬ãã¼ã ãã¼ã¸ã¯ç¾å¨ç²¾åçã«ä½æä¸ã§ã</b> 107 </p> 108 109 <div class="contents"> 110 <p><b>ç®æ¬¡</b></p> 111 <p class="section"><a href="#dml">ãã¼ã¿æä½è¨èª (DML)</a></p> 112 <p class="subsection"><a href="#select">鏿 (åºæ¬)</a> / <a href="#join">鏿 (çµå)</a> / <a href="#subquery">鏿 (å¯ååã)</a> / <a href="#collection">鏿 (éåæ¼ç®å)</a></p> 113 <p class="subsection"><a href="#insert">追å </a> / <a href="#update">æ´æ°</a> / <a href="#delete">åé¤</a></p> 114 <p class="subsection"><a href="#summary">éè¨é¢æ°</a> / <a href="#string">æåå颿°</a> / <a href="#math">æ°å¦é¢æ°</a> / <a href="#date">æ¥ä»é¢æ°</a> / <a href="#ctype">å夿颿°</a></p> 115 <p class="section"><a href="#ddl">ãã¼ã¿å®ç¾©è¨èª (DDL)</a></p> 116 <p class="subsection"><a href="#database">ãã¼ã¿ãã¼ã¹</a> / <a href="#table">ãã¼ãã«</a> / <a href="#view">ãã¥ã¼</a> / <a href="#index">ã¤ã³ããã¯ã¹</a> / <a href="#user">ã¦ã¼ã¶ã¼</a> / <a href="#trigger">ããªã¬ã¼</a></p> 117 <p class="section"><a href="#dcl">ãã¼ã¿å¶å¾¡è¨èª (DCL)</a></p> 118 </div> 119 120 <a id="dml"></a> 121 <h3>ãã¼ã¿æä½è¨èª (DML)</h3> 122 <p>表ããã¥ã¼ãªã©ã®ãã¼ã¿ã®æ¤ç´¢ï¼è¿½å ï¼æ´æ°ï¼åé¤ãè¡ãããã®SQLãç´¹ä»ãã¾ãï¼</p> 123 124 <h4 id="select">鏿 (åºæ¬)</h4> 125 <table> 126 <tr> 127 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 128 </tr> 129 <tr> 130 <td><a href="./select/select.html">ã¬ã³ã¼ããæ¤ç´¢ãã</a></td><td>SELECTï¼FROMï¼<br />WHEREï¼ANDï¼OR</td> 131 </tr> 132 <tr> 133 <td><a href="./select/distinct.html">éè¤ããã¬ã³ã¼ããçãã¦æ¤ç´¢ãã</a></td><td>DISTINCT</td> 134 </tr> 135 <tr> 136 <td><a href="./select/is_null.html">NULLå¤ãæã¤ãã¼ã¿ãæ¤ç´¢ãã</a></td><td>IS NULLï¼IS NOT NULL</td> 137 </tr> 138 <tr> 139 <td><a href="./select/between.html">æå®ããç¯å²ã®ã¬ã³ã¼ããæ¤ç´¢ãã</a></td><td>BETWEEN</td> 140 </tr> 141 <tr> 142 <td><a href="./select/in.html">æå®ããè¤æ°ã®å¤ã«ä¸ã¤ä»¥ä¸ä¸è´ããã¬ã³ã¼ããæ¤ç´¢ãã</a></td><td>IN</td> 143 </tr> 144 <tr> 145 <td><a href="./select/like.html">ã¯ã¤ã«ãã«ã¼ãã使ç¨ãã¦ã¬ã³ã¼ããæ¤ç´¢ãã</a></td><td>LIKE</td> 146 </tr> 147 <tr> 148 <td><a href="./select/as.html">æ¤ç´¢çµæã®ååãå¥åã§è¡¨ç¤ºãã</a></td><td>AS</td> 149 </tr> 150 <tr> 151 <td><a href="./select/orderby.html">ã¬ã³ã¼ããä¸¦ã³æ¿ãã</a></td><td>ORDER BYï¼ASCï¼DESC</td> 152 </tr> 153 </table> 154 155 <h4 id="join">鏿 (çµå)</h4> 156 <table> 157 <tr> 158 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 159 </tr> 160 <tr> 161 <td><a href="./select/inner_join.html">ãã¼ãã«ãçµåãã(ç価çµå|å é¨çµå)</a></td><td>JOINï¼INNER JOIN</td> 162 </tr> 163 <tr> 164 <td><a href="./select/outer_join.html">ãã¼ãã«ãå¤é¨çµåãã</a></td><td>LEFT OUTER JOINï¼<br />RIGHT OUTER JOINï¼<br />FULL OUTER JOIN</td> 165 </tr> 166 <tr> 167 <td><a href="./select/self_join.html">ãã¼ãã«ãèªå·±çµåãã(å帰çµå)</a></td><td>JOINï¼AS</td> 168 </tr> 169 <tr> 170 <td><a href="./select/cross_join.html">ãã¼ãã«ãã¯ãã¹çµåãã(ç´ç©)</a></td><td>CROSS JOIN</td> 171 </tr> 172 </table> 173 174 <h4 id="subquery">鏿 (å¯ååã)</h4> 175 <table> 176 <tr> 177 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 178 </tr> 179 <tr> 180 <td><a href="./select/subquery.html">å¯ååãï¼ãµãã¯ã¨ãªï¼ãè¡ã</a></td><td>INï¼EXISTS, <br />ANYï¼SOMEï¼ALL</td> 181 </tr> 182 <tr> 183 <td><a href="./select/subquery_in.html">INå¥ãç¨ããå¯ååã</a></td><td>IN</td> 184 </tr> 185 <tr> 186 <td><a href="./select/subquery_exists.html">EXISTSå¥ãç¨ããå¯ååã(ç¸é¢å¯ååã)</a></td><td>EXISTS</td> 187 </tr> 188 <tr> 189 <td><a href="./select/subquery_any.html">ANY(SOME)å¥ãç¨ããå¯ååã</a></td><td>ANYï¼SOME</td> 190 </tr> 191 <tr> 192 <td><a href="./select/subquery_all.html">ALLå¥ãç¨ããå¯ååã</a></td><td>ALL</td> 193 </tr> 194 <tr> 195 <td>FROMå¥ã®ä¸ã«SELECTæãè¨è¿°ãã (表å¼/ã¤ã³ã©ã¤ã³ãã¥ã¼)</td><td>FROM</td> 196 </tr> 197 <tr> 198 <td>䏿çãªãã¥ã¼ã使ãã (å ±é表å¼/CTE)</td><td>WITH</td> 199 </tr> 200 <tr> 201 <td>å帰çã«SELECTæãå®è¡ãã (å帰CTE)</td><td>WITH, RECURSIVE</td> 202 </tr> 203 </table> 204 205 <h4 id="collection">鏿 (éåæ¼ç®å)</h4> 206 <table> 207 <tr> 208 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 209 </tr> 210 <tr> 211 <td><a href="./select/union.html">è¤æ°ã®æ¤ç´¢çµæãçµ±åããï¼åéåï¼</a></td><td>UNIONï¼UNION ALL</td> 212 </tr> 213 <tr> 214 <td><a href="./select/except_minus.html">
214è¤æ°ã®æ¤ç´¢çµæã®å·®éåãåå¾ãã</a></td><td>EXCEPTï¼MINUS</td> 215 </tr> 216 <tr> 217 <td><a href="./select/intersect.html">è¤æ°ã®æ¤ç´¢çµæã®å ±éãããã¼ã¿ãåå¾ããï¼ç©éåï¼</a></td><td>INTERSECT</td> 218 </tr> 219 </table> 220 221 <h4 id="insert">追å </h4> 222 <table> 223 <tr> 224 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 225 </tr> 226 <tr> 227 <td><a href="./insert/insert.html">ã¬ã³ã¼ãã追å ãã</a></td><td>INSERT</td> 228 </tr> 229 <tr> 230 <td><a href="./insert/insert_select.html">ä»ã®ãã¼ãã«ããã¥ã¼ãã鏿ããã¬ã³ã¼ãã追å ãã</a></td><td>INSERT,SELECT</td> 231 </tr> 232 </table> 233 234 <h4 id="update">æ´æ°</h4> 235 <table> 236 <tr> 237 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 238 </tr> 239 <tr> 240 <td><a href="./update/update.html">ã¬ã³ã¼ããæ´æ°ãã</a></td><td>UPDATE</td> 241 </tr> 242 </table> 243 244 <h4 id="delete">åé¤</h4> 245 <table> 246 <tr> 247 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 248 </tr> 249 <tr> 250 <td><a href="./delete/delete.html">ã¬ã³ã¼ããåé¤ãã</a></td><td>DELETE</td> 251 </tr> 252 </table> 253 254 <h4 id="summary">éè¨é¢æ°</h4> 255 <table> 256 <tr> 257 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 258 </tr> 259 <tr> 260 <td><a href="./summary/summary.html">éè¨é¢æ°ã使ç¨ãã(åºæ¬)</a></td><td>GROUP BY, SUM, AVG, <br />MAX, MIN, COUNT</td> 261 </tr> 262 263 <tr> 264 <td><a href="./summary/having.html">æ¤ç´¢æ¡ä»¶ã«éè¨é¢æ°ã使ç¨ãã</a></td><td>HAVING</td> 265 </tr> 266 267 <tr> 268 <td><a href="./summary/sum.html">æå®åã®åè¨ãæ±ãã</a></td><td>SUM</td> 269 </tr> 270 <tr> 271 <td><a href="./summary/avg.html">æå®åã®å¹³åãæ±ãã</a></td><td>AVG</td> 272 </tr> 273 <tr> 274 <td><a href="./summary/max_min.html">æå®åã®æå¤§å¤ãæå°å¤ãæ±ãã</a></td><td>MAXï¼MIN</td> 275 </tr> 276 <tr> 277 <td><a href="./summary/count.html">ã¬ã³ã¼ãæ°ãåå¾ãã</a></td><td>COUNT</td> 278 </tr> 279 </table> 280 281 <h4 id="string">æåå颿°</h4> 282 <table> 283 <tr> 284 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 285 </tr> 286 <tr> 287 <td><a href="./string/concatenate.html">æååãé£çµãã</a></td><td>CONCATENATEï¼<br />CONCATï¼||ï¼+</td> 288 </tr> 289 <tr> 290 <td><a href="./string/upper_lower.html">æååã大æåãå°æåã«å¤æãã</a></td><td>UPPERï¼LOWERï¼<br />UCASEï¼LCASE</td> 291 </tr> 292 <tr> 293 <td><a href="./string/substring.html">æååã®ä¸é¨ãåå¾ãã</a></td><td>SUBSTRINGï¼<br />SUBSTRï¼MID</td> 294 </tr> 295 <tr> 296 <td><a href="./string/trim.html">æååã®å·¦ç«¯ãå³ç«¯ã«ãã空ç½ãåé¤ãã</a></td><td>TRIMï¼LTRIMï¼RTRIM</td> 297 </tr> 298 <tr> 299 <td><a href="./string/trim2.html">æååã®å·¦ç«¯ãå³ç«¯ã«ããç¹å®ã®æåãåé¤ãã</a></td><td>TRIM, BOTH, LEADING, TRAILING</td> 300 </tr> 301 <tr> 302 <td><a href="./string/translate.html">æååãç½®æãã</a></td><td>TRANSLATE, REPLACE</td> 303 </tr> 304 <tr> 305 <td><a href="./string/char_length.html">æååã®æåæ°ãåå¾ãã</a></td><td>CHAR_LENGTHï¼LEN, LENGTH</td> 306 </tr> 307 <!-- <tr> --> 308 <!-- <td><a href="./string/bit_length.html">æååã®ãããæ°ãåå¾ãã</a></td><td>BIT_LENGTHï¼LENGTHB</td> --> 309 <!-- </tr> --> 310 <tr> 311 <td><a href="./string/octet_length.html">æååã®ãã¤ãæ°ãåå¾ãã</a></td><td>OCTET_LENGTH, LENB, LENGTHB, LENGTH</td> 312 </tr> 313 <!-- <tr> --> 314 <!-- <td><a href="./string/position.html">æååããé¨åæååã§å§ã¾ãä½ç½®ãåå¾ãã</a></td><td>POSITION</td> --> 315 <!-- </tr> --> 316 </table> 317 318 <h4 id="math">æ°å¦é¢æ°</h4> 319 <table> 320 <tr> 321 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 322 </tr> 323 <tr> 324 <td><a href="./math/operatore.html">ååæ¼ç®ãè¡ã</a></td><td>+ï¼-ï¼*ï¼/</td> 325 </tr> 326 <tr> 327 <td><a href="./math/mod.html">ä½å°ãæ±ãã</a></td><td>MODï¼%</td> 328 </tr> 329 <tr> 330 <td><a href="./math/abs.html">絶対å¤ãæ±ãã</a></td><td>ABS</td> 331 </tr> 332 <tr> 333 <td><a href="./math/sin_cos_tan.html">ä¸è§é¢æ°ãè¨ç®ãã</a></td><td>SINï¼COSï¼TAN</td> 334 </tr> 335 <tr> 336 <td><a href="./math/asin_acos_atan.html">éä¸è§é¢æ°ãè¨ç®ãã</a></td><td>ASINï¼ACOSï¼ATANï¼ATAN2</td> 337 </tr> 338 <tr> 339 <td><a href="./math/round.html">丸ã(忍äºå ¥ï¼åãæ¨ã¦ï¼å¤©äºé¢æ°ï¼åºé¢æ°)ãè¡ã</a></td><td>ROUNDï¼CEILINGï¼<br />CEILï¼FLOOR</td> 340 </tr> 341 <tr> 342 <td><a href="./math/exp.html">ææ°é¢æ°ãè¨ç®ãã</a></td><td>EXP</td> 343 </tr> 344 <tr> 345 <td><a href="./math/log.html">対æ°(èªç¶å¯¾æ°ï¼å¸¸ç¨å¯¾æ°)ãæ±ãã</a></td><td>LOGï¼LOG10</td> 346 </tr> 347 <tr> 348 <td><a href="./math/power.html">ã¹ãä¹ãæ±ãã</a></td><td>POWï¼POWER</td> 349 </tr> 350 <tr> 351 <td><a href="./math/sqrt.html">å¹³æ¹æ ¹ãè¨ç®ãã</a></td><td>SQRT</td> 352 </tr> 353 <tr> 354 <td><a href="./math/pi.html">åå¨çãæ±ãã</a></td><td>PI</td> 355 </tr> 356 <!-- <tr> --> 357 <!-- <td><a href="./math/rand.html">ä¹±æ°ãåå¾ãã</a></td><td>RAND</td> --> 358 <!-- </tr> --> 359 <tr> 360 <td><a href="./math/sign.html">符å·ãæ±ãã</a></td><td>SIGN</td> 361 </tr> 362 </table> 363 364 <h4 id="date">æ¥ä»é¢æ°</h4> 365 <table> 366 <tr> 367 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 368 </tr> 369 <tr> 370 <td>
370ç¾å¨ã®æ¥ä»ãåå¾ãã</td><td>CURRENT_DATE</td> 371 <!-- <td><a href="#">ç¾å¨ã®æ¥ä»ãåå¾ãã</a></td><td>CURRENT_DATE</td> --> 372 </tr> 373 <tr> 374 <td>ç¾å¨ã®æå»ãåå¾ãã</td><td>CURRENT_TIME</td> 375 <!-- <td><a href="#">ç¾å¨ã®æå»ãåå¾ãã</a></td><td>CURRENT_TIME</td> --> 376 </tr> 377 <tr> 378 <td>ç¾å¨ã®æ¥ä»ã¨æå»ãåå¾ãã</td><td>CURRENT_TIMESTAMPï¼<br />SYSDATEï¼NOW</td> 379 <!-- <td><a href="#">ç¾å¨ã®æ¥ä»ã¨æå»ãåå¾ãã</a></td><td>CURRENT_TIMESTAMPï¼<br />SYSDATEï¼NOW</td> --> 380 </tr> 381 <tr> 382 <td>æ¥ä»/æå»ããå¹´ãæãªã©ã®ç¹å®ã®è¦ç´ ãåå¾ãã</td><td>EXTRACT</td> 383 <!-- <td><a href="#">æ¥ä»/æå»ããå¹´ãæãªã©ã®ç¹å®ã®è¦ç´ ãåå¾ãã</a></td><td>EXTRACT</td> --> 384 </tr> 385 </table> 386 387 <h4 id="ctype">å夿颿°</h4> 388 <table> 389 <tr> 390 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 391 </tr> 392 <tr> 393 <td>æ°å¤ãæååã«å¤æãã</td><td>TO_CHARï¼STR</td> 394 <!-- <td><a href="./ctype/.html">æ°å¤ãæååã«å¤æãã</a></td><td>TO_CHARï¼STR</td> --> 395 </tr> 396 <tr> 397 <td>æååãæ°å¤ã«å¤æãã</td><td>TO_NUMBER</td> 398 <!-- <td><a href="./ctype/.html">æååãæ°å¤ã«å¤æãã</a></td><td>TO_NUMBER</td> --> 399 </tr> 400 <tr> 401 <td>æ¥ä»ãæååã«å¤æãã</td><td>TO_CHAR</td> 402 <!-- <td><a href="./ctype/.html">æ¥ä»ãæååã«å¤æãã</a></td><td>TO_CHAR</td> --> 403 </tr> 404 <tr> 405 <td>æååãæ¥ä»ã«å¤æãã</td><td>TO_DATEï¼TO_TIMESTAMP</td> 406 <!-- <td><a href="./ctype/.html">æååãæ¥ä»ã«å¤æãã</a></td><td>TO_DATEï¼TO_TIMESTAMP</td> --> 407 </tr> 408 <tr> 409 <td>æ±ç¨çãªå夿ãè¡ã</td><td>CASTï¼CONVERT</td> 410 <!-- <td><a href="./ctype/.html">æ±ç¨çãªå夿ãè¡ã</a></td><td>CASTï¼CONVERT</td> --> 411 </tr> 412 </table> 413 414 415 <h3 id="ddl">ãã¼ã¿å®ç¾©è¨èª (DDL)</h3> 416 <p> 417 表ããã¥ã¼ãªã©ã®ä½æãåé¤ãè¡ãããã®SQLãç´¹ä»ãã¾ãï¼GRANTãREVOKEã¯DCLã«åé¡ãã¦ããæç®ãå¤ãããã¾ããï¼æ¬ãµã¤ãã§ã¯ä¾¿å®ä¸DDLã«åé¡ãã¦ãã¾ãï¼ 418 </p> 419 420 <h4 id="database">ãã¼ã¿ãã¼ã¹</h4> 421 <table> 422 <tr> 423 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 424 </tr> 425 <tr> 426 <td>ãã¼ã¿ãã¼ã¹ã使ãã</td><td>CREATE DATABASE</td> 427 <!-- <td><a href="#">ãã¼ã¿ãã¼ã¹ã使ãã</a></td><td>CREATE DATABASE</td> --> 428 </tr> 429 <tr> 430 <td>ãã¼ã¿ãã¼ã¹ãåé¤ãã</td><td>DROP DATABASE</td> 431 <!-- <td><a href="#">ãã¼ã¿ãã¼ã¹ãåé¤ãã</a></td><td>DROP DATABASE</td> --> 432 </tr> 433 </table> 434 435 <h4 id="table">ãã¼ãã«</h4> 436 <table> 437 <tr> 438 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 439 </tr> 440 <tr> 441 <td>ãã¼ãã«ã使ãã</td><td>CREATE TABLE</td> 442 <!-- <td><a href="#">ãã¼ãã«ã使ãã</a></td><td>CREATE TABLE</td> --> 443 </tr> 444 <tr> 445 <td>ãã¼ãã«ãåé¤ãã</td><td>DROP TABLE</td> 446 <!-- <td><a href="#">ãã¼ãã«ãåé¤ãã</a></td><td>DROP TABLE</td> --> 447 </tr> 448 <tr> 449 <td>ãã¼ãã«ã®å®ç¾©ã夿´ãã</td><td>ALTER TABLE</td> 450 <!-- <td><a href="#">ãã¼ãã«ã®å®ç¾©ã夿´ãã</a></td><td>ALTER TABLE</td> --> 451 </tr> 452 <tr> 453 <td>ãã¼ãã«åã夿´ãã</td><td>RENAME TABLE</td> 454 <!-- <td><a href="#">ãã¼ãã«åã夿´ãã</a></td><td>RENAME TABLE</td> --> 455 </tr> 456 </table> 457 458 <h4 id="view">ãã¥ã¼</h4> 459 <table> 460 <tr> 461 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 462 </tr> 463 <tr> 464 <td>ãã¥ã¼ã使ãã</td><td>CREATE VIEW</td> 465 <!-- <td><a href="#">ãã¥ã¼ã使ãã</a></td><td>CREATE VIEW</td> --> 466 </tr> 467 <tr> 468 <td>ãã¥ã¼ãåé¤ãã</td><td>DROP VIEW</td> 469 <!-- <td><a href="#">ãã¥ã¼ãåé¤ãã</a></td><td>DROP VIEW</td> --> 470 </tr> 471 </table> 472 473 <h4 id="index">ã¤ã³ããã¯ã¹</h4> 474 <table> 475 <tr> 476 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 477 </tr> 478 <tr> 479 <td>ã¤ã³ããã¯ã¹ã使ãã</td><td>CREATE INDEX</td> 480 <!-- <td><a href="#">ã¤ã³ããã¯ã¹ã使ãã</a></td><td>CREATE INDEX</td> --> 481 </tr> 482 <tr> 483 <td>ã¤ã³ããã¯ã¹ãåé¤ãã</td><td>DROP INDEX</td> 484 <!-- <td><a href="#">ã¤ã³ããã¯ã¹ãåé¤ãã</a></td><td>DROP INDEX</td> --> 485 </tr> 486 </table> 487 488 <h4 id="user">ã¦ã¼ã¶ã¼</h4> 489 <table> 490 <tr> 491 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 492 </tr> 493 <tr> 494 <td>ã¦ã¼ã¶ã¼ã使ãã</td><td>CREATE USER</td> 495 <!-- <td><a href="#">ã¦ã¼ã¶ã¼ã使ãã</a></td><td>CREATE USER</td> --> 496 </tr> 497 <tr> 498 <td>ã¦ã¼ã¶ã¼ãåé¤ãã</td><td>DROP USER</td> 499 <!-- <td><a href="#">ã¦ã¼ã¶ã¼ãåé¤ãã</a></td><td>DROP USER</td> --> 500 </tr> 501 <tr> 502 <td>ã¦ã¼ã¶ã¼ã«ã¢ã¯ã»ã¹æ¨©ã追å ãã</td><td>GRANT</td> 503 <!-- <td><a href="#">ã¦ã¼ã¶ã¼ã«ã¢ã¯ã»ã¹æ¨©ã追å ãã</a></td><td>GRANT</td> --> 504 </tr> 505 <tr> 506 <td>ã¦ã¼ã¶ã¼ããã¢ã¯ã»ã¹æ¨©ãåé¤ãã</td><td>REVOKE</td> 507 <!-- <td><a href="#">ã¦ã¼ã¶ã¼ããã¢ã¯ã»ã¹æ¨©ãåé¤ãã</a></td><td>REVOKE</td> --> 508 </tr> 509 </table> 510 511 <h4 id="trigger">ããªã¬ã¼</h4> 512 <table> 513 <tr> 514 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 515 </tr> 516 <tr> 517 <td>ããªã¬ã¼ã使ãã</td><td>CREATE TRIGGER</td> 518 <!-- <td><a href="#">ããªã¬ã¼ã使ãã</a></td><td>CREATE TRIGGER</td> --> 519 </tr> 520 <tr> 521 <td>ããªã¬ã¼ãåé¤ãã</td><td>DROP TRIGGER</td> 522 <!-- <td><a href="#">ããªã¬ã¼ãåé¤ãã</a></td><td>DROP TRIGGER</td> --> 523 </tr> 524 </table> 525 526 <h3 id="dcl">ãã¼ã¿å¶å¾¡è¨èª (DCL)</h3> 527 <p> 528 ãã©ã³ã¶ã¯ã·ã§ã³ãå¶å¾¡ããSQLãç´¹ä»ãã¾ãï¼ 529 </p> 530 <table> 531 <tr> 532 <th class="col-item">é ç®</th><th class="col-sql">é¢é£SQL</th> 533 </tr> 534 <tr> 535 <td>ãã©ã³ã¶ã¯ã·ã§ã³ãéå§ãã</td><td>BEGIN TRANSACTIONï¼<br />BEGIN TRANï¼BEGIN WORK<br />START TRANSACTION</td> 536 <!-- <td><a href="#">ãã©ã³ã¶ã¯ã·ã§ã³ãéå§ãã</a></td><td>BEGIN TRANSACTIONï¼<br />BEGIN TRANï¼BEGIN WORK<br />START TRANSACTION</td> --> 537 </tr> 538 <tr> 539 <td>ãã©ã³ã¶ã¯ã·ã§ã³ã確å®ããï¼ã³ãããï¼</td><td>COMMIT</td> 540 <!-- <td><a href="#">ãã©ã³ã¶ã¯ã·ã§ã³ã確å®ããï¼ã³ãããï¼</a></td><td>COMMIT</td> --> 541 </tr> 542 <tr> 543 <td>ãã©ã³ã¶ã¯ã·ã§ã³ãåãæ¶ãï¼ãã¼ã«ããã¯ï¼</td><td>ROLLBACK</td> 544 <!-- <td><a href="#">ãã©ã³ã¶ã¯ã·ã§ã³ãåãæ¶ãï¼ãã¼ã«ããã¯ï¼</a></td><td>ROLLBACK</td> --> 545 </tr> 546 <tr> 547 <td>ã»ã¼ããã¤ã³ãã使ãã</td><td>SAVEPOINTï¼SAVE TRANSACTION</td> 548 <!-- <td><a href="#">ã»ã¼ããã¤ã³ãã使ãã</a></td><td>SAVEPOINTï¼SAVE TRANSACTION</td> --> 549 </tr> 550 </table> 551 552 <h3 id="cursor">ã«ã¼ã½ã«å®ç¾©ã»æä½</h3> 553 <p></p> 554 555 <h3>ãªã³ã¯</h3> 556 <table> 557 <tr> 558 <th class="col-site">ãµã¤ãå</th><th class="col-site-summary">æ¦è¦</th> 559 </tr> 560 <tr> 561 <td><a href="https://www.c-tipsref.com/">Cè¨èªé¢æ°è¾å ¸</a></td><td>Cè¨èªã®Tipsã¨ãªãã¡ã¬ã³ã¹é</td> 562 </tr> 563 <tr> 564 <td><a href="https://www.objectivec-iphone.com/">éå¼ãObjective-C</a></td><td>
564Objective-Cã®éå¼ããªãã¡ã¬ã³ã¹</td> 565 </tr> 566 <tr> 567 <td><a href="https://javascriptref.web.fc2.com/">JavaScript Object Reference</a></td><td>JavaScriptã®ãªãã¡ã¬ã³ã¹é</td> 568 </tr> 569 <tr> 570 <td><a href="https://www.latex-cmd.com/">LaTeXã³ãã³ãé</a></td><td>LaTeXã®ã³ãã³ãéï¼åè«ãã¬ãã¼ããªã©ã«</td> 571 </tr> 572 <tr> 573 <td><a href="https://gnuplotref.web.fc2.com/">gnuplotã³ãã³ãé</a></td><td>gnuplotã®ã³ãã³ãéï¼åè«ãã¬ãã¼ããªã©ã«</td> 574 </tr> 575 </table> 576 </div> 577 <!-- left-index end --> 578 579 <div id="right-index"> 580
580<script type="text/javascript" src="https://ad.pitta.ne.jp/ads/ed41a00fa5745988e08f2f83203031217163f029"></script>
580 581 </div> 582 <!-- right-index end --> 583 584 <div class="clr"></div> 585 </div> 586 <div class="clr"></div> 587 </div> 588 <div id="footer"> 589 <div id="footer-resize"> 590 <p class="leftt">| <a href="https://jigsaw.w3.org/css-validator/">CSS</a> | <a href="https://validator.w3.org/check?uri=referer">XHTML 1.1</a> |</p> 591 <p class="rightt">© Copyright 2010, <a href="https://www.sql-reference.com/">éå¼ãSQLæ§æé</a> - Created by <a href="mailto:[email protected]">Kojo Sugita</a></p> 592 <div class="clr"></div> 593 <div class="clr"></div> 594 </div> 595 </div> 596 </div> 597 598
598<script type="text/javascript"> 599 var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "https://www."); 600 document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); 601 </script>
601 602
602<script type="text/javascript"> 603 try { 604 var pageTracker = _gat._getTracker("UA-5663763-10"); 605 pageTracker._trackPageview(); 606 } catch(err) {}</script>
606 607 </body> 608</html>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.