I may have asked this before, at least to some degree.
Anyway I'd like to clarify.
I have two entities that need a 1:1 relationship.
Table1(Innodb)Table2(myISAM)
PostID (int) (auto inc) PostID (int)
DateEntered (timestamp) VendorID (int)
ReferenceID
Hi,
Is this possible to set a timeout value for mysql_query() call?
Regards,
- Joe
GRANT usage on samp.* to 'permtest'@'localhost' identified by 'password';
GRANT insert, update, delete on samp.secrettable to
'permtest'@'localhost';
GRANT select, insert, update, delete on samp.Account to
'permtest'@'localhost';
This worked much better for me, though it's not a perfect
Hi,
I know what the deal is supposed to be but can't seem
to fix it.
Two tables, VendorID exists in both tables (neither
are primary keys)
I'm getting a VendorID in where clause is ambiguous
Sometimes it actually processes the SQL weird.
I think this is because same column name in both
I think that INSERT-only would be as good as we could hope for as I have
been having a very hard time trying to think of a valid business reason
why a user would be allowed to either UPDATE or DELETE rows from a table
where they weren't allowed to even see the data. However I can think of
Hi,
I know what the deal is supposed to be but can't seem
to fix it.
Two tables, VendorID exists in both tables (neither
are primary keys)
I'm getting a VendorID in where clause is ambiguous
Sometimes it actually processes the SQL weird.
I think this is because same column name in both
Try specifying the source tables more explicitly in your SELECT statement.
SELECT table_a.VendorJobs opt_a
, table_b.VendorJobs opt_b
...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You have to say which table's VendorID column you want to evaluate your
WHERE clause against (just as the error message says). Try this
WHERE
(VendorJobs.`VendorID` = 13)
As a shortcut , and to keep you from getting typist's cramp, you only
_need_ to specify the table name for columns that
Hi Per,
Thank you for the additional information. It helps me understand your
situation a lot better. Unfortunately, it also raises more questions ;-)
My first comment is that you really ought to have a primary key on your
table. From the sound of it, you are new to MySQL at least and possibly
On Monday 30 August 2004 4:08 pm, [EMAIL PROTECTED] wrote:
I think that INSERT-only would be as good as we could hope for as I have
been having a very hard time trying to think of a valid business reason
why a user would be allowed to either UPDATE or DELETE rows from a table
where they
Typist's cramp ? Can you say visual query builder.
;)
Stuart
--- [EMAIL PROTECTED] wrote:
You have to say which table's VendorID column you
want to evaluate your
WHERE clause against (just as the error message
says). Try this
WHERE
(VendorJobs.`VendorID` = 13)
As a shortcut , and
Thinking about this some more, it might be possible to achieve what my last
email suggests by allowing select on the primary key column. Or would that
set us back again? Thoughts?
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Could one of you send me an invite to gmail?
I screwed mine up by admitting I sold some on ebay.
As soon as I did that I stopped getting any mail.
You may recall me as [EMAIL PROTECTED]
Thanks!
R. Whitney
Transcend Development
Producing the next phase of your internet presence
http://xend.net
Slightly off the main topic:
The point about retaining the data from abandoned carts is a very good one.
The idea of per-user discount based on a previous 'almost purchase' makes me
feel a little uncomfortable though.
Perhaps if more than one particular item appeared in (let's say) 10 shoppers
Sorry to reply yet again, but I think I have the solution. After doing all we
have said above I added
grant select(ID_Num) on sampdb.secrettable to 'user'@'localhost' identified by
'password';
and of course updates and deletes are done via
update secrettable set secretinfo=blah where
Yes, I think that _may_ solve your problem. Try granting only INSERT and
UPDATE on the table then grant only SELECT permission on the ID column (I
assume it's autoincrementing?) and the user_id column. If you don't make
the user_id column visible, how will you ever discover the correct ID to
- Original Message -
From: Kapoor, Nishikant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 30, 2004 2:41 PM
Subject: very simple query but strange results
This little sql has me puzzled. Would appreciate your help.
mysql drop table if exists T;
Query OK, 0 rows affected
Rhino wrote:
- Original Message -
From: Kapoor, Nishikant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 30, 2004 2:41 PM
Subject: very simple query but strange results
This little sql has me puzzled. Would appreciate your help.
mysql drop table if exists T;
Query OK, 0
I skimmed the whole article twice, including the user comments, and still
missed that :-(
Thanks for catching that Michael! That explanation makes a lot of sense, a
lot more sense than forcing there to be at least two columns in the
fulltext() column.
Rhino
- Original Message -
From:
Hi -
I'm new to this list and I didn't see a FAQ (I apologize if I missed it somewhere).
How do I set MySQL's logging level? And, where are MySQL's logs (i.e. is there
anything in addition to /var/lib/host.err)?
Thanks!
Gary
--
MySQL General Mailing List
For list archives:
At 17:42 -0600 8/30/04, Newell, Gary wrote:
Hi -
I'm new to this list and I didn't see a FAQ (I apologize if I missed
it somewhere).
How do I set MySQL's logging level? And, where are MySQL's logs
(i.e. is there anything in addition to /var/lib/host.err)?
The logs are discussed in the
I'm trying to teach my students how to use MySQL, and have installed it
on all the lab machines along with Cygwin. Originally, I had the
permissions set wrong and my students couldn't start the server, but I
fixed that, and now mysqld works fine.
Unfortunately, if you then mysql -u root, after a
I have posted this in a subject called - InnoDB table
creation. I am just trying to be specific. Please
forgive me if this is not allowed.
I have searched the online help and this site. I can
not find out why I am getting this error:
ERROR 1005 at line 33: Can't creat table
Todd,
I don't use Windows XP as a production machine, but I do run MySQL on my
personal machine running Windows XP, I run the Windows version of MySQL. Is
there any reason that you are using Cygwin to run MySQL when you can run the
MySQL windows binaries without any problems? The only thing I
The problem is in table SECTIONS. From the manual, In the referencing
table, there must be an index where the foreign key columns are listed as
the first columns in the same order. In the referenced table, there must be
an index where the referenced columns are listed as the first columns in
[EMAIL PROTECTED] wrote:
I was blocked from running a SELECT query against secrettable. I could
INSERT values but not DELETE them. I reason that this is because DELETE
... WHERE ... requires a SELECT to be run on the table to identify the
rows to get rid of. The error I got when trying to
Hello,
Not sure this is possible to do with SQL or if needs to be done with in the
application programming language we're using(Perl), but I need to get the a
weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to do, is if the query above is greater or less then
Thank you very much. I really appreciate your analogy to the waterfall.
This helped me out tremendously. I was able to sort out the problem and
all is now well! It appears that this wonderful little GUI tool the
lets you create ER diagrams that auto-generate CREATE scripts assumes
that you
Mike Blezien wrote:
Hello,
Not sure this is possible to do with SQL or if needs to be done with in
the application programming language we're using(Perl), but I need to
get the a weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to do, is if the query above is
Can anyone help me optimise the way I do this?
I have two tables, 'article' and 'user'. Article has a user_id which
related to the user table.
When selecting all articles from the the article table, I'd like to be
able to get the username of the user_id. Currently I'm doing this as a
30 matches
Mail list logo