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 ab
>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 sel
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 star
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 t
Hi All,
Is anybody having interview point of questions on mysql ,
pl. let me know any other source..
-Aman.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 mysql-3.2
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 there
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 there
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 there
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 e
> 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
One solution is to define a separate table "changes" in which you insert the
changes, updates, deletes (possible field names: id, change_date,
change_type, affected_table, affected_id). That means, if you
updates/inserts/deletes record in a table, you make an additional entry in
the new table "chan
On Tuesday, January 06, 2004 2:54 PM, Patrick Shoaf wrote:
> At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote:
> >Now, I know there are a few discrepancies there but I just don't know
> >enough to argue it. I * need* to use MySQL as the server because of
> >cost reasons. I *WANT* to use MySQL b
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
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
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)
>
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,
Heikk
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
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;
>
> T
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 defaul
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
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 depend
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 tha
The usual solution to this problem is to always code for things that exist.
Then you have a relatively predictable coding path and relatively reliable
testing tools.
In the best of circumstances, you have no control over when something will
be sufficiently bug-free and reliable to move into pro
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
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 create
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 files
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 mysql
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 (o
All IMHO of course...
> > Will I use them in MySQL 5.0? Probably, but only when justified.
> >
> >
>
> 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
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."
-Or
Original Message -
From: "robert_rowe" <[EMAIL PROTECTED]>
>
> Will I use them in MySQL 5.0? Probably, but only when justified.
>
>
So what are the justifications? What makes a wise stored procedure and an
unwise stored procedure?
--
MySQL General Mailing List
For list archives: http:
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]
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 (designed as M
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 pro
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 whe
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 simp
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 tri
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 quits.
There is no complete backup of this file
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 f
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
Morten Gulbrandsen wrote:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=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 ca
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 pa
>Description:
FLUSH TABLE 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): Wron
>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
lat
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:http://li
> 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'
>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 go
Michael,
Thanks very much for the insites.
Cheers,
-Richard
Michael Stassen wrote:
I've faced the same questions you raise here. Some things which occur
to me:
First, are you certain that 4.0.5a is working "perfectly"? A lot of
bugs have been fixed since then. Is it possible you just hav
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 whe
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()) - YEA
[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 FR
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
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
>
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 yo
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 proce
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
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 r
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: http://lists.m
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 si
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 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 to the beginning on any error,
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 lis
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: http://list
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 u
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 d
[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 es
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
apostrophe/single
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 Maili
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
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. All
> >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
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 `min
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
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
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 nea
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 worker.fname,worker.lname,worker
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 - a
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
demon
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
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 https:/
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,
your password should replace
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 this
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 ('kan
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 resul
!= 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
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="latar
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
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
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 ta
90 matches
Mail list logo
