Hi i have just come across an issue where a word is not being searched up if there is
any punctuation ie. AMROZI'S will not be search upon if you type AMROZI , please help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Thanks. :-)
On another note, do you automate your sig in some way? And, more
importantly, does the access of the MySQL server to determine the quoted
statistics count as one query or more than one? :-)
Chris
quote who=Jeremy Zawodny
On Mon, Aug 18, 2003 at 04:09:01PM +1000, Chris Nolan wrote:
On Tue, Aug 19, 2003 at 04:10:12PM +1000, Chris Nolan wrote:
Thanks. :-)
On another note, do you automate your sig in some way?
Yup, I use mysig:
http://jeremy.zawodny.com/mysql/mysig/
But I havne't posted the code yet. Hmm. I've been meaning to do that
for about a year now. Bug me
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote:
I have an ibdata file that its size is 4.5GB, and it will increase
every day the max size of the hard disk is about 330GB, the question
is should I split this ibdata file in several files in a way that I
can reach this size?
Does
Does the version of mysqlbinlog match that of the server that wrote
the binlog?
I'm using MySQL 4.0.14 [linux]
mysqlbinlog version 1.6 [linux]
Regards
Jan Josefowicz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I've used a lot of Oracle, some MS Access and I'm newish to MySQL. I
found it easy to write an abstraction layer for Ms Access and Oracle
despite their different approaches to some important things. I find
MySQL very sparse by comparison and I spend more time working round the
db than working with
Dear all,
I have lot of problem due to scrolling .e.g. When i give
command select * from table-name .if the records are more than the srceen
width then i am unable to see all the records ,only last records are
visible.Is there any command suffix to SQL commands so that i may
Dear All,
Has the alpha release mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz
changed since April 12 2003? Just want to save myself a few hours
downloading...
I am putting it into production shortly, and was wondering too if there's
any news on the stable release of the same?
Thanks
Terence
I am hopping to get mysql compiled for arm in an i386 redhat pc.
I have the cross compiler and some arm distribution, the version of the
gcc is 2.95.3,
and mysql distribution is 3.23.57. (I also tried 4.0.14 withthe same
results/error)
I do a:
./configure --prefix=/usr/local/arm/arm-linux
Hello,
I have aproximately 1,000,000 rows and I would like to do some query. The
first one is to get the number of row so I do :
mysql SELECT COUNT(*) FROM `Log`;
+--+
| COUNT(*) |
+--+
| 969129 |
+--+
1 row in set (0.00 sec)
mysql SELECT COUNT(*) AS `Nb` FROM `Log`
sanjay gupta [EMAIL PROTECTED] wrote:
I have lot of problem due to scrolling .e.g. When i give
command select * from table-name .if the records are more than the srceen
width then i am unable to see all the records ,only last records are
visible.Is there any command suffix
Hello,
I have aproximately 1,000,000 rows and I would like to do some query.
The first one is to get the number of row so I do :
mysql SELECT COUNT(*) FROM `Log`;
+--+
| COUNT(*) |
+--+
| 969129 |
+--+
1 row in set (0.00 sec)
MyISAM tables keep a specific
Un beau jour, Nick Gaugler a écrit:
Hello,
I have aproximately 1,000,000 rows and I would like to do some
query. The first one is to get the number of row so I do :
mysql SELECT COUNT(*) FROM `Log`;
+--+
COUNT(*) |
+--+
969129 |
+--+
1 row in set (0.00 sec)
Arno [EMAIL PROTECTED] wrote:
I have aproximately 1,000,000 rows and I would like to do some query. The
first one is to get the number of row so I do :
mysql SELECT COUNT(*) FROM `Log`;
+--+
| COUNT(*) |
+--+
| 969129 |
+--+
1 row in set (0.00 sec)
mysql
Un beau jour, Victoria Reznichenko a écrit:
Arno [EMAIL PROTECTED] wrote:
I have aproximately 1,000,000 rows and I would like to do some
query. The
first one is to get the number of row so I do :
mysql SELECT COUNT(*) FROM `Log`;
+--+
COUNT(*) |
+--+
969129 |
Daniel Rossi [EMAIL PROTECTED] wrote:
Hi i have just come across an issue where a word is not being searched up if there
is any punctuation ie. AMROZI'S will not be search upon if you type AMROZI , please
help
Take a look at * operator which you can use in BOOLEAN MODE.
--
For technical
Terence [EMAIL PROTECTED] wrote:
Has the alpha release mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz
changed since April 12 2003? Just want to save myself a few hours
downloading...
4.1.1 will be released in September.
I am putting it into production shortly, and was wondering too if
thanks for the reply,
i have tried limit , but i want 10 records at a time and when i hit return
key i will show next 10 records, and so on. how i can achieve this .
sanjay
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 19,
Jan Josefowicz [EMAIL PROTECTED] wrote:
Does the version of mysqlbinlog match that of the server that wrote
the binlog?
I'm using MySQL 4.0.14 [linux]
mysqlbinlog version 1.6 [linux]
This version of mysqlbinlog can work properly only with 3.23 server binary logs.
--
For technical
I guess MySQL is a DBMS ans not a frontend.
thanks for the reply,
i have tried limit , but i want 10 records at a time and when i hit
return
key i will show next 10 records, and so on. how i can achieve this .
sanjay
- Original Message -
From: Victoria Reznichenko [EMAIL
hmm well sorry to be unclear i know this works but it would return more
results than needed also i cant expect users to add this themselves, like i
would have to add the astrerix to every word in that case like i do to get
all words ;\
-Original Message-
From: Egor Egorov [mailto:[EMAIL
sanjay gupta [EMAIL PROTECTED] wrote:
thanks for the reply,
i have tried limit , but i want 10 records at a time and when i hit return
key i will show next 10 records, and so on. how i can achieve this .
Use SELECT LIMIT 10, 10 to retrieve rows 11-20
sanjay
- Original Message
Hello,
I am having a problem when doing a SELECT. Here is the
scenerio:
I have a table that has an event StartDate and
EndDate, based on the current Date NOW() I need to
know which records are currently active. Can anyone
help with a quick SELECT statement?
Thanks.
=
On Tue, 19 Aug 2003 04:11:32 -0700 (PDT)
Rob Sirota [EMAIL PROTECTED] wrote:
Hello,
I am having a problem when doing a SELECT. Here is the
scenerio:
I have a table that has an event StartDate and
EndDate, based on the current Date NOW() I need to
know which records are currently active.
SELECT * FROM table_name WHERE EndDate now();
Is this what you need?
-Original Message-
From: Rob Sirota [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 4:12 AM
To: [EMAIL PROTECTED]
Subject: Help with SELECT statement for date range
Hello,
I am having a problem when doing a
Hi,
try this:
SELECT * FROM your_table
WHERE StartDate NOW()
AND EndDate NOW()
Hello,
I am having a problem when doing a SELECT. Here is the
scenerio:
I have a table that has an event StartDate and
EndDate, based on the current Date NOW() I need to
know which records are currently
[snip]
Table name campuses
inst_id, name, zip_id, state (inst_id is an auto-increment integer data
type)
The CSV file has the following format
Name, zip, state
For example:
ACADEMY OF ART COLLEGE,94105,CA
In phpMyAdmin I go to SQL - Insert data from a textfile into table,
then
fill in the
Hey all,
I have 3 databases replicating (ver 3.23) A to B and B to C
On C I want to modify one of the tables and add a column. Tables A and
B will not have this new column added. Will this cause a problem
replicating data form B to C?
Thanks,
Jeff
--
MySQL General Mailing List
For list
On moving my data files from /var/lib to /mnt/ramdisk I seem to be missing
something. I've changed every .ini and .conf file I can find (/etc/my.cnf,
/etc/init.d/mysql, /etc/init.d/mysqld, /etc/php.ini and
/etc/httpd/conf/httpd.conf (for DAV-lock)). MySQL seems to start ok, but
when I use my
MySQL is pretty good about following symlinks. Move /var/lib/mysql to
/mnt/ramdisk/mysql and then symlink to it.
# ln -s /mnt/ramdisk/mysql /var/lib/mysql
Changing where everything resides in my.cnf should have been sufficient
but the symlink way works great as well. And there should be no
* sanjay gupta
i have tried limit , but i want 10 records at a time and when i
hit return key i will show next 10 records, and so on. how i
can achieve this .
Depending on your OS, you could try something like this:
$ mysql -e SELECT * FROM tablename database | more
It won't give you 10
Hello all,
Sorry to post this again, but I go not response and was really hoping
someone can help me as this is a mission-critical problem. I have 3
slave MySQL servers (4.0.13) replicating from a master machine
(4.0.13). The master machine is running only MySQL while the slave
machines
Would anything happen to the database if I ran myisamchk --silent
/usr/data/mysql/*/*.MYI when I havent run FLUSH TABLES first?
As it states in the documentation:
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and
ensure that no one is using the tables while
In one of my logfiles I have quite repeatedly the following message:
InnoDB: Warning: using a partial-field key prefix in search
What does this warning mean ?
Regards,
Marc Mechain
Atos Origin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I've been trying to solve this problem for a long time. Only thing
I did when upgrading from 3.25 to 4.0.14 I took the default my.cnf. I
did not convert the privilege tables with mysql_fix_privilege_tables.
Suddenly, the mysql started to show all databases to all users (even
though the
No, it doesn't realize that the file size is about 330GB. To best
performance is better split the ibdata in several files? or should I have
only one?
Thanx
From: Jeremy Zawodny [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Miguel Perez [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
My web site is pulling from several tables that don't change all that often
and seems to be an ideal candidate for query caching. I tried to enable it
by copying the my-medium.cnf to /etc/my.cnf and restarted the service. From
my query editor I typed SHOW VARIABLES LIKE 'QUERY_CACHE_TYPE' and it
Luc Foisy [EMAIL PROTECTED] wrote:
Last week many of our server and client servers had a power problem. Not quite sure
how the servers were handled, wasn't on site, but I don't think some of these
servers got shut down gracefully. but anyways that shouldn't matter to my question
I ran
Vladimir Trebicky [EMAIL PROTECTED] wrote:
I've been trying to solve this problem for a long time. Only thing
I did when upgrading from 3.25 to 4.0.14 I took the default my.cnf. I
did not convert the privilege tables with mysql_fix_privilege_tables.
Suddenly, the mysql started to show
Further investigation shows that Qcache_free_memory = 0,
Qcache_free_blocks=0, and Qcache_total_blocks=0. So it seems that the cache
is enabled but no sizes/limits have been allocated? Could someone tell me
what I need to add/modify to my my.cnf file to set those? Or are these
variables indicating
Landers, Jason [EMAIL PROTECTED] wrote:
My web site is pulling from several tables that don't change all that often
and seems to be an ideal candidate for query caching. I tried to enable it
by copying the my-medium.cnf to /etc/my.cnf and restarted the service. From
my query editor I typed
I'm a relative newbie to MySql, and I've got a small project I'm working
on and hopefully you folks can either point me in the proper direction
or give me a little help.
I have multiple spreadsheets in Excel format and in .csv format too,
that I would like to possibly import to a mysql database.
You guess correctly :) I set the variable in my config file and the query
cache does seem to be working. The counters are incrementing and it's
caching the majority of my queries (it says).
I do notice a very slight improvement in the performance but it's not as
fast as I was expecting. I guess
[snip]
Basically I need a way to import them from the Excel sheet to the
database so at that point I can manipulate the data and use a php script
of some sort to run a whois after extracting the domain name, and then
return the results to the database and have it attached to the domain
name.
Hi, I am writing a Web app that inserts Referring and Requesting
addresses into a MySQL database. On some of these URL strings the
INSERT statement will insert all the other fields but not the URL.
There are no errors and 95% of the time the entire record inserts
perfectly. What the?
I am also working on something like this but am taking a different approach.
Basically I'm creating an Excell Add-in in VBA that adds a button to the
Excel toolbar. When a user clicks it I take the highlighted rows and columns
and verify that they are in the proper format and everything looks good
1.2Ghz Pentium, with 1/2Gig of ram, 4.0.14MySQL, RedHat9.0
I have about 20K records that result from the following query. Front end for the
database is ACCESS97 and pulling up 20K records makes a huge performance hit.
For the form in question I am using PASSTHROUGH type query (the one that just
VR What do you mean didn't work properly'? What exactly was
VR wrong with mysql_fix_privilege_tables?
Sorry, cannot reproduce the error. The result was that some of the
tables were corrected, some not. Anyway, even old privilege tables
shouldn't IMHO cause the SHOW DATABASES to work. In addition,
I went thru the documentation this weekend on it and found that there is
really not to much to this database. One thing we learn as Oracle DBA's is
how the whole database starts up and how all those processes work together
and where to find bottlenecks when things start to bog down.It didnt
You might also like the INNODB table type for which there is a fairly
large online manual at http://www.innodb.com/ibman.html
-Original Message-
From: Johnson, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 12:48 PM
To: 'Andy Jackman'
Cc: MySQL Users
Subject: RE:
Michael,
The reason you think there's not much to this database is that compared
to Oracle, there really is not much to this database. :-)
From a 50,000-foot point of view, it's really just a nice SQL interface
to ISAM files (it started out that way, anyway). It is designed for
I have a table with a Longtext field in it. This is a field which I would
like to print out, but I only wish to print a couple of lines of data from
this field for each record.
I'm using PHP with $row=mysql_fetch_row function and then printing out that
row as one of of the fields.
Can someone
If you are using *nix, fire up the mysql command-line client and type the
following:
\P more
Then hit enter. That forces the client to pass all of its output through
the more command and will thus return a screen's worth of records at a time.
\P will pipe the client's output through whatever
On Tue, 19 Aug 2003 12:42:44 -0500
Sean Meegan [EMAIL PROTECTED] wrote:
I have a table with a Longtext field in it. This is a field which I would
like to print out, but I only wish to print a couple of lines of data from
this field for each record.
I'm using PHP with $row=mysql_fetch_row
On Tue, Aug 19, 2003 at 09:12:03AM -0400, Jason McCormick wrote:
Hello all,
Sorry to post this again, but I go not response and was really hoping
someone can help me as this is a mission-critical problem.
Please don't take this the wrong way, but mission-critical problems
should be sent
Hello,
I am using the mysqlclient library 4.0.14 on win2k.
It works fine but there are memory leaks I have no solutions for.
I have tried this:
int _tmain(int argc, TCHAR* argv[], TCHAR* envp[])
{
MYSQL MySQL;
mysql_init(MySQL);
I am having another problem with replication in mysql 4.0.13. The
slave server crashed and upon re-starting there was a new relay-bin
log file created and the old relay-bin log file remained. MySQL,
however seemed to be stuck on the old one. The slave reported to be
running fine according to
On Tue, Aug 19, 2003 at 02:51:28PM -0400, [EMAIL PROTECTED] wrote:
I am having another problem with replication in mysql 4.0.13. The
slave server crashed and upon re-starting there was a new relay-bin
log file created and the old relay-bin log file remained.
Right. It needs to finish with
Hallo User,
diese eMail wurde automatisch als Antwort auf Deine Nachricht generiert und bestaetigt
Dir die Uebernahme in unser Bearbeitungssystem.
Wir werden schnellstmoeglich antworten. Bitte ein wenig Geduld, wir vergessen
niemanden. Solltest Du Information sofort benoetigen, rufe uns bitte
Hallo User,
diese eMail wurde automatisch als Antwort auf Deine Nachricht generiert und bestaetigt
Dir die Uebernahme in unser Bearbeitungssystem.
Wir werden schnellstmoeglich antworten. Bitte ein wenig Geduld, wir vergessen
niemanden. Solltest Du Information sofort benoetigen, rufe uns bitte
Please don't take this the wrong way, but mission-critical problems
should be sent thru MySQL's official support channels. Otherwise
you're at the mercy of a bunch of volunteers...
I don't. :) I use a lot of free/open software. I've found that the
volunteers are often better then paid
I may be trying to do too much in a single query here, but it would be nice if I could
get it working! Apparently, the version of MySQL used by my work does not support the
WITH ROLLUP feature, otherwise I think that would work.
What I have are 3 tables: gc_info, amends, payments.
'gc_info'
Thomas Deliduka unknowingly asked us:
and then it ran the mysql_select_db which selected the wrong table.
Please re-read, re-phrase. I have an uncomfortable feeling when people
use the wrong function for the wrong purpose.
I'm an idiot, I should have looked for this before.
Think to think more.
At 03:18 PM 8/19/2003, you wrote:
I may be trying to do too much in a single query here, but it would be
nice if I could get it working! Apparently, the version of MySQL used by
my work does not support the WITH ROLLUP feature, otherwise I think that
would work.
What I have are 3 tables:
Is it possible to resort the rows in a table like in a query where using
ORDER BY, but have to new sort order stored in the table structure?
--
anders thoresson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I have two tables, contact_account and contact.
contact_account has two fields: contact_id (pk) and account_id
contact has a PK of contact_id
I to select all the columns in contact where account_id=13
I tried:
SELECT * FROM (contacts INNER JOIN account on contact.contact_id =
I would like to set up a round robin cluster with mysql. The round robin would be
done through the DNS to two different servers. Each of those servers would have mysql
installed and each would reference the same data directory on our SAN. Are there any
problems with doing this?
Thanks in
On 19 Aug 2003 at 13:17, Jack Lauman wrote:
I have two tables, contact_account and contact.
contact_account has two fields: contact_id (pk) and account_id
contact has a PK of contact_id
I to select all the columns in contact where account_id=13
I tried:
SELECT * FROM (contacts
ALTER TABLE table ORDER BY col
--from the manual--
ORDER BY allows you to create the new table with the rows in a specific order. Note
that the table will not remain in this order after inserts and deletes. In some cases,
it may make sorting easier for MySQL if the table is in order by the
In the last episode (Aug 19), anders thoresson said:
Is it possible to resort the rows in a table like in a query where using
ORDER BY, but have to new sort order stored in the table structure?
CREATE TABLE newtable AS SELECT * FROM oldtable ORDER BY myfield
newtable will have its records
* Jack Lauman
I have two tables, contact_account and contact.
contact_account has two fields: contact_id (pk) and account_id
contact has a PK of contact_id
I to select all the columns in contact where account_id=13
I tried:
SELECT * FROM (contacts INNER JOIN account on
Is it a bug or a feature that with the conditions
1. INNODB is not configured in my.cnf
2. Table type is specified as INNODB
that when you create the table there is no warning,
and no syntax error, and the table type silently
and Microsoft-like, defaults to MyISAM?
Now, if you specify table
Hi,
This version of mysqlbinlog can work properly only with 3.23 server binary logs.
is there a mysqlbinlog version that matches to MySQL 4.0.xx?
Regards
Jan Josefowicz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I am unable to find any information about master-master replication. I
need to replicate 1 mysql server over to other as a standby master
server.
Any help ? Any ideas at all ?
-
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
anders thoresson unknowingly asked us:
Is it possible to resort the rows in a table like in a query where using
ORDER BY, but have to new sort order stored in the table structure?
If you use PhpMyAdmin (latest version), follow these steps:
1. Select your table by clicking on the left.
2. Choose
I'm sure there's gonna be some file locking issues.. If you just trying to
get some scalability, might want to look at replication instead, with the
SAN hosting 1 copy of the database for each server..
On Tue, 19 Aug 2003, Scott Pippin wrote:
I would like to set up a round robin cluster with
I've got a library of PHP code whose first line is a mysql_connect
statement, like this:
$dbh=mysql_connect() or die(mysql connect failed: $php_errmsg);
Approximately 1% of the time it just fails, for no stated reason:
Warning: mysql_connect() [http://www.php.net/function.mysql-connect]:
in
I keep getting a syntax error, when trying to run this query (perl script):
SELECT * FROM temp_hits WHERE url NOT IN SELECT * FROM hits
Ive tried with brackets around the last SELECT statement ... no better ...
(Essentially, the tables hits, new_hits and temp_hits hold the same columns,
Try
SELECT * FROM contact INNER JOIN contact_account ON
contact.contact_id=contact_account.contact_id WHERE
contact_account.account_id = 13
At 04:17 PM 8/19/2003, Jack Lauman wrote:
I have two tables, contact_account and contact.
contact_account has two fields: contact_id (pk) and
Dan F wrote:
Thanks for your reply! Very helpful.
Presumably, I can read about SET FOREIGN_KEY_CHECKS = 0; and it will
only apply as long as the file is running, or I can turn it back on at
the end of the whole process.
Out of curiosity, are you saying mysqldump of a whole DB does some
sort
At 16:36 -0400 8/19/03, [EMAIL PROTECTED] wrote:
Is it a bug or a feature that with the conditions
1. INNODB is not configured in my.cnf
2. Table type is specified as INNODB
that when you create the table there is no warning,
and no syntax error, and the table type silently
and Microsoft-like,
Thanks for your reply! Very helpful.
Presumably, I can read about SET FOREIGN_KEY_CHECKS = 0; and it will
only apply as long as the file is running, or I can turn it back on at
the end of the whole process.
Out of curiosity, are you saying mysqldump of a whole DB does some sort
of global lock
If you are using a MySQL version allowing subselects, try this:
SELECT * FROM temp_hits WHERE url NOT IN(SELECT * FROM hits)
use parenthesis not brackets
hope it helps
Allen
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Soren O'Neill
Sent: Tuesday, August 19, 2003
Are you connecting through a TCP or a UNIX domain socket?
--Michael
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Jon Drukman
Sent: Tuesday, August 19, 2003 2:36 PM
To: [EMAIL PROTECTED]
Subject: PHP mysql_connect randomly failing
I've got a library of
Patrick,
Thanks! But - same result... It was worth a shot, however I still got 12 instances of
'amend' instead of 1.
If I can't work it out, I'll just split up this one query into two and see about using
PHP to do the math. Not something I wanted to do, but it should work just as well.
Thanks
See the attached file for details
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear you!
I try to install MySQL Server and Client 4.0.14b.
I will use this together with the program ZOBB.
(http://www.z-wp.com/zobb/index.php)
This ZOBB need to leg SQL be placed at C:\ but I selected D:\
Then I install at C:\ but get problem.
Now I can not UNINSTALL and I can not DELETE
So my problem below still exists, but I think I have a better way (and SQL example) to
describe what's going on. Consider the following SQL:
SELECT gc_info.award,amends.amend,payments.paid
FROM gc_info
LEFT JOIN amends ON gc_info.gc_number=amends.gc_number
LEFT JOIN payments ON amends.gc_number
unix domain.
Michael S. Fischer wrote:
Are you connecting through a TCP or a UNIX domain socket?
--Michael
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Jon Drukman
Sent: Tuesday, August 19, 2003 2:36 PM
To: [EMAIL PROTECTED]
Subject: PHP mysql_connect randomly
Just look at amazon. There are more books popping up all the time.
The manual with user comments is the best.
http://www.mysql.com/doc/en/
Paul DuBois wrote a good book that helped me get started on a few things.
This one is a newer one I think.
Thank you for submitting your request to Quest Software Technical Support. We are
unable to process your request because our records indicate that you are not
registered for Technical Support.
To register, logon to our Supportlink web site http://www.quest.com/support , and
self-register
I have a large list of email addresses that I have found are undeliverable
to users, I want to mark a field in mysql to 1 where there is this email
address, how can I do this in one go from a \r file.
Something like
update mytable set bad_email = 1 where email_address =
hi,
the power outage in ontario caused my server to crash. after i booted up
again it was as if the past 18 hrs never happened. all the changes to the
database were gone. is there anyway to recover the missing data? it's
probably too late now since new data has been put into the database
The MySQL client won't be able to do that on its own; you'll need to
write a script in your favourite scripting language to do that.
--Michael
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 9:00 PM
To: MySql
Subject: marking all
I need to generate record counts for each month in a year, just one year at
a time, but a full year at a glance.
I am thinking 12 hits to the DB is perhaps not the most idea way to do it,
is there a way to rip this out in one go?
--
-
select count(*), monthname(yourfield)
from yourtable
where year = '2003'
group by monthname(yourfield)
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:38 PM
Subject: month by month count
I need to generate record
Can someone please tell me if my problem with the punctuation in a fulltext search is
a bug or limitation? Ultimately the users of the system i built do not want to have to
try using the + search then trying the * search for all the words which will
obviouslly return a lot of results, is there
97 matches
Mail list logo
