Thomas,
- Original Message -
From: "Thomas Gusenleitner" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 9:24 AM
Subject: Re: mysql 4.0.15 and latest redhat enterprise AS Beta - segmention
fault
> Heikki,
>
> thanks for the information, i use th
I've got a somewhat advanced mysql administration question for y'all.
Here's my situation:
I've got a master database that is doing lots of inserts, deletes, and
updates. It has a number of slaves hanging off of it. One of those
slaves is completely unloaded - so it keeps very close track of
I guess that's because you don't have the privilege to create a database.
Make sure you're using the *right* account to create the database.
cheers,
feng
- Original Message -
From: "ddonahoe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 4:17 PM
Subject: New
When I type the command:
CREATE DATABASE testing;
I get a 1044 access denied error, stating that access is denied for user
'[EMAIL PROTECTED]' to database 'testing'
Why cant i create a database? I made one before, so why not now?
thanks,
dan
--
MySQL General Mailing List
For list archives:
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Thomas Gusenleitner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, October 04, 2003 11:58 PM
Subject: Re: mysql 4.0.15 and latest redhat enterprise AS Beta - segmention
fault
> At 12:01 +0200 10/3/03, Thomas Gu
Hi all,
Having a slight problem with mysql select query right here.
I've learnt that if I were to select a particular data within the last 30 days,
this is what my select query should be like:
SELECT something FROM tablename
WHERE TO_DAYS(NOW(()_TO_DAYS(date_column)<=30;
(This query sel
Jeff,
Your name is familiar to me. Are you involved in any way with the Borland C++
Builders
list on Topica.com?
OK, that explains why I can't find the feature. I consider them to be important, but
not
mandatory. Their presence can simplfy business rules in data processing.
regards
greg
Thanks Paul.
Fully understand!!
cheers,
feng
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 4:38 AM
Subject: Re: mysql account
> At 14:00 +1000 10/5/03, Wang Feng wrote:
> > > If
Information from the manual:
1.7.4.4 Stored Procedures and Triggers
Stored procedures are being implemented in our version 5.0 development
tree. See section 2.3.4 Installing from the Development Source Tree .
This effort is based on SQL-99, which has a basic synt
Hi All,
I am looking into putting triggers, procedures and into MySQL.
The tools I am using seem to lack this facility, unless MySQL doesnot actually have
these important database features.
Any help is appreciated.
Gregory Hicks
Database Analyst Programmer
--
MySQL General Mailing List
For
Warren:
Yes and no. You can use Access as a "front end" to MySQL, including
creating forms and queries. If you want relational integrity you'll need to
handle that directly in MySQL (with "raw" SQL) or with a dedicated MySQL
designer tool (there are several available, both freeware and commercia
Hi guys n gals
OK MySQL is nice and robust, i'm stiil new to it and have an "M$ Access" mentality
when it come to buiding and working with DBs.
Can i build an "example_client" table and an "example_appointment" table in MySQL and
then use M$ Access(odbc) or "data sources" in Open Office to crea
The SQL specification does allow aggregates in the
ORDER BY. Does mySQL have any plans to add such
functionality (or at least add it to its list of
things it doesn't do)? The problem with the solution
of ordering by an alias is that I may not necessarily
want the thing I'm ordering by to be in th
Any mysql encryption functions would be done server side ofcourse before
putting it into the database.. I'd just incorporate an de/encryption
scheme into your client app, and insert as standard BLOB string to remote
server.
On Sat, 4 Oct 2003, sian_choon wrote:
> Hi,
> I have the question rel
Might instead want to look at
where fooid in (xx, xx, xx, xx)
On Sat, 4 Oct 2003, Marc Slemko wrote:
> If I do a query such as:
>
> SELECT * from foo where fooid = 10 or fooid = 20 or fooid = 03 ...
>
> with a total of around 1900 "or fooid =" parts on a given table with 500k
> rows, it takes
Hi,
- Original Message -
From: "Marc Slemko"
Sent: Sunday, October 05, 2003 2:27 PM
Subject: Re: slow performance with large "or" list in where
> On Sun, 5 Oct 2003, Santino wrote:
>
> > Have You test in operator?
> >
> > select * from table where id in (10,20,30,50,60,90, )
>
> Yes,
Just got back onto this again now.
To quote the docs you pointed me at:
If MySQL crashes in the middle of an ALTER TABLE operation, you may end
up with an orphaned temporary table inside the InnoDB tablespace. With
innodb_table_monitor you see a table whose name is #sql..., but sin
Check out safari.oreilly.com, they have a two week trial right now, and they
have a sh*tload of books online, including 'MySQL Cookbook' by Paul Dubois,
and they also have 'MySQL' and 'MySQL and Perl for the Web' by Paul also,
I would say they are probably the best MySQL books I've found,
I als
On Sun, 5 Oct 2003, Santino wrote:
> Have You test in operator?
>
> select * from table where id in (10,20,30,50,60,90, )
Yes, IN does perform at the levels I want and works for the simplified
example I gave, but doesn't work for the generalized case I need,
which is matching individual rows
Does anyone have a recommendation for a good SQL cookbook? I can do
some basic selects, updates and deletes but I'm not comfortable with
some of the logic involved in joins or the proper use of group by,
etc. In addition, though a full exposition on the SQL "language"
might
be instructive, right no
At 18:47 +1000 10/5/03, Wang Feng wrote:
Greetings,
I'm so curious about this:
If a new MySQL database account need to be created, do you insert the
account info to the *user* table of the *mysql* database OR do you grant the
new account by the GRANT query? What are the differences andn which one
Have You test in operator?
select * from table where id in (10,20,30,50,60,90, )
Santino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 14:00 +1000 10/5/03, Wang Feng wrote:
> If you deleted the rows with a DELETE statement, you'll need to also
issue a FLUSH PRIVILEGES statement to cause the server to reread the
grant tables.
In order to try the FLUSH PRIVILEGES statement, I inserted a new user
account into the 'user' table o
On Sun, 5 Oct 2003, Alexis da Cruz Henriques Guia wrote:
>
> Your problem is that MySQL don't use indeces in selects with 'or' (See MySQL
> manual).
If you are referring to:
http://www.mysql.com/doc/en/Searching_on_two_keys.html
then that page doesn't say mysql doesn't use indexes on se
hello,
i spent about 2 hours solve this problem, i have got a 2 mysql tables,
eg:
data
room_id
user_id
user_typ
user_login
messages
id
text
from
from_type (quest, user)
to
to_type (quest, user)
itime (type datetime, time when message were insert)
and my situation:
data
1 1 ujoe
1 2
Your problem is that MySQL don't use indeces in selects with 'or' (See MySQL
manual).
But i didn't have understand what's your problem executing individual
selects...
You don't need to open parallel connections. Put the UPDATE commands in a file,
and execute them in mysql prompt like this:
mysql>
Title: Message
capital ÅÄÖ and ь (cyrillic soft-sign).
>Description:
The UTF-8 encoding for capital swedish characters ae aa and oe doesn't work. Some
cyrillic
characters doesn't work either. A lot of other utf-encoded characters work so the
settings
are not wrong.
It seems like mysql looses some information when it stores these characters.
At first
Greetings,
I'm so curious about this:
If a new MySQL database account need to be created, do you insert the
account info to the *user* table of the *mysql* database OR do you grant the
new account by the GRANT query? What are the differences andn which one do
you prefer?
(I got some trouble whe
Thomas,
the current mysqld-standard does not work with the Red Hat AS beta (Taroon).
We are looking into solving this issue. The problem seems to be connected to
statical linking.
You can try mysqld-max, as it is dynamically linked.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
F
30 matches
Mail list logo
