Hi,
A few days ago i posted a quaestion about performace, I now have a
little more info, hopefully someone can help.
I have a table, tblShoppingCart with 3 fields,
cartUid (int 11 auto increment)
userUid (int 11, indexed)
strCartHash (varchar 32)
The table is innodb
Nomally my server load i
At 21:24 -0600 7/14/05, Warren Young wrote:
When you have a stored procedure that returns a result set, it seems
that the server returns its results the same way as with a
multi-query. As a result, if you don't set the multi-query option
when setting up the connection with the C API, the serve
I've got some years-old MySQL databases mostly in 4.0, but one server
running 3.23 that are all using the default encoding.
I want to update all their data to 4.1 with UTF-8 encoding.
Anyone done this kind of dump-and-update?Any advice to share or
good URLs you've seen with others' advice abo
When you have a stored procedure that returns a result set, it seems
that the server returns its results the same way as with a multi-query.
As a result, if you don't set the multi-query option when setting up
the connection with the C API, the server refuses to return the result
set. You get
I can successfully LOAD a UDF in mysql-4.1.10, but I can't DROP it.
MySQL reports that the DROP FUNCTION was OK, but the function still
shows up in the mysql.func table. The function no longer works, but I
have to TRUNCATE the mysql.func table in order to be able to LOAD it
again. I am doing this
on 7/14/05 3:54 PM, Sebastian at [EMAIL PROTECTED] wrote:
> i have a text field column and i want to select the rows based on the
> first letter in this column, eg:
SELECT field from table WHERE field LIKE 'M%'
--
-
Scott Haneda
i have a text field column and i want to select the rows based on the
first letter in this column, eg:
-
| topics |
-
Motherboard
Hard Drives
Memory
Video Cards
Monitors
i want to select all the rows that begin with the letter M (Motherboard,
Memory, Monitors)
any suggestions?
Hi,
MySQL 5.0.9-beta, a new version of the popular Open Source Database
Management System, has been released. It includes support for
Stored Procedures, Triggers, Views and many other new enhancements.
The Community Edition is now available in source and binary form for a
number of platforms from
Here is the startup script:
#!/bin/sh
#
# /Library/StartupItems/MySQLCOM/MySQLCOM
#
# A script to automatically start up MySQL on system bootup
# for Mac OS X. This is actually just a wrapper script around
# the standard mysql.server init script, which is included in
# the binary distribution.
#
#
Michael Stassen wrote:
Danny Stolle wrote:
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): A
Tried that. I get the following:
Oliver:~/Research/Right Whale chris$ mysql mysql -u root -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
On 7/14/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
>
> What does
>
> show grants for 'chris'@'localhost';
>
>
> reports when you're logged as root?
>
I get the following:
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD '3446cb892d3dffdd' WIT
Hello.
What does
show grants for 'chris'@'localhost';
reports when you're logged as root?
Chris Fonnesbeck <[EMAIL PROTECTED]> wrote:
> I have mysql 4.1.12 installed on OSX 10.4, and have run into the
> curious problem that mysql forgets my user password (but not my root
> p
Mark Leith wrote:
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Something like
ORDER BY IF(col IS NULL, 1, 0), col
Michael
Or simply:
ORDER BY col IS NULL, col
Which will probably be *slightly* faster..
Good point.
Михаил Монашёв wrote:
> Hello
>
> MS> Something like
>
> MS>O
Roberto,
>The problem came when I want to show all computers and I g oto
>the id 1 for show all and any product have stored this CAT_ID,
>because all have the last “subcategory” id.
You've coded tree-like relationships between 'cat_id' and 'relation' in
your categories table, but raw SQL doe
the version is 4.1.12.
show variables like this,
| character_set_client|
latin1
| character_set_connection|
latin1
| character_set_database |
latin1
| character_se
Danny Stolle wrote:
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user 'c
Hello.
> it be "optimal" to use primary key + non-unique key combination to narrow
> down the search?
According to:
http://dev.mysql.com/doc/mysql/en/mysql-indexes.html
"Suppose that you issue the following SELECT statement:
mysql> SELECT * FROM tbl_name WHERE col1=val1 AND col2=va
Hello.
This weird behavior is very similar to described at:
http://bugs.mysql.com/bug.php?id=7361
Nico Alberti <[EMAIL PROTECTED]> wrote:
> Hi everybody.
>
> During the migration of our mysql test server to version 5 I noticed a
> problem when I tried to import a table that I dumped
Thanks for your reply. Should we move this discussion to
[EMAIL PROTECTED]
> Also, notice that unless your application is under _extreme_ load,
none
> of these SET queries will are likely to have an impact on the
> performance of your application.
I was hoping someone would reply saying that SET
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (usin
Dan,
Hi, I remember reading about an SQL query type which did something like
select all 'aircraft hangers' which contained exactly (or at least) some
given set of aircraft.
Or did it select the list of pilots qualified to fly all the airplanes in
the hanger...
Anyway, I forget the syntax (and
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (using
password: YES)
Yet, whe
wow thanks ! this i can do. was just downloading python for windows,
will still keep it, may be usefull one day, but i would lot rather
update via access.
thanks again.
nephish <><
On Thu, 2005-07-14 at 09:18 -0400, [EMAIL PROTECTED] wrote:
> If you have your native, auto-updated table in MS Acces
Hi, I remember reading about an SQL query type which did something like
select all 'aircraft hangers' which contained exactly (or at least) some
given set of aircraft.
Or did it select the list of pilots qualified to fly all the airplanes in
the hanger...
Anyway, I forget the syntax (and the fa
Joerg Bruehe <[EMAIL PROTECTED]> wrote on 07/14/2005 09:35:50 AM:
> Hi!
>
> Jochem van Dieten wrote:
> > On 7/14/05, Joerg Bruehe wrote:
> >
> >>
> >>However, the online manual is not cloned, so while we are building
5.0.9
> >>there can also be new text for 5.0.10 changes that gets integrated
Hi!
Sujay Koduri wrote (in personal mail):
Hi jorg,
DO you have any idea when MySQL 5.0 is going to get into production.
Sujay, please
1) mail such questions to the list, not just to me personally
2) do not post above a full quote, it wastes readers' time, bandwidth,
and disk space.
Re
What if:
Mysqldump TABLE --where="id<@middle" >> first_part.sql
Mysqldump TABLE --where="id>[EMAIL PROTECTED]" >> second_part.sql
@middle can be calculated in another place
And then:
You will need to edit each file to change table name
:: ISC Edwin Cruz Garcia ::
IT Factory Systems - Systems
Manoj <[EMAIL PROTECTED]> wrote on 07/14/2005 06:09:24 AM:
> Greetings,
> I am trying to get a feel of how MySQL would handle certain types of
> situation, mainly concerning the usage of indices.
>
> Say I have two exactly identical table structures namely table A &
B.
>
> For table
Hi!
Jochem van Dieten wrote:
On 7/14/05, Joerg Bruehe wrote:
However, the online manual is not cloned, so while we are building 5.0.9
there can also be new text for 5.0.10 changes that gets integrated into
the online manual, and this may become visible earlier than 5.0.9 gets
published.
Wh
If you have your native, auto-updated table in MS Access and a different
Linked table pointing to the MySQL copy of it in the same database, just
build an Access query that will INSERT or UPDATE (as appropriate) your
linked table with data from your native table. No scripting required,
just th
On 7/14/05, Joerg Bruehe wrote:
> Rick Robinson wrote:
>
> However, the online manual is not cloned, so while we are building 5.0.9
> there can also be new text for 5.0.10 changes that gets integrated into
> the online manual, and this may become visible earlier than 5.0.9 gets
> published.
Why a
Hey thanks for the link, yep, i guess i am going to have to write
something up in python. (or maybe be lucky enough to find something i
can modify from hotscripts :) .
i may check out that piece called Navicat. saw some reviews of it and it
may have what i need also.
thanks again
nephish <><
On
Hi Rick, all!
Rick Robinson wrote:
Just a question on upcoming MySQL 5.0.x releases...what the heck is going on? I
see doc notes for 5.0.8, 5.0.9, and 5.0.10 all concurrently. Is the plan to
merge all these together for a single 5.0.10 release? Or will there be a 5.0.11
that merges all these
Hi everybody.
During the migration of our mysql test server to version 5 I noticed a
problem when I tried to import a table that I dumped from our 4.1
production machine.
The table has some fields defined as float(31,30) (they came from an
old Access table converted with DBTools Manager). When I
Greetings,
I am trying to get a feel of how MySQL would handle certain types of
situation, mainly concerning the usage of indices.
Say I have two exactly identical table structures namely table A & B.
For table A, I just have one composite primary key on (Code, Date1 &
Date2).
Fo
Greetings,
I am trying to get a feel of how MySQL would handle certain types of
situation, mainly concerning the usage of indices.
Say I have two exactly identical table structures namely table A & B.
For table A, I just have one composite primary key on (Code, Date1 &
Date2).
Fo
The original message was received at Thu, 14 Jul 2005 11:44:49 +0300
from [34.202.52.137]
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Hi List,
I belive version 5 does not allow me to grant access to execute
procedures, but deny updates to tables directly? I am attempting to
ensure that
all data modification is done through procedures. Any tips or ideas when
this will be available or work-arounds?
Thanks,
Terence
--
MySQL
Just a question on upcoming MySQL 5.0.x releases...what the heck is going on? I
see doc notes for 5.0.8, 5.0.9, and 5.0.10 all concurrently. Is the plan to
merge all these together for a single 5.0.10 release? Or will there be a 5.0.11
that merges all these?
Just curious, as it seems that this
Hi ,
We are a company specialized in developing tools for Internet Marketing domain.
We are developing a product for which we need consultancy services from
professionals speacilized in Mysql server optimization and tuning.
Adequate financial remuneration will not be problem for effective soluti
41 matches
Mail list logo
