spss16 0Why can t I merge databases horizontally by ID number sometimes? 10

When creating a table, the ID is set to automatic, and then when pouring in, don't use the old ID, only guide the following fields, and let the ID increase automatically.

Now it is not popular to write if i mod 2 = 0 then this way, and it is easy to do it directly with div+css.

First of all, you need to use it.

For example, there are two columns: %do while not > loop.

rs("field")%

- Here width width: 60px is 1/2 of the width of the div loop

set rs = nothing

For example, there are three columns: %do while not > loop.

rs("field")%

- Here width width: 40px is 1/3 of the width of the div loop

set rs = nothing

- Arrange using div tag width.

If there are the same number of properties and the same data type, you don't need to do anything else, just import it directly, because you don't have a primary key and no error.

First, add a temporary field (with duplicate flags) in Table 2, and then set the duplicate flag to the duplicate field, so that the duplicate flag field can be used as a condition when merging.

You can write a PHP program to solve it.,Just follow what you said.。 But to know the data structure, it's best to have a test environment to guarantee that there are no errors.

Link the user table in one of the access databases to the user table in the other access database, and you can implement your function.

Steps: 1. Suppose there are two access databases, and 2. there is a user table.

3. Select the last item of the new table and connect to the user table.

4. In this way, the data synchronization of the user table of the two access data calendar chain lead libraries can be realized.

Above, I hope it will help you.

Set the CC table ID field to the auto-increment primary key.

Then: insert into cc(username,level,password)select username,level,password from aa

insert into cc(username，level，password)select username，level，password from bb

select id,username,level,password

from aa,bb;

In this way, the query result is shown in the cc table.

Just use Union All when plugging in.

insert into cc (select a union all select b)

To write specifically by myself, I only wrote one thought.

Access can be queried across databases.

For example: select [uid], [pwd] from [table] in'The full path to the database'

It can be achieved. I did.

You use cookies to authenticate your login

When logging in, use the registered user's username and password. Log in and write cookies.

That library can be a validator library.

Using the following SQL statement, run it once and then you can delete the adress2 column:

update adress set adress1=concate(adress1,adress2)