Hi
I would like to have a SQL query to couple all the five tables to
accomplish my need.
This is a search page and the user will be searching using the don_id
Presently I am using a simple equi join which works fine if all the five
tables contain data for user_id
But if any of the tables have no
You need a combo of cron jobs (man crontab) and use either mysqldump or
mysqlhotcopy.
cron:
* 3 * * *
script
./mysqldump --opt -A > -u
this is just one of the many ways.
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2
Hi all,
I would like to create an index to speed up the following query:
SELECT Account, Status, count(*) From MessageStatus WHERE sentDate >
'(variable)' AND sentDate < '(variable)' GROUP BY Account,Status ORDER BY
Account
sentDate is a timestamp(14), Account and Status are both varchars.
The
I compile the source code of mysql-3.23.51 on a system of solaris 8. The
following error information was produced:
make[2]: Entering directory `/user1/mals/chensong/share/mysql-3.23.51/libmysql'
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_CURSES_H
-I/user1/mals
Hi all,
I tried to use config. variable 'bind-address' for MySQL 4.0.2a
(mysqld-max-nt) to assign a particular ip for the server. However, I got
the following error:
E:\mysql4.0.2a\bin>mysqld-max-nt --help
Unknown suffix '.' used for variable 'bind-address' (value '192.168.0.176')
mysqld-max
Hello,
I have a small(hopefully) sql-query problem.
I have 2 table like this:
Table member:
Id number,
Namevarchar,
Table member_points:
Id number
Member__id number (fk from member_table)
Round number
Points number
Now one example:
In table one is a membe
Hi all,
I've discovered that we have a select query that blocked all others query to
this table.
99% of query used indexs, no join ...
But this one is a problem :
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field
select
m.Name,
mp1.Points as Round1,
mp2.Points as Round2,
mp3.Points as Round3,
mp4.Points as Round4,
mp5.Points as Round5
from
member m,
member_points mp1,
member_points mp2,
member_points mp3,
member_points mp4,
member_points mp5
where
m.Id = mp1.Member__id
and m.Id = mp2.M
As first step, try to optimize table with help of
OPTIMIZE TABLE MyTable
command.
Any progress?
Best regards,
Mikhail.
- Original Message -
From: "David BORDAS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 12:34 PM
Subject: Slow select query, need some clu
Michael,
Tuesday, August 27, 2002, 12:40:31 PM, you wrote:
MT>I tried to use config. variable 'bind-address' for MySQL 4.0.2a
MT> (mysqld-max-nt) to assign a particular ip for the server. However, I got
MT> the following error:
MT> E:\mysql4.0.2a\bin>mysqld-max-nt --help
MT> Unknown suffix
ME> As first step, try to optimize table with help of
ME> OPTIMIZE TABLE MyTable
ME> command.
ME> Any progress?
Already done something like optimize :
myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
David
sql,query
--
> Already done something like optimize :
> myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
And? No result?
Mikhail.
P.S. Can you send a copy to mysql-list, please.
- Original Message -
From: "David BORDAS" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
S
Check the query plan
EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR
Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
Mikhail.
- Original Message -
From: "David Bordas" <[EMA
DB> Already done something like optimize :
DB> myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
ME> And? No result?
Some good result but nothing enough good :(
I'll have a look to fulltext search, perhaps i'll find something good.
I know that fulltext search only search for full wor
Can I create an integer field which automaticly look after in two
tables to have the biggest id from this tables and increment this
maxid and store it?
thanks
ilyas
filter: mysql
-
Before posting, please check:
http://w
From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]>
KF> an Index wouldnt help much , because of the 'LIKE "%..." '.
KF> If a wildcart is at the beginning of the search-string , an Index
KF> cannot help much.
Ok as i thought, index text field is a bad thing ...
KF> You have to think about why a
From: "Andrew Izsof" <[EMAIL PROTECTED]>
DB > I know that '(Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR Field5
LIKE
DB > '%John')' part is the problem.
AI> The formula : '%John%' always sweeps through all of the records, because
it
AI> can't utilize any indexes, sorting, etc. But if you lea
* Mylin Campos
> I'm a newbie with mysql. I have a few question and would really
> appreciate it if you can help me. I'm creating a database for a
> payroll system. I actually finish with my entity relationship
> diagram. What should be the next step? I know I should create
> the database already
Hello,
sorry for a late answer, but here it comes.
On Tue, 27 Aug 2002, Mylin Campos wrote:
> I'm a newbie with mysql. I have a few question and would really appreciate
> it if you can help me. I'm creating a database for a payroll system. I
> actually finish with my entity relationship diagram
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> Check the query plan
ME> EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
ME> MyTable WHERE
ME> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
ME> Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
Pada Tue, 27 Aug 2002 12:34:32 +0200
"David BORDAS" <[EMAIL PROTECTED]> menulis :
> Hi all,
>
> I've discovered that we have a select query that blocked all others query to
> this table.
>
> 99% of query used indexs, no join ...
> But this one is a problem :
> SELECT Field1,Field2,Field3,Field4
I need to run the following query:
SELECT WRK_ImplDisp_1.Livello, WRK_ImplDisp_1.Origine, WRK_ImplDisp.Padre,
WRK_ImplDisp_1.Figlio, WRK_ImplDisp.QUnit*WRK_ImplDisp_1.QUnit AS Espr1,
WRK_ImplDisp_1.DaAggregare, -1 AS Espr2
FROM WRK_ImplDisp INNER JOIN WRK_ImplDisp AS WRK_ImplDisp_1 ON
WRK_I
Hallo all
I am setting up replication.
Now I am sure my servers can connect but I still have a problem.
I setup my slave server to only replicate one table
The error I get is copy'd underneath here.
I am sure it is easey to solve I have just started thinking in loops now
Tnx
Mozzi
+
Can you send result of the query, please:
select * from MyTable PROCEDURE ANALYSE();
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 2:13 PM
Subject: Re: Slow select
- Original Message -
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> Can you send result of the query, please:
ME > select * from MyTable PROCEDURE ANALYSE();
Here you are :
mysql> select * from MyTable PROCEDURE ANALYSE();
+--+--+--++---
- Original Message -
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
DB> SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
DB> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
DB> Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
DWP> h
Hi,
I am using a query that returns around 13000 records from a mysql database.
The problem i am facing is, if i want to add any more columns in the query,
mysql does not return all the records. It returns only around 8000 records.
I somehow feel that it has something to do with the number of by
IMHO the problem is in this condition
...Field5 LIKE '%John'...
Can you remove it from query and try again?
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 2:49 PM
Hi,
i still have a "little" problem. When i do multiple connections to
my database over network (via mysql) then i get strange errors. I don't
know how to explain this so i'll give you an example.
(it is part of my real prog so it isn't probably the simplest one)
CREATE TABLE TR_TEMP (DELETE_
Your query overloads expendituredate.
Mysql now has to scqan the whole table to see if the new expenditure
date will
meet the where clause ( which it never will )
try DATE_FORMAT(expendituredate,"%F=%b-%Y) as expdate
and see what happens.
kamesh jayachandran wrote:
>Hi all,
>I have a table na
Mozzi schrieb:
> Hallo all
> I am setting up replication.
> Now I am sure my servers can connect but I still have a problem.
> I setup my slave server to only replicate one table
> The error I get is copy'd underneath here.
> I am sure it is easey to solve I have just started thinking in loops
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> IMHO the problem is in this condition
ME> ...Field5 LIKE '%John'...
>
ME> Can you remove it from query and try again?
In fact it was Field5 LIKE '%John%',
but "Field5 LIKE '%John'" and "Field5 LIKE '%John%'" don't change query
speed at all excep
Hi Gerald,
I tried the following query,
select DATE_FORMAT(expendituredate,"%d-%b-%Y") as expdate,sum(amount) as
amount from expenditure where userid=11 and expendituredate between
'2002-8-01' and '2002-8-31' group by expendituredate order by
expendituredate;
which is not overriding the expend
As I understand...
After removing "Field5 LIKE '%John'" condition the query works much faster.
But it is different query... :)
I mean that queries return different results.
On other hand you can't change type of Field5 because you have a row with
51723 symbols in Filed5. :(
So...
question: Do you
Can I also use a select statement in a create statement. Something like this:
create table mytable
(
id int not null primary key (select max(id) from mytable2),
name varchar(255)
);
is this possible or is there an other way to do something like this?
ilyas
filter: mysql
--
Hi,
I have a database which a few tables which have a few fields set with
auto_increment and i'm having alot of trouble restoring the backup because
the backup recreates the table with the auto_increment field, but when it
tries to enter the data back into the table it cant because it is trying to
> Can I also use a select statement in a create statement. Something like this:
>
> create table mytable
> (
> id int not null primary key (select max(id) from mytable2),
> name varchar(255)
> );
>
> is this possible or is there an other way to do something like this?
>
> ilyas
>
Hi,
try this:
"create table mytable select max(id),space(1) name from mytable2"
and then this:
"alter table mytable modify name varchar(255)"
Danilo Maurizio
-Messaggio originale-
Da: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Inviato: martedì 27 agosto 2002 15.56
A: [EMAIL PROTECTED]
O
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> As I understand...
> After removing "Field5 LIKE '%John'" condition the query works much
faster.
Nop, sorry i'm not clear, the query works mush slower ...
> But it is different query... :)
> I mean that queries return different results.
Yep ...
>
Brad,
Tuesday, August 27, 2002, 7:59:19 AM, you wrote:
BB> is this "tee" or "\T" command supposed to still work in mysql 4.x?
[skip]
BB> should work similarly. but this is what happens:
BB> mysql> tee /tmp/log.txt
BB> No outfile specified!
BB> the --tee=filename argument to the mysql client w
Andrew,
Tuesday, August 27, 2002, 4:21:29 AM, you wrote:
>>Stuart Low wrote:
>> > Have had continuing issues with trying to actually get LOAD LOCAL INFILE
>> > commands working
>>At 11:45 26/08/02 +0300, Victoria Reznichenko wrote:
>>Did you specified local-infile=1 for client, too?
AM> H
Mylin,
Tuesday, August 27, 2002, 8:17:13 AM, you wrote:
MC> I'm a newbie with mysql. I have a few question and would really appreciate
MC> it if you can help me. I'm creating a database for a payroll system. I
MC> actually finish with my entity relationship diagram. What should be the
MC> nex
Ilyas,
Tuesday, August 27, 2002, 4:55:45 PM, you wrote:
IK> Can I also use a select statement in a create statement. Something like this:
IK> create table mytable
IK> (
IK> id int not null primary key (select max(id) from mytable2),
IK> name varchar(255)
IK> );
Nope.
IK> is thi
Ilyas,
Tuesday, August 27, 2002, 2:45:12 PM, you wrote:
IK> Can I create an integer field which automaticly look after in two
IK> tables to have the biggest id from this tables and increment this
IK> maxid and store it?
Nope.
--
For technical support contracts, goto https://order.mysql.c
Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
I would like to use the "getGeneratedKeys()" method.
Thanks.
Mike
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-
The server that has the mysql DB, has a control panel adding and
removing new mysql databases and mysql users all of the time. Is there
any possible way to have one global grant table for all of the users
coming from 192.168.1.%? I believe I attempted this a while ago, but I
used an INSERT comm
> > As I understand...
> > After removing "Field5 LIKE '%John'" condition the query works much
> faster.
> Nop, sorry i'm not clear, the query works mush slower ...
:( That's strange. You removed condition (which can only _increase_ number
of records in resultset)
and query works much slower...
Hi:
If my MySQL server updates a table, does the ability exist to inform a
client or clients (observers) that a table has changed. I do not want to
replicate the data, I just want to know the name or names of the tables that
have been updated.
Thank you
Phil Willemann
---
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 4:55 PM
Subject: Re: Slow select query, need some clues to speed it up please ...
> ME> :( That's strange. You removed condition (which can only _incr
Which Operating Systems limit MySQL to a 2GB table size?
-
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 <[
When will MySQL 4.0 be released as a stable version?
-
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 <[EMA
ME> In this case...
ME> Can you try again?
Sure.
query 1 :
> SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR Field5 LIKE
> '% John%' ) ORDER BY Field6 LIMIT 0,20;
query 2:
> SELECT Field1,
Ben
It would appear that the deletion of rows may be a problem.
After deleting rows older than 6 months, do you optimize the
table?
As I understand it, mysql does not delete delete, only marks
a bit for every row thats deleted. That way, delete speed is
fast. However, it slows down queries and i
Try to remove two 'LIKE' conditions.
query 3:
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
Field7=15 AND Field2=0 AND Field3 LIKE '%John%'
ORDER BY Field6 LIMIT 0,20;
What do you have now???
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL
On Tue, 27 Aug 2002, Will K. wrote:
> Date: Tue, 27 Aug 2002 01:09:32 +
> From: Will K. <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: NULL ?
>
> hello,
>
> Please dont tell me to RTFM on this one (cause I am already doing that), but
> for clarity's sake... can someone tell me what
Try MySQL Connector-J 3.0.0 (dev). You can download it from mysql.com.
Regards,
Michael
-Original Message-
From: Mike Duffy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 7:41 AM
To: [EMAIL PROTECTED]
Subject: JDBC 3.0 Driver
Does anyone know if there is a good JDBC 3.0 Dri
Hi Victoria,
May I ask when 4.0.3 will be released?
In addition, I found 4.0.x contains the "max" sqld as well. Are there any
different between the 4.0.x and 4.0.x-MAX version?
Regards,
Michael
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
> Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
> I would like to use the "getGeneratedKeys()" method.
The mm.mysql driver has been taken over (with it's author), renamed (but
not the author) to Connector/J, and enhanced to 3.0 level. It is still Beta
at the moment, but suppor
Mike Duffy wrote:
> Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
>
> I would like to use the "getGeneratedKeys()" method.
>
> Thanks.
>
> Mike
>
> __
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://financ
On Mon, 26 Aug 2002, Donald J Miller wrote:
> Hello everyone,
>
> I am trying to create a mysql table to hold either the entire contents
> of text or WordPerfect files. I've read about BLOB or TEXT type columns
> so I've tried creating a table such as:
>
> CREATE TABLE filetest(fileid int(5) n
On Tue, Aug 27, 2002 at 09:17:46AM -0600, Scott Pippin wrote:
> When will MySQL 4.0 be released as a stable version?
Where there have been no reported bugs for a sufficient amount of
time.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http:
I would like to know if it is possible to configure mysql auo increment
feild to start from a specific number or configure it to have a specific
character such as a letter inserted infront of it.
Thanks
" I have no respect for reality as soon as it is acknowledged as such. I am
interested
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
wor
Dear Sir/Madam,
In dos-prompt, I type at c:\mysql\bin>mysql for testing to see if mysql is
connected successful but
the error is : Error 2003: Can't connect to MySQL server on 'localhost'
<10061>
How to solve this problem?
Hope to hear from you soon.
Thank you.
Regards
Ellen
---
On Tue, 27 Aug 2002, Will K. wrote:
> hello,
>
> Please dont tell me to RTFM on this one (cause I am already doing that), but
> for clarity's sake... can someone tell me what it means when you use NULL
> and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I
> use them?
Wi
I would like to know if it is possible to configure mysql auto increment
field to start at a specific number or to configure the auto increment field
with a character such as a letter inserted infont of it(eg. r1, r2..)
Thanks
F belfon
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tuesday 27 August 2002 17:17, Scott Pippin wrote:
> When will MySQL 4.0 be released as a stable version?
As soon as it actually *is* stable :)
On a more serious note, we are currently working on preparing the first
release of 4.0 (4.0.3)
Hi
I have a table that returns the following error message as soon as I run
a query that reads out more then 300 posts from the table
ERROR 1030: Got error -1 from table handler
The strange part is that the table works without any problem except when I
try to select more then 300 posts. I have t
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
wor
According to the book I'm working from right now, you can't do this directly. What it
suggests is that you insert the first row in your table manually and insert the
integer that you want to start at. AUTO_INCREMENT will then use this number as its
starting point and continue upwards.
I haven'
Scott Pippin wrote:
> Which Operating Systems limit MySQL to a 2GB table size?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
Thomas Spahni wrote:
> On Mon, 26 Aug 2002, Donald J Miller wrote:
>
> > Hello everyone,
> >
> > I am trying to create a mysql table to hold either the entire contents
> > of text or WordPerfect files. I've read about BLOB or TEXT type columns
> > so I've tried creating a table such as:
> >
> >
Frederick,
ALTER TABLE will do the biz:
http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
> I would like to know if it is possible to configure mysql auto increment
> field to start at a specific number or to configure the auto increment
field
> with a character such as a letter insert
Hello,
If you're using MyISAM tables, shut down your server and run myisamchk
For example, myisamchk \mysql\data\dbname\*.MYI
See the MySQL Technical Reference for detailed syntax and usage
information. However, it seems like your table is corrupted, indeed.
Regards,
Iikka
On Tue, 27 Aug 2002
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote:
> As soon as it actually *is* stable :)
>
> On a more serious note, we are currently working on preparing the first
> release of 4.0 (4.0.3) that will be declared "Beta" instead of "Alpha".
The
The search function for our ecommerce site has worked great up until the
other day, but now when a search is ran the whole system just hangs. Here
is what I have found:
A process is started (search.cgi) that stays open until all of the memory is
used up (sometimes two same-named processes). Th
Elias,
ALTER TABLE will do the biz: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
> I would like to know if it is possible to configure mysql auo increment
> feild to start from a specific number or configure it to have a specific
> character such as a letter inserted infront of it
On Tue, 27 Aug 2002, Scott Pippin wrote:
> I found out my AIX box's maximum file size is 2GB. What can I do if I
> will have MySQL tables that are possibly over 2GB?
Hello,
There are basically two things you should consider:
1) Switch to InnoDB tables and create several data files just under 2
In the last episode (Aug 27), Chad Arimura said:
> The search function for our ecommerce site has worked great up until
> the other day, but now when a search is ran the whole system just
> hangs. Here is what I have found:
>
> A process is started (search.cgi) that stays open until all of the
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 20:05, Scott Pippin wrote:
> I found out my AIX box's maximum file size is 2GB. What can I do if I
> will have MySQL tables that are possibly over 2GB?
You could either use MERGE tables:
http://www.mysql.com/doc/en/MERGE.h
Dean Ellis wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote:
> > As soon as it actually *is* stable :)
> >
> > On a more serious note, we are currently working on preparing the first
> > release of 4.0 (4.0.3) that will be declar
Hi,
My opinion:
Personally, i'm not agree with this model of data in a table...but it's
your choice.
Anyway, i think you can try this :
select field1,field2,field3,field4,field5,field6,field7 from YOUR_TABLE
WHERE field2=0 AND field7=15 AND (CASE WHEN field3 like 'john' THEN field3
like 'john' W
I'm building a job database with simple invoicing. I have one table called
JOBS and one called INVOICES. In INVOICES there's a foreign key column
called job_id referencing INVOICES to JOBS.job_id.
in a simplified way it looks like this:
(there are a lot of other columns of course)
tabl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sql,query ...
On Tuesday 27 August 2002 02:30 pm, walt wrote:
> There has been some issues with gcc 3.x if I remember correctly. I know
> RedHat released another beta because of problems with gcc 3.x. Have you
> tried it on a box with gcc 2.9x ?
your date strings are incorrect.
As a string it should be '2002-08-01'
but it can also be treated as a numeric.
try:
and expendituredate between 20020801 and 20020831
kamesh jayachandran wrote:
>Hi Gerald,
>I tried the following query,
>select DATE_FORMAT(expendituredate,"%d-%b-%Y") as expdate,
use the -f option to ignore the duplicates.
Chris Barnes wrote:
>Hi,
>I have a database which a few tables which have a few fields set with
>auto_increment and i'm having alot of trouble restoring the backup because
>the backup recreates the table with the auto_increment field, but when it
>trie
Does anyone have any idea when Mysql 4 will be classed as stable.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Hi,
I'm running mysql 3.23.52 w/ innodb tables, and I started getting some
deadlocks since upgrading from .51. When I do a show innodb status in
prints out the following:
020826 19:22:15 LATEST DETECTED DEADLOCK:
*** (1) TRANSACTION:
TRANSACTION 0 16655549, ACTIVE 1 sec, OS thread id 87339022 i
Matt Darcy wrote:
> Does anyone have any idea when Mysql 4 will be classed as stable.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list a
Sounds fair.
I have played with it a bit and found it good.
Just hoping it was be found stable soon as I am keen to use it in
production.
I'll get back to some testing.
Thanks,
Matt
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: 27 August 2002 22:15
To: [EMA
I'm trying to put together some statistics on our queries and am wondering
what percentage of our queries involve a full table scan. The variable
which kind of tracks this is Handler_read_rnd_next. However, since a
query may cause multiple Handler_read_rnd_next events to occur to get all
of it's
When will 4.0.x finally be released to beta?
The facts as I understand them:
- 4.0 went alpha in Nov or Dec of '01
- At the time, Monty and his gang projected stabilization by Jan or Feb
- More than 6 months have passed since and the product is not yet stabilized
- No meaningful information has b
On Tue, Aug 27, 2002 at 05:45:07PM -0400, Will French wrote:
> When will 4.0.x finally be released to beta?
>
> The facts as I understand them:
> - 4.0 went alpha in Nov or Dec of '01
> - At the time, Monty and his gang projected stabilization by Jan or Feb
> - More than 6 months have passed sinc
The confusing thing is, I run the query across the EXACT same code on a
different database (old copy of same database), and it works just fine. Are
there any ways to peak into what mysql is doing besides "mysqladmin
showprocesses"?
Thanks,
Chad
-Original Message-
From: Dan Nelson [mai
Hi there,
I have a big table which has 25 rows.And each row has a BLOB field
which stores lots of text. When I search text in this table(using the query:
where CONTENT like '%news%'),the searching speed is quite slow. is there
anybody also have such problem? Any ideas about improving the sp
In the last episode (Aug 27), Chad Arimura said:
> The confusing thing is, I run the query across the EXACT same code on
> a different database (old copy of same database), and it works just
> fine. Are there any ways to peak into what mysql is doing besides
> "mysqladmin showprocesses"?
If the
Joe,
- Original Message -
From: "Joe Shear" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 28, 2002 12:15 AM
Subject: Innodb deadlock printouts in .52
> Hi,
> I'm running mysql 3.23.52 w/ innodb tables, and I started getting some
> deadlocks since upgradi
Hi Will,
As far as I have heard (from MySQL) is that MySQL 4.0.3 is being made ready for Beta
as we speak and is likely to be released in the next month. V4.1 will most likely be
released Early Sept in Src form and in Binaries two months later.
4.0.x branch will be allowed to stabalise from th
Hi there,
I have a big table which has 25 rows.And each row has a BLOB field
which stores lots of text. When I search text in this table(using the query:
where CONTENT like '%news%'),the searching speed is quite slow. is there
anybody also have such problem? Any ideas about improving the s
1 - 100 of 128 matches
Mail list logo
