Hello,
MySQL has been running smoothly on my machine for the past month. This morning I
installed PHP 4.3.2 and now I can't seem to get MySQL running anymore.
I get the following error message:
# Starting mysqld daemon with databases from /var/lib/mysql
030616 11:19:03 mysqld ended
Any clues?
Hi,
Does anyone know of any written stats on how much overhead for CPU/ Disk
IO replication has for a single master and a single slave?
I am looking for any detailed stats on the proformance issues associated
with replication.
thanks
-Nathan
--
MySQL General Mailing List
For list archives
manual
on table types and decide which is best for you. AFAIK there is no "pack" option for
MyISAM.
# Nathan
- Original Message -
From: "savaidis" <[EMAIL PROTECTED]>
To: "MySQL list (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 12
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
Get rid of the second "values".
mysql> INSERT into book(
-> isbn,
-> title,
-> authlname,
-> authfname,
-> publisher,
-> pubdate,
-> dewey,
-> lcnum
-> )
-> values (
-> '1-56592-434-7',
-> 'MySQL & mSQL',
-> 'Yarger',
-> 'Randy Jay',
->
... ?
# Nathan
- Original Message -
From: "Mark Stringham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 10:22 AM
Subject: Re: table backups
2 quick questions -
1. What is the Windows equivelant to a cron job. I would like to perform a
-
From: "Mark Stringham" <[EMAIL PROTECTED]>
To: "Nathan" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 11:26 AM
Subject: Re: table backups
Ok - I am going to show my complete ignorance here now.
How do I configure my
ave tried a few things and it's beyond me at the moment... any insights would be
greatly
appreciated!!! Further info is definitely available if needed.
Thanks!
# Nathan
-
Before posting, please check:
http://www.mysql
Well after reviewing the DELETE section of the manual, I see nothing to suggest that
it supports
multiple-table deletes...
# Nathan
- Original Message -
From: "Daren Cotter" <[EMAIL PROTECTED]>
To: "Nathan" <[EMAIL PROTECTED]>; "Daren Cotter" &
like.
Does that not fit in with your plans?
# Nathan
- Original Message -
From: "Forer, Leif" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 11:56 AM
Subject: SELECT this IF that
I want to select and join data from two tables if the same id
e.
Cheers,
# Nathan
- Original Message -
From: "Alainq" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 3:34 PM
Subject: Summarize
Dear,
I am stuck on something,
I would like to summarize multiple columns to a total value in a query and
the
If you're going to post this much information please use:
mysql> SELECT * FROM user \G
so that this is actually readable.
Thanks
# Nathan
- Original Message -
From: "Brian Warn" <[EMAIL PROTECTED]>
To: "'Daniel Negron/KBE'" <[EMAIL PROTE
You could also bypass the num_rows entirely...
".$query);
echo '';
for ($i=0; $row = mysql_fetch_assoc($result); $i++) {
echo ''.($row["field"]).'';
}
echo '';
?>
# Nathan
- Original Message -
From: &q
If you hadn't read up on this yet, the attachment AnnaKournikova.jpg.vbs which is
accompanying Mr.
Arora's e-mail is a virus. McAfee doesn't know what the damage is, because it was
created by a worm
that changes the damage slightly for every lucky recipient. Just a heads up.
Ch
I sincerely hope this is the result of a virus.
# Nathan
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 8:54 AM
Subject: TheCasino.com: Registration Confirmation
TheCasino.com - Serving ''Winners'
Read the MySQL manual, it is very well written and will tell you exactly how to create
any index you
like. Try here: http://www.mysql.com/doc/O/p/Optimizing_Database_Structure.html
# Nathan
- Original Message -
From: "Miguel Enriquez Alvarado" <[EMAIL PROTECTED]>
To: &
wires. :-)
# Nathan
- Original Message -
From: "Colin Faber" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 30, 2001 7:03 PM
Subject: Re: How to turn beeping off
>
>
> Hey now, why would you want to turn it off, After all its a `fe
No it is not. Reserved word list: http://www.mysql.com/doc/R/e/Reserved_words.html
I think Richard's problem is the NULL. You could do default NULL, but I think NULL by
itself doesn't
mean anything to mysql (in a create table, anyway).
- Original Message -
From: "rc" <[EMAIL PROTECTED]
ed to select into a temp table or my php form, get it all in the right
order, then insert
it back into table2?
Thanks!!
# Nathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Jason
The forums at http://forums.devshed.com aren't half bad either... Apache, PHP, MySQL,
HTML/Javascript...
# Nathan
- Original Message -
From: "Paul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 4:28 PM
Subject: Re: Is th
er to read!
Cheers,
# Nathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
T
But if this is the MyISAM table type, and you performed an insert, then a delete, your
MAX + 1 would
get the next value of the series, but the auto_increment will actually use MAX + 2.
Correct? Is
there a system call to find out what MySQL will use next rather than the highest + 1?
# Nathan
system.
# Nathan
- Original Message -
From: "JC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 12:10 PM
Subject: renaming a database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm kind of interested to find if there is a wa
SELECT DATE_FORMAT(date_column, %j) AS newdate FROM table
$j = Day of year (001...366)
- Original Message -
Sent: Friday, February 01, 2002 1:57 PM
Subject: Determining day of year
Hi, folks.
I have what I hope is a simple problem. Hope someone can help.
I have a database with a da
Hi;
I have run into 'potholes' with CMP beans on Sun's Java App Server 8.1.
While googling around I [think I] see that Sun's Server doesn't really
'like' mysql. (When it comes to CMP beans.)
Question: Honest please! Is this supposed to work? (Nothing fancy, not
even auto generated pk.)
What's t
Hi;
On FC3, for some silly reason, Yum deleted my mysql 4.1x production server!
I do have my data. Now that I am in this hole, maybe I should go to mysql 5.
Can I install mysql 5, and it will migrate/work with my existing data?
Thanks,
-nat
Hi;
I have been running this server, 4.1.14 on Linux FC 4 for while, no problems.
Yesterday I fiddled with my.cnf via the Administrator console to,
tried some graphs, and also turned on binary logs.
Later in the day, (don't think it was immediate after the server
process restart, but maybe), the JB
On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x.
I have an Innodb table with over 20 million records and index size
about 3.7 gig, data size 2.2gig (yes, many indexes, more space then
the data itself). Last night I tried an Optimize from the Admin gui
console (logged in as root at the host
Does anybody know what it is I can do to start to get around this
problem?
Thank you very much in advance,
Nathan Whitington <><
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi;
A while ago, I changed most of my myisam based tables over to innodb. Fine.
A while later, I noticed and implemented the option to keep the files separate.
Now, weeks later, I still have a huge, 7 gig ibdata1, plus many *.ibd files.
Can I delete ibdata1? What worries me is that when I have new
Hi;
Is there a formula I can go by in order to estimate how long it would
take to change over from innodb to myisam. Say for a 100meg file, a 5
gig table, etc.
Thank you;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi;
Mysql 4x on Linux Fc4.
In /var/lib/mysql there is an ibdata1 file. Also in this directory I
also have various database folders, with *.ibd data files. I would
like to locate the ibdata1 somewhere else, say, /usr/extraData/mysql.
I am confused as how to set *innodb_data_file_path* as well as
*in
On 12/20/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> Please, next time answer to the list as well.
Sorry. I didn't realize Gmail's 'reply' didn't go to the list. First
time I noticed the 'reply to all' option in Gmail. Thanks.
> As far as I know, you can't specify the location
Hi;
[Mysql 4x] In a table where I get data from another program, I have
many records (about 1000) that have illegal chars in a [unique]
indexed varchar field. I would like to clean the illegal characters
out and leave the rest of the data intact.
1. Is there a utility to do this?
1b) Or an UPDATE c
On 12/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Nathan Gross <[EMAIL PROTECTED]> wrote on 12/20/2005 05:34:58 PM:
>
> > Hi;
> > [Mysql 4x] In a table where I get data from another program, I have
> > many records (about 1000) that have ille
On 12/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Nathan Gross <[EMAIL PROTECTED]> wrote on 12/21/2005 11:20:50 AM:
>
>
> > On 12/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > Nathan Gross <[EMAIL PROTECTED]>
On 12/21/05, JamesDR <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
>
>
> >
> > I get two lists from different sources which I merge into the database
> > via a Java program. Since these two lists themselves sometimes get
> > their data from the same
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> >>Nearly every mysql client library has some kind of function to perform this
> >>escaping for you. Please refer to the manual of the client library you are
> >>using to see
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> >>/* hint: java.sql.PreparedStatement */
> >
> > I thought we are talking about a mysql specific function, which would
> > not be in the vanilla j2se/j2ee pkg's. Actua
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> > Woa! Let me verify. If I pass a qry string:
> > "SELECT Anyfield from Anytable where Anyfield = 'The man was 100% correct'
> > "
> > to a Connecto
On 12/21/05, Mark Matthews <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Nathan Gross wrote:
> > On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> >> Nathan Gross wrote:
> >>
> >>>> /* hint
Yesterday I installed the XAMPP (used to be called LAMP) stack, which
includes mysql 5.0.18, on a Fedora Core 4 system. This seems like the
quickest way of getting version 5 running WITHOUT clashing at all with
my current install.
Everything went 100% smooth, and I was able to copy my 4.x myisam
ba
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
Thanks
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Aye. -v. thanks!
-nat
On 1/26/06, Pooly <[EMAIL PROTECTED]> wrote:
> 2006/1/25, Nathan Gross <[EMAIL PROTECTED]>:
> > Hi;
> > My query.log is full of 'show innodb status' queries.
> > How do I get this ascii log file not to log these. OR some help with
I recently changed all my ibd files to MYISAM. Can I safely remove the
ibdata file and restart mysql?
Thanks;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Sorry] I didn't realize that hitting Reply (using Gmail) sent a
private message. Usually on lists the message ends up on the list.
Will need to observe the header in the future.
tx;
-nat
On 1/27/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> Please, next time always CC your messages t
On 1/27/06, Imran Chaudhry <[EMAIL PROTECTED]> wrote:
> > Hi;
> > My query.log is full of 'show innodb status' queries.
> > How do I get this ascii log file not to log these. OR some help with a
> > grep script to copy the file without these lines.
>
> I noticed the same in the logs of a 4.1 test s
Hi guys
Please tell me the command syntax, how to add a colmmen foreign key in
alter syntax
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Neil,
You can turn on the general query log by adding a line like this to your
configuration file:
log=/var/log/mysql_queries.log
Regards,
Nathan
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, May 27, 2009 9:13 AM
To: [MySQL]
Subject
Ray,
You can use the results of a query in a join with something like:
select tmp.id, t1.id
from (some_query_selecting_id) as tmp
join t1 on t1.id=tmp.id
Hope that helps.
Regards,
Nathan Sullivan
-Original Message-
From: Ray [mailto:r...@stilltech.net]
Sent: Tuesday, June 02, 2009
Hello
I want to fetch and calculate the data from remote database(for example
Japan) and insert them into my local database(for example usa), does
mysql have such function to do it, or do I have to write a script using
perl or other language to help achieving it?
thank you in advance
nathan
John,
I think this should work:
UPDATE members SET email=REPLACE(email, SUBSTRING(email,INSTR(email,'@')+1),
'Thanks_in_advance.com.com')
Regards,
Nathan
-Original Message-
From: John Furlong [mailto:john.furl...@rakutenusa.com]
Sent: Monday, June 29, 200
(date_field_3 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 3
else 4
end, date_field_3, date_field_2, date_field_1;
Hope it helps..
Regards,
Nathan
-Original Message-
From: Ravindra Harige [mailto:ravindra.har...@gmail.com]
Sent: Thursday, July 02
day))) then 2
when (date_field_1 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 3
else 4
end, date_field_3, date_field_2, date_field_1;
-Original Message-
From: Nathan Sullivan
Sent: Thursday, July 02, 2009 1:07 PM
To: 'Ravindra Harige&#x
server or database to
calculate timestamps of it
thanks in advance
nathan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
f) to avoid that locking is to
break the operation into two steps: 1) store the result of the select in a
file or something 2) load the result into the destination table. Perhaps
somebody else knows of a better solution...
Regards,
Nathan
-Original Message-
From: Walton Hoops [mailt
Matt,
If you went with option #3, you could avoid the looping by using (tCount - 1)
as the LIMIT in the delete statement instead of always using 1.
Regards,
Nathan
-Original Message-
From: Matt Neimeyer [mailto:m...@neimeyer.org]
Sent: Tuesday, July 14, 2009 8:58 AM
To: mysql
Carlos,
I think this does what you want: (untested though)
UPDATE identities
SET email=replace(email, 'mail.', '')
WHERE email like '%mail.iamghost.com'
Regards,
Nathan
-Original Message-
From: Carlos Williams [mailto:carlosw...@gmail.com]
Sent: Wedne
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote:
> On 10/8/2009 4:19 PM, John Oliver wrote:
> > 1) When I select * from whatever; is there a way to have the results go
> > by one screen at a time?
> >
>
> You can limit output by delimiting your search ie
>
> select * from users li
Brian Dunning wrote:
> Hey all -
>
> I need a few million sample contact records - name, company, address, email,
> web, phone, fax. ZIP codes and area codes and street addresses should be
> correct and properly formatted, but preferably not real people or companies
> or email addresses. But th
s for optimising this design? Or where
to start from? One option and at the moment the only option I have is
to denormalise my schema but this will complicate stuff at the
application level considerably.
Any suggestions welcome,
Nathan
--
MySQL General Mailing List
For list archives:
I think you want to do something like this:
select prod, group_concat(category separator ', ')
from products
group by prod;
Hope this helps.
On Wed, Apr 07, 2010 at 08:37:04AM -0700, kalin m wrote:
>
> hi all...
>
> i have a bit of a problem with this:
>
> table products:
>
> --
Paul,
I think you could accomplish this by adding a subquery to your where clause,
like:
AND NOT EXISTS (SELECT * FROM mappings m where m.src_ip=src_ip)
Hope that helps.
Nathan
On Tue, Oct 12, 2010 at 03:19:36AM -0700, Paul Halliday wrote:
> I have 2 tables: events and mappings.
>
Bryan,
Maybe something like this would work?
select 1296158500 - (1296158500 % 3600)
Hope that helps,
Nathan
On Thu, Feb 24, 2011 at 08:41:58AM -0800, Bryan Cantwell wrote:
> How would I go about modifying a unix timestamp to actually represent
> the 'top of the hour' th
Hi,
I ve recently been playing with storing trees in mysql using nested
set, and I was wondering if anyone knows if this could be extended to
forests (set of trees) to be stored in one table?
Many Thanks in advance,
Nathan
--
MySQL General Mailing List
For list archives: http
nline manual is
just confusing me.
Thanks.
-- Nathan Christiansen
Software Engineer
Tahitian Noni International
http://www.tahitiannoni.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
x(t2.weird, '-', -1)
)
where
t1.key =
and
t1.id = t2.id;
-- Nathan Christiansen
> -Original Message-
> From: Nathan Christiansen
> Sent: Thursday, January 29, 2004 3:49 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL outer join with substring_
I have a php page which displays quite a bit of dynamically calculated
data which I need to be sortable using different SQL statements.
Currently to display this data, a user browses to the page, the page
checks for a cookie, if the cookie doesn't exist it includes some php to
generate a temporary
Kind of what I was thinking of. How can I generate a unique identifier?
-Nate
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 2:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Temporary table issues. Do I need persistent connections
with ph
work fine
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = 3
and
select ROLE_ID from ACL_ROLE where ROLE_NAME = 'projectmanager'
cheers
Nathan
--
Nathan Coast
Managing Director
codeczar ltd
mobile: (852) 9049 5581
email: mailto:[
Hi,
is it possible to extract the ddl for a table or whole db? ie the ddl
that would be needed to re-create that table. JBoss automatically
creates some tables during ejb deployment and I want to move this to a
manual process.
cheers
Nathan
--
Nathan Coast
Managing Director
codeczar ltd
Hi,
Is it possible to modify parameters passed to prepared statements?
e.g.
select ...
where username like '%?%'
I'd like to put wildcard chars '%' on either end of a parameter. Is
this legal? or do I have to modify the parameter before passing it to
mysql.
than
te to text data.
more than happy to read the docs, just need a pointer to which docs I
should be reading :)
thanks
Nathan
--
Nathan Coast
Managing Director
Codeczar Ltd
mob : (852) 9049 5581
tel : (852) 2834 8733
fax : (852) 2834 8755
web : http://www.codeczar.com
--
MySQL General Mailing List
Fo
To any Moderators: This is the only time I will send this message.
Dear List Members,
I am seeking a co-op/paid internship in a Computer Science related
field. If you or someone you know, directly or indirectly, works for a
company that deals with Computer Science, i.e. Computer Programming,
ple
Hello everybody,
We have a few Linux/MySQL boxes and recently we have been having some
problems with one of our databases. We have checked out the usual things
(hardware, disk quotas, table limits etc...) and we have spent several
days looking over newsgroups and other postings with no luck. We are
er if others have had
problems with this particular binary.
-nb
Victor Pendleton wrote:
How is this table accessed and updated? Do you have file contention issues?
Is the MySQL message 145?
-Original Message-
From: Nathan Boeger
To: [EMAIL PROTECTED]
Sent: 7/30/04 9:40 AM
Subject: File size
in advance,
Nathan E. Pierce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to any hosts due to exception:
java.security.AccessControlException: access denied (java.net.SocketPermission
127.0.0.1:3306 connect,resolve)
SQLState: 08S01
VendorError: 0
Nathan E. Pierce
Quoting Sergei Skarupo <[EMAIL PROTECTED]>:
> Generally applets are an
nd "select" syntax?
Any help would be much appreciated.
Thanks,
Nathan
--
Nathan Mealey
Director of Operations
Cycle-Smart, Inc.
P.O. Box 1482
Northampton, MA
01061-1482
[EMAIL PROTECTED]
(413) 587-3133
(413) 210-7984 Mobile
(512) 681-7043 Fax
--
MySQL General Mailing List
For
Is it possible to install 2 versions of MySQL, 4.0.x and 4.1.x, on the
same system? Do you just have to ensure that they are installed in
separate, distinct, directories?
Thanks for any help/advice!
Nathan
--
Nathan Mealey
Director of Operations
Cycle-Smart, Inc.
P.O. Box 1482
Northampton, MA
Has anyone out there had any trouble installing DBD::MySQL for MySQL
4.1.x on Mac OS X 10.3? I have tried it on several machines in my
company's office, but it fails on all that are running 4.1.x, and
installs fine on those running 4.0.x
Thoughts?
Thanks,
Nathan
--
Nathan Mealey
Direct
SELECT city, state, SQRT( POWER( (
latitude - 39.039200
), 2 ) + POWER( (
longitude + 95.689508
), 2 ) ) AS distance
FROM geographics
WHERE distance <1
ORDER BY distance
LIMIT 10;
Returns:
#1054 - Unknown column 'distance' in 'where clause'
Are alias not allowed in WHERE clauses?
I am able to
ct_id, company_name, product_name, url, description
FROM product, company
WHERE product.product_id = company.company_id AND description regexp
'#FORM.query#'
Thanks for your help,
Nathan
_
Help STOP SPAM with the new MSN 8 a
id AND
company_name regexp '#FORM.query#' AND
product_name regexp '#FORM.query#' AND
description regexp '#FORM.query#'
Also what about indexes?
Thanks in advance for your help.
Nathan
On Fri, 22 Aug 2003 23:28:18 +
"Nathan Simms"
ctual
data? Thanks for your insights!
Nathan
show table status;
---+-+++
---+
| Name | Type | Row_format | Rows| Avg_row_length | Data_length
| Max_data_length | Index_length | Data_free | Auto_increment | Create
mysql> explain select distinct AccountLevelId from PostedZpdi;
++---+---+-+-+--+-+-
+
| table | type | possible_keys | key | key_len | ref | rows|
Extra |
++---+---+-+--
>
> From: Haydies [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 11:19 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Select distinct speed on an indexed column
>
>
> Its a compound key, they are always slow. I would imagin you will need to
> seriously redesign your database to speed t
Well, it's an InnoDb database and has some decent memory pools.
| innodb_additional_mem_pool_size | 33554432
| innodb_buffer_pool_size | 536870912
-Original Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 11:47 AM
To: Nathan Cassa
Yeah, I have a similar box like yours. I copied the first column to a new
table with an index. I ran select distinct and the query took 6 seconds to
execute. This must have to do with the record length, because when I indexed
the origional table's first column the query was 1 minute 30 seconds to
I'm looking for a way to select data from one table that is not found in
another. I am sorting on a column called 'model_id'. Basically I want
something like this to work:
"SELECT t1.*, t2.model_id FROM data1 as t1, data2 as t2 WHERE
t1.model_id != t2.model_id"
t1 has about 1000 entries and t
I'm relatively new to MySQL, and I'm writing a PHP script that doesn't know
what kind of system the MySQL database is on. The script and database
don't have to be on the same system, so I need a way to determine what kind
of system (*nix, Win, etc.) MySQL is running on. Is there a "fool proof"
than
try to create it and find out it can't be created because it already
exists. An alternative (which is actually better) would be a query to
determine case sensitivity, but I can't figure out how to get that info
from MySQL either.
At 02:43 AM 11/11/2003, Matt W wrote:
Hi Nathan
I've seen this question posted in various forms on the web, but not in
such a way that I have found helpful. I have a column of data in the
following format name.xx.yy where the x's and y's represent numbers.
When selected by mySQL, the column is sorted in an odd way, given by the
following exampl
How do you merge duplicate rows? All rows involved contain identical data
in each column.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d from the "title"
column are not bringing up any results (for known-item searching).
The query against this index was: >SELECT * FROM articles WHERE MATCH
(title,text) AGAINST ('search_term');
Am I missing something? Is the query I wrote above incorrect?
Any help would be
On Wed, 2004-05-05 at 22:49, Paul DuBois wrote:
> At 22:39 -0400 5/5/04, Nathan Jones wrote:
> > > Hi there,
> >>
> >> I seem to be having a problem retrieving the last inserted ID for a
> >> table.
> >>
> >> The query I am using is as
> Hi there,
>
> I seem to be having a problem retrieving the last inserted ID for a
> table.
>
> The query I am using is as follows:
>
It's far easier than anyone else has mentioned, as of my writing. Just
use the PHP function 'mysql_insert_id()' after your insert query. This
function has bee
create
instance if MySQLProv.
And the other thing is what version of mysql supports multple sql commands
in the one statement eg.. Select 'nathan' ; insert into tablename(field)
values(1)
any help would be super ;)
Kind Regards
Nathan Franklin
TSN Internet
[EMAIL PROTECTED]
MSN: [EMAIL
urned from
your query.
Hope this saves a few people some agony.
# Nathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
1 - 100 of 139 matches
Mail list logo
