2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→Select Rows: Added "AS"
m (Added "Select Rows") |
m (→Select Rows: Added "AS") |
||
| Line 83: | Line 83: | ||
== | == SELECT Rows == | ||
''' | '''AS''' | ||
<source lang="mysql"> SELECT INET_NTOA(ip) AS ip, name FROM hosts; </source> | |||
<br>'''JOIN'''<br> | |||
<source lang="mysql">SELECT make, model FROM table JOIN hosts ON table.id=hosts.id WHERE hosts.ip=INET_ATON('10.10.255.253');</source> | <source lang="mysql">SELECT make, model FROM table JOIN hosts ON table.id=hosts.id WHERE hosts.ip=INET_ATON('10.10.255.253');</source> | ||
== Software Packages == | == Software Packages == | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||