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