Daniel Kasak wrote:
>Mauricio Pellegrini wrote:
>
>
>
>>Hi,
>>I need to select the max value from a set of records but I also need the
>>primary key for that record.
>>
>>The problem is that the record id may not be the same as the record max
>>
get the following result
>
>Id x_col date_col
>4 1 2005-04-12
>
>and what I would like to get is
>
>Id x_col date_col
>3 1 2005-04-12
>
>
>
That *is* what you'd get. The max() function works on an individual
column, not on all c
f. If you want to use logging for
backup purposes, use the binary logging format.
Also, in this section [mysqld] add:
query_cache_type= 1
query_cache_size= 16M
and restart mysql. This should give you a nice performance hit - how
much will depend on how efficient phpbb2 is - with
ing incremental history tracking rather
than data duplication but I suppose that one's too far off since it should
normally be implemented at the storage engine level.
Any thoughts on the best way to implement this using MySQL 4.1 are highly
appreciated.
Thank you,
Daniel
- Original
or its ability to
perform best on a given SQL engine (MySQL in this case). Not being that
familiar with the inner workings of MySQL though, I can only submit the
module above to the attention of MySQL specialists who may have the time to
post back their thoughts.
Thanks,
Daniel
"Daniel BODEA
ptimal indexing.)
So, if anybody has practical eperience about these issues, please give me some
advice.
Thank you,
Daniel
On Sat, 09 Apr 2005 12:50:42 -0400, Michael Stassen wrote:
>
> On Apr 9, 2005, at 8:05 AM, olli wrote:
>
>> hi,
>> if your table is indexe
nyone have experience with extremely large databases?
Thank you,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
oduction-quality requirements.
Thanks,
Daniel
> I am not familiar with the use of the adjective "temporal" with the word
> "database". To me "temporal" means "of or having to do with time or it's
> measurement". Could you have meant "temp
people may have been
referring to this thing in other terms.
And so I'm asking : Are there any obvious resources I've missed or would it
be simpler just to post the issues in here ?
Thank you,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Tom Crimmins wrote:
>On Wednesday, March 30, 2005 22:25, Daniel Kasak wrote:
>
>
>
>>update
>>_cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
>>on LNT.Line=TLP.Line
>>inner join TelecomAccountPosting TAP
>>on TLP.
7;group by
TLP.Line'
Looks right to me...
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailin
Robert-
I apologize for not being clearer.
The operating system is Windows 2003 Server.
Dan
-Original Message-
From: Robert Dunlop [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 3:09 PM
To: Daniel Cummings; mysql@lists.mysql.com
Subject: Re: mysqlconnecernet not closing
I posted this late last Friday. I'm hoping everyone missed it and that
someone has an answer. :-)
We have a quote server on both a 2003 server and an XP machine. The quote
server is an asp.net server.
The XP machine is closing the connections without a problem.
For some reason
>
>
3 million records in an Access database! The hairs on the back of my
neck are still standing on end :)
Good plan on upgrading to MySQL.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922
couldn't say. The DBI drivers aren't marked as stable yet on my distro
( Gentoo ), so be careful there.
If you use ODBC, you will have to upgrade to the latest version of
MyODBC - which has some bugs so scan the MyODBC mailing list first.
--
Daniel Kasak
IT Developer
NUS Consulting Group
between
>vertebrates (which I'll use the most) and
>invertebrates.
>
>Thanks.
>
>
mdb is a binary format, and contains data, forms, reports, queries, vb
code and other 'stuff'.
There is an mdbtools project on sourceforge:
http://mdbtools.sourceforge.net/
I'm p
r:
where
some_field > x
in the case where a NULL value is detected in y, or:
where
some_field < y
in the case where a NULL value is detected in x
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+6
We have a quote server on both a 2003 server and an XP machine. The quote
server is an asp.net server.
The XP machine is closing the connections without a problem.
For some reason the mysqlconnecernet is not closing the connections when
used on the 2003 server.
It connection count climbs to
targetting ( Access developers wanting to migrate
to Linux ), so I'd be very interested to hear what you think,
suggestions, feature requests, etc.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9
qld will
quit with a SIGSEGV signal.
SELECT post_urltitle
FROM evo_posts
WHERE post_urltitle
REGEXP '^erster_eintrag(_[0-9]+)?$' AND ID <> 0;
>How-To-Repeat:
Just execute the just provided SQL expression on the
same FreeBSD system.
>Fix:
No idea.
>Submitter-Id:
>O
Hi,
I have been trying to construct an SQL query joining two tables for an image
gallery.
I want to display all the IMAGE_CATEGORIES along with the first image in
that category from the IMAGES table. The images are ordered by an integer
field called IMAGE_ORDER.
Here's what I have so far:
I'm pleased to annouce the 8th release of Gtk2::Ex::DBI ...
http://entropy.homelinux.org/Gtk2-Ex-DBI/
Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl
apps data aware. It handles querying, 'painting' records on your
Glade-generated form, passing updates back to the database s
lTimer - Funciones Locales - Graba_Recibido:
Error #3151 (Línea: 285) (Source: DAO.Database) ODBC--connection to
'{MySQL ODBC 3.51 Driver}dellserver' failed.
You may find out more info on what's causing your problems by checking
the mysql logs. For example, is Access taking
re.
I'm not sure if you can use the pipe symbol as an OR operator in the way
you want - to be honest I haven't used it at all in SQL.
Try rewriting it to use nothing but case statements ( no | operators ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
Nort
Osvaldo Sommer wrote:
Daniel:
The program is an interfase for a weigth system in a Retail
environment.
The program query the weigth system for new data every 200 miliseconds,
if new data is received it has to be stored in the database. The table
has automatic correlative, the data in ascii, the
server error
3151.
What I can do to fix the problem?
Osvaldo Sommer
Provide more details.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http
e and
will have to re-apply your patches, and do full regression testing, for each
MySQL upgrade/version.
Under such loads even the slightest memory leak or resource locking can
really mess things up.
Good luck.
-Daniel.
-Original Message-
From: Michael Loftis [mailto:[EMAIL PROTECTED]
Sen
the client side and/or middle tier
anyway.
Just my $0.02 worth.
-Daniel.
-Original Message-
From: Michael Loftis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 2:45 PM
To: mysql@lists.mysql.com
Subject: mysql error logging
OK I've honestly banged my head against everyi
the data the correct way, and change it back to a date or
datetime field
Hope it helps :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nus
for utf8?
The only way to get things to work is to set charset to utf8 for everything,
and utf8_bin collation for everything as well. (connection, db, tables)
Cheers,
-Daniel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
cally every day in this forum and the
MyODBC forum - sometimes a couple of times a day!!!
It does pay to do *some* research before installing a new version of
anything, to see if there are going to be any issues!!! You certainly
wouldn't have had to look far to stumble across this one!!!
!!
Jim McAtee wrote:
Say a row is inserted into a table with an auto_increment column and
then deleted before another record is inserted. When a new row is
inserted, will the value of the auto_increment column be the same as
the deleted record's, or will it be one greater?
Greater.
--
D
t can only read it ( you have to set the correct permissions
here too of course ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.c
uot;. You find a way to make it happen ... or
if you can't you at least don't start blaming your software for what is
obviously a hardware issue.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (
ou're experiencing.
Post ALL details you can. Give examples of queries, error messages,
query execution times, table sizes.
You can't just say "lots of overhead". I'm not even sure what you're
referring to when you say "overhead".
--
Daniel Kasak
IT Developer
NUS Consu
saction or 2, and
continued on it's way.
There's nothing like a UPS though. Or better yet, a UPS, daily backups,
and a transaction log.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9
Chuck Flowers wrote:
mySQL Mailing List test
Luckily there are only very few people who do this, otherwise I'd spend
my whole day deleting people's test messages.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+
I am not really experienced on this, but i have noticed that simply
truncating an innodb table doesnt reset the autoinc key, u have to redump
the table.
I cant see what you are trying to do here
ALTER TABLE users auto_increment = 590;
set it to start @ 590 ?
> Hello,
> I am trying to get auto_
> Daniel,
>
> It's really not clear to me exactly what you want. For example, what
> do you mean by file numbers? Perhaps if you could tell us a little
> more about your table, your query, and the result you want, we could
> provide a solution.
>
File number = Job
> At 04:35 pm 2/16/2005, you wrote:
>>Hi there is there any way at all that with a special field type mysql
>>can generate file numbers like so AUD-01 then AUD-02
>>AUD-00010 etc ... Let me know.
> You can get the 01, etc via something like SeqItem int(6) unsigned
> zerofill auto_i
x27;, '45' becomes
> '45', etc ). Then shove the 'AUD' bit at the start.
> Using an integer as the primary key you'll get faster joins, searches
> etc than using a string fields as the primary key.
>
> --
> Daniel Kasak
> IT Developer
>
hen do the formatting in code ( ie pad '1' to '01', '45' becomes
'45', etc ). Then shove the 'AUD' bit at the start.
Using an integer as the primary key you'll get faster joins, searches
etc than using a string fields as the primary key.
--
D
Hi there is there any way at all that with a special field type mysql can
generate file numbers like so AUD-01 then AUD-02 AUD-00010
etc ... Let me know.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
> Does anyone know where I can find in-depth, precise instructions to
> install MySQL on Mac OS X Panther client?
>
> - Asad
>
Just get the binary for OSX and follow the readme its simple.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
my previous post I think I said to use 'cast(ud.StartTime as
varchar(50))', which doesn't work - I wasn't near a MySQL install, but
the basic idea is right, you just have to search for 'cast' on the mysql
web site to get the correct usage ( varchar isn't one o
Dan Wareham wrote:
Hello,
I have a table in my database with two fields set as Time types.
The issue I seem to have is when I use an ADO connection in VBA for
Excel to select the two fields.
Instead of the expected format HH:MM:SS held within my recordset, I
get the current date in the format DD
I'm pleased to annouce the 7th release of Gtk2::Ex::DBI ...
http://entropy.homelinux.org/Gtk2-Ex-DBI/
Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl
apps data aware. It handles querying, 'painting' records on your
Glade-generated form, passing updates back to the database
I have worked out, to send that field to the where query, i have to select
the outer table again !!
i dont think this is very efficient ?
select * from complaints, (SELECT IF (count(*) > 1,"Yes","No") AS count
FROM complainant ccINNER JOIN complaints c ON cc.complainantID=c.complainantID
WHERE
c.
Hi there, I was wondering if its possible to be able to send a field
from the outer table to be used as the where statement for the sub
query ?
something like this
select somefield from table 1, (select count(*) from table2 inner join
table1 using somekey where table1.key=somefield) as alias
w
Jerry Swanson wrote:
Does binary logs are avaialbe in Mysql 4 or only in Mysql 5?
Thanks
On Thu, 10 Feb 2005 10:28:56 +1100, Daniel Kasak
<[EMAIL PROTECTED]> wrote:
Jerry Swanson wrote:
Is it possible to do "daily incremental backups" on mysql?
Thanks
MySQL 4.x
umentation for mysqldump
and for processing the binary transaction logs.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.a
On Tuesday 08 February 2005 08:09, Joachim Klöfers wrote:
> Hi, all
>
> I hope somebody can help me.
>
> Many thanks in advance
> Joachim
That is a very thorny problem. May I observe that you will find things much
easier, if you add unique primary keys to tables 2 & 3, thus:
ALTER TABLE ADD p
a new connection and insert records via it, then it won't be
affected by a rollback on the 1st connection.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: htt
excellent tutorial:
http://www.sitepoint.com/article/hierarchical-data-database
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
d the
new authentication system.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list arch
Thanks, works fines.
I use access because i don´t know a GUI tool that make SQL querys more easy.
Thanks all again,
Daniel Sousa
- Original Message -
From: [EMAIL PROTECTED]
To: Daniel Sousa
Cc: mysql@lists.mysql.com
Sent: Wednesday, 26 January, 2005 14:57
Subject: Re
anguage_id WHERE
(((categories.parent_id)=285) AND ((languages.languages_id)=1))
i run this query in my computer and work, but in the internet server don´t.
If anyone can solve this problem answer me.
Daniel Sousa
to stick with open
source solutions. MySQL gets far more testing with open source languages
than with C#, and your tech support for open source systems is going to
be far better as well.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydne
I have a pretty standard database schema here with the primary key prod_id
being my most often used join column in select queries. Categories, rankings
.. just about anything having to do with products uses prod_id in a join,
and user access on these queries is pretty heavy.
I wonder whether the p
eries that span multiple lines
...change databases when appropriate before queries
...add the ; to the end of the query
an option to only reprocess unique queries might also be nice.
has anyone already done this?
daniel
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: M
Daniel Gaddis wrote:
does anyone know of a utility that will processes the query log to rerun
the queries?
The program would need to...
...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add the ; to
query
an option to only reprocess unique queries might also be nice.
has anyone already done this?
daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phing modules around for Perl, but I don't think
there's anything as nice as JPGraph. If there is, I'd like to know about
it :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 992
Hi all.
Does anyone know if there are any issues with PHP-4.1 and MySQL-4.1?
I assume I'll have to recompile PHP ( and Perl and other stuff that
talks to MySQL ), but other than that, are there any gotchas I should
know about?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level
The program would also need to handle...
...queries that span multiple lines
...change databases when appropriate before queries
yes I could program such a beast but I thought someone else might have
already done it.
daniel
-Original Message-
From: Andy Davidson [mailto:[EMAIL
is there a utility like mysqlbinlog but instead processes the query log?
I would like to reprocess the queries from the query log.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is there a utility like mysqlbinlog but instead processes the query log?
I would like to reprocess the queries from the query log.
additional features that would be nice would include:
listing unique queries
the number of times each unique query is executed
Thanks,
Daniel
--
MySQL
On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote:
> Daniel,
>
> it is simply processing big SELECT queries. Maybe their optimization
> changed lately? You should tune your queries.
>
> You should also tune InnoDB, because you are running with the default 8 MB
> buffer pool si
> please post the complete outputs of
>
> SHOW PROCESSLIST;
>
> and
>
> SHOW INNODB STATUS
>
> during such CPU peak.
>
> > Daniel
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> Foreign keys, transactions, and row level locking for MySQL
&g
nyone out there ever
seen a problem like this in the past, or could anyone shine some light on
what might be causing it?
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
As you may know, the mambo (open source CMS) table names
begin with a “#” character. How does one describe a table that
begins with “#”?
-DK
Daniel Kemper
Lead Programmer
Intellisys, Inc.
wow this is a massive feat, 5 will make many people proud, 4.1 has done
the same aswell as 4.0.Well done, if you need testers for solaris or OSX lemme
know. I also had a
question thoughregarding INNODB and fulltext searching, when is this going to
be made
available or if ever ? I'vehad to do pat
Hi all.
I'm pleased to announce the 5th release of Gtk2::Ex::DBI ...
http://enthalpy.homelinux.org/Gtk2-Ex-DBI/
Gtk2::Ex::DBI is a helper object that makes your gtk2-perl apps data
aware.
Changes in this release:
- Formatting changes in sourcecode. I bought myself a copy of Komodo,
and decided t
Chip Wiegand wrote:
How do I copy all data only from one table into another table? Both tables
are in the same database. I have phpMyAdmin and it suppossedly does this,
but it is not working, and there are no error messages.
Thanks,
--
Chip
create table table_2
select * from table_1
--
Daniel
g ).
What I do is try MyISAM tables to start with, and as more people start
to use the table ( and get the above error ), I convert them to InnoDB
tables, and don't get any more problems.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Aus
x27;re better off checking
out the performance tuning guides available on the MySQL website. The
query cache is particularly effective for us.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
ema
;t know. See my above comments.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives
than it solves. See above example.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing Lis
sounds like what you want is a primary key.
Do you have one in your table?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
Daniel Kasak wrote:
Write your script with the following line at the top:
tee /path/to/output/file.sql
Actually thinking about this more, you can probably skip this bit and
just direct your output from the command called by cron, as per
Spenser's example.
ie:
mysql -u username -ppas
hould work. At
least I use each of the individual parts at one point or another, but
never all together.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website:
ee profilespage heheheh. Little bit about me, I am a PHP/Mysql/Java/Unix/Flash
Actionscript 2 developer fora Tv station in Sydney building business level web
applications.
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>>
> The keyword UNION should ensure that all duplicate rows are removed
> from the combined result set. If you use UNION ALL instead of UNION,
> the duplicates are left in the result set.
>
Yeh right, funny, early versions of 4.0, UNION had in the docs this was
only avail in 4.1, i am so sure i
ring the initial data set according to some
predefined criteria which wouldn't have left any possibility of ordering the
results according to however I eventually wanted them.
Daniel
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Daniel BODEA" <[EMAIL PROTECTED]
Hi all.
Is there an official / unofficial list of MySQL icons around somewhere?
It's for a application launcher bar...
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [
to myself the (disputable of course) impossibility
of this thing using one trip only.
Daniel
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Daniel BODEA" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 26, 2004 3:41 PM
Subject: Re: Query
o back and
forth between the server and the client so I ruled this one out.
Now unless there is another simpler and miraculous solution that I haven't
thought of, I have to find out which one of these alternatives is the best
one speed-wise so any help on this is sincerely appreciated.
Dan
than what you can get from putting your data into a
filesystem. I haven't done it myself, but I've seen it mentioned in the
mailing list. Check the archives / web site. I think you have to use
InnoDB to use raw partitions, but I might be wrong.
Dan
--
Daniel Kasak
IT Developer
NUS Cons
Thanks for verifying that.
Dan
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 12:23 PM
To: Daniel Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Insert Delayed
I verified the same error for myself, and then found:
http://bugs.mysql.com
We have what is called a data grabber for quotes that is inserting rows into
both InnoDb and MyIsam tables.
When the data is being imported ( inserted ), it is dramatically slowing
clients down that are running queries against the table.
Our first attempt at a solution was to insert one row at
Does "Insert Delayed" work on any version of MySql for INNODB tables?
The docs state that it does but I keep getting the error that the engine
doesn't support this.
TIA
Dan
h for a
3-field job :)
What OS are you developing for?
Do you want any scripting? What language?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
web
ant make PK.
Reg,
Eldo.
count(1) is the same as sum(1)
After thinking more about the 'group by' clause, I think I was wrong to
start with. You don't have to concat() the fields, and can use the above
clause.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Hi
. Try something like:
select sum(1) as number_of_duplicates, concat(member_id, '___',
message_id) as my_problem
from message_inbox
group by concat(member_id, '___', message_id)
having sum(1)>1
Have fun.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
No
t's well outside the scope of the mailing list, and I've never really
used RedHat apart from my first 3 months of Linux, so I don't want to
give you advice that will mess up your system, but it looks like either
your X installation is broken, or too old.
--
Daniel Kasak
IT Develop
* the name of it with ./ eg:
cd /path/to/binary
./mysql-query-browser
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
I am working on a replacement GINA (Graphical Identification and
Authentication) for the University I work for. It is a DLL written in C
and I need to add mysql connectivity to it.
I am writing this in Visual Studio 2003. It took me forever to get all
the MySQL API's libs to link correctly bu
function for this:
update table X set field1=replace(field1, 'functionalities',
'functionality') where tableid=1;
http://dev.mysql.com/doc/mysql/en/String_functions.html
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2
Patrick Connolly wrote:
|> Last time I checked ( which was a while ago ) the only difference I
|> found was that table & field names weren't case sensitive under Windows
I think you mean ...table and database names
Yeah that too.
Like I said, it was a while ago.
--
MySql doesn't support Guids but we were attempting to use a VarChar. We set
the VarChar to binary, but from what I'm reading the binary setting doesn't
affect storage just sorting and evaluations.
I was able to get the binary storate I needed in a TinyBlob but I can't set
this to a primary key
401 - 500 of 1341 matches
Mail list logo
