On Fri, 8 Apr 2005, Brent Baisley wrote:
> I may have been reaching a little on the dynamic sorting since some of
> what I had in mind entails adding more data to the categories. But at a
I see. Thank you.
> minimum, you would be able to sort ascending or descending and possibly
> use an ind
At 17:15 -0400 4/8/05, Paul Beer wrote:
I'm trying to pass a value into a stored procedure to dynamically set
which column(s) to sort by. The following code doesn't work.
The query executes but ignores my order by parameter.
I assume there is a simple answer to this that I'm just missing.
Yes. Un
Greetings,
I wanted to see if anyone else has found this problematic, or if
I just missed something. I upgraded from 5.0.2 to 5.0.3-beta on my Red
Hat AS3 platform. It appears everything was fine till I went to execute
my stored procedures, which were owned by root at the console, since
th
On Fri, 8 Apr 2005 [EMAIL PROTECTED] wrote:
>Dan Bolser <[EMAIL PROTECTED]> wrote on 04/08/2005 12:41:35 PM:
>
>> On Thu, 7 Apr 2005, Sean Nolan wrote:
>>
>> >I think you'll find you can do what you want with a cross join. A cross
>join
>> >will join every row from the first table with every ro
Yes I received the same email about being a spammer.
Somebody on the list told me that our email headers get rewritten and
sometimes you get this email about being a spammer.
Laurie
At 02:29 PM 4/8/2005, Keith Ivey wrote:
[EMAIL PROTECTED] wrote:
This is what I call WAY OVER REACTING.
*This membe
[EMAIL PROTECTED] wrote:
This is what I call WAY OVER REACTING.
*This member turned my email into the spam report immediately without
thinking. Now I am recieving these.*
I doubt that there's any connection. It's impossible to tell
for sure, but the message was probably rejected because of th
I'm trying to pass a value into a stored procedure to dynamically set
which column(s) to sort by. The following code doesn't work.
The query executes but ignores my order by parameter.
I assume there is a simple answer to this that I'm just missing.
create procedure sp_equipment_find (
IN L_ORDER
This is what I call WAY OVER
REACTING.
This member turned
my email into the spam report immediately without thinking. Now I am
recieving these.
ThanksDonny LairsonPresident29
GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183
-Original Message-From: [EM
Chuzo,
SELECT MAX(LENGTH(...)) FROM ... ought to work.
SQL doesn't allow aggregate funcs like MAX() in the WHERE clause. Use
HAVING().
For nested queries like SELECT ... WHERE colvalue=(SELECT...) you need
version 4.1 or later.
Peter Brawley
http://www.artfulsoftware.com
-
Chuzo Okuda wrote
We overcame that problem to infinite levels with our Blog Software. Instead
of loops we use "Anchor Points" in the url to tell the navigation where it
was at all times. This allows for a more dynamic navigation system as you
can have Nav trees that not Expand with more subcatorgies but also colla
I am a newbie here. I created a simple table defined as:
create table test (
testID int unsigned not null auto_increment,
testName varchar(128) not null,
primary key (testID)
) type = MyISAM;
Now, I filled out test table, and looking for the testName with max
characters.
The follo
On Fri, 8 Apr 2005, Jacob, Raymond A Jr wrote:
>Does such a JOIN exist that can create a pivot table?
> Thank you:
> 182361 by: Dan Bolser
> 182362 by: Peter Brawley
>
>Now I must go into my cave and meditate on these queries:
>Ommm,Ommm,...Ommm :-)
Great! Its a
Hi, just got intro to the list and i hope I can find some help here.
I'm trying to figure out the true syntax of a project im working on,
basicly theirs a menu on my site that has several catagoies and in those
catagories are secondary, and some times 3rd level and 4th level sub
lists, i want to
Does such a JOIN exist that can create a pivot table?
Thank you:
182361 by: Dan Bolser
182362 by: Peter Brawley
Now I must go into my cave and meditate on these queries: Ommm,Ommm,...Ommm :-)
raymond
MY first post had html in it where I posted my indexin that I am using.
URL UNIQUE 5451 URL
expiresFlag INDEX 1 expiresFlag
title FULLTEXT 1 title
keywords
body_1 FULLTEXT 1 body_1
body_2
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 8825
URL UNIQUE 5451 URL
expiresFlag INDEX 1 expiresFlag
title FULLTEXT 1 title
keywords
body_1 FULLTEXT 1 body_1
body_2
Whoops on the html copy, calm down there guy.
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
46
I may have been reaching a little on the dynamic sorting since some of
what I had in mind entails adding more data to the categories. But at a
minimum, you would be able to sort ascending or descending and possibly
use an index on the sort depending on the query. Depending on how you
join your
Raymond,
Can you bend one or more of the pivot table examples at http://www.artfulsoftware.com/queries.php
to your requirement?
PB
-
Jacob, Raymond A Jr wrote:
Question: I frequently would like to summarize the results of my query in heiarchical layout also
known as a Pivot table.
H
I think what you are talking about could be called a 'crosstabulation' or
a crosstab.
Their are some tutorials about making cross-tabs using perl. I have used
them a lot, and they are really great.
I tend to stack up lots of IF statemens...
Table1
month person sex sales
1 a
"l'[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 04/08/2005 01:52:20
PM:
>
> When I opened the message send by:
> [EMAIL PROTECTED]>
> subject: Boolean searches
>
>
> a pop up box appeared stating
>
> "Connect to 70.84.29.164"
> Web host manager
> Username
> password:
>
>
>
> Has anybo
On Friday 08 April 2005 18:52, l'[EMAIL PROTECTED] wrote:
> When I opened the message send by:
> [EMAIL PROTECTED]>
> subject: Boolean searches
>
>
> a pop up box appeared stating
>
> "Connect to 70.84.29.164"
> Web host manager
If you bothered to check the source of the HTML mail (why does your
Are you sure that your mail client did not reply by accident?
164.29.84.70.in-addr.arpa. 86400 IN PTR mail.gunmuse.com
On Fri, Apr 08, 2005 at 10:52:20AM -0700, l'[EMAIL PROTECTED] wrote:
>
> When I opened the message send by:
> [EMAIL PROTECTED]>
> subject: Boolean searches
>
>
When I opened the message send by:
[EMAIL PROTECTED]>
subject: Boolean searches
a pop up box appeared stating
"Connect to 70.84.29.164"
Web host manager
Username
password:
Has anybody encountered this problem when you cliked on his email
Should we FLAME that guy?
In the mean time I am sending an
Hi,
sorry for the noise, it may be useful for someone else :
cat backup20050408.sql | sed 's/INSERT/SHOW WARNINGS;INSERT/' | sed
's/CREATE/SHOW WARNINGS;CREATE/' | sed 's/DROP/SHOW WARNINGS;DROP/' >
backup.sql
then use the backup.sql thus created.
So I got :Invalid TIMESTAMP value in column 'tim
Question: I frequently would like to summarize the results of my query in
heiarchical layout also
known as a Pivot table.
Here is an example of what I would like output. NULL will be printed as a space
when output.
sum of broken| source of | qty |reseller of |qty |customer with |qty
i have replication going between 2 boxes. the master crashed a few days
ago, and this morning i noticed that the slaves slave thread errored
out. the binary log and offset had changed on the master and the slave
couldn't sync up. i got the slave up and running again by changing the
log file and
When using the
Boolean search capabilities, I am finding it terribly slow. Since I am
sure MySql uses this on their own site. What version of MySql is the
fastest at this 5.0?
I am using the
PHPMySearch and I really think he did fair job on the crawler part. I
built an XML converter f
Dan Bolser <[EMAIL PROTECTED]> wrote on 04/08/2005 12:41:35 PM:
> On Thu, 7 Apr 2005, Sean Nolan wrote:
>
> >I think you'll find you can do what you want with a cross join. A cross
join
> >will join every row from the first table with every row from the second
> >table. It will not randomly d
Hi,
I got back warnings, event when started with mysql -v -v, I don't have
the Warnings appearing on the console... Do I really have to insert
SHOW WARNINGS; in the dump file after each statements ???
On Apr 7, 2005 6:10 PM, Mister Jack <[EMAIL PROTECTED]> wrote:
> Hi !
>
> Thanks, for your answ
Who can I prod about setting up a UDF repo at MySQL. I think 'they' should
do this ;)
http://lists.mysql.com/community/97
Anyway I am posting this request to 'community' because I still don't know
the appropriate place to post UDF related stuff.
This is anoter (potentially crazy) idea for a UDF
On Thu, 7 Apr 2005, Sean Nolan wrote:
>I think you'll find you can do what you want with a cross join. A cross join
>will join every row from the first table with every row from the second
>table. It will not randomly do this, so you'd have to be creative in
>"randomly" selecting rows in the WH
On Apr 7, 2005, at 5:20 PM, Marilyn Davis wrote:
Hi MySQL people.
I'm trying to understand the pros and cons of the "set" column type.
Here is an excerpt from the article:
http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
Why You Shouldn't Use SET
"Third, using a set means
On Thu, 7 Apr 2005, Brent Baisley wrote:
Thank you Brent.
> As mentioned in the manual you specified, there are limits to how many
> items you can have in a set, among other issues. My biggest issue
> against using sets is that you need alter the table structure whenever
> you want to change t
I just installed the 32-bit SPARC Solaris package
(mysql-standard-4.1.11-sun-solaris2.9-sparc.pkg.gz) in made a symbolic
link to the install directory as /usr/local/mysql . I am having the
following problems:
1) when I start mysql with the included mysql.server script, I get the
following erro
hi,
we are running a forum with about 600 to 700 people online at the same time
plus a
shop and other database relying services.
because this was to much for our single mysql server we are running a
master-slave
setup now, both of version 4.0.23. now we get occasional 2013 errors from our
fo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a stored procedure called assignItem. I would like to call this
from another stored procedure.
Thanx.
- --
"Love is mutual self-giving that ends in self-recovery." Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Ve
Heikki,
Yes, I'm running MySQL on 32-bit Linux.
I think maybe something had just gotten corrupted. MySQL restarted
itself yesterday, with the following in the error log:
050407 16:24:49 [ERROR] Out of memory; check if mysqld or some other
process uses all available memory; if not, you may have
As a newbie on Linux (FC3), I have (evidently) done something stupid and
lost part of the Administrator application.
When first installed, it was fine. I then treid to change the path on the
restore page, assuming that it was to point to where backups would be
stored. Whatever was entered ther
Hiya. Is there any way to define the pid file for the mysqlmanager?
--pid-file=/var/run/mysqld/mysqlmanager
The only way i've found so far is to modify the init file that comes
with the RPM. Not something I'd like to do : )
Thanks!
--
Sasha Dolgy
[EMAIL PROTECTED]
--
MySQL General Maili
At 22:13 07.04.2005, Gleb Paharenko wrote:
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
the temporary result set was larger than tmp_table_size and the thread
is changing the temporary table from in-memory to disk-based format to
save memory. I suggest you to play
Hello Sergei
On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote:
> > I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
> > using precomiled Debian packages on Debian Woody although I read the
> > comments regarding upgrading on dev.mysql.com.
>
> > After start
On Friday 08 April 2005 06:14, Richard Miller wrote:
> I didn't know the CSV table-type existed -- sounds really cool!
>
> As I understand it, it will save table data in a flat CSV file, but if
> I already have a CSV file, can I trick MySQL into thinking it's a
> table? That wasn't clear from the
Hi,
I have a table called Bookings which holds start times and end times for
appointments, these are held in Booking_Start_Date and Booking_End_Date. I
have a page on my site that runs a query to produce a grid to show
availiability per day for the next ten days for each user of the system.
Use
At 22:13 07.04.2005, Gleb Paharenko wrote:
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
the temporary result set was larger than tmp_table_size and the thread
But we get max. 10.000 long values in out result set.
is changing the temporary table from in-memory to di
Hi,
After SET CHARACTER SET GB2312 , create table a1 (b1 char(6))
charset=gb2312, the char field width in 2 times.
select * from a1
胶版材料重量
123456
金属材料12
Should be
胶版材
123456
金属材
server : win98/linux mysql4.1.11
client : windows ,bcc55,libmysql.dll
Rega
Hello.
See:
http://dev.mysql.com/doc/mysql/en/table-cache.html
Frank Bax <[EMAIL PROTECTED]> wrote:
> It seems the "bad file number" error was caused by MySQL trying to have
> more than 128 files open at one time. This was "fixed" by changing MySQL
> startup, but the "fix" would not
Hello.
Does the problem remains if you're executing the query just after
the 'FLUSH TABLES' statement.
"Jon Wagoner" <[EMAIL PROTECTED]> wrote:
> Recently I've been getting error 1041 at times, which gives the message
> to update the ulimit or add swap space. =20
>
> This is a dedic
Hello.
Usually the CHAR type is fastest, although it wastes more space.
>Hi all
>
> Suppose that I want to create a table with a column named
> "DETAILS" that
> will contain textual data. Performance-wise, does it matter if I
> represent
> this column wit
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
the temporary result set was larger than tmp_table_size and the thread
is changing the temporary table from in-memory to disk-based format to
save memory. I suggest you to play with the value of this variable wh
Hello.
Manual build of MySQL server is not usually a simple task. In most
cases an official binaries are preferred. Use the latest
release (4.1.11 now). Read the operating system specific notes:
http://dev.mysql.com/doc/mysql/en/operating-system-specific-notes.html
Dar$o Zapata V
Hello.
Analyzing the General Query Log could give such kind of information.
See:
http://dev.mysql.com/doc/mysql/en/query-log.html
Dilshad Ali <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there a way to determine when was the last time a MySQL user
> attempted to connect to the MySQL D
Greetings,
I have successfully configured mysqld_multi to have mysql 4.1.11 and
5.0.3 beta running on the same machine:
# mysqld_multi start &
# exit
% mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld4 is running
MySQL server from group: mysqld5 is running
%
However, I
I didn't know the CSV table-type existed -- sounds really cool!
As I understand it, it will save table data in a flat CSV file, but if
I already have a CSV file, can I trick MySQL into thinking it's a
table? That wasn't clear from the documentation.
Richard
On Apr 5, 2005, at 7:47 PM, Renato Go
Hi!
Am Do, den 07.04.2005 schrieb Joerg Bruehe um 18:45:
> [[...]]
>
> The problem is with the HTML generation, [[...]]
> It seems that in the HTML page generation this has not been changed in
> one place. [[...]]
I just checked the 4.1 download page: It seems corrected now.
>
> Aside: This p
On Thu, 7 Apr 2005, Gleb Paharenko wrote:
> Hello.
>
> If you're using an InnoDB tables you could monitor the progress
> with SHOW INNODB STATUS using the number of proceeded rows. See:
>
> http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
>
>
Thanks. I'll give it a shot.
Mike
>
>
> Is there a simple wat to get a word count out of a field in mysql, or to
at
> least split on " " and tell me how many items in that array.
Well, you can count the number of spaces:
SET @str = 'A four word sentence';
SELECT LENGTH( @str ) - LENGTH(
REPLACE (
@str ,
' ',
''
) ) +1;
Maybe this is
56 matches
Mail list logo
