> How do you find what position a value is in a larger query's result?
Well, if you put some sorting to your search, you will know the position of
your item by the count of the loop you are using to extract the data.
You use limit to return a max number of items, and keep a tab of where your
lim
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 19 Oct 2001, Clyde Jones wrote:
> Sorry,
> I forgot to answer your question about similar rows.
> Rows 5208 and 3063 are NOT the same (row 5208 has spaces and returns),
> besides your query asked for ALL rows not just the unique ones.
>
>
Hi.
This may be a obvious problem but...
I want to re sequence a auto increment column called p_key starting with 1001.
I found some information on this the Paul DuBois book MySql:
I tried dropping the column and adding it again per there instructions:
ALTER TABLE t DROP i;
ALTER TABLE t ADD i
Hi,
I hope I get your question right. Your problem sounds like:
Given the number of items per page, what page will an Id
fall into
The solution I propose is not very sophisticated but it does work for me.
Say your table looks like
Page 1
1Image A
2Image B
3Image C
--
Okay, so I did some detective work and found the problem. I thought you
might want to know the cause.
I use Textpad as my HTML editor right now, and when you create an HTML file
from scratch, it has the following tag:
The BACKGROUND="?" part was causing the problem. When I remove ONLY that
p
Hi,
I have Apache running on a solaris 7 on one box and mysql on another box.
Im using a program called right now live (www.rightnow.com), which is a
web-based FAQ and customer support tool. How can i get the box running
apache pull data from the box running mysql? Any suggestions?
Thank u
-
>Description:
When doing the following update I get a table crash.
>How-To-Repeat:
CREATE TABLE tester (
id int(11) auto_increment,
title varchar(100) default '',
PRIMARY KEY (id),
#If you comment out the following index, then the table is briefly marked as crashed
# but
That's why I told you to keep on running it until it was all fixed. Every time there
will be one less white space, until you're down to just one.
Steve Meyers
> -Original Message-
> From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 3:44 AM
> To: Steve M
Hello,
I have in mind a site that would require a Java applet to load
information from a MySQL database...
The applet would pull fields from a row randomly selected each
time is is loaded onto a web page on a client computer.
Fields would include some text and one picture.
Of course, login info
I'm running MySQL on a WIN2k server box. I'm doing inserts using PHP.
Here's the code for the insert:
$db = mysql_connect($hostname, $uid, $pwd); //$hostname is "localhost" and
$uid/$pwd are userid and password
mysql_select_db("heroes",$db);
$insertQuery = "INSERT INTO UniqueCardList (MCardI
Short version:
How do you find what position a value is in a larger query's result?
Long version:
I have a thumbnail image viewing page that pages through search results
using LIMIT page * page_size, page_size and that table does keep id's from
all results but they are not always 1, 2, 3, 4, 5...
On Thu, 18 Oct 2001, Steve Meyers wrote:
> Trim won't work because the newline is in the middle of the string. Try using the
>REPLACE function, ie
>
> UPDATE hotel SET nome_hotel=replace(nome_hotel, '\n', '')
Ok it replaced it.
>
> For the second question, it actually doesn't matter if it's
On Fri, 19 Oct 2001, Steve Meyers wrote:
> Well, you still have white space in there. Try running the following until it's
>fixed:
>
> UPDATE hotel SET nome_hotel=replace(nome_hotel, ' ', ' ')
>
> That will replace any double spaces to one space. If there's still a problem,
>replace all ta
Since this is an open source product, it could happen a lot sooner if you wrote it :)
I don't know of any plans to include that, at least in the near future.
Steve Meyers
> -Original Message-
> From: can [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 8:14 PM
> To: [EMAIL
InnoDB tables support foreign keys with full referential integrity constraints. They
do not yet support cascading deletes and updates. You'll want to use the MySQL-Max
version of MySQL to get support for InnoDB tables.
Steve Meyers
> -Original Message-
> From: Sandra Rovena Frigeri
> So there is no magic bullet that indexes everything so it works well with
> any given query? Does it help to index each field by itself for general
> queries and then I guess you index combinations of fields that will be
> used together in a WHERE clause?
>
Nope, no magic bullet... Indexes sp
> Okay, then I'll go through it point by point :)
Thanks. Helps a lot.
> Yes they're the same. How you index depends on your queries.
> Generally, just look at what your doing in your where clauses. If
> you're looking up rows based just on the path, then index path. If
> you're looking up
I'm pretty sure that the "complete" implementation is not done yet, in the
sense that there is no RDI enforcement.
Good Luck,
Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
- Original Message -
From: "Sandra Rov
When will mysql support XML with function same as Oracle XSU?
Kenneth.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
thank you
Steve Meyers wrote:
>That will be in some release of either 4.0 or 4.1, I'm not sure which.
>=20
>Steve Meyers
>
>
>> -Original Message-
>> From: JohnHomer [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, October 19, 2001 2:11 AM
>> To: [EMAIL PROTECTED]
>> Subject: join tables on
hi,
which windows mysql version supports foreign key and its "complete" implementation:
referential integrity constraint, avoid delete parent key, etc.?
or
Which foreign key features that has the best windows mysql version?
thanks,
sandra.
-
Okay, then I'll go through it point by point :)
> Thanks. I've read the manual. I guess I was looking for a more direct
> explanation to make sure I had it clear and to learn any tips that might
> be useful that wouldn't be in the manual. As my database will be quite
> large I'm worried about ef
You haven't given your table definition, but I'm guessing that your primary key is a
TINYINT, which only supports -128 to +127. Figure out how big you need that key to
be, then change the column as appropriate to a SMALLINT, MEDIUMINT, INT, or BIGINT.
Steve Meyers
> -Original Message---
David Loszewski writes:
> I typed './mysqladmin -u root -p password ' and this
> came up, ideas on what I could do to solve this problem that I'm having?
> Check that mysqld is running and that the socket: '/tmp/mysql.sock'
> exists!
Start mysqld before you try to connect to it. If it
doesn't
I typed './mysqladmin -u root -p password ' and this
came up, ideas on what I could do to solve this problem that I'm having?
By the way, I'm using the MySQL 3.23
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Thanks. I've read the manual. I guess I was looking for a more direct
explanation to make sure I had it clear and to learn any tips that might
be useful that wouldn't be in the manual. As my database will be quite
large I'm worried about effective optimizations.
> http://www.mysql.com/doc/C/R/CRE
I typed './mysqladmin -u root -p password ' and this
came up, ideas on what I could do to solve this problem that I'm having?
By the way, I'm using the MySQL 3.23
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
- Original Message -
From: "Barbara Ferrell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 6:51 PM
Subject: Fw: Can Mysql search full text fast through 3.3 million text
documents?
> We have 3.3 million text documents ( U.S. Patents) that we can put into
any
Bill Adams wrote:
> Spoiler: You may be right about the bad libs...
[snip]
> *** OMG ***
> But haha I cannot believe this, I was just looking at the libraries linked by
> mysqld with ldd and it is using the informix libpthread.so. Hmm, crap. *me
> slaps head*
Small Update:
o If there is no c
David> Hi!
David>
David> When you have a indexed field that allows NULL (as per mysql >= 3.23.2)
David> and there is more than one row that has null in that column,
David> then an equality comparison between that field and NULL returns true
David> if the index is used.
David>
David> The proble
All of the locked queries are happening because another query has locked them out.
That is, until a certain query finishes, none of the others can execute. See the
manual for more info on table locking. You can generally fix this simply by fixing
your bad queries (adding proper indexes, etc)
Tried turning force on so that it'll ignore errors? That way only
duplicate rows are ignored?
*^*^*^*
Michael McGlothlin <[EMAIL PROTECTED]>
http://mlug.missouri.edu/~mogmios/projects/
On Fri, 19 Oct 2001, Robert Trembath wrote:
> I have some nice database for a biotech lab running on the windo
In the last episode (Oct 19), Robert Trembath said:
> I have some nice database for a biotech lab running on the windows
> version of mysql 3.23 on a W2K server. For some reason when my ID or
> Auto-increment field get to 127 I can't insert any additional records. I
> get the following error:
Cha
Robert Trembath wrote:
>
> I have some nice database for a biotech lab running on the windows
> version of mysql 3.23 on a W2K server. For some reason when my ID or
> Auto-increment field get to 127 I can't insert any additional records. I
> get the following error:
>
> Error
> SQL-query : [Edi
See:
http://www.mysql.com/doc/C/R/CREATE_INDEX.html
http://www.mysql.com/doc/M/y/MySQL_indexes.html
Steve Meyers
> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 2:07 PM
> To: [EMAIL PROTECTED]
> Subject: indexing question
>
>
> Can any
I have some nice database for a biotech lab running on the windows
version of mysql 3.23 on a W2K server. For some reason when my ID or
Auto-increment field get to 127 I can't insert any additional records. I
get the following error:
Error
SQL-query : [Edit]
insert into curvesdb (Genus, Speci
When I try to connect a client to MySQL server on RH Linux 7.0 box I get
this message window "Host 'name.name.net' is not allowed to connect to this
MySQL server" I am new to the software and I could really use the help. The
MySQL client is running on a Windows 2000 box. I have put the my.cnf fil
Mark Maunder wrote:
> Hi,
>
> I think this is a bug. The script to recreate the problem is included
> below. This problem appears consistently as long as there's a fulltext
> index and a regular index on the same field and you do an update to
> change the case of a single char. It doesn't matter
Hi Howard,
I would start with the bottom of every message.
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
I like this:
http://www.bitbybit.dk/mysqlfaq/faq.html
http://www.dwam.net/MySQL/
and this:
htt
Hello,
I am seeing rather frequently our mySQL DB Freezes up. It runs the back end
of a web site that gets decent traffic. When I check the process list for
the DB, there is a bunch of processes all locking that table sitting there.
I normally disable connections from the Cold Fusion server, me
Hi,
I think this is a bug. The script to recreate the problem is included
below. This problem appears consistently as long as there's a fulltext
index and a regular index on the same field and you do an update to
change the case of a single char. It doesn't matter if the fulltext
index includes o
On Wed, Oct 17, 2001 at 06:25:49PM +0200, Ciprian A. wrote:
> I need to select from a table all the records that do not contain a certain
> string. Any idea how I can do this?
You mean like SELECT * FROM TABLE WHERE FIELD NOT LIKE "%stuff%"? :)
--
Michael T. Babcock
http;//www.fibrespeed.net/~m
Brand new Newbie here! My first post of any meaning!
Considering the futile exercise of building an Access frontend to MySql.
Where are the best FAQs, Books, Websites?
Thanks
howard gramer Home of NYPD and FDNY
Environment..: Telecommunications at the circuit level.
Hello,
I'm running the following
Redhat Linux
IASP 2.0
mySQL
If my site is continually viewed the iASP engine or mySQL seems to slow
down Any
ideas on why or how to correct this problem
Thanks
Neil
-
Before posting, p
Can anyone give me some tips on how indexes work?
I noticed that UNIQUE() seems to create a lock on all given fields per
call like UNIQUE (md5, mime) so that no row can have the same combination
of md5 and mime type which is good but assuming I wanted to have each
unique on it's own I'd need UNIQ
You may want to check your /tmp partion. it may be creating some temp tables.
-t, --tmpdir=path
Path for temporary files. It may be useful if your default /tmp directory
resides on a partition too small to hold temporary tables.
Byron
[EMAIL PROTECTED] wrote:
> Hello All,
>
> Background
> Britt> o Lock optimization - MySQL executor acquired
> Britt> more locks than required for common queries.
>
> Just a note: The extra locks are only relevant for Gemini and BDB tables,
> not for MyISAM or InnoDB tables.
The extra locks issue does apply to InnoDB for update statements
checkout pam_mysql under the ports collection in fBSD...;)
cheers,
Mikel
Chris Aitken wrote:
> Hi,
>
> Something ive been thinking about for a while but havent been able to come
> up with a definitive answer is this...
>
> Is there a system out there which can take over from the normal
>Description:
The commandline completion cache of table/column names for the mysql
client is not cleared after a DROP TABLE statement is (succesfully)
executed.
>How-To-Repeat:
Executed the following using the client:
mysql> drop table NIDABA_PROJECT_DOCUMENT_RESERVATION;
Query OK, 0 rows affect
I had one mysql database established on my development server. A new project
came along so I created a new database. The new database works fine, but the
first database doesn't work any more. When I try to access data from the
database, either from JDBC or by starting mysql I get this error:
Didn
Hi!
First I have to apologize to the email list for this discussion: It
certainly doesn't belong here. On the other hand, as the creator of
MySQL and one who has personally sued by NuSphere corporation I can't
let things like this go unanswered.
> "Britt" == Britt Johnston <[EMAIL PROTECTE
Dear Sir,
Please do help me. I am trying to install the mysql-3.23.42 on my
FreeBSD4.3.
However, the mysql cannot interface with the BerkeleyDB3.1.17. An error
message come up the Version 3.2.9 is need, but when I used the
2BerkeleyDB3.2.9 , the error messsage come up again.
Please advise.
You
Hi.
I have ran into couple of problems using Oracle workbench migration tool.
I was wondering if anyone out there has any insight.
1. If a date field in a mysql table has a default (let's say -12-31)
the script for oracle table will also have -12-31 as a default field.
This doesn
Well, answering my own email, what I thought was a bug is not one at
all. I was mistaken in thinking that MySQL paid any attention to the
WHERE conditions when optimizing the join order beyond determining
which keys are used for the join, correct?
This is really terrible for queries like mine
I'm developing a Java application that uses a pool of JDBC connections
to store and retrieve data in a MySQL database. I'm using the 3.23.38
Win32 version of MySQL, on Windows 2000 Professional, and the
mm.mysql-2.0.4 JDBC driver.
I'm using a table with a MEDIUMTEXT field, which the MySQL docume
Hello,
I'm losing precision when I send a double to a mysql database from a Java
program trough JDBC.
Code:
stmt.setDouble(i+3,((Double)value).doubleValue());
I use a prepared statement.
Now, if I print out the double in java before sending it to the MySql
database this is what it looks like:
127
cedric wrote:
> /usr/bin/mysql start returns the error message:
> Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock.
> It was there, but now it's not.
That is the wrong command, use either safe_mysqld or mysqld_safe. Or possibly
/etc/rc.d/init.d/mysql start
> Also,
Hi,
Has anyone been able to build MySQL 4.0 source using pgcc?
I tried for several hours with different setting in each try without any success.
MySQL 4.0 alpha does compile, but it refuses to start, dumping the same
error output each time such attempt is made:
*** Being error output ***
hi,
I have installed mysql3.23.39 on solaris2.8.
but,when I try to run the server, I am getting segmentation fault.can anybody help
me..?
I have followed instructions as given in the php manual.
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip mysql
Mark Coldheart wrote:
> I've a little bit problem about running mysqld
> server. I've run "/etc/rc.d/init.d/mysqld start" it
> will appear "mysqld dead but subsys locked". But if i
> stop the service, it will fail. It is also happened
> when i kill the service.
Mm, redhat question.
Make sur
Hi!
On Oct 19, Jeroen Geusebroek wrote:
> Hi,
>
> >May be because your LIKE query finds also
> >'something will not shed any light on this!!!'
>
> That's what i though just after posting this to the list.
> When is the phrase support planned to be inserted in MySQL 4?
No specific deadlines yet
JohnHomer wrote:
> can mysql allow table joins when using UPDATE query? like
The manual answers these questions.
> update tranfer left join transferdetails
> on transfer.docno = transferdetails.docno
> set transferdetails.docno = concat('SJ',transferdetails.DocNo)
> where
> transferdetails.docn
/usr/bin/mysql start returns the error message:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock.
It was there, but now it's not.
Also, all the files in /var/lib/mysql now have green question marks over them.
The did not before. I was able to open *.err and read it.
'/
That will be in some release of either 4.0 or 4.1, I'm not sure which.
Steve Meyers
> -Original Message-
> From: JohnHomer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 2:11 AM
> To: [EMAIL PROTECTED]
> Subject: join tables on UPDATE
>
>
> hi list,
>
> can mysql allow
Spoiler: You may be right about the bad libs...
Kyle Hayes wrote:
> On Thursday 18 October 2001 12:31, Bill Adams wrote:
> Hmm, 2.2 doesn't do SMP really well. However, its drawbacks are limited to
> underuse of the CPUs rather than any kind of corruption or other issue. You
> would get much
Hi,
>May be because your LIKE query finds also
>'something will not shed any light on this!!!'
That's what i though just after posting this to the list.
When is the phrase support planned to be inserted in MySQL 4?
That would be a very nice feature!
Regards,
Jeroen
-
I have found the MySQL Manager to be incredibly buggy and a pain to even do
the most simplest things.
I would suggest that you try MySQL-Front
http://www.anse.de/mysqlfront/
Very easy to use and very functional.
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[E
Hi!
On Oct 19, Jeroen Geusebroek wrote:
> Hi there,
>
> I'm trying to use fulltext for speeding up my queries, but i found some
> strange
> difference in the results between fulltext & Like ; for example:
>
> AGAINST('+shed +some +light +on +this')
>
> gives less matches then:
>
> AND field L
cedric writes:
> MySQLGUI-1.7.5 was working.
> Now, when I start it and put the mouse pointer over it, it disappears.
> Reinstalled only to get the same thing.
>
> Any ideas?
>
> cedric
>
What operating system do you use ??
Have you changed X version or window manager ??
I never heard of so
I downloaded MySql v3.23.43 binaries to see if I could make use of the
system for my database 'stuff'. I have several tables that when loaded will
be >2gb and the concept of raid support would be appealing.
Raid does not seem to be enabled on the default download. Because of this I
downloaded
Hi there,
I'm trying to use fulltext for speeding up my queries, but i found some
strange
difference in the results between fulltext & Like ; for example:
AGAINST('+shed +some +light +on +this')
gives less matches then:
AND field LIKE '%shed%' AND field LIKE '%some%' AND field LIKE '%light%'
A
It was my understanding that it should actually work that way, but SQL does not
guarantee that with GROUP BY clauses -- you would want to use an ORDER BY clause if
you want to guarantee order. The problem could be in one of your char fields --
maybe an extra space somewhere that's messing up
Hi,
Just stopped and started mysql with the -O max_binlog_cache_size=100,
but still this bin.001 file is increasing way over this limit, so it may not
be this:(
I didn't think it was due to replication as we do not have any replication
setup.
Also check the contents of the file.
?bin(iI;E
MySQLGUI-1.7.5 was working.
Now, when I start it and put the mouse pointer over it, it disappears.
Reinstalled only to get the same thing.
Any ideas?
cedric
-
Before posting, please check:
http://www.mysql.com/manual.php (
Philip Lijnzaad writes:
>
> > Upload your file to this directory :
>
> >ftp://support.mysql.com:/pub/mysql/secret
>
> Done.
>
> --
> The mail transport agent is not liable for any coffee stains in this message
>
> Philip Lijnzaad writes:
>>
>> > Upload your file to this directory :
>>
>> >ftp://support.mysql.com:/pub/mysql/secret
>>
>> Done.
> Sorry, it is 0 bytes long !!
No it is not.
Guest login ok, access restrictions apply.
Logged in to support.mysql.com.
OK,
I have got a first one.
I will try it out as soon as I find some time ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca,
I've got a mysql database with unique index on a column defined as varchar,
and character =
set=latin1. But, if I insert, for example, 'protege' into the varchar
column, then try to insert 'protegé', I get a 'duplicate entry' error.
Mysql seems to be treating 'e' and 'é' as the same character. I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
OK
it looks like you have gotten rid of your excess carriage returns, but
now you need to remove the excess spaces. did you try nesting the
functions?
try this
select
replace(replace(nome_hotel,\n,""), " ", " ") as nome d'hotel
from hotel
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sorry,
I forgot to answer your question about similar rows.
Rows 5208 and 3063 are NOT the same (row 5208 has spaces and returns),
besides your query asked for ALL rows not just the unique ones.
Remember, computers only give you what you asked for,
Sorry for that - Recompiled and everything works as expected.
ta.
-Original Message-
From: Mark Cance [mailto:[EMAIL PROTECTED]]
Sent: 19 October 2001 14:07
To: [EMAIL PROTECTED]
Subject: mysqladmin
Hi,
I know I'm probably doing something really dumb but has anyone got any ideas
why I
> Upload your file to this directory :
>ftp://support.mysql.com:/pub/mysql/secret
Done.
--
The mail transport agent is not liable for any coffee stains in this message
-
Philip Lijnzaad, [EMAIL PROTECTED] Europea
Hi,
I know I'm probably doing something really dumb but has anyone got any ideas
why I get the problem below.
I cant connect using 'mysqladmin', but using the same user/password can with
'mysql'? The user in question has been set up correctly with grant all from
any host. Wouldn't normally be a p
Hi!
Is there a possibility to rotate mysql error log without stoping the server?
TIA
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 52
Sorry for a typo.
Upload your file to this directory :
ftp://support.mysql.com:/pub/mysql/secret
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___
Hi everybody!
I need to download MySQL version 3.22.15-Gamma for Solaris.
Does anyone know where I can find it?
thank you very much
/ Johan
Johan Brunius
DebiTech AB
System Developer
Stadsgården 6
S-116 45 STOCKHOLM
SWEDEN
[EMAIL PROTECTED]
http://ww
Is there away to control the max size of each database create by user. I mean
built into MySQL??
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-
Philip Lijnzaad writes:
>
> Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686.
>
> Please try and reproduce it using
> http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz.
>
>
> Philip
> --
> The mail
> Philip Lijnzaad writes:
>>
>> Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686.
>>
>> Please try and reproduce it using
>> http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz.
> Please upload your file to:
> ftp://support.mysql.com:/pub/mysql/secreat
ncftp /pub/my
Hi,
did someone tell me why group by clause not work? I'd like to group
volume of order from my customer at the same price and my supplier. here
is my code
Select custid, symbol, sum(volume) as sumvol, price, mktid, supplier,
supplierflag
From confirm
WHERE mk
Hi!
> "Jonathan" == Jonathan Hilgeman <[EMAIL PROTECTED]> writes:
Jonathan> The harm doesn't come from you offering something beneficial to the MySQL
Jonathan> community. It comes when you abuse the privileges of being on this list and
Jonathan> send spam. While there may not be anything in
Hi
Environment
Mysql ver. 3.23.36
Mysqldump ver. 8.13
Solaris 2.7
Problem
I have been trying to use mysqldump --tab to dump a database of
93 records but it always fails on the 61st table with the following
error code
mysqldump: Can't create/write to file '/bu/fred.sql' (Errcode: 24)
(Error
Hi!
> "Britt" == Britt Johnston <[EMAIL PROTECTED]> writes:
Britt> Now that the patch for Gemini has been created and made
Britt> available for the new MySQL 4.0 alpha release we are
Britt> back whole again.
I wouldn't really agree with this.
Britt> I am told that binaries for the compl
Hi everybody!
I need to download MySQL version 3.22.15-Gamma for Solaris.
Does anyone know where I can find it?
thank you very much
/ Johan
Johan Brunius
DebiTech AB
System Developer
Stadsgården 6
S-116 45 STOCKHOLM
SWEDEN
[EMAIL PROTECTED]
http://www
Hi everybody!
This is my problem:
1) Environment:
OS:sun4u sparc SUNW,Ultra-250
MySQL:3.22.32
2) What I do:
I make an excerpt of a table using " select
lpad(my_field,5,'0') into outfile 'my_file_path' from my_table" ...
3) What I would like:
Hi!
> "Michael" == Michael Furgal <[EMAIL PROTECTED]> writes:
Michael> Monty and all:
Michael> I have re-applied all the Gemini table handler support and
Michael> ported it to MySQL 4.0. It is too large to send as an email
Michael> so the patch can be found at:
Michael> ftp://ftp.nusphe
DISTINCT?
=dn
> On Thu, 18 Oct 2001, Steve Meyers wrote:
>
> > Trim won't work because the newline is in the middle of the string. Try using the
>REPLACE function, ie
> >
> > UPDATE hotel SET nome_hotel=replace(nome_hotel, '\n', '')
>
> Ok it replaced it.
>
> >
> > For the second question, it
Erik,
run the MySQL server mysqld from a command prompt and do with
the mysql client:
mysql>create table innodb_lock_monitor(a int) type = innodb;
(assuming you run a recent version).
Then mysqld will print lock information to the standard output
and you see what is happening.
Regards,
Heikk
hi list,
can mysql allow table joins when using UPDATE query? like
update tranfer left join transferdetails
on transfer.docno = transferdetails.docno
set transferdetails.docno = concat('SJ',transferdetails.DocNo)
where
transferdetails.docno not regexp '^SJ' and
lower(xfrom) = 'san juan';
i get
>Description:
mysql-test-run script uses the test [ -e "$BASEDIR/client/.libs/mysqltest" ]
(line 276 )
since the script uses /bin/sh, and this test [ -e ] is not implemented
in /bin/sh on solaris, the mysql-test-run script fails & exits
>How-To-Repeat:
run mysql-test-
1 - 100 of 102 matches
Mail list logo
