* 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,
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*
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
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
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.
For
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
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
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
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,
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 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
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
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:
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 3
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 3
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
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
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
-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
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
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
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 just
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
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
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 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
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
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
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,
-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
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
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
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
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 if there
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
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
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
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
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 following
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
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
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 General
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
Access, but
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
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
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
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
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
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
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
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
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
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,
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:
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 or
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 requirements.
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
Add GROUP BY/DISTINCT
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
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
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,
actors
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 row in
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
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]
[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
[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
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 = 46 AND
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
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
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
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
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
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
73 matches
Mail list logo