通过cmd终端向sqlite中插入多行数据的方法

czhtr

The settings we try to set lies in "system" table, so then we list all items in the table to view the current table information.

sqlite>

.dump system

BEGIN TRANSACTION;

CREATE TABLE system (_id INTEGER PRIMARY KEY AUTOINCREMENT,

name

TEXTUNIQUE ON CONFLICT REPLACE,

value

TEXT);

INSERT INTO "system" VALUES(3,'volume_system','5');

INSERT INTO "system" VALUES(4,'volume_voice','4');

INSERT INTO "system" VALUES(5,'volume_alarm','6');

INSERT INTO "system" VALUES(6,'mode_ringer','2');

INSERT INTO "system" VALUES(7,'vibrate_on','4');

INSERT INTO "system" VALUES(8,'mode_ringer_streams_affected','6');

INSERT INTO "system" VALUES(9,'mute_streams_affected','14');

INSERT INTO "system" VALUES(10,'dim_screen','1');

INSERT INTO "system" VALUES(11,'stay_on_while_plugged_in','0');

INSERT INTO "system" VALUES(12,'screen_off_timeout','60000');

INSERT INTO "system" VALUES(13,'airplane_mode_radios','cell,bluetooth,wifi');

INSERT INTO "system" VALUES(14,'airplane_mode_on','0');

INSERT INTO "system" VALUES(15,'bluetooth_on','0');

INSERT INTO "system" VALUES(16,'usb_mass_storage_enabled','1');

INSERT INTO "system" VALUES(17,'wifi_on','0');

INSERT INTO "system" VALUES(18,'wifi_networks_available_notification_on','1');

INSERT INTO "system" VALUES(19,'network_preference','1');

INSERT INTO "system" VALUES(20,'auto_time','1');

INSERT INTO "system" VALUES(21,'screen_brightness','102');

INSERT INTO "system" VALUES(23,'window_animation_scale','1');

INSERT INTO "system" VALUES(24,'transition_animation_scale','0');

INSERT INTO "system" VALUES(26,'data_roaming','0');

INSERT INTO "system" VALUES(27,'date_format','MM-dd-yyyy');

INSERT INTO "system" VALUES(30,'device_provisioned','0');

INSERT INTO "system" VALUES(31,'location_providers_allowed','gps');

INSERT INTO "system" VALUES(32,'install_non_market_apps','1');

INSERT INTO "system" VALUES(119,'ringtone','content://media/external/audio/media/11');

INSERT INTO "system" VALUES(243,'volume_music','15');

INSERT INTO "system" VALUES(244,'volume_music_last_audible','15');

INSERT INTO "system" VALUES(266,'volume_ring','7');

INSERT INTO "system" VALUES(267,'volume_ring_last_audible','7');

INSERT INTO "system" VALUES(274,'font_scale','1.0');

INSERT INTO "system" VALUES(275,'adb_enabled','0');

INSERT INTO "system" VALUES(276,'next_alarm_formatted','');

CREATE INDEX systemIndex1 ON system (name);

COMMIT;