Table creation/Postal addresses: Difference between revisions
no edit summary
No edit summary |
|||
Line 1,066:
zip --> 20500
----------------------------------------</pre>
=={{header|Ring}}==
<lang ring>
# Project : Table creation/Postal addresses
# Date : 2018/04/19
# Author : Gal Zsolt (~ CalmoSoft ~)
# Email : <calmosoft@gmail.com>
load "stdlib.ring"
oSQLite = sqlite_init()
sqlite_open(oSQLite,"mytest.db")
sql = "CREATE TABLE A(" +
"addrID INT NOT NULL," +
"street CHAR(50) NOT NULL," +
"city CHAR(25) NOT NULL," +
"state CHAR(2), NOT NULL" +
"zip CHAR(20) NOT NULL);"
sqlite_execute(oSQLite,sql)
</lang>
=={{header|Ruby}}==
| |||