Hi Chris,
My apologies, I didn't correctly explain what I was looking for. I mean
more of a solution to creating a client program. I'm thinking of php-gtk
but not sure how well this works under windows, especially for printing
reports.
Thanks,
Bryan
On Sat, 17 Jan 2004, Chris Nolan wrot
Has anyone done any programming relating to using mysql as a mail
archive? I'd like to play around with mysql, and I happen to have alot
of old mail that I don't need. I'm using Mozilla, so it shouldn't be
hard to extract mail from the mail folders and input them into a
database. I'm a newbi
Hi,
I also faced this kind of error in sub query,
any solution for this?:
-Aman.
On Mon, 19 Jan 2004, Director General: NEFACOMP wrote:
> Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1
> When the SUB-SELECT contains more than one field, it does not work (this works
hi vijay,
You can use order by & group by commands in the queries..
Thanks and Regs,
- Aman.
On Mon, 19 Jan 2004, Vijay Patel wrote:
> Hello friends,
>
> I have a problem with one of the JOIN query here.
> Below is a brief description of the problem.
>
> tablename : test
>
> RecordId Ef
I've inserted the following currecy sumbols in my table (structure mentioned
below). All symbols are displayed properly when I do select, expect for the
Euro symbol, which just shows a question mark (?). Any idea why is it
behaving like that? I am using MySQL 4.0.17 on Windows XP Pro. My production
Michael Satterwhite wrote:
On Monday 19 January 2004 16:30, Jochem van Dieten wrote:
Michael Satterwhite said:
On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
So let's make it 2 fields:
SELECT
t1.*
FROM
table1 t1,
table2 t2 INNER JOIN table2 t3
ON (t2.rdid = t3.rdid AND t2.vid =
On Monday 19 January 2004 16:30, Jochem van Dieten wrote:
> Michael Satterwhite said:
> > On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
> >> So let's make it 2 fields:
> >>
> >> SELECT
> >> t1.*
> >> FROM
> >> table1 t1,
> >> table2 t2 INNER JOIN table2 t3
> >>ON (t2.rdid = t3
> [EMAIL PROTECTED] wrote:
>>> DVD_Actor:
>>> dvd_ID REFERENCES DVD
>>> actor_ID REFERNCES Actor
>>
>> Is this how you setup a join table ?
>
> Yes.
>
>
>> what exactly is the references keyword ?
>
> It indicates a foreign key. Full syntax is something like:
> dvd_ID CONSTRAINT dvc_fk FOREIGN KEY
[EMAIL PROTECTED] wrote:
DVD_Actor:
dvd_ID REFERENCES DVD
actor_ID REFERNCES Actor
Is this how you setup a join table ?
Yes.
what exactly is the references keyword ?
It indicates a foreign key. Full syntax is something like:
dvd_ID CONSTRAINT dvc_fk FOREIGN KEY REFERENCES DVD (dvd_ID)
Read the ma
>
> DVD_Actor:
> dvd_ID REFERENCES DVD
> actor_ID REFERNCES Actor
>
Is this how you setup a join table ? what exactly is the references
keyword ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bjorn Barton-Pye wrote:
I am using a test database to teach myself MYSQL and am using my DVD
collection as the subject. I have 3 tables in this example:
Actresses
===
actr_id
name
Actors
==
acto_id
name
DVD
==
Title
acto_id
actr_id
The acto_id and actr_id in the DVD table indicates the
> so soemthing like
>
> select * from dvd left join actresses actr on actr.actr_id=dvd.actr_id
> left join actors acto on acto.acto_id=dvd.acto_id or by dvd.title
>
>
totally forgot, to get a really good query especially when you use Innodb
it doesnt like null values on foreign keys, i'd setup a r
> So, can somebody please correct the following query (and explain the
> syntax) so that it will work please? (I haven't tried putting an outer
> join in it because I don't understand the syntax.)
>
> Select
> actr.name,
> acto.name,
> dvd.title
> from
> actresses actr,
>
> Hi,
>
> I'm just getting into MYSQL after nearly 12 years away from relational
> databases and I'm trying to blow the cobwebs away. So please bear with me
> if this is a simple question!
>
> I am using a test database to teach myself MYSQL and am using my DVD
> collection as the subject. I have
Hi,
I'm just getting into MYSQL after nearly 12 years away from relational
databases and I'm trying to blow the cobwebs away. So please bear with me if
this is a simple question!
I am using a test database to teach myself MYSQL and am using my DVD
collection as the subject. I have 3 tables in thi
Michael Satterwhite said:
> On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
>> So let's make it 2 fields:
>>
>> SELECT
>> t1.*
>> FROM
>> table1 t1,
>> table2 t2 INNER JOIN table2 t3
>>ON (t2.rdid = t3.rdid AND t2.vid = 46 AND t3.vid = 554)
>> WHERE
>> t1.rdid = t2.rdid
>>
>>
On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
> So let's make it 2 fields:
>
> SELECT
> t1.*
> FROM
> table1 t1,
> table2 t2 INNER JOIN table2 t3
>ON (t2.rdid = t3.rdid AND t2.vid = 46 AND t3.vid = 554)
> WHERE
> t1.rdid = t2.rdid
>
> Add GROUP BY/DISTINCT per your requireme
Lincoln Milner said:
> Or, if I'm not mistaken, you could do something like:
> SELECT t1.*
> FROM table1 t1, table2 t2
> WHERE t1.id = t2.rdid
>AND t2.vid IN (46, 554)
> ;
>
> That should work
No. You are back to square one where there should only be one record
in t2 with a vid of either 46
There is an issue in ISAM/MyISAM tables of needing to have correctly
sized row pointers. I submitted this as a bug report (it's really a
documentation bug), but don't know if it will be fixed. I was happy
to get an answer, though, so will share it with you :-)
If you get an error like this:
"ER
Jochem,
I believe this works. This is also easy to build dynamically. The query
is going to be generated based upon some user input. Thank you very
much,
Joe
On Monday, January 19, 2004, at 04:38 PM, Jochem van Dieten wrote:
Michael Satterwhite said:
On Monday 19 January 2004 13:17, sulewski
Or, if I'm not mistaken, you could do something like:
SELECT t1.*
FROM table1 t1, table2 t2
WHERE t1.id = t2.rdid
AND t2.vid IN (46, 554)
;
That should work, but the joining thing should too. I can never get the joining
straight, so I always enjoy a shorter route.
-Original Message---
Michael Satterwhite said:
> On Monday 19 January 2004 13:17, sulewski wrote:
>> Okay, I think I'm missing something obvious. I have two tables
>>
>> Table 1 Table 2
>> ___ _
>> ID rdid vid
Hi,
I rely on max_questions to balance the load on my servers. I'd like to
tune them more effectively than just a ballpark guess.
During the course of an hour (the question count resets each hour) is it
possible to retrieve the question count for a particular user? Obviously
it must b
On Monday 19 January 2004 13:17, sulewski wrote:
> Okay, I think I'm missing something obvious. I have two tables
>
> Table 1 Table 2
> ___ _
> ID rdid vid
> ___ _
Is there a way to tell mysql witch row (from a non unique value column)
return when you do a group by omitting some fields from the ones
that apear in the select list?
Thanks in advance
Please reply to this addres to.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
The ands are killing you in regards to what no data returned is that
what
you mean.
Yes, I'm not getting any data on a return. Because the vid can only be
one value not both.
because" (vid=54 and vid=65)" which you already know means both have to
succeed and if there is no data to match that cr
Mikel,
have you set the size of the InnoDB log files as recommended in the manual?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
Order My
Let me post the question this way,
MyTable
---
pointerid valueid
811 54
811 63
812 100
813 200
814 300
815 400
I want all the records in MyTable w
Could someone please tell me if tyhe following is possible or if a solution
accomplishing the same thing is available?
I would like to build a database using two MySQL servers accessing the same
physical file on a common Drive attached to each computer via a SAN. Can
this be done or is there data
Ian O'Rourke wrote:
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'),SectionID,Title,Summary,Content FROM articles
ORDER BY EntryDate
DESC LIMIT 10
I'm still new to Mysql so I'm not sure on this but I think the problem
is with your ORDER BY field. Since you
On Mon, 19 Jan 2004, Ian O'Rourke wrote:
> Regarding the following query:
>
> SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
> %y'),SectionID,Title,Summary,Content FROM articles
> ORDER BY EntryDate
> DESC LIMIT 10
>
> Okay, I've looked in the manually up and down, as I know how to do it in
> Acce
rom: "sulewski" <[EMAIL PROTECTED]>
> I think you can just put the alias after the field like so,
>
> select id,author,date_format(entrydate,'%d %m %y') ArticleDate,
> SectionId,Title,Summary...
>
You were correct - the version using AS does not work (I'd tried that before
mailing).
--
MySQL
mysql> select count(*) from atoms_in_universe;
+-+
| count(*)|
+-+
| 30204541410292874012341 |
+-+
1 row in set (0.07 sec)
Daevid Vincent
http://daevid.com
> -Original Message-
> From: Will
I think you can just put the alias after the field like so,
select id,author,date_format(entrydate,'%d %m %y') ArticleDate,
SectionId,Title,Summary...
On Monday, January 19, 2004, at 02:16 PM, Ian O'Rourke wrote:
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'
you were so close
http://www.mysql.com/doc/en/SELECT.html
SELECT COLUMNNAME AS WHATEVER FROM TABLENAME;
Marty Gainty
- Original Message -
From: "Ian O'Rourke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 2:16 PM
Subject: Expressions
> Regarding the followi
Okay, I think I'm missing something obvious. I have two tables
Table 1 Table 2
___ _
ID rdid vid
___ _
ID in table 1 links to rdid in table 2. This is
I need MySQL version 4.1.2 build for Windows.
Does anyone have a built version of it, or know when it will be released?
Thanks for your help,
Kate
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'),SectionID,Title,Summary,Content FROM articles
ORDER BY EntryDate
DESC LIMIT 10
Okay, I've looked in the manually up and down, as I know how to do it in
Access, but I can't find it. I want to set an expression so I
Hi all,
I've got strange thing with my UDF.
My UDF receives 2 text columns as parameters - fields of type "text"
(protein or nucleo sequences). It makes by pair comparison and the result
is char* - set of output sequences (aligned).
Input table is seqTbl:
id | seq_type | seq
For example, I run
Donald Henson said:
> On Fri, 2004-01-16 at 17:05, Bryan Koschmann - GKT wrote:
>> Hello,
>>
>> I run an ISP where our web customers have access to the MySQL server.
>> When they want a database, they request it through me and I add it. I
>> was just curious if this is the common way it is done, or
Neil Gunton wrote:
>
> Since I didn't get any replies to my previous message (see below), I am
> trying to compile MySQL myself, to see if it results in a more stable
> system when using replication. However this is failing consistently with
> the following error:
>
> make[4]: Entering directory
Hi list, does anyone know a faster way to recover a mysqldump file cause
When I recovered one dump file it took 26 hours ! to finish, I think it's
too slow.
Thnx in advanced, greetings
MySQL server 3.23.58
RedHat 7.3
4GB RAM
2 scsi disk via fiber channel (333GB each)
2 processor Xeon 1.6GHZ
dum
Try using this command instead:
rpm -e --nodeps (the RPM you want to remove)
Eve Atley wrote:
I've been trying to install a later version of MySQL (4.0.16). The Redhat
default install is 3.x, and using rpm -e fails to remove the default
packages due to 'dependencies'. How can I safely and success
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 19 January 2004 08:56, you wrote:
> The password column is 41 bytes in 4.1, except for 4.1.0 which uses 45
> bytes. If I understand you, though, you reinstalled 4.1.0, so that
> isn't the problem.
>
> Perhaps you started mysqld with --old-pa
I've been trying to install a later version of MySQL (4.0.16). The Redhat
default install is 3.x, and using rpm -e fails to remove the default
packages due to 'dependencies'. How can I safely and successfully uninstall
the default mysql packages (server and client) so I can start fresh?
Thanks,
E
Carsten Pedersen wrote:
I have heard from some candidates that they regard the Core exam as
being more of a "memorization" exam than Professional. Which only goes
to show, once again, that perceptions differ quite a bit as people come
out of the testing room.
Carsten,
Do you know when the Profess
The password column is 41 bytes in 4.1, except for 4.1.0 which uses 45
bytes. If I understand you, though, you reinstalled 4.1.0, so that
isn't the problem.
Perhaps you started mysqld with --old-passwords before but not after the
reinstall? Leaving that out would prevent connections from pyth
I tried it with an 854kb WKT block with out any problems. A total of 64k
points in fact. Two things, did you correctly close the polygon (first
and last points must be the same). Did you use the astext() function to
display the polygon in your select statement?
CREATE TABLE big (
g geometry NOT NU
I received a suggestion that the problem might be in the privilege tables.
Note that this server has never been at a level less than 4.1. The password
field in user is 45 char long, and passwords already begin with a "*".
The suggestion was a good one based on the symptom, but it doesn't apply
> I have Mysql 4.0.13 installed. I need to know if upgrading is an option
> or if installing the latest binary is a better option.
>
> To be more candid, I have finished the install with the following
> config. Not so much content yet...Just some pictures that can be
> uploaded again.
>
> Windows
I create a Visual C++ COM object that makes use of ADO Recordset for database queries.
I need to execute an update query in MySQL. I am using MyODBC-3.51.06 and
mysql-4.1.1-alpha.
My table has a field with datatype as mediumtext. One record consists the value as
"NULL" for this field. But, the
"Mike Mapsnac" <[EMAIL PROTECTED]> wrote:
> I think that main disadvantage of this command is thah it works for the
> database but not for specific table. So if a database has 200 tables, find
> result for specific table is not an easy task.
If you want to get info about specific table, you can
On Mon, 19 Jan 2004, Mike Mapsnac wrote:
> I think that main disadvantage of this command is thah it works for the
> database but not for specific table. So if a database has 200 tables, find
> result for specific table is not an easy task.
SHOW TABLE STATUS LIKE 'tablename'\G
cheers,
Tobias
I have Mysql 4.0.13 installed. I need to know if upgrading is an option
or if installing the latest binary is a better option.
To be more candid, I have finished the install with the following
config. Not so much content yet...Just some pictures that can be
uploaded again.
Windows 2000 Advanced S
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm running the SuSE 8.2 distro with MySQL 4.1.0-0 and python-mysql-0.9.1-430.
On Saturday, I had to do a reinstall of everything (long story). The software
listed above is the same as it was before the reinstall. The only difference
is that this t
> I think that main disadvantage of this command is thah it works for the
> database but not for specific table. So if a database has 200 tables, find
> result for specific table is not an easy task.
Easy:
SHOW TABLE STATUS LIKE 'table_name'
Regards, Jigal.
--
MySQL General Mailing List
For l
> I didn't know if this was possible and haven't tried yet. My boss wants
> me to sort results by 3 columns (city, county, price.) He would like city
> and county in alphabetical order a-z and have price from highest to
> lowest. I told him I didn't think it was possible to sort two different
> fi
Hi,
> I told him I didn't think it was possible to sort two
> different fields one acending and one descending.
But, of course, it is possible :)
http://www.mysql.com/doc/en/SELECT.html
SELECT
...
ORDER BY
city, county, price DESC
Take care,
Aleksandar
--
MySQL General Mailing
ORDER BY city, price DESC
- Original Message -
From: "Ed Curtis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 2:00 PM
Subject: Sorting by more than 1 column
>
> I didn't know if this was possible and haven't tried yet. My boss wants
> me to sort results by
ORDER BY city, price DESC
- Original Message -
From: "Ed Curtis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 2:00 PM
Subject: Sorting by more than 1 column
>
> I didn't know if this was possible and haven't tried yet. My boss wants
> me to sort results by
I think that main disadvantage of this command is thah it works for the
database but not for specific table. So if a database has 200 tables, find
result for specific table is not an easy task.
From: Victoria Reznichenko <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: table info
Date:
I didn't know if this was possible and haven't tried yet. My boss wants
me to sort results by 3 columns (city, county, price.) He would like city
and county in alphabetical order a-z and have price from highest to
lowest. I told him I didn't think it was possible to sort two different
fields one
Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1
When the SUB-SELECT contains more than one field, it does not work (this works very
well with 4.1.0 )
For example:
SELECT field1 FROM Table1 WHERE (field2,field3) IN (SELECT field2,field3 FROM Table2)
The above quer
"Mike Mapsnac" <[EMAIL PROTECTED]> wrote:
> Is it possible to find out when the table was created? How to get information about
> the table?
SHOW TABLE STATUS command provides info about table:
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
--
For technical support contracts, goto
Hi all,
Herewith I want to confirm that the info passed to the Socket
parameter of mysql_real_connect() is correct or not?
we have C API function to handle MySQL database using C programs.
MYSQL *mysql_real_connect(MYSQL *mysql,
const char *host,
Hello mysql,
the message "MySQL server has gone away" appears during
upload to db mediumblob file of size > 2M
i tried to set max_allowed_packet=16M in my.cnf
(and it shows me 16M in mysqladmin variables),
but error still appears
any ideas?
used mysql4.1 (mysql3.23.58) on FreeBSD
--
Best regar
try this, i found this when solving similar problem.There is another method
to make and free connection, here is just one change.
The trick is that you dont call mysql_close( ) on &mysql_connection , but
on return of mysql_real_connect();
Try it, i think that this solve your is problem.
static M
Hello friends,
I have a problem with one of the JOIN query here.
Below is a brief description of the problem.
tablename : test
RecordId EffectiveDate othertableidvalue
- -
1 2004-01-10 1 10
2
On Sun, 2004-01-18 at 20:51, Johannes Franken wrote:
> * Marc Dver <[EMAIL PROTECTED]> [2004-01-18 18:30 +0100]:
> > 1. What is the format of the test questions? I.e., are they multiple
> > choice, free answer, essay, etc.?
>
> They are multiple-choice (but very tricky) and fill-in-the-gaps.
>
Hassan Shaikh wrote:
Hi,
I've inserted the following currecy sumbols in my table (structure mentioned below). All symbols are displayed properly when I do select, expect for the Euro symbol, which just shows a question mark (?). Any idea why is it behaving like that? I am using MySQL 4.0.17 on Wi
Hello List!
I forgot that OSX Server had mysql installed already. So in installed
another version on top of it.
How in the user/local/ folder I have two versions. And when I try to connect
to which ever oneis running, is says I cannot connect to the mysql.sock
socket.
So I am thinking I need to
Mysql doesn't run correctly.Because libgcc_so.1 can not be found.I
restored the library,but i had the same problem.Why does this problem
occur?Thanks for your helps.
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
htt
* Bob Ramsey <[EMAIL PROTECTED]> [2004-01-18 22:54 +0100]:
> So how reflective of the real test is the sample test at mysql.com?
They've got sample questions for the core certification only. Their
level looks similar, but the real exam offers answers like "none of the
above" and "all of the above
73 matches
Mail list logo
