Thanks to all, but I solved this problem by converting this field to
VARCHAR(255) (the same to TINYTEXT) type.
Chris, I tried your solution, it works but TINYTEXT's index behavior seems
to be very odd. E.g. if length is set to 3 it will never complain about
duplicate 'ab' but shows error in case
Hi
I have two tables; tbl_Headers and tbl_SubItems.
tbl_Headers contain my Header Items such as (fields: ID & HEADER)
ID HEADER
---
1.00 TOPIC ONE
2.00 TOPIC TWO
3.00 TOPIC THREE
tbl_SubItems contain Sub Header Items such as (fields: ID & SUBITEM)
ID SUBITEM
I'm not sure I understand what your asking. Order by can be used for
asc or desc (http://dev.mysql.com/doc/mysql/en/Sorting_rows.html). If
you are looking to update a column in a specific order then you are
using the correct syntax(http://dev.mysql.com/doc/mysql/en/UPDATE.html).
I hope those
Is there a trick to remember the sort order? I want
to update some field to be the ordinal of the record according
to some sort criteria.
update record set ordinal=CURRENT_ROW() order by xx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Does MySQL have commands that would allow me to convert Base64 data to
Binary and then convert that Binary to a string format?
have a look at the attached file (hope the attachment did not get
stripped). it contains some udf-functions for base64 en/de-coding. a
little description is included.
ciao,
Hi Donny,
Remember that the Date field is also indexed:
KEY `myKey` (`AccountID`,`WordID`,`Position`,`date`);
Whether it is a SELECT COUNT(*) or a SELECT locationid, it still must
evaluate the Date field, in both cases it should and does (according to
explain) use the key: myKey w/o a table-scan
Thank you very much for your help!
-Teresa
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE:
Rob,
First of all I would say, your query is pretty badly laid out. First,
unless you need every fields from a table returned only ask for those
specific fields, and do you have an index on the combination of person_id +
session_start? If not, your query will always be slow.
But this is how I wo
Greetings from Austin, TX:
What is the proper syntax for SELECT INTO OUTFILE
in a statement with a UNION keyword, like the following:
SELECT Addresses FROM editors
UNION
SELECT Addresses FROM authors
Thanks,
Lynn Bender
UnsubCentral
Secure Email List Suppre
Bryan,
Select count(*) is basically a different query then select locationid or any
of your fields. I have tables with way more than a billion rows of
information, I have some in innodb and some in myisam, and neither of them
when heavily loaded will take as long as yours is taking.
I recommend
Bryan Heitman wrote:
I am experiencing extreme slowness performing a query in which 2 rows
are returned hanging in the "sending data" status.
Performing an index only query such as SELECT COUNT(*) is extremely
quick so I know the only extra step is retrieving the data from the MYD.
I am looking
Thanks, Shawn. I didn't think count would just limit to the items being
grouped - very handy =)
-Ed
> SELECT URL, count(1) as popularity
> FROM yourtablename
> GROUP BY URL
> ORDER BY popularity DESC
> LIMIT 50;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Thursday 23 December 2004 02:01 pm, Bryan Heitman wrote:
> Hi Sergio,
>
> All of your suggestions deal with key optimization, I do not believe I have
> a key issue here. Remember that select count(*), an index-only query
> returns in .06 seconds which is very quick. The real question, is why d
Hi Sergio,
All of your suggestions deal with key optimization, I do not believe I have
a key issue here. Remember that select count(*), an index-only query
returns in .06 seconds which is very quick. The real question, is why does
it take 5 mins to retrieve the row data for these 2 rows that t
Ed,
Try the following query
select ID,
DateAdded,
URL,
count(*) as 'cnt'
from mytable
group by URL
order by cnt desc
It should display the most numerous URLs in the table.
dimitar
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]
Sent: Thursday, Decemb
Yes, this has been reported on this list a couple times already.
Really baffling how this one made it out of QA.
Josh
On Thu, 23 Dec 2004 21:43:27 +0200 (EET)
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> SQL
>
> Hello, All!
>
> IMHO this the bug in 4.1.8 to create library shared libraries
Hi Rob!
Am Don, 2004-12-23 um 18.54 schrieb Rob Keeling:
> I have a 152MB MyISAM table that I am trying to execute a simple select
> statement on,
> I need to retreave all rows with a given index, sorted by date.
>
> This is taking a very long period of time to execute.
Can you give the time
SQL
Hello, All!
IMHO this the bug in 4.1.8 to create library shared libraries without .so
suffix.
After this any programs linked with static libraries not dynamic,
because of convention lib*.so.[0-9] in shared libraries names.
ldconfig doesn't see new libraries at all too.
This bug in 4.1.8
4.1.7
In the last episode (Dec 23), Teresa A Narvaez said:
> > Dan wrote:
> > In the last episode (Dec 23), Teresa A Narvaez said:
> > > We were running mysql 3.22.30 on an Tru 64 Alpha server OSF 4.0F.
> > > We recently upgraded to mysql 3.23.58 on the same server.
> > >
> > > In the code fragment belo
To me, that error means that you ALREADY HAVE duplicates in your data. You
will have to eliminate the dupes before you can create the unique index.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Chris <[EMAIL PROTECTED]> wrote on 12/23/2004 01:55:34 PM:
> When specifying an
This will return the top 50 urls in descending order of popularity.
SELECT URL, count(1) as popularity
FROM yourtablename
GROUP BY URL
ORDER BY popularity DESC
LIMIT 50;
Feel free to adjust as needed.
HTH,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Ed Lazor" <[EMAIL P
When specifying an index for TEXT and BLOB types, you must specify a length.
as an example...
CREATE TABLE test
(
sValue TINYTEXT NOT NULL,
UNIQUE KEY(sValue(90))
)
Denis Gerasimov wrote:
Hello,
Is that possible to ensure uniqueness for a TINYTEXT field?
I tried to create an index (with UNIQUE c
I use a table to log what pages on the website are getting visits with a
table structure like this:
ID
DateAdded
URL
Now I'm trying to query the database to see which URLs are most popular, but
I'm not sure how to go about doing this. Any ideas?
Thanks,
Ed
--
MySQL General Mailing List
For
"kernel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Rob,
> Have you run "show full processlist;" to see if it is copying to a tmp
> table ??
>
> walt
Nothing listed other than the query itself. Should have said its on Mysql
3.21.
Rob Keeling
--
I love deadlines. I love the
Rob Keeling wrote:
I have a 152MB MyISAM table that I am trying to execute a simple select
statement on,
I need to retreave all rows with a given index, sorted by date.
This is taking a very long period of time to execute.
What can I do to speed up the query.
The sql is,
SELECT * FROM table WHERE
On Thu, 23 Dec 2004 11:54:30 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Yes, it should be possible to 'alias' an entire table through a view
Thank you all for your help. Of course the production server is 4.1,
but I will start immediately to test version 5
--
Ciao
Nico
--
MySQL G
Thank you for the response. I completely agree with your response. The
reason why I asked this question is because I remember seeing len(unsigned
long *lengths;) dynamically allocated in the MYSQL manual some time
ago(when I was running mysql 3.23.30). So, I wonder if there was a change
in t
On Thu, 23 Dec 2004 11:30:34 -0500, Rhino <[EMAIL PROTECTED]> wrote:
>
> It is always best if you post followup questions/remarks back to the list.
Sorry, wrong button.
--
Ciao
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
On Thu, 23 Dec 2004, Bryan Heitman wrote:
> My mistake! Here you go:
Ok, no prob :)
>
> CREATE TABLE `matrix` (
> `WordID` int(11) unsigned NOT NULL default '0',
> `LocationID` int(11) unsigned NOT NULL default '0',
> `Position` enum('Body','From','Subject','To','Mailbox','File') NOT NU
I have a 152MB MyISAM table that I am trying to execute a simple select
statement on,
I need to retreave all rows with a given index, sorted by date.
This is taking a very long period of time to execute.
What can I do to speed up the query.
The sql is,
SELECT * FROM table WHERE (person_id LIK
I know that with M$ SQL server, if a view is based on a JOIN and provides
a deterministic recordset, then the view could be updateable. But like
everything else they put out, if it's a day ending with "Y" and between 10
and 11 AM on the third odd Tuesday of the calendar season, the planets
wil
Hi,
I am trying to change my root password for mysql 4.1.7 running on Linux (as
I forgot it) using the docs found at:
HYPERLINK
"http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html"http://dev.mys
ql.com/doc/mysql/en/Resetting_permissions.html
When I get to the step:
shell> mysqladmin -
In the last episode (Dec 23), Teresa A Narvaez said:
> We were running mysql 3.22.30 on an Tru 64 Alpha server OSF 4.0F. We
> recently upgraded to mysql 3.23.58 on the same server.
>
> In the code fragment below, there is a memory leak at line 8 because
> mysql_fetch_lenghts returns an array of u
If MySQL works like DB2 - in most respects, they behave the same - a view
based on a Join is ALWAYS read-only.
Rhino
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "mysql" ; "Nico Alberti" <[EMAIL PROTECTED]>
Sent: Thursday, December 23, 2004 11:54 AM
Yes, it should be possible to 'alias' an entire table through a view
(assuming your version of MySQL has views). Views will be "updateable" so
long as none of the columns are computed. That means that a view based on
SELECT * FROM tablename should give you two options
a) you can call you
My mistake! Here you go:
CREATE TABLE `matrix` (
`WordID` int(11) unsigned NOT NULL default '0',
`LocationID` int(11) unsigned NOT NULL default '0',
`Position` enum('Body','From','Subject','To','Mailbox','File') NOT NULL
default 'Body',
`times` int(11) unsigned NOT NULL default '0',
`MyOrder
We were running mysql 3.22.30 on an Tru 64 Alpha server OSF 4.0F. We
recently upgraded to mysql 3.23.58 on the same server.
In the code fragment below, there is a memory leak at line 8 because
mysql_fetch_lenghts returns an array of unsigned long integers representing
the size of each column.
- Original Message -
From: "Nico Alberti" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Thursday, December 23, 2004 10:25 AM
Subject: Re: Tables "shortcuts"?
> On Thu, 23 Dec 2004 08:46:13 -0500, Rhino <[EMAIL PROTECTED]> wrote:
> >
>
> > I am not very clear on what you want
Jeff Smelser wrote:
Do the developers read these messages as well? If not, where should I
report the problem?
bugs.mysql.com..
Thanks. I already posted a bug report. FWIW, here is the bug tracking
URL: http://bugs.mysql.com/bug.php?id=7510.
Regards,
--
Ney André de Mello Zunino
--
MySQL General M
version: 4.0.22
This is probably documented somewhere, but I can't seem to find it. Can
someone point me in the right direction? I want a setup similar to the
following:
/var/lib/mysql/data/[databases]
/var/lib/mysql/logs/[logs] (binary, etc)
Currently, everything is in /var/lib/mysql (includ
Bryan,
Can you send the output of "show create table matrix"? You've just sent
the "location" table output, but your select command refers to a table
called "matrix".
[]s,
Sergio.
On Wed, 22 Dec 2004, Bryan Heitman wrote:
> I am experiencing extreme slowness performing a query in which 2 rows
" Because it should scan through all the table to get all records,so it
takes so a long time,i think."
Leo, see below in the Extra column, it is not doing a table scan according
to explain.
mysql> explain select locationid from matrix where accountid = 11 and wordid
= 71 and position = 'Body' a
Thanks Leo,
However, remember that the key returns quickly on index-only queries, so the
conditions in the WHERE are not my delay at this time. I want to know why
it takes 5
mins to scan 2 rows from the MYD
Bryan
- Original Message -
From: "Bryan Heitman" <[EMAIL PROTECTED]>
To: "leo" <
Hello.
Your entry in the user table doesn't have the FILE privilege enabled.
What output does the following statement produce:
show grants for 'your_dba_user'@'your_dba_host';
You can find out your username by executing 'status' command in mysql.
Have you reloaded grant tables after
Hello.
You may execute "SET FOREIGN_KEY_CHECKS=0;" in mysql and then use
"source sql.file;". Run mysql with -B command line option.
Terence <[EMAIL PROTECTED]> wrote:
> Hi,
>
> After reading the docs I realise that in order to use mysqldump with
> innodb tables i need to include
>
Hello.
>I use my.ini in MySQL install directory
On Windows, MySQL programs reads startup options from the following files:
WINDIR\my.ini
C:\my.cnf
Use --defaults-file=/path/ command line option to specify exact location
of my.ini file.
Zimoo <[EMAIL PROTECTED]> wrote:
> Hel
So -- what's the field that relates a booking to an allocation? Do they
share a project_ID or what? If they do, you might try this:
SELECT DISTINCT U.User_ID, U.User_Firstname, U.User_Lastname
FROM Users U
LEFT JOIN Allocations A
on A.User_ID = U.User_ID
LEFT JOIN Bookings B
ON B
On Wednesday 22 December 2004 12:02 pm, Philip Barlow wrote:
> I am working on a query that was built for Oracle databases but I need
> to make it compatible with MySQL. Basically I need to convert or cast an
> INT as a CHAR. The Oracle query just uses TO_CHAR() to achieve this but
> I am stumped
On Wednesday 22 December 2004 09:28 pm, Ney André de Mello Zunino wrote:
> I have just obtained that conclusive evidence. The MySQL installer is
> indeed messing up the type of the /Path/ value on the registry, changing
> it from REG_EXPAND_SZ to REG_SZ. The problem will only take place when
> you
Hello,
I was looking throught the manual a bit, I haven't found the answer
I'm looking for...
Does MySQL have commands that would allow me to convert Base64 data to
Binary and then convert that Binary to a string format?
Thanks,
--
Yves Arsenault
--
MySQL General Mailing List
For list archiv
Hi,
Thanks for your reply but that produces exactly the same result...
Any ideas?
From: Sasha Pachev <[EMAIL PROTECTED]>
To: shaun thornburgh <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Help with a join query please!
Date: Tue, 21 Dec 2004 14:57:43 -0700
shaun thornburgh wrote:
Hi,
I
Hi,
I am working on a query that was built for Oracle databases but I need
to make it compatible with MySQL. Basically I need to convert or cast an
INT as a CHAR. The Oracle query just uses TO_CHAR() to achieve this but
I am stumped in my search for an equivalent method in MySQL or even an
altern
>> That particular formula cannot handle ANY non-positive number because
>> the LOG() function is undefined for values less than or equal to zero.
>> I just reviewed the archives and realized that this point has never
>> been discussed before (I thought it had). Good catch.
well, the slow and dirty
Hi everybody.
I am rather new to MySQL (and to dba in general), so sorry for the
lame question (and for my English).
Our company is migrating several Access database to MySQL by now with
good results. This process sometimes brings to a reorganization of
some key tables that are used by many appli
Hi Jim,
Your advice is indeed correct for the access denied problem. For your own
problem, you might consider taking a look at max_allowed_packet variable of
MySQL, as this error is common when you are sending a large blob update and the
variable is too small for the update SQL, i.e. max_allo
N¬™ë,j°jËkj{ zºÞw…«k‰©oz»"¢z
‰¦ºx†jטúèDear all,
I have a mysql-4.0.12 server installed on RH 8, it works fine for months before
I
find the server unavailable from the remote host on the same LAN. I am sure
there
isn't any firewall between server and client. I ssh to the server and find th
56 matches
Mail list logo
