且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用autohotkey将值插入sqlite3

更新时间:2023-02-01 08:07:35

MyName := name
myTel := telphonenumber

$sSQL := "insert into myTable Values ('" MyName "', '" myTel "');"

我更希望将电话号码也放在撇号中. 如果您没有电话号码,则没有错误:

I prefer to put the phone number also into apostrophe. if you do not have a phone number then there is no error:

insert into myTable Values ('John', '' );

正如加里所说的那样:如果数字以0或...开头." 选择电话号码
0177 ... ,稍后会给您 177 ...

and as Gary said right: "If a number begins with 0 or ... issues." the select of the telephone number
0177... will give you later 177...

***您也使用字符串作为电话号码,而不是数字格式.

better you also use a string for the phone number and not an number format.

create table myTable
(
    name TEXT
    phone TEXT
) ;