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
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.
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.
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.
SELECT
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 :
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
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
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 directly to
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
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
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 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 a
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
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
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 data
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:
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
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, 2003 6:53 PM
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 online manual is
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 record
[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 Ideas what this
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
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
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
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
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
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.0.12
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
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){
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
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
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,
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
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
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
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
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,
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
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
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:
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
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 explain what
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
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
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:
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
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
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
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 =
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
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:
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 I
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
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 string in
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
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]
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
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_increment
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:
On Tue, 2003-11-25 at 10:24, [EMAIL PROTECTED] wrote:
snip
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?
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 ..
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
--
Dan
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]
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 and
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]' Table 'danamon.[trx_temp2]' doesn't
exist
I'm sure the trx_temp2 table in danamon database
exists.
I'm
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
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
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
68 matches
Mail list logo
