Hi,
Warm Greetings!
I am using C mysql for my program In AIX and while compiling I am getting
the following error.
exec(): 0509-036 Cannot load program /az/smsbbs/bin/wittservw because of the
following errors:
0509-130 Symbol resolution failed for
On 4/23/07, Andreas Iwanowski [EMAIL PROTECTED] wrote:
Hello MySQL experts,
I am trying to create a view whose access is based on a User ID that
need to be looked up in a different table.
Here is an example of what I'm trying to do:
CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL
I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a
noticing A LOT of errors in there like the following:
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information
in file: '.\nfcamp\societies.frm'
This spans multiple databases and tables. I am using
Dear all,
I create a database called test_aaa to a user. And give him
a permission to create and drop on this database. But I found
he can create a database called test-aaa by his own. Can MySQL
identify this problem?
Also, can I limit user can only drop table in test_aaa but CAN NOT
drop
Hi Suresh,
you are showing an enormous confidence in the working of our crystal
balls - but they wear out under such stress:
suresh kumar wrote:
Hi,
Warm Greetings!
I am using C mysql for my program In AIX and while compiling I am getting the following error.
“exec():
Hi Jesse,
Jesse wrote:
I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server.
I a
noticing A LOT of errors in there like the following:
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect
information
in file: '.\nfcamp\societies.frm'
This spans multiple
Brown, Charles wrote:
Mysql Replication is not scope to one database. Rather it was intended
for the entire instance. The slave reads its master's transaction log
and applies those changes. Before it applies the changes, it will query
the master just to make sure the values are the same --
I'm trying to stop replication between two servers that I've got here. I
set it up originally, to play with it and see how it works. However, I now
want to use these two servers separately.
I have edited the my.ini file on both the server and slave machines, and
removed the server-id from
Hello Christian,
Thank you very much for this reply. It was very helpful, and the user
matching part works as it should.
Is there any way to JOIN on two tables, so I can match the Users.GroupID
field against a JOIN on Groups.ID?
Also, I tried adding a WHERE clause after the join to compare
Thanks Mike.
So let's say I have in index on each of the columns below...and I do
a search for
make=5
model=2
body_color=7
tire_type=11
hub_caps_type=1
MySQL will only pick one of them right? Let's say it picks make_index.
Then what does it do? Does it scan the entire set of results
Hello Andreas,
I tried the following statement:
CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL
SECURITY DEFINER VIEW `shared_v` AS SELECT `shared`.`ID` AS
`ID`,`shared`.`RawID` AS `RawID`,`shared`.`OwnerID` AS
`OwnerID`,`shared`.`UserID` AS `UserID`,`shared`.`GroupID` AS
Hello,
I'm having a problem when trying to update a record. I'm trying to set a
field called 'balance' to 0 but instead of 'balance' becoming 0 the
field 'name' becomes 0. None of the other columns are updated
incorrectly.
Here's the SQL statement I'm using:
UPDATE `users`
SET `name` = 'First
On Tue, Apr 24, 2007 at 10:03:58AM -0700, Chris W. Parker wrote:
UPDATE `users`
SET `name` = 'First Last'
AND `email` = '[EMAIL PROTECTED]'
AND `balance` = 0
AND `accrual` = 14400
AND `is_manager` = 1
AND `is_superadmin` = 1
AND `type` = 0
AND
On Tuesday, April 24, 2007 10:12 AM Jim Winstead mailto:[EMAIL PROTECTED]
said:
AND `type` = 0
AND `manager_id` = 0
AND `modified` = NOW()
WHERE `id` = 5
you can't use 'AND' to connect your updates, you need to use commas:
UPDATE users SET name = 'First Last', email =
Can you post your table definitions and some sample data.
Also what is the end requirement - how should the end result look like?
Anoop
On 4/23/07, Clyde Lewis [EMAIL PROTECTED] wrote:
Guys,
I have the following table that contains some information about a
cars. I'm trying to write a query
Jesse wrote:
I'm trying to stop replication between two servers that I've got here.
I set it up originally, to play with it and see how it works. However,
I now want to use these two servers separately.
I have edited the my.ini file on both the server and slave machines, and
removed the
you mill also do well to eliminate the master.nfo file from your data directory.
On 4/24/07, Gerald L. Clark [EMAIL PROTECTED] wrote:
Jesse wrote:
I'm trying to stop replication between two servers that I've got here.
I set it up originally, to play with it and see how it works. However,
I
(Read ref manual: 6.4)
Here's the best kept secret:
The Slave has two files called master. info and relay-log.info. The
slave uses these two files to keep track of how much of the master's
binary log it has processed and all pertinent info about the master( i.e
userid, password, hostname) are
What do you guys think of this approach...
Always query on all 5 columns...and then create a multicolumn index
using all 5 columns?
-James
On Apr 24, 2007, at 11:42 AM, James Tu wrote:
Thanks Mike.
So let's say I have in index on each of the columns below...and I
do a search for
Thanks,
I've removed these files. Also, there are a BUNCH of files named
webserver2-relay-bin.{some#} in the data folder. Can I delete all of
these (including the .index file)?
Thanks,
Jesse
- Original Message -
From: Brown, Charles [EMAIL PROTECTED]
To: Michael Dykman [EMAIL
Thank you for the clarification!
For some reason I believed the WHERE belonged to the specific JOIN
clause.
I came up with a clause, but I removed the Group part, for I didn't know
how to do that.
I will work on that later.
Would this statement be good SQL practice?
This one time, at band camp, [EMAIL PROTECTED] wrote:
I don't feel the implementation direction this article takes is good. It
uses single row binary storage, which anyone who has had to deal with
large files knows is a definate issue.
According to your method of storing binary data in
Hello,
I am trying to debug another application and I need to enable logging of all
queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL
installed from ports.
any Instructions, or pointers to documentation would be appreciated.
Thanks,
Ray
--
MySQL General Mailing List
For
There is a sql log that you can enable in the config file.
If you look at the config file now it will most likely only have one log file,
Look at MSQL manual and logging.
I dont have the setting infront of me at the moment.
If you cannot find give a yell.
On Wednesday 25 April 2007
I would love to see an implementation with 1 row for large data that works
well. The main issues I had were that mysql has a default max packet size
limit (I think it used to be like 16MB (mysql 3.23) - 1GB Mysql 4 - Not
sure v5. Alot of people don't have control over those settings in their
25 matches
Mail list logo