to maintain the trigger when
adding new milestones.
Any other options I'm missing ??
Regards
Phil
Why not just use a union ?
select userID,NULL as clientID from user where userCodeDrivingLicense =
'321321321' union select NULL as userID,clientID from client where
clientCodeDrivingLicense = '321321321';
2011/5/6 Rocio Gomez Escribano r.go...@ingenia-soluciones.com
Tables client an user
could write something in perl or php to run through each and update them
but was wondering if there is a way to do this within mysql itself? The
regexp only returns a boolean so I can't see how to use that.
Regards
Phil
--
Distributed Computing stats
http://stats.free-dc.org
: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 10
ref: stats.a.proj
rows: 1
Extra: Using where
2 rows in set (0.00 sec)
I could just remove the order by altogether and perform the sort in php
afterwards I guess but any other ideas?
Thanks
Phil
?
- michael dykman
On Thu, Sep 9, 2010 at 1:53 PM, Phil freedc@gmail.com wrote:
I wonder if anyone could help with a query which I've been unable to
prevent
from using a filesort. Might be something obvious I'm overlooking!
I have a table which tracks milestones in distributed computing
by is, in effect a sorting
process.. perhaps that contains enough data to justify going to disk.
What is the value of the variable sort_buffer_size?
show variables like '%sort%';
- md
On Thu, Sep 9, 2010 at 3:04 PM, Phil freedc@gmail.com wrote:
On average it would be between 10 and 40
in my.cnf, will cause mysql to run out off MEMORY and
paging will happen
regards
anandkl
On Fri, Sep 10, 2010 at 1:10 AM, Phil freedc@gmail.com wrote:
Even prior to the group by it's still not likely to ever be more than 200
or
so maximum.
I have the sort_buffer_size at 256Mb so I don't
of Created_tmp_disk_tables
before and after your query to see for sure.
-Travis
-Original Message-
From: Phil [mailto:freedc@gmail.com]
Sent: Thursday, September 09, 2010 11:54 AM
To: mysql
Subject: Trying to remove a filesort.
I wonder if anyone could help with a query which
create table TableDEF like TableX;
Or am I missing something ??
On Tue, May 11, 2010 at 11:36 AM, mos mo...@fastmail.fm wrote:
I'd like to get the field names and data types of a table, say TableX, and
put it into TableDef using nothing but SQL. I know I can list the table
definition using
For the exchange rates only you don't really need more than one table. I
work with an enterprise financial system and we have exchange rate tables
which are updated with data every day.
Something like
BASE_CURR char(3)
NONBASE_CURR char(3)
EFF_DATE DATE
EXCH_RATE DECIMAL(15,6)-- or
Try Chartdirector, available in many languages..
http://www.advsofteng.com
Regards
Phil
On Mon, Nov 16, 2009 at 12:38 PM, Mikie k...@mikienet.com wrote:
Hello MySQL list people!
I need software that will graphically plot 2d line charts vs. time for
various data points from a MySQL
You are missing a BEGIN in the trigger
delimiter |
CREATE TRIGGER greylist AFTER INSERT on greylist
BEGIN
delete from greylist where first_seen NOW()-60*60*24*5;
END;
|
delimiter ;
Phil
On Wed, Nov 4, 2009 at 2:28 PM, Stefan Onken supp...@stonki.de wrote:
Hello,
I am new to using
to their own!
Phil
On Wed, Nov 4, 2009 at 5:40 PM, Gavin Towey gto...@ffn.com wrote:
Oops, one more mistake:
NOW()-60*60*24*5 isn't the way to do date math. It should be: NOW() -
INTERVAL 5 DAY
-Original Message-
From: Gavin Towey
Sent: Wednesday, November 04, 2009 2:33 PM
To: 'Phil
|
| b |800 | team1 |
| c |906 | team2 |
If not, is there an easy way to have another column, say mostteam char(10)
and run an update statement on the whole table which would put the correct
value in?
Regards
Phil
--
Distributed Computing stats
http
How about something like
select account,customer,max(total) from (select
account,customer,sum(sale_amount) as total from tablename group by
customer) as y group by account;
Seems to work in my test case..
Regards
Phil
On Tue, Jan 6, 2009 at 3:13 PM, Jerry Schwartz
jschwa
form of cursor wrapped around the group by to
get the top20 for each account.
Sorry about that!
Phil
On Tue, Jan 6, 2009 at 3:59 PM, Jerry Schwartz
jschwa...@the-infoshop.comwrote:
-Original Message-
From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
Phil
Sent
Am I totally missing something? Why do you believe the two queries should
return the same # of rows? First one has a qualification of proj_adv_date
'2008-12-16' whilst the second one does not...
On Mon, Dec 15, 2008 at 12:12 PM, Néstor rot...@gmail.com wrote:
I have a char fiel where I am
Just a wild guess but, did you perhaps change the filesystem to a
journalling filsystem when moving to the different server?
I once accidently moved my database from an ext2 to an ext3 partition and it
took me a while to figure out the degradation of queries..
Phil
On Wed, Sep 24, 2008 at 6:16
I did something similar to this recently. I ended up using the following
select date_sub(curdate(), interval(dayofweek(curdate()) + (($week - week) *
7) - 1) DAY) as mydate.
This was in php and ahead of time I set $week as select week(curdate()).
It could easily be extended with year.
Phil
?
Phil
--
Help build our city at http://free-dc.myminicity.com !
-pxxx status. This would write lock information
into the machine.err log file. Check in this file also if there is any
locking happening.
R u sure, this disk is a FASTER disk then the earlier one.
On 7/21/08, Phil [EMAIL PROTECTED] wrote:
Hi All,
Given a fairly simple table as follows
cached
Phil
On Mon, Jul 21, 2008 at 9:41 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
when you run this update, what is the IO WAIT from the top command.
regards
anandkl
On 7/21/08, Phil [EMAIL PROTECTED] wrote:
Nothing else running and no queries go against that table, it's
effectively
So just use REPLACE instead of INSERT...
http://dev.mysql.com/doc/refman/5.0/en/replace.html
On Mon, Jul 21, 2008 at 11:44 AM, mos [EMAIL PROTECTED] wrote:
At 08:23 PM 7/20/2008, Perrin Harkins wrote:
On Sun, Jul 20, 2008 at 12:12 AM, mos [EMAIL PROTECTED] wrote:
Is there a way to get
to ext2. Users RankRAC and
rankinteams was dramatically dfferent.
Phil
On Mon, Jul 21, 2008 at 12:39 PM, Wm Mussatto [EMAIL PROTECTED] wrote:
On Mon, July 21, 2008 09:14, Brent Baisley wrote:
Copying 5GB files shows you what kind of performance you would get for
working with say video
missing.
Phil
--
Help build our city at http://free-dc.myminicity.com !
OLD_TABLE old group by
old.x)
works fine...
Any ideas ?
Phil
On Wed, Jul 9, 2008 at 1:07 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
you should say group by old.x and not old.a
On 7/9/08, Arthur Fuller [EMAIL PROTECTED] wrote:
I think that you need to select old.a otherwise you cannot group
As cats1 ON cats1.ParentId = cats.catid
LEFT JOIN vb_ldcats As cats2 ON cats2.ParentId = cats1.catid
LEFT JOIN vb_ldcats As cats3 ON cats3.ParentId = cats2.catid
Phil
On Tue, Jul 8, 2008 at 3:45 PM, Jim MacDiarmid [EMAIL PROTECTED]
wrote:
I'm hoping someone can help me with this. I have a table
Regards
Phil
--
Help build our city at http://free-dc.myminicity.com !
read_buffer_size=16M
query_cache_size=64M
query_cache_limit=8M
table_cache=100
max_connections=250
max_heap_table_size=64M
myisam_sort_buffer_size=64M
wait_timeout=3000
On Mon, Jun 9, 2008 at 3:54 PM, Gerald L. Clark
[EMAIL PROTECTED] wrote:
Phil wrote:
I have a table as follows containing approx
Just a very quick guess but is innobd engine running ?
SHOW STATUS like '%inno%'
On Wed, Jun 4, 2008 at 6:44 PM, Stut [EMAIL PROTECTED] wrote:
On 4 Jun 2008, at 23:10, Stut wrote:
HELP!!
Our database just died. SHOW TABLE STATUS shows the message in the status
line for every table except
it as an ASC index.
Same can be done with dates.
Not always applicable, but it works and is fairly easy to implement.
Phil
On Tue, May 20, 2008 at 2:20 PM, Bof [EMAIL PROTECTED] wrote:
Hi all -
Is there a good workaround for mysql's lack of 'DESC'
functionality when creating an index?
I'm
yes, you'd have to alter the queries to use the new index. As I say it's
very application dependent and does not always apply, but you can normally
shoehorn any application to use it.
Phil
On Wed, May 21, 2008 at 9:22 AM, Bof [EMAIL PROTECTED] wrote:
Hi Phil -
Thanks for the suggestion
I'm sure if you created an index on
client_id,client_unit_id,transaction_date (with optionally something else to
make unique) it would increase performance.
What does an EXPLAIN give you?
Phil
On Tue, Apr 22, 2008 at 11:41 AM, Bruno B. B. Magalhães
[EMAIL PROTECTED] wrote:
Hi everybody,
I
Not knowing your msqyl version, perhaps it's the form of your LIMIT clause.
try LIMIT 0,10 instead.
Phil
2008/4/22 liaojian_163 [EMAIL PROTECTED]:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from
I would have thought your not = though is matching a lot more rows every
time..
I would look into using where not exists as a subselect
delete from bar where not exists (select 'y' from foo where foo.phone =
bar.phone);
something like that.
On Tue, Apr 15, 2008 at 5:00 PM, Patrick J. McEvoy
an AVG for a
string, or a median perhaps.
Regards
Phil
--
Help build our city at http://free-dc.myminicity.com !
You need to escape the apostrophe first
so
select count(*) from table where field like '%\'%'
On Tue, Mar 25, 2008 at 2:37 PM, Saravanan [EMAIL PROTECTED] wrote:
hi lists,
I want to count the number of rows containing ' aphostrophe in a
particular field. I tried with
select count(*) from
Are the table structures identical ?
If so, you could just move the data files themselves.
Otherwise consider using
unload from table B into TAB seperated format (mysql load format)
truncate table A
load data infile into table A
On Thu, Mar 20, 2008 at 2:20 PM, Daniel Brown [EMAIL PROTECTED]
you could do something like
select dummy.row_id,real.reference from dummy left join real on
real.row_id=dummy.row_id;
would give NULL on the 'missing' rows,
On Wed, Mar 12, 2008 at 12:50 PM, roger.maynard
[EMAIL PROTECTED] wrote:
Anyone got any bright ideas of how to solve this one?
I have
mysqldump from the commandline. You are most likely running into php
execution time limits using phpmyadmin
OR you could probably just copying the underlying files, .frm,MYI and MYD
I've successfully done that with myisam databases going from version 4 - 5
on tables exceeding 50M rows. Not sure
In my never ending quest for speed ups I've been trying the following..
I pull in xml data for roughly (at the peak) 1.8M hosts from the BOINC
[EMAIL PROTECTED] hosts files.
Each host will have a unique id, a score, createdate and possibly a country
team (as well as a number of other
Just inheritance from an old design that has passed it's limits.
I actually have a development version which does just that, but there is a
lot of work to convert many php scripts and sql to include the new column.
It's some way away from live though, so the problem I outlined still exists.
Phil
to figure out what limits are being hit
without success.
Would certainly appreciate any pointers to look at..
Phil
On Thu, Feb 28, 2008 at 11:19 AM, Phil [EMAIL PROTECTED] wrote:
I'm trying to figure out which limits I'm hitting on some inserts.
I have 50 plus tables lets call them A_USER, B_USER
is causing it?
Regards
Phil
Awesome!
Thanks Baron, works perfectly..
Phil
On Tue, Feb 26, 2008 at 10:06 PM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi!
On Tue, Feb 26, 2008 at 7:04 PM, Phil [EMAIL PROTECTED] wrote:
I have a table countrystats defined as
CREATE TABLE IF NOT EXISTS `countrystats` (
`proj
I'm confused as to why you need the subselect at all?
As it's all the same table why can't you just use
select candidate,count(*) as total from vote where voter '$me' group by
candidate order by total
desc;
On Wed, Feb 27, 2008 at 9:04 AM, Olav Mørkrid [EMAIL PROTECTED]
wrote:
hello
i
Ok then, so
select candidate,count(*) as total from vote where (voter '$me' and
vote =1) group by candidate order by total
desc;
On Wed, Feb 27, 2008 at 9:37 AM, Olav Mørkrid [EMAIL PROTECTED]
wrote:
hi phil, i forgot to mention one thing.
the table also has a column called vote which
I have a table countrystats defined as
CREATE TABLE IF NOT EXISTS `countrystats` (
`proj` char(6) NOT NULL default '',
`country` char(50) NOT NULL default '',
`score` double default NULL,
`nusers` int(11) default NULL,
`RAC` double default NULL,
`last_update` double default NULL,
Hello!
I am looking for an easy solution for eliminate duplicates but on a row
level.
I am having 2 tables. 1 destination for all not duplicated info (a)
and 1 for input table (b) which might have duplicates related to table
a. Now I am using this kind of insert:
INSERT INTO a
I'm trying to write an update which generates ranking data for a table.
Table is as follows
CREATE TABLE `A` ( `id` INT NOT NULL ,
`score` DOUBLE NOT NULL ,
`projrank` INT NOT NULL ,
`other` VARCHAR( 10 ) NOT NULL
) ENGINE = MYISAM
Real table actually contains 30 or so more fields but it gives
I've read the notice AND tried to unsubscribe TWICE. I still get the mail.
++
Phil Robbins
Auckland
New Zealand
++
_
Need more speed? Get Xtra Broadband @
http://jetstream.xtra.co.nz/chm/0
++
Phil Robbins
Auckland
New Zealand
++
_
Discover fun and games at @ http://xtramsn.co.nz/kids
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Why am I suddenly getting huge volumes of mail about SQL? What forum is
this, and how do I get out of it?
++
Phil Robbins
Auckland
New Zealand
++
_
Find the coolest online games @ http
Why am I suddenly getting huge volumes of mail about SQL? What forum is
this, and how do I get out of it?
++
Phil Robbins
Auckland
New Zealand
++
_
Discover fun and games at @ http
This is quite odd. I have five .asp pages all using
the exact same connection code. For some reason, one
of the pages is getting a No Database Selected
error, yet the other four are not, which leads me to
believe my DSN config works fine. Below are the
details.
Getting the following error:
breaking apt's database (ie overwriting
the files that already exist) and using canonical debian path conventions.
2) compile by myself, but I *really* need some help with all the options
./configure provides, in order, again, to use the debian patch conventions.
thanks in advance,
Phil
--
MySQL
rows.
Hi again, does the key page size differ depending on the type of the column
(BIGINT, INT, etc)? Is there any way I can work out the key page size, or
configure it?
Cheers,
-Phil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
^9) = 3.91
Splitting it into 10 smaller tables would make log 200 (10^9) = 3.47, which
isn't a huge amount of difference I guess.
Still, worth testing to see how it performs in practice I guess. Thanks for
the tip :)
Cheers,
-Phil
- Original Message -
From: Gary Richardson [EMAIL PROTECTED
of indexes, including primary keys?
- Original Message -
From: mos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 4:20 AM
Subject: Re: B-tree index question
Phil,
The fastest method to load data into a table is to use Load Data
Infile. If the table is empty
Thanks for the informative reply Sergei,
We're actually just using an INT field at the moment, we were going to move
over to BIGINT when we start using 64-bit MySQL (soon).
Do you know where I should look for information on writing our own table
handler?
Thanks,
-Phil
- Original Message
someone shed some light on how B-tree indexes work. Do they behave well
when values passed in are sequential (1, 2, 3, ...) rather than random values?
Thanks in advance,
-Phil
is...
ERROR 1049: Unknown database '\n''
ERROR:
Can't connect to the server
Hmm, I accessed the server using...
mysql -u root -p databasename
What am I doing wrong here?
TIA
Phil.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version
Resolved, used this syntax...
LOAD DATA INFILE '/path/from/root/to/file.csv' INTO TABLE ma0133 FIELDS
TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' LINES
TERMINATED BY '\r\n'
- Phil.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http
for root, and what did I do? Any help will be greatly appreciated.
TIA
Phil.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
will be greatly appreciated.
TIA
Phil.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from people that know databases... that's all.
Thanks,
Phil
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Friday, March 19, 2004 12:34 PM
To: Philippe LeCavalier
Subject: Re: AddressBook CMS
I don't understand your question. Are you asking us to tell
you how
that a particular database has changed since it must be
shared by all databases that have InnoDB table in... unless you only
have 1 database with InnoDB tables in! Cheers,
Phil
On Sat, 2004-02-07 at 17:41, Brian Reichert wrote:
On Fri, Feb 06, 2004 at 08:18:10PM +, Phil wrote:
Doesn't seem
modified, so that I can decide whether to run mysqldump on it
again or not? Any help with this would be much appreciated.
Thanks,
Phil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of them at backup time :(
Anyone got any other ideas?
On Fri, 2004-02-06 at 14:09, gerald_clark wrote:
Add a timestamp field to each table.
Phil wrote:
Hi,
I have many smallish, discrete MySQL databases, each of which I would
like to backup individually (mysqldump seems fine
timestamp?
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 9:09 AM
To: Phil
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Add a timestamp field to each table.
Phil wrote
do the extra work and risk
not having backups?
Evelyn
-Original Message-
From: Phil [mailto:[EMAIL PROTECTED]
Sent: Fri 2/6/2004 9:27 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last
Thanks Gowtham and Ed. However, even this solution seems a bit dodgy
when it comes to backing up... I'll stick with backing up all databases
for now, and put in an enhancement request. Thanks,
Phil
On Fri, 2004-02-06 at 16:35, [EMAIL PROTECTED] wrote:
You could try the following:
1) Perform
Doesn't seem to change the mtime on table files. It appears that for
InnoDB tables these files are only updated when the definition of a
table is changed. The content of the all InnoDB tables is kept in one or
two massive files directly under the 'data' directory!
On Fri, 2004-02-06 at 18:13,
As far as I am aware mysqladmin is a server control program so it comes with
the mysql-server RPM .. The one listed below is purely a mysql client and
shared library package.
Regards,
Phil.
From: Todd Cary [mailto:[EMAIL PROTECTED]
Sent: 30 November
We've had problems with a production database having indexes getting
corrupt. There are about 17 million records (500,000 new records a day)
in the table (MyISAM) and we run a delete script against it every night
to delete old data so the table doesn't get too big. We are running
mysql 3.23.56
need access to mysql db's, but I don't know
what the username/password was for them. What are my options here to be
able to not lose this info and get root access into the db's in
mysql?
Thank you,
~Phil
server through
socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3
Unable to select database
TIA
Phil.
Phil Ewington - Technical Director
--
43 Plc
35 Broad Street, Wokingham
Berkshire RG40 1AU
T: +44 (0)118 978 9500
F: +44 (0)118 978 4994
E: mailto
Could not read response from last sender :o(
-Original Message-
From: Phil Ewington - 43 Plc [mailto:[EMAIL PROTECTED]
Sent: 01 September 2003 11:35
To: Mysql
Subject: Cannot Connect to Server
Hi All,
Having problems with connecting to mysql server as we have had to change all
the IP
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.
Any help would be greatly appreciated!
~Phil
an error;
CREATE TABLE test_table (
last_updated datetime NOT NULL default 'NOW()'
) TYPE=MyISAM;
Now the table shows a default value of -00-00 00:00:00, when I add a new
row the value of last_updated is also -00-00 00:00:00. I am using MySQL
3.23.37, can anyone help?
TIA
Phil Ewington
No functions as default values is a bummer, but timestamp will do he trick,
so thanks for your help; much appreciated.
Phil.
-Original Message-
From: Cybot [mailto:[EMAIL PROTECTED]
Sent: 06 August 2003 15:37
To: [EMAIL PROTECTED]
Subject: Re: Functions as default values
I am trying
For what it's worth, I get the same problem with 4.0.13, and have posted the
same question a few times with no response.
It works fine at the command line, but not through the mysql++ API.
It doesn't work on my home/work machines (both running XP), though my
colleague doesn't experience the
if the duplicate ratio is high or low?
Cheers,
-Phil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does your university have a webpage indicating what advice is acceptable and
not considered plagarism?
- Original Message -
From: Antonio Jose Rodrigues Neto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 9:54 PM
Subject:
I've been having the same problem, using mysql++ with mysql 4.0.13.
It works just fine entered into mysql-front or mysql.exe, but not through
mysql++
Can I check the CREATE TEMPORARY TABLES privilege through the API?
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To:
Is there a limit to the number of records I can insert in a multiple-value
insert?
- Original Message -
From: Rudy Metzger [EMAIL PROTECTED]
To: Phil Bitis [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:18 AM
Subject: RE: Improving insertion performance by locking
Might it be worth looking at the mailing list manager software for this
list? ACCU's mailing lists use Majordomo and add this line to the rfc822
headers:
Reply-To: [EMAIL PROTECTED]
You can still see the sender's email address if you want to reply directly.
--
MySQL General Mailing List
For
Yeah, put LIMIT 20 on the end.
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:12 PM
Subject: SELECT TOP
What's wrong with the following query? The application used to use Access
via
ODBC, now running MySQL 3.23.xx, MyISAM
You can use BIT or BOOL, but these are currently just synonyms for
TINYINT(1). Still your best bet though.
The manual says under new features planned for 5.1: Optimise BIT type to
take 1 bit (now BIT takes 1 char)
- Original Message -
From: Dan Anderson [EMAIL PROTECTED]
To: [EMAIL
int(1) takes up 4 bytes worth of space, and just displays 1 character.
BIT or TINYINT(1) take up 1 byte.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 13, 2003 6:05 PM
Subject: Re: does mySQL support a boolean data type?
why don't you use int(1)
Presumably if you don't specify a display size it defaults to the maximum.
I'm just quoting from the manual, have a look at 6.2 Column Types
- Original Message -
From: [EMAIL PROTECTED]
To: Phil Bitis [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, July 13, 2003 7:40 PM
Subject: Re
Hiya. I take it you mean ancestors rather than descendants.
For finding descendants I've been using tables like this:
ID ParentIDLineage
1000/100
101100/100/101
102100/100/102
103101/100/101/103
104103
seperate such inserts?
How do these locks affect select statements involving the locked tables?
Thanks in advance,
-Phil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi there. I am a rank amateur at this trying to make sense out of a heap (and growing)
of data.
I have a resultset with this structure:
nodatadate
1uytd1
1klhd2
1oiud3
2kjhd1
2kljhd2
2asdd3
that I wish to convert to this structure.
no
As a way of getting around the lack of subselect (I'm aware this is coming
soon) we're parsing sql queries, running subselects and storing their
results in a temporary table and replacing the subselect in the sql with the
temporary table name.
This has been working fine, but on upgrading to
;
try
{
query.parse();
query.execute();
}
- Original Message -
From: Phil Bitis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:41 PM
Subject: Create Temporary Table problem
As a way of getting around the lack
Further to this, I should point out everything works fine in mysql-front
or at the mysql console.
The problem shows up when using mysql++, a BadQuery exception is thrown.
query.reset();
query CREATE TEMPORARY TABLE sTemporary TYPE=HEAP
MAX_ROWS=1
TEMPORARY
TABLE rights.
Any ideas why this is intermittent?
Thanks for your help!
Phil Dowson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
]
To: Phil Dowson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 2:29 am
Subject: Re: [PHP-DB] Create Temporary Table
Does the ip address of where you are trying to access the mysql database
from (client), change?If you have a dynamic ip address
your ISP
I've just installed various updates to SuSE 8.2 via SuSE's web site. One of
these was an update to MySQL to fix a security bug. Now MySQL doesn't work!
During boot-up, I get the message that MySQL failed. In the log it says:
starting service mysql
failed
[..]S13mysql
1 - 100 of 161 matches
Mail list logo