2,187
edits
m (→Data Types: Added SyntaxHighlight) |
|||
Line 36: | Line 36: | ||
To set a field to NULL, use NULL without any quotes eg... | To set a field to NULL, use NULL without any quotes eg... | ||
<source lang="mysql"> | |||
INSERT INTO table (col1, col2) VALUES ('data1', NULL); | |||
</source> | |||
=== IP Addresses === | === IP Addresses === | ||
IP addresses are most efficiently stored as an UNSIGNED INT, though obviously this isn't particularly human readable. | IP addresses are most efficiently stored as an UNSIGNED INT, though obviously this isn't particularly human readable. | ||
MySQL will do the conversion between INT and dotted quad using the INET_ATON and INET_NTOA functions. For example; | MySQL will do the conversion between INT and dotted quad using the INET_ATON and INET_NTOA functions. For example; | ||
<source lang="mysql"> | |||
SELECT INET_NTOA(ip) from ips; | |||
INSERT INTO ips SET ip=INET_ATON('10.1.2.3'); | |||
</source> | |||
Alternatively, use VARCHAR(15) to store as text. | Alternatively, use VARCHAR(15) to store as text. | ||
== Insert / Update Rows == | == Insert / Update Rows == |