mysql question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

mysql question

mysql question# Database - 数据库

b*e2002-08-08 07:08

1 楼

newbie question to mysql.. i installed mysql on my w2k, and copied the entire
data folder from another user's installation (hoping to replicate his database
and tables and data)
but then when i tried to run mysql.exe it's giving me this error:
ERROR 1045: Access denied for user: '[email protected]' (Using password: NO)
then i tried mysql.exe -D dbname -u username
it still gives me the same error:
ERROR 1045: Access denied for user: '[email protected]' (Using password: NO)
how do i get it to take pas

a*m2002-08-08 07:08

2 楼

mysql:
how to select field from a table, and the field not in another table's
field?
select * from table1 where table1.field not in (select field from table2)
but mysql does not support not in (sub-select)
i know i can use "join", but it really takes time.
thanks a lot.

g*n2002-08-08 07:08

3 楼

The performance of using LEFT JOIN won't be worse

【在 a****m 的大作中提到】

: mysql:
: how to select field from a table, and the field not in another table's
: field?
: select * from table1 where table1.field not in (select field from table2)
: but mysql does not support not in (sub-select)
: i know i can use "join", but it really takes time.
: thanks a lot.