正在加载图片...
Example SQL Syntax Android CREATE TABLE CUSTOMERS( void execSQL( CREATE TABLE CUS TOMERS( 工DTNT NOT NULL 工DNT NOT NULL NAME VARCHAR(20) NOT NULL, NAME VARCHAR(20) NOT NULL AGE INT NOT NULL, AGE INT NOT NULL ADDRESS CHAR (25) ADDRESS CHAR(25), SALARY DECIMAL(18, 2), SALARY DECIMAL (18, 2), PRIMARY KEY (ID) PRIMARY KEY (ID) Field Null Key Default Extra I ---------+ int (11) PRI NAME varchar(20) AGE int(11 N ADDRESS char(25) YES ULL SALARY decimal(18, 2)YES 35Example 35 CREATE TABLE CUSTOMERS( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , SALARY DECIMAL (18, 2), PRIMARY KEY (ID) ); +---------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------+------+-----+---------+-------+ | ID | int(11) | NO | PRI | | | | NAME | varchar(20) | NO | | | | | AGE | int(11) | NO | | | | | ADDRESS | char(25) | YES | | NULL | | | SALARY | decimal(18,2) | YES | | NULL | | +---------+---------------+------+-----+---------+-------+ void execSQL(“ CREATE TABLE CUSTOMERS( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , SALARY DECIMAL (18, 2), PRIMARY KEY (ID) )”): SQL Syntax: Android:
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有