e a lot of triggers, not sure if it could be done
in a single trigger, plus then I would have 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
> Tables "client" an "user" are quite similar, but they
ackets.
I 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
ast. You might check the value 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 fileso
will cause mysql to run out off MEMORY and
> paging will happen
>
> regards
> anandkl
>
> On Fri, Sep 10, 2010 at 1:10 AM, Phil wrote:
>
>> Even prior to the group by it's still not likely to ever be more than 200
>> or
>> so maximum.
>>
>>
n 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 wrote:
> > On average
> - michael dykman
>
> On Thu, Sep 9, 2010 at 1:53 PM, Phil 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 m
id: 1
select_type: SIMPLE
table: b
type: 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 t
create table TableDEF like TableX;
Or am I missing something ??
On Tue, May 11, 2010 at 11:36 AM, mos 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 "Describe Table"
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 however
Try Chartdirector, available in many languages..
http://www.advsofteng.com
Regards
Phil
On Mon, Nov 16, 2009 at 12:38 PM, Mikie wrote:
> Hello MySQL list people!
>
> I need software that will graphically plot 2d line charts vs. time for
> various data points from a MySQL datab
o it, but each to their own!
Phil
On Wed, Nov 4, 2009 at 5:40 PM, Gavin Towey 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: Wedn
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 wrote:
> Hello,
>
> I am new to using triggers
ery but not in the group by.
The question is, is there any way to modify this query so that it would
return the team having the most entries?
Theoretical what I would like:
| cpid | sum(score) | team |
+---++---+
| a |600 | team1
;d expect you'd need some 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
wrote:
>
>
> >-Original Message-
> >From: freedc@gmail.com [mailto:freedc@gmail.com
How about something like
select account,customer,max(total) from (select
account,customer,sum(sale_amount) as total from 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
wrote:
> Here's a bit of
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 wrote:
> I have a char fiel where I am keeping dates forma
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
On
I put them 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 f
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 t
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
show full processlist".
>
> Also run mysqladmin -uroot -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.
>
>
>
/mysql caching but the
performance has not increased any in subsequent runs.
Any advice on where to look ?
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:
>>
>
silly I'm missing.
Phil
--
Help build our city at http://free-dc.myminicity.com !
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.
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
` (`proj`,`today`,`id`),
KEY `prank` (`proj`,`projrank0`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Regards
Phil
--
Help build our city at http://free-dc.myminicity.com !
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 ta
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 -
>
>
and use 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'
&
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>
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:
>
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 <[E
et 'X' as there are two instances of 'X' and
only one of 'Y'
Is this possible in the same sql statement, something like 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 coun
Are the table structures identical ?
If so, you could just move the data files themselves.
Otherwise consider using
unload from table B into 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]> w
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
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 a
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 characteri
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 exi
ng 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 plu
ut what is causing it?
Regards
Phil
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
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
>
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
> >
> > C
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,
PRI
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 a
> > 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:
>
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/
++
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
++
_
Discover fun and games at @ 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
++
_
Find the coolest online games @ 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:
her
1) use the precompiled binaries without 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 pat
is 200, log 200 (10^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: "
to the table with one hundred 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
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 Me
es 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 "Loa
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
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 certi
\' LINES TERMINATED BY '\r\n';
The error I get is...
ERROR 1049: Unknown database '\n''
ERROR:
Can't connect to the server
Hmm, I accessed the server using...
mysql -u root -p
What am I doing wrong here?
TIA
Phil.
---
Outgoing mail is certified Virus Free
w do I reset the
password 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]
greatly appreciated.
TIA
Phil.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
book.
I'm just looking for insight 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
>
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 +0000, Phil wrote:
> >
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, Br
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:
>
As long as you only keep
> the most recent backup online I don't see the harm. Why 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
>
his, but what about the .myd file 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 data
und all 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
> >lik
last 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]
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 on
Admin is gone now, I 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
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
ocal MySQL 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
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.
Any help would be greatly appreciated!
~Phil
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
Phi
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 try
to locate the record
What about 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]
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 problem
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
Subj
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:
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,
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 l
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:
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/10
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 PR
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
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: <[E
ing 2 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
> > 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
> >
; " TYPE=HEAP
MAX_ROWS=1 " << subselect;
try
{
query.parse();
query.execute();
}
- Original Message -
From: "Phil Bitis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 12:41 PM
Subj
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 v4.0.1
t; <[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
>
7;t changed, and I have CREATE 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]
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 start
1 - 100 of 166 matches
Mail list logo
