SELECT u.UserName, u.userID, u.lastip, u.totallogins, u.lastbrowser,
u.lastlogin, u.Password, u.person, u.entryid, u.namerep, u.countryid,
c.countryid, c.image,
c.countryid, c.country
FROM Users as u, Country as c INNER JOIN Country as cc ON
cc.countryid = u.countryid
WHERE UserName = 'angelica'
At 03:05 PM 10/23/2004, you wrote:
Hi,
I'm using mysql with php and have recently made some effort optimizing all
queries on a project and I noticed something strange and wanted to check
if this is correct.
Lets say I have a table looking like this:
CREATE TABLE `profile_visitors` (
`profile_o
Hi all,
With 3.23.38 I have:
my $sql = "LOCK tables TBUSR write, TBAUTH write, TBDATALOG write,
TBAGCY write, TBREL write, TBACCESSLOG write";
my $sth = $dbh->prepare($sql);
$sth->execute($sql) || die "Cannot lock: " . $sth->errstr();
I get:
Cannot lock: called with 1 bind variables when 0 are need
Hi all,
I am using Navicat to connect to my MySQL database. I get the following error when I
try a query even though there is only one table called Country. Why do I get this
error? Thank you for any advice
Error: 1066 Not Unique Table/Alias Country
QUERY:
SELECT users.UserName, users.u
When I'm posting a question here I usually post a simplified abstraction. This
time I have to post the full problem - and my problem is that my query takes
far too long to complete. The query is quite speedy with very small data sets,
but it slows down unacceptably with data sets of any decent si
Hi,
I'm using mysql with php and have recently made some effort optimizing
all queries on a project and I noticed something strange and wanted to
check if this is correct.
Lets say I have a table looking like this:
CREATE TABLE `profile_visitors` (
`profile_owner` int(10) unsigned NOT NULL def
Hi, Sean Leach wrote:
> my question is in the best way to sync Slave 1 and Slave 2 with Master B
> since Master A and Master B weren't completely in sync.
>
Well, obviously you need to sync the slaves to B. ;-)
I've written a Python script that does this. Holler if you want it.
NB, the script
