I am using 4.0.15 on RedHat 7.3 and ran it to a strangest problem today.
SELECT col FROM table WHERE site_id=123;
returns a list of data.
SELECT col FROM table WHERE site_id IN(123);
returns an empty set.
Upon further investigation, I found cases when the IN() syntax gets a
smaller subset of th
hi all.,
i tried to compile mysql-3.23.58 source
distribution for windows using VisualStudio 6 and
found that MySqlManager.rc file missing and hence the
compilation failed , The MySqlManeger.rc file is not
available in the MySqlManager folder downloaded from
mysql home site.
plz help me out in
Description:
I am trying to install mysql 4.0.16 on Solaris 8 on a i86pc. I
created the user and group and everything went fine until I ran
scripts/mysql_install_db.
When I run the script I come acoss the error
ld.so.1: ./bin/mysqld: fatal: librt.so.1: version `SUNW_1.2' not found
(requ
I have problem with mysqldump.
This query results an error.
mysqldump danamon [trx_temp2] > trx_temp2.sql
The error message is :
mysqldump : Can't get CREATE TABLE for table
'[trx_temp2]'
I'm sure the trx_temp2 table in danamon database
exists.
I'm running MySQL 4.0.13
___
Thanks Ricard, Mike,Kim,Chris and John. Now thats going the extra mile,
giving me the ISBN code to the book.
Once again, thanks.
Braulio
"mike" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> >As for a book, I recommend the one on PHP and mySQL web development by
Luke
> Willing
You are correct. I interpreted "Function or a procedure" to be the
questioner referring to stored procedures with two seperate terms.
Mike Hillyer
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2003 8:06 PM
> To: mike
> Cc: [EMAIL PROTECTED
In the last episode (Nov 25), mike said:
> >wanted to know if one can write a Function or a procedure in a mysql
> >4.0.12..???
>
> This is not going to be supported until MySQL 5.
Mysql has supported user-defined functions since 3.21.
http://www.mysql.com/doc/en/Adding_functions.html
--
>wanted to know if one can write a Function or a procedure in a mysql 4.0.12..???
This is not going to be supported until MySQL 5.
>Also about this data dump, i went to C:\ and typed mysqldump test. .. this thing ran
>for quite some time but where was the dump finally could figure that out ..
On Tue, 2003-11-25 at 10:24, [EMAIL PROTECTED] wrote:
> However the following (see quotes below) still does not work.
>
> Any ideas?
>
> Thanks in Advance,
> Ted
>
>
What is the output of the php subroutine mysql_error() when used after
your db calls?
http://us2.php.net/manual/en/function.my
>As for a book, I recommend the one on PHP and mySQL web development by Luke
Willing and Laura Thompson.
>Good luck!
>Richard
I would second that reccomendation. Luke Welling and Laura Thompson have a really good
book. ISBN 067232525X.
--
MySQL General Mailing List
For list archives: http://l
On Tue, 2003-11-25 at 13:15, Diana Cristina Neves Soares wrote:
> I think it is not possible to have things as you stated, but you could have an
> auto_increment field and a date field in your table.
> Every time you insert a record, you set the date field and the other field will
> auto_increm
Awesome! It worked perfectly! Thanks Pat and Stephen.
Bob
-Original Message-
From: Patrick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 4:20 PM
To: Bob Loeffler; [EMAIL PROTECTED]
Subject: Re: Replacing text using the Update command?
Bob,
Try:
UPDATE pictures set caption
Pat's version was better than mine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
When you have a table with more than 10 million rows, one row less or
one row more
shouldn't make a difference, right? ... Well, think again. Look at this
EXPLAIN statements,
it seems that the optimizer prefers a full table scan in the normal
query but uses the index
if there's a LIMIT *numb
Hello Bob,
- Original Message -
From: "Bob Loeffler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 10:01 AM
Subject: Replacing text using the Update command?
> Hi all!
>
> I would like to update many records in a table called "pictures" where I
> find a s
Bob,
Try:
UPDATE pictures set caption = REPLACE(caption,'www.bob.com',www.bubba.com')
WHERE caption like '%www.bob.com%'
Make sure you backup or copy data before trying...
See MySQL Manual 'Language Reference->String Functions'
I hope this helps...
Pat...
CocoNet Corporation
825 SE 47th Ter
Hi all!
I would like to update many records in a table called "pictures" where I
find a string in the "caption" column. If the string (e.g. "www.bob.com")
is found, replace it with another string (e.g. "www.bubba.com").
Unfortunately, there is other text in the caption column of these records,
so
Du
If I have two tables with the first table containing a field which is FK of
table 2, when I insert a value into this field, should it not automagically
insert a value into that PK in the second table?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Assuming he is using the mysql init script from Gentoo, he just needs to run
/sbin/depscan.sh
-Original Message-
From: Bob Lockie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 2:50 PM
To: MySQL Mailing List
Subject: start warning
I am posting this on behalf of a Gentoo user
I have two different versions running 3.23 & 4.0
If I wanna configure the section [mysqld_multi] how can the machine
automatic boot with two different mysqld since 3.23 uses safe_mysqld
Mysqld= /usr/local/bin/mysqld_safe ( and not for 3.23 safe_mysqld)
Mysqladmin = /usr/local/bin/mys
At 8:10 +0200 11/25/03, Jozsa Boti wrote:
> >Hi!
Please reply to the list, not to me personally, so that others can
follow this discussion. Thanks.
Sorry,
No apology required. It's just that others may have something to
contribute.
I was able to duplicate your results and raised the question
You just need to reverse the order of your variables. Set "b" based on
"a", then set "a" to the new value.
UPDATE t1 SET col_b = CASE WHEN col_a = 1
THEN col_b + 1
ELSE 0
END,
col_a = CASE WHEN col_a = 1
Using CASE... WHEN... THEN in my update query doesn't behave the way I
expect it to. It's using the result of the query in the second WHEN
condition rather than the original value. See this example:
CREATE TABLE t1 (col_a tinyint not null, col_b tinyint not null);
INSERT INTO t1 VALUES (1,1);
I am posting this on behalf of a Gentoo user.
Does anyone know why this warning happens?
# /etc/init.d/mysql start
* Could not get dependency info for "mysql"!
* Could not get dependency info for "mysql"!
* Starting mysqld...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
I am trying to upload an icon from a client to a server and then to
other clients over tcp/ip. the icon data will be stored in mysql on the
server. the column is defined as a mediumblob field. once on the
server, i escape the string and then put it into a mysql statement to
insert it into the d
On Tue, 25 Nov 2003, Stefaan Van Dooren wrote:
> Can anyone tell me what this option does, besides adding debug information ?
> When I add this option, I get a working mysqld server. When I remove it and
> recompile, my server won't work anymore
It does a lot of things. With MySQL-4.0.16 is
On Mon, 24 Nov 2003, Stefaan Van Dooren wrote:
>
> As you can (could) see in my previous post, I managed to get MySQL working
> on SCO with "--with-debug" as a configure option.
> Whenever I remove "--with-debug", I can compile and install it, but I can't
> connect to it.
>
> Can someone please exp
Hello everyone,
I hope I have not reinvent the wheel with this but maybe it's worth sharing.
:)
I have Solaris8 and I needed multiple instances of MySQL (4.0.16), loading
at boot up, each one with unique configuration and running on different
ports.
Though in the manual (http://www.mysql.com/doc
I think it is not possible to have things as you stated, but you could have an
auto_increment field and a date field in your table.
Every time you insert a record, you set the date field and the other field will
auto_increment himself.
Then, when you want to do a select, you may do as:
SELECT
Hello.
MySQL 4.1.0 is not respecting the registered privileges.
Before I switch back to the last stable version, I would like to know if
there is a workaround to my problem or if other persons have met the
same problems. Following is the description of the troubles.
I have installed MySQL 4.1
On Tue, 25 Nov 2003 16:10:47 +, Duncan Hill <[EMAIL PROTECTED]>
wrote:
Greetings,
I've just finished installing 4.1 alpha (yes, I know, alpha) on a test
setup.
Now that I'm starting to stress test it, I've run into an odd bug:
Every once in a while, (and from what I can tell, randomly) the
I've been trying to understand the format of the MySQL binary logs: I've
noted from /clients/log_event.h that there are two formats, the "old"
one with an event header length of 13 bytes, and a "new" one with an
event header length of 19 bytes. That's perfectly clear: but supposing I
have two logs,
Hello gentelmen,
can anybody guide or point me how to compile mysql (4.0) with specific
zlib library?
I've precompiled zlib which came with OS (FreeBSD 4.5) in /usr/lib:
libz.a
libz.so
libz.so.1
libz.so.1.1.3
libz.so.2
and have installed myself libz 1.1.4 to /opt/zlib (with usual structure
/opt
On Tuesday 25 November 2003 16:25, you wrote:
> is the access control by hostname or ipnumber? if by name, you could be
> running into a dns failure on the inverse map lookup.
IP based - the machines communicate over an internal-only network on their
second network card.
--
MySQL General Mail
Thanks Heikki, I'll send those along a little later today. I believe that
there is a second row in the table that has the name value "Technical
Questions: API"... If I am reading your comments correctly we are running
into a problem where the Key is limited to the first ten characters and
therefore
Greetings,
I've just finished installing 4.1 alpha (yes, I know, alpha) on a test setup.
Now that I'm starting to stress test it, I've run into an odd bug:
Every once in a while, (and from what I can tell, randomly) the server will
reject the attempted connection from another host on the netwo
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Service Shutsdown when not running as LocalSystem
>Description:
I have installed MySql 4.0.16 on a WinXP laptop. No matter how I
install it (default directories or not), the service works fine after
running 'mysqld --install'. However, i
Well, a friend told me that:
"register_globals is off by default in recent versions of PHP. You need
to
refer to GET/POST variables using the $_GET or $_POST associative
arrays,
or turn register_globals on in your php.ini."
I enabled register_globals, it was Off.
However the following (see quo
yo yo yo,
another phat option is to create another page on your system that returns the %
number, and using flash, call that url and parse the results, and update your flash
chart accordingly. We've done similar things to have flash talk to our systems (set
up web pages that return xml rather
Ok here is the soluction. Feel me, yall, this is the winner of the prize.
You see, it is an uncommon operation, but you CAN have a JavaApplet
call a method on your window object. By having the java applet gain
access to its window object, you can drill down into the
if(window.methodName==true){
Absolutely not. First, you have the overhead of maintaining the two
tables. Second, MySQL doesn't know that they are identical tables, so
it will try to cache both of them. On a self join, MySQL does know they
are identical, so it will only need to load the data into memory once.
If there is en
Hello Serge,
Serge E. Yakubovich wrote:
>>Description:
First of all I want to thank you for your excelent bug report and apologize for
delayed responce.
>The same test script I've submitted today to [EMAIL PROTECTED],
> which demonstrates improper(?) behaviour of UPDATE statement on
> 4.
On Mon, Nov 24, 2003 at 02:49:12PM -0700, Jeff Mathis wrote:
: maybe one more particle of information is that enums are actually
: strings, not numbers, so you may have to do a conversion somewhere. this
: is a pain for us, so we use tiny ints.
The bigger problem I've had with ENUMs as strings is
Hi Guys
I'm very new to the MySql, and I'm only using it for my php based
chatboard at the moment. Plans are that I'll try and use the database
for some more exciting things, and therefore I would like to be on the
newest version.
I've made a my.cnf, and the database is placed on a different volum
On Nov 25, 2003, at 1:10 AM, Jozsa Boti wrote:
Please reply to the list, not to me personally, so that others can
follow this discussion. Thanks.
Sorry,
Don't feel bad. The list admins could easily set up the list so that
the default action when replying is the correct one, but apparently
choo
Chris,
Thats not what i think im Asking.
I was wondering if its possible to have a
AUTO_INCREMENT ID
number also have the format mmddyy.
So when you query the table it would be the PRIMARY KEY AUTO_INCREMENT ID
field:
select * from table:
name email phone ID
Bugs [EMAIL
Hello,
I have a query that will be used alot on my website that involves a 42
million record table being self-joined. The primary table instance will be
limited by an index resulting in 1 to about 50,000 rows being selected, then
joined to the second instance of the table, which will retrieve
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I am getting the following error when I try to access a merged table:
>
> This:
>
> Select * from subjects_2; or insert into subjects_2 (subj_id) values('10');
>
> Returns:
>
> ERROR 1017: Can't find file: 'subjects_2.MRG' (errno: 2)
>
> Any Id
May Yang <[EMAIL PROTECTED]> wrote:
> Dear everyone,
>
> I'd like to ask you a question, thanks in advance.
>
> Q: How long will it take to import 100GB data into MySQL DB by command "mysqlimport"
> ?
>
Depends on how many records are to be inserted. Hard to tell not knowing your hardware
and
Thanks, John.
Braulio
"John Nichel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Braulio Lumbreras wrote:
>
> > What is the best way to learn php and mysql? What book is recommended
for
> > self study of both ?
> >
> > Braulio
> >
>
> The PHP website is an excelent place. The o
Thanks, Chris.
Braulio
""Chris"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> PHP and MySQL Web Development, by Luke Welling and Laura Thomson
>
> It's an excellent book.
>
> -Original Message-
> From: Richard Bewley [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 24,
thanks...
-Original Message-
From: Mikael Fridh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 4:23 PM
To: Swati K; [EMAIL PROTECTED]
Subject: Re: Functions and Procedures in Mysql
Regarding your mysql dump
If you did not redirect standard output (mysqldump test > dumpfile.sq
Hi
Thanx for both your replies, until recently I was doing the intelligent stuff outside
MySql ie in the Perl/PHP.
I'm learning to think database!!
Best Regards
David Rayner MSc CEng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Regarding your mysql dump
If you did not redirect standard output (mysqldump test > dumpfile.sql),
it did not go anywhere.
Mike
On Tuesday 25 November 2003 11.46, Swati K wrote:
> Hi People,
>
> wanted to know if one can write a Function or a procedure in a mysql
> 4.0.12..???
> Also about this
Hi,
> wanted to know if one can write a Function or a procedure in a mysql
> 4.0.12..???
No, MySQL 5 is supposed to support this.
Another note:
When writing to a mailinglist, please don't say your post is "urgent".
You're
sending your message to hundreds of people that decide themselves if your
Hi People,
wanted to know if one can write a Function or a procedure in a mysql
4.0.12..???
Also about this data dump, i went to C:\ and typed mysqldump test. .. this
thing ran for quite some time but where was the dump finally could figure
that out ..
can some one help me on this..
thanks in ad
Hi Dominic,
> I think everyone is misunderstanding my problem as perhaps I didnt phrase
it very well.
>
> I need to add a new autonumber field to my db, but I need to make sure
when the numbers go into the field they are in the order of one of my other
fields that is a date field.
>
> i.e. I have
One of My MySQL slaves is trailing behind its master.
| 42 | system user | | NULL | Connect | 8193 | Has read all relay
log; waiting for the I/O slave thread to update it | NULL |
8193 seconds behind.
Why might the slave be trailing?
I just did a
slave stop;
slave start;
Hi,
I think everyone is misunderstanding my problem as perhaps I didnt phrase it very well.
I need to add a new autonumber field to my db, but I need to make sure when the
numbers go into the field they are in the order of one of my other fields that is a
date field.
i.e. I have a field which s
Bruce,
I am not able to repeat the crash. I tested on Linux with 4.0.17.
You have the index
KEY `jiveForum_name_idx` (`name`(10)),
The bug is probably in the column prefix index. That feature was introduced
in 4.0.14. Did you create the table with a version < 4.0.14? What kinds of
operations ha
> I disagree, you can restrict access to SELECT only
Sure, but no access is much more secure than restricted access.
> and plus
> any normal form
> on a web page has access to a DB in much more insecure ways
> (SQL injection,
> etc.),
What you consider insecure should not been written directl
I disagree, you can restrict access to SELECT only and plus any normal form
on a web page has access to a DB in much more insecure ways (SQL injection,
etc.), and as I said, it must be a 'real-time' progress meter without
refreshing the .php/.html page.
Javascript is not able to query the DB.
A
Hi,
(please reply to the list only)
> Yes thanks but how do I then add a new auto number field and still keep
the order?
What order? What has an auto-number have to do with what order?
Please explain your problem in detail - it might be completely clear to you,
but we're outsiders :-)
With reg
Hi,
Can anyone tell me what this option does, besides adding debug information ?
When I add this option, I get a working mysqld server. When I remove it and
recompile, my server won't work anymore
It looks like the server is started (hostname.err), but no pid file is
created
MySQL : 4.0
Hi,
> I need to add a new auto field to my db, but I need to make sure the
records are listed in order of one of the other fields first which is a date
field.
>
> Any ideas how I do this would be greatly appreciated!
"listing records" is in no particular order, unless you ask for an order.
SELEC
> I've scoured the web and can't seem to find any examples, and
> can't find
> anything that shows flash actually making the connection to
> mysql on its
> own. They all seem to rely upon PHP or something passing the value.
> Refreshing the page is not acceptable.
Flash is executed in the client
Have a need to do several queries, probably about 1 per second or so, and
the result of these queries will give me a # completed and a number total =
percentage done. I have an external program populating a db table and I want
to show progress on a web page till the program is done populating.
Doe
Hi,
I need to add a new auto field to my db, but I need to make sure the records are
listed in order of one of the other fields first which is a date field.
Any ideas how I do this would be greatly appreciated!
Thanks.
D.Hayhoe
This email has been scanned for viruses.
--
MySQL General Maili
68 matches
Mail list logo
