problem about merge tables in mysql

[luoya li]

Hi, all

I have two tables with full of data. Their structure is same.


Tables1

id type name
1
2
3
...


Tables2
id type name
1
2
3
4


I want to merge them into one table.

id   typename
1
2
3
4
5
6
7
...

How can I  do it?

thanks in advance.

luoya

sql,query,queries,smallint


_
MSN 8: advanced junk mail protection and 2 months FREE*. 
http://join.msn.com/?page=features/junkmail


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

help for image into database

[luoya li]

Hi, mysql

I want to put a image into mysql database,but when I run program listed 
below

%
formsize=Request.TotalBytes
formdata=Request.BinaryRead(formsize)

set rs=server.CreateObject(adodb.recordset)
strconn=driver={mysql};dbq=server.MapPath(test.mdb);uid=root;pwd=l05m;
sql=SELECT * FROM imgtable
rs.Open sql,strconn,1,3

rs.AddNew
rs(img).appendchunk formdata
rs.Update
rs.Close
%

the system says:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC Drivers can't support this attribute
/upload.asp, line 7


I want to know what is the problem.
I have the  Mysql 3.23.52-max-nt, ODBC2.50, windows XP and ASP.

Can anyone help?

Regards,
luoya


_
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

can't connect to remote host

[luoya li]

Hi,
I just  install mysql 3.23.52-max-nt on two computers. One is Win2K and 
another is winXP. It seems  all right. I  use the following commands on 
both.
C:\mysql\binmysql ¨Chlocalhost ¨Curoot ¨Cp
Mysql prompt:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 3.23.52-max-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Mysql

But when I use following commands to connect remotely from winXP to win2K.
C:\mysql\binmysql ¨Ch202.112.224.1 ¨Curoot  ¨Cp
(202.112.202.1 is IP of Win2K.)
Mysql prompt:
ERROR 2003: Can't connect to MySQL server on '202.112.224.1' (10060)
Win2K and winXP all be connected to internet.

Can anyone help?

Thanks.
Alice


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Access denied for user

[luoya li]

Hi,
I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like  to set a password for root 
so I  use the following commands:

mysql use mysql
Database changed
mysql update user set password=password('l05m')
- where host='localhost' and user='root';
Query OK, 1 row affected (0.00 sec)

Mysql prompt a password be set. So I  use the following commands to reload 
system parameters:

C:\mysql\binmysqladmin reload

But mysql shows:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'

then I use the new password to start mysql.

C:\mysql\binmysql -hlocalhost -uroot -p
Enter password: 

mysql shows:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

Does anybody give help for me?

Thanks for any suggestions,


Alice


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Access denied for user

[luoya li]

Hi
I just installed a mysql 3.23.52. I want to set a password for root. But 
when I execute :

C:\mysql\bin\mysqladmin -u root password aaa

system remind:
mysqladmin:connect to server at 'localhost' failed
error: Access denied for user:'root@localhost'(using password:No)

Please tell me why?

thanks for any help.

Alice



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php