10 points Find an explanation of a simple SQL statement in ASP really simple .

I think the first thing the landlord knows is,Why:name='"+name+"', and tel="+ is not added to the back of the tel"'。

It means that there is a character after the name, so it is necessary to + connect, and there is no character after tel, so it is not used;

Another very important problem is that if tel is shaped, the shaping does not use single quotes, and if it is other types to add single quotes, it also needs a +"' to connect the single quotes, that is, it must be like this tel='"+tel+"‘。

Seeking, not seeking wealth.

Question No. 1. name='"+name+"' and tel="+tel why not name='"+name+"' and tel="+……

This is more than just what you want to ask.

You may put"+xx+"I think this is a fixed format, right? ......Hehe, that's what I thought at first.

This" "And + is not a fixed format, but simply refers to referencing the name of a variable in a script into a string (i.e., a string). In this case, the content of the variable (e.g. tel or name in the script) (i.e. number and text).

It will be added to the string when the script runs.

The above is complicated, now it's simple:

That is!

exec = I'm a written string + I'm the variable name representing a string + I'm a written string +

In other words, if the variable name is included in the quotation marks " " ", it becomes a simple character! It doesn't have the ability to become content at runtime

And then further deduce, leave it to you to think about it for yourself, I'm sure you can understand :)

Then, question No. 2.

First of all, I am not in a hurry to help you solve it, I will first tell you the meaning of what the exec contains.

In this world, there are a lot of SQL statements. (There's no end, hey!) I don't want to listen to you! ）

After the relaxation, it is time for a serious discussion.

Database (MDB), which can be linked in many ways. (i.e., there are different interfaces, languages, and methods when called externally).

We now use the Adobe way the most.

This is most commonly used in asp html and the like (I'm not a computer professional, but I use it when I make web pages).

Why? Because I think it's easy to understand and very simple.

Now I'm going to revert the select statement to you.

What it wants to convey is:

Please bring up the data I want from the guest data table. So what do I want? I want the name column in the table to have the same value as the name in the current script, and the tel column in the table to have the same value as the tel in the current script. 〗

I don't need to say anything else, hehe:)

I don't have enough time to type so many words, if you don't understand it after thinking about it, text me or hi I'll do it I will help you answer when I have time :))).

Characters need to be quoted in single quotation marks, and numbers do not need to be added. name='"+name+"' and tel="+tel+"

This tel is followed by this + or not"It's all the same.

It is related to the field type setting of the database, name should be character-based, tel look at the program, it should be numeric, and the character-type should be single-quoted, and the number should not be used.