problem about merge tables in mysql

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,sm

help for image into database

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="SELE

help for put image into mysql

Hi, I want to put a image into mysql,but when I run program listed below <% formsize=Request.TotalBytes formdata=Request.BinaryRead(formsize) Dim mycon set mycon=server.createobject("adodb.Connection") mycon.mode=adModeReadWrite mycon.connectionString="DSN=ez;UID=aa;PWD=bb" mycon.open "e

can't connect to remote host

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\bin>mysql ¨Chlocalhost ¨Curoot ¨Cp Mysql prompt: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id

Access denied for user

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

Access denied for user

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