Hi,
I'm baffled. Been lookin at this for the last hour now.
SELECT worker.fname,worker.lname,worker.workerid FROM
worker,webprojectassign WHERE worker.workerid!=webprojectassign.workerid
ORDER BY worker.lname ASC;
That's the SQL in question. There's currently nothing in the
webprojectassign
On 6 Jan 2004 at 1:00, Tyler Longren wrote:
Hi,
I'm baffled. Been lookin at this for the last hour now.
SELECT worker.fname,worker.lname,worker.workerid FROM
worker,webprojectassign WHERE worker.workerid!=webprojectassign.workerid
ORDER BY worker.lname ASC;
That's the SQL in
Rory wrote:
The query is behaving exactly as it should. Your query asks it to return
only those
workers that are listed in the webprojectassign table. Seeing as there are
no entries in
the webprojectassign table, no workers match and hence no results are
produced.
No'am adds:
I think that Tyler
From: Willy Dockx [EMAIL PROTECTED]
Sent: Monday, January 05, 2004 7:23 PM
Subject: RE: French characters ok with mysql in Windows, nok with mysql in
Linux
Hello,
etc/sysconfig/i18n contains:
LANG=en_US.UTF-8
SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en
SYSFONT=latarcyrheb-sun16
!= and both mean not equal.
To find workers with projects, you join the worker table to the
webprojectassign table.
To get all workers whether they have a project or not, you use LEFT
JOIN, as Rory McKinley suggested. With a LEFT JOIN, missing rows from
webprojectassign (the table on the
On 6 Jan 2004 at 9:31, Noamn wrote:
Rory wrote:
The query is behaving exactly as it should. Your query asks it to return
only those
workers that are listed in the webprojectassign table. Seeing as there are
no entries in
the webprojectassign table, no workers match and hence no results
You want each user with a match to show up once, regardless how many art
items match, right? How about
SELECT * from users INNER JOIN art ON (users.user_id = art.user_id)
WHERE MATCH (nickname, name_first, name_last, name_middle, city,
state, zip_area, country, bio_short, bio_desc) AGAINST
your password should replace password
Your hostname should replace `hostname`
Hope this helps
Thanks
Emery
- Original Message -
From: Lost Idols [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 00:06
Subject: What is code and what's not?
I found a script on
Pete,
what does
SHOW VARIABLES LIKE '%timeout%';
say?
Does the MNRD mysqld server crash? Anything in the .err log?
What do you have as max_packet_size in my.cnf? Could row: 13154861 be bigger
than that?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions,
Chris,
you should set max_packet_size in my.cnf.
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 MySQL technical support from
Roman,
set-variable = sort_buffer_size=1M
set-variable = read_buffer_size=1M
set-variable = read_rnd_buffer_size=1M
are relevant also for InnoDB.
Only a small
key_buffer
for MyISAM is normally needed. MySQL's system tables are always MyISAM type,
and in some rare cases MySQL may create MyISAM
Hal Vaughan wrote:
I've found an odd problem in queries.
I have a lot of data regarding vehicle speeds in a survey. All the data is in
the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles
per hour in a 55 miles per hour zone. 80/55 means we have a serious speed
Don,
the InnoDB text below is only a help message, not an error, and is not
dangerous. It is not associated with the timeout problems you have on
Fedora.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup -
Rory, that's awesome. Exactly what I needed. After reading your first
reply I wrote a query that was very similar to the one you just posted
(included below). It didn't quite work right however. It was still a
lot closer than I was before. Thanks again!
SELECT
I've been playing with MySQL for a bit now (and it is playing) and I'm using
it for a number of personal sites (ie not many users, and only I really post
stuff). I've also adopted it at work, and we use it to dump Lotus Domino
information into for more structured reporting. All is good.
In the
Hi Tyler
You're welcome..I just wish I had got it right the first time :).
On 6 Jan 2004 at 3:15, Tyler Longren wrote:
Rory, that's awesome. Exactly what I needed. After reading your first
reply I wrote a query that was very similar to the one you just posted
(included below). It didn't
On Mon, 5 Jan 2004, Hal Vaughan wrote:
I've found an odd problem in queries.
I have a lot of data regarding vehicle speeds in a survey. All the data is in
the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles
per hour in a 55 miles per hour zone. 80/55 means we have
Hello folks :)
I'm trying to eliminate a filesort from a very simple query but having
no luck. Even though I've read the manual section on when indexes are
used in conjunction with ORDER BY, it seems I just can't get an index to
be used.
I'm running MySQL 3.23.58.
The table:
CREATE TABLE
I need a WEEKOFMONTH function for a calendar query. Does
anyone have such a function already?
What are the semantics?
What I need is the first Monday of each month type of function.
WHERE
DATE_FORMAT(.$this-objE-_table..cal_datetime, '%Y-%m-%d')
= DATE_FORMAT('$dt', '%Y-%m-%d') AND
Ian O'Rourke wrote:
I've been playing with MySQL for a bit now (and it is playing) and I'm using
it for a number of personal sites (ie not many users, and only I really post
stuff). I've also adopted it at work, and we use it to dump Lotus Domino
information into for more structured reporting.
Ian ORourke said:
In the near future we face making a decision for a database backend,
and the logical choice for us is MSSQL as we have one server already
for Great Plains - but it would seem MySQL is much cheaper.
Perhaps. But supporting 2 database servers sounds like the most
expensive
On Mon, 5 Jan 2004, Allen Weeks wrote:
Hi All,
Just a quick question, does anyone have a good estimate of when ver 4.1 will
go production.
When known bugs are fixed.
You can read up on MySQL's release policy here:
http://www.mysql.com/doc/en/Release_philosophy.html
--
MySQL General Mailing
I am on my first MySQL DB and it is very text heavy because it is a
news site, therefore there is a great deal of use of the apostrophe or
as MySQL would see it the single quote. I was hoping to be able to use
double quotes to overcome the need to constantly have to escape the
[snip]
Are my prayers answered? I have been a bit concerned that I might not
be able to completely fulfill my clients needs because of them being
restricted to the use of single quotes.
[/snip]
Mat,
What is your programming language for the site? If it is PHP you have a
wealth of options for
I'm lead developer for a company that writes custom software for the mining industry.
We support MSSQL and MySQL. I've found that from a programming aspect (VB + ADO) there
is relatively little difference between MSSQL and MySQL. There is some sight syntax
differences and MySQL versions 5.0
Direct your developer to www.vbmysql.com. This site is dedicated to supporting
developers who want to use MySQL with VB. We will be happy to help him with anything
he runs into while writing your system for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
Is altering a table and column supported for the
characterset/collation?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives:
Hi,
In MySQL 4.1, is there a function to know what the
current default server-wide characterset is?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
DK It depends why step 3 failed.
DK If you want to rollback the transaction to the beginning on any error,
DK you
correction:
D Data integrity logic should be ensured by client application
should be read as:
Data integrity logic should be defined by client application
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Quoting robert_rowe [EMAIL PROTECTED]:
I'm lead developer for a company that writes custom software for the mining
industry. We support MSSQL and MySQL. I've found that from a programming
aspect (VB + ADO) there is relatively little difference between MSSQL and
MySQL. There is some sight
On Tue, 6 Jan 2004, Martijn Tonies wrote:
Hi,
In MySQL 4.1, is there a function to know what the
current default server-wide characterset is?
You can find all those with:
SHOW VARIABLES LIKE 'character_set%'
cheers,
Tobias
--
MySQL General Mailing List
For list archives:
Quoting DeBug [EMAIL PROTECTED]:
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
DK It depends why step 3 failed.
DK If you want to rollback the transaction
Hi Tobias,
On Tue, 6 Jan 2004, Martijn Tonies wrote:
Hi,
In MySQL 4.1, is there a function to know what the
current default server-wide characterset is?
You can find all those with:
SHOW VARIABLES LIKE 'character_set%'
Thanks, that'll do the trick.
Is there any reason why variable
I've found, in my many years of app dev work with Oracle, MSSQL, and now a little
MySQL, that stored procedures are a very mixed blessing.
Depending on your application architecture, they be just what you want, a means of
encapsulating a complicated, data-centric function. Database stored
As I understand stored procedures:
Stored procedures offer a level of performance that you normally can not
replicate in code. The stored procedure actually has the query stored in the
query parser ready to rumble. You do not have to invoke network or socket
overhead in calling a long query and
Matthew Stuart said:
I am on my first MySQL DB and it is very text heavy because it is a
news site, therefore there is a great deal of use of the apostrophe
or as MySQL would see it the single quote. I was hoping to be able
to use double quotes to overcome the need to constantly have to
This is basic, but need help anyway.
I am using PHP and Mysql on a webpage. Here
is my query which works:
$query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as
timein FROM emp2 where mo
nth(hdate)=$mymonth order by timein;
now I need to modify it so that it ignores all
[snip]
$query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate))
as
timein FROM emp2 where mo
nth(hdate)=$mymonth and empnum order by timein;
[/snip]
Change to single quotes around data
$query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate))
as timein FROM
Jay Blanchard wrote:
[snip]
$query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate))
as
timein FROM emp2 where mo
nth(hdate)=$mymonth and empnum order by timein;
[/snip]
Change to single quotes around data
$query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) -
Hi,
I am trying to build an application in Java (1.4.2) which will have a
notification mechanism to notify various components within the system when
database changes occur. Since MySQL does not support triggers I am trying to
figure out an efficient way of implementing this. How can I know
Description:
Maybe that I abuse the API. Nevertheless, the server should
not crash. I tried with a self-compiled kernel, from the 5.0
bitkeeper repository and with the pre-compiled version
mysql-standard-5.0.0-alpha-pc-linux-i686.
The message is:
mysqld
Obviously, the details are vague here, I was just wondering if anyone had
any stories, personal ones, rather than the press announcements, of adopting
MySQL for line of business, critical stuff - what it involved, how it went,
what issues they faced in getting it accepted and so on.
I'm
MySQL 5.0 does support triggers. It is still alpha though.
You might try using a timestamp field and polling your tables at intervals. It won't
be real time but it might be close enough.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Description:
I had some difficulties to send a bug report by mysqlbug. It
inserted my UNIX user name as From: and used some default mail
agent, which used my UNIX username @ local domain as the
sender address. While the first is merely uncomfortable, the
Description:
FLUSH TABLE name requires a global RELOAD privilege, even
though it only operates on a table in a given database. RELOAD privileges
cannot be granted on specific databases or even tables.
How-To-Repeat:
mysql grant reload on test.* to [EMAIL PROTECTED];
ERROR 1221 (HY000):
I poked around the docs and mailing list for a bit, and didn't see any references to
ideas/future of this? I'm not looking so much just to store xml in MySQL, obviously I
can just use a text column for that. I was more thinking along the lines of eXist and
dbXML and the XML:DB initiative in
Morten Gulbrandsen wrote:
http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston
Subject: Re: Can MySQL table handle 3 million+ entries?
Newsgroups: comp.lang.php
Date: 2003-04-11 15:20:10 PST
MySQL is NOT a toy database - it is far superior to many I have used in my
long
Thanks for the responses on this. I've gotten so used to using the ref
materials I have on hand that, unfortunately, I forgot to check online
manuals from time to time. (My measly sources had helped with what I needed
until now and my best source, MySQL Cookbook, is on loan to a friend.)
I
Kool,
there are no longer GPL binaries of MySQL for SCO operating systems. Only
commercial binaries that you have to buy from MySQL AB.
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
At 19:04 6/1/2004 +, Mike Brickman wrote:
If you are able for to build myisamchk from the 4.1 bk tree
it will permit you to set a max row length for to skip them
and continue the recovery.
Hi,
I have a client who has managed to corrupt an MYD table so that it can
not be repaired. I have
I have a mysql database that is running in conjunction with a PHP website,
and I am experiencing some significant slowdowns in times of moderate
traffic.
Now, by moderate, I mean moderate for them, but fairly light traffic in
terms of actual visitors.
The library the is causing the slowdowns
Is it possible that some portions of your code do not disconnect thier db connections
when they are done? I've seen issues like this with platforms that do not use db pool
managers to ensure release of db connections when they are idle for a while.
Particularly if there are error scenerios
Dan:
Thanks for the suggest. I will check it out. The strange thing is that as
I mentioned, the PHP code that I am using is straightforward, and I have
never had any problems with the database not disconnecting properly with
PHP, but that being said, the possibility that it is a db connector
soapbox
Back to stored procedures for a second. I use them with MSSQL. For certain tasks they
greatly improve performance because I don't have to move all the data client side. For
the vast majority of tasks though stored procedures yeild little performance gain.
I've seen systems that
Try single quotes around instead of double quotes.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Original Message -
From: robert_rowe [EMAIL PROTECTED]
Will I use them in MySQL 5.0? Probably, but only when justified.
/soapbox
So what are the justifications? What makes a wise stored procedure and an
unwise stored procedure?
--
MySQL General Mailing List
For list archives:
Any chance that there's a quarterly strategic roadmap published
somewhere?
I have projects that sometimes depend on a feature in the next rev' or
some such, and I need to plan out for my organization... Difficult to
answer my boss when the dependencies are released when they're ready.
All IMHO of course...
Will I use them in MySQL 5.0? Probably, but only when justified.
/soapbox
So what are the justifications? What makes a wise stored procedure and an
unwise stored procedure?
I've used them a lot with Oracle. The n-tier days weren't really alive
when I was doing that
You could always write your own function to do the escaping for you. This following
link is an example written in VB that you could adapt to whatever language you are
using.
http://www.vbmysql.com/samplecode/stripquote.html
Here is another way of doing it if you can link to the libmySQL.dll
Just fired up mysql 3.23.53 *
Created a d/b, and then created an admin user for that d/b, using
GRANT ALL ON URCMS.* TO urcms_admin
IDENTIFIED BY 'changeme'
WITH GRANT OPTION;
Ok, it never prompts me for a password, nor did it let me, as that user, use
URCMS. I looked in
In the last episode (Jan 06), Ludwig Pummer said:
I'm trying to eliminate a filesort from a very simple query but
having no luck. Even though I've read the manual section on when
indexes are used in conjunction with ORDER BY, it seems I just can't
get an index to be used.
Sometimes a filesort
Hi mark,
I would recommend to use
GRANT ALL ON URCMS.* TO 'urcms_admin'@'localhost'
IDENTIFIED BY 'changeme'
WITH GRANT OPTION;
if you only need to connect to URCMS database from localhost.
HTH
Michael
mark wrote:
Just fired up mysql 3.23.53 *
Created a d/b, and then
There was a user comment under the Foriegn Key section of the documentation reading:
To restore from a mysqldump file that uses foreign keys:
mysql SET FOREIGN_KEY_CHECKS = 0;
mysql SOURCE your_dump_file;
mysql SET FOREIGN_KEY_CHECKS = 1;
The command I am looking for is the call SOURCE. Where
On Tuesday 06 January 2004 03:27 pm, Michael Wittmann wrote:
I would recommend to use
GRANT ALL ON URCMS.* TO 'urcms_admin'@'localhost'
IDENTIFIED BY 'changeme'
WITH GRANT OPTION;
if you only need to connect to URCMS database from localhost.
The problem is that I'm
On Tue, 6 Jan 2004, Knepley, Jim wrote:
Any chance that there's a quarterly strategic roadmap published
somewhere?
I have projects that sometimes depend on a feature in the next rev' or
some such, and I need to plan out for my organization... Difficult to
answer my boss when the
Hi,
I downloaded the 5.0 binary for windows and installed it, but I can't create
store procedure using MySQL Control Center, does the 5.0 alpha-binary have
store procedure feature?.
TIA,
Ulises
At 01:56 PM 1/6/2004, you wrote:
Just fired up mysql 3.23.53 *
Created a d/b, and then created an admin user for that d/b, using
GRANT ALL ON URCMS.* TO urcms_admin
IDENTIFIED BY 'changeme'
WITH GRANT OPTION;
Yup. Well known privileges problem. The short answer is that the
On Tue, 6 Jan 2004, Luc Foisy wrote:
There was a user comment under the Foriegn Key section of the documentation reading:
To restore from a mysqldump file that uses foreign keys:
mysql SET FOREIGN_KEY_CHECKS = 0;
mysql SOURCE your_dump_file;
mysql SET FOREIGN_KEY_CHECKS = 1;
The command
At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote:
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS SQL). It is all
windows based software (written in VB).
So far his arguments against it are this (not my words):
-No
Hi!
I have a hobby of predicting release dates.
It took 17 months for 4.0 to be declared 'production'. That gives us an
estimate that 4.1 will be declared 'production' in September 2004. But since
4.1.1 already seems to be a very stable release, I expect it to happen
sooner.
Best regards,
Hi!
On Jan 06, Mike Brickman wrote:
Hi,
I have a client who has managed to corrupt an MYD table so that it can
not be repaired. I have tried:
Myisamchk -re {table}
And this crashes out with:
myisamchk: error: Not enough memory for blob at 3960 (need 1090519040)
and then
Hello,
I changed etc/sysconfig/i18n to:
LANG=fr_FR
SUPPORTED=fr_FR:fr
SYSFONT=lat0-sun16
SYSFONTACM=iso15
and everything works perfectly.
Thank you very much for your help.
Greetings,
Willy Dockx
-Original Message-
From: David Bordas [mailto:[EMAIL PROTECTED]
Sent: dinsdag 6
Mike Morton said:
Dan:
Thanks for the suggest. I will check it out. The strange thing is that
as I mentioned, the PHP code that I am using is straightforward, and I
have never had any problems with the database not disconnecting properly
with PHP, but that being said, the possibility that
Hi!
I have some trouble tring to compile Mysql 4.0.17 with de options:
--with-vio --with-openssl, I try with some recomedation about it but
none
successful.
Compiling with:
./configure --with-vio --with-openssl=/path/to/openssl --with-openssl-includ
e=/path/to/include/ssl.h
Here're a couple of tables:
create table company(CompanyID varchar(32),...);
create table contact(CompanyId varchar(32),...
INDEX (CompanyID),
FOREIGN KEY (CompanyID) REFERENCES company(CompanyID);
Now, my expectation is that if contact has a CompanyID but it does
not
match one already
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because
I have 3.23 that comes with my Linux distribution, now when I tried to
do a rpm installation of 4.0, I got messages like:
warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID
...,
file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with
file from package
You can use navicat-pro tool (free ware) to repair
the corrupted MYD files, I was repaired with the same
TOOL.
-Aman.
miguel solorzano wrote:
At 19:04 6/1/2004 +, Mike Brickman wrote:
If you are able for to build myisamchk from the 4.1 bk tree
it will permit you to set a max row length for
Hi everyone,
I am trying to get the following statement to work from any directory
besides [ /usr/local/mysql/data/testdb ] :
LOAD DATA INFILE 'data.txt' INTO TABLE sometbl TERMINATED BY '|' LINES
TERMINATED BY '\n';
I see ERROR 1105: File './testdb/data.txt' not found (Errcode: 2)
I also
So what are the justifications? What makes a wise stored procedure
and an unwise stored procedure?
Use them when there is a real benefit to using stored procedures. I will give one
example when I would have used them:
With a CRM solution I once wrote, I wanted to get a list of n randomly
Hi
I understand the concept of master n slave
relationship but have certain queries regarding
this...
1) In case the master is down i do i configure my
system so that a present active slave becomes the
master or any other way to tackle this
situation.How
does the clients know
83 matches
Mail list logo