更新时间: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
) ;