table. So shouldn't this SQL just return the
fname,lname,workerid from the workers table? Could someone just
explain to me why this doesn't work the way I expected it to?
Maybe I'm doing something wrong.
THANKS!
Best Regards,
--
Tyler Longren
J.D. Web Services, L.C.
--
MySQL General Mailing
how to do this in
mySQL. When I've needed such a query, to find 'childless' records, I've
always done it with a looped query in the client program.
-Original Message-
From: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 06, 2004 9:19 AM
To: Tyler Longren
MySQL CC from www.mysql.com is pretty good.
Tyler
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:49 PM
Subject: mySQL GUI
I have recently purchased the lease of a dedicated mySQL server running on
linux.
I normally
UmI don't think anyone (or hope noone) on this list is stupid
enough to get sucked in by a piece of spam.
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Thu, 11 Jul 2002 15:39:33 +0100
Kevin Passey [EMAIL PROTECTED] wrote:
Do not give your
Hi Amaury,
R.B. Roa would be correct in saying that subqueries are in the 4.x branch of
MySQL. I'm not sure when 4.xx will be the stable branch though. Instead of
using subqueries, you could try using some JOIN statments.
Tyler Longren
Captain Jack Communications
www.captainjack.com
[EMAIL
did you FLUSH (reload) your mysql server?
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Dan Egli [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 04, 2002 6:21 PM
Subject: Authentication messed up?
I tried
It can't, try using JOIN.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Leo Przybylski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 1:35 PM
Subject: Subqueries
Hello all,
Does anyone know
MySQL will be good for this type of stuff.
Tyler
- Original Message -
From: Zhao, Charles [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 3:53 PM
Subject: Beginners Question
Hello there,
I am trying to find which database to use. I will have text and image
You have to have the LIMIT clause after the ORDER clause.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: destr0 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 30, 2002 1:32 PM
Subject: LIMIT, ORDER Dilema
Can
Visual Basic and Visual C++ are 2 completely different things, so no, visual
basic will not work.
There might be some free C++ compilers for you to use for windows. You
could always buy a copy of an older version of Visual C++. Older versions
probably won't be too horribly expensive.
Tyler
This worked for me:
SELECT * FROM table ORDER BY id ASC LIMIT 9,21;
There's probably a better way to do that though.
tyler
- Original Message -
From: Aman Raheja [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 2:04 PM
Subject: select a certain num of items in sql
might want to open port 3306 on the firewall.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Paul Rose [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 27, 2002 11:07 PM
Subject: Host permissions
I have read the mail
I suggest you use MySQL from MySQL AB. Progress Software (parent of
NuSphere), is having some legal troubles.
http://www.newsforge.com/article.pl?sid=02/02/26/1825200
Tyler
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 1:01 PM
Nope, privs are the same.
Tyler
- Original Message -
From: Daniel Rosher [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 5:19 PM
Subject: RE: SET field=field+1 no longer works?
Have
!
tyler
- Original Message -
From: Stewart Gateley [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 5:56 PM
Subject: Re: SET field=field+1 no longer works?
Try:
UPDATE users SET board_posts
Hello,
I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until
3.23.49 was released. After upgrading to 3.23.49, queries like this don't
work:
UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND
password='blah';
Normally, that would increment the value in
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
It's at the bottom of every message sent to this list.
Tyler
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
is mysqld running on your box?
Tyler
- Original Message -
From: Rich [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Monday, February 11, 2002 6:49 AM
Subject: Where Did Mysql Go?
I was working on updating some databases yesterday and when I booted up
my computer this morning I
Might wanna try MySQL Front at http://www.mysqlfront.de.
It's pretty good.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: John Mayson [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, December 24, 2001 6:41 PM
' because that will
give me a bunch of gibberish. Is there anyway to get the password back into
plaintext to be emailed to the user?
Thanks,
Tyler Longren
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hello,
I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED]
(using password: YES)
errors. I'm connecting to this MySQL server from a remote site.
I don't see any reason for this. I KNOW that my password is correct. In
the user table, the Host is set to % for the mysql user.
]
To: Tyler Longren [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2001 3:28 PM
Subject: RE: Error 1045 - Access denied
Hello,
I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED]
(using password: YES)
errors. I'm connecting to this MySQL
mysqldump -uusername -ppassword -hhostname dbname dbname.sql
That will dump the database 'dbname' into the file 'dbname.sql'
Tyler Longren
- Original Message -
From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 9:40 AM
I think that's the error code that's spit out when permissions are wrong on
the DB file. You might want to check permissions.
Good luck,
Tyler Longren
- Original Message -
From: Venu Allavatam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 28, 2001 4:10 PM
Subject
DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
Anyone know what that means? As you can see, it came from tryign to do a
DROP on a table.
Thanks,
Tyler Longren
-
Before posting, please check
Does /var/lib/mysql/mysql.sock exist???
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 21 Aug 2001 10:06:43 -0700 (PDT)
my sql [EMAIL PROTECTED] wrote:
On a new install of Suse 7.2 I get this message when
attempting to acces MySQL through a php
post some code. Make sure you're using quotes in the right places.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 14 Aug 2001 13:39:48 -0700
Nate Sanden [EMAIL PROTECTED] wrote:
Hey im pretty new to mysql, but I made a basic html form and used php
Which Linux 7.0 are you using?
I'll assume you're talking about Redhat. So why don't you just download
the mysql rpm and install it instead of doing it from source?
Good luck,
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
I don't think MySQL supports sub selects.
Tyler
On Tue, 07 Aug 2001 14:57:33 +0200
Anders Alstrin [EMAIL PROTECTED] wrote:
Does anyone know how to do this sub select in MySQL.
I know how to do it in Oracle!
table media
+--+---+--+
| media_id | price |filename |
No need to install locally. You could write everything locally, upload it
to the server, and see if what you wrote works.
Tyler
On Tue, 7 Aug 2001 13:51:01 +0100
Matt Gaskin [EMAIL PROTECTED] wrote:
Hi All
Currently I have rented space on a Web Server that has MySql installed
and
PHP,
Get the mysql client from www.mysql.com.
Tyler
On Sun, 5 Aug 2001 13:38:09 -0400
Chris [EMAIL PROTECTED] wrote:
Is there a method I can use to log into a remote mysql server through
something such as telnet to pass queries on my database?
You could just filter for [EMAIL PROTECTED]. That's what I do.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 7 Aug 2001 17:12:29 -0700, Randy Johnson wrote:
I am not sure if this has been addressed before, I think it would be
neat if
the list admin
$ ps -ax | grep mysqld
get the pid of mysql
$ kill -9 pid_of_mysql
that'll do it.
:)
Tyler
On Thu, 26 Jul 2001 13:24:41 -0500
cjackson [EMAIL PROTECTED] wrote:
Hello all,
I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server
running apache and php. I could start msqld and
Try doing it as root if you're not already.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Michael Nezi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 11:08 AM
Subject: Problems running
Hi everyone,
Is there a way to NOT select the last row that was inserted into a table? I
want everything before it.
I know how I could do this using 2+ queries, but can it be done by issuing
just 1 query?
Thanks everyone,
Tyler
That should work just fine. :)
Thanks!
- Original Message -
From: John Meyer [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Friday, July 20, 2001 3:21 PM
Subject: Re: not selecting last row
At 12:25 PM 7/20/01 -0500, Tyler Longren wrote
copy a table:
mysqldump database table_name table.sql
or to copy the whole db:
mysqldump database db.sql
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 12:51 PM
Subject: Easiest way to create a duplicate of a db?
do this:
mysql -uusrename -ppassword dbname brand.txt
mysql -uusrename -ppassword dbname brand.sql
Tyler
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 1:59 PM
Subject: How do I restore a database backed up using
Hello everyone,
I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had
been running just fine, then all of a sudden stopped working. When I try a
'NET START mysql', I get the below error:
---Begin Error
The MySql service is starting.
The MySql service
just do:
mysqldump options db_name db_name.sql
Your database tables and contents will be dumped into db_name.sql
Tylre
- Original Message -
From: ah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:19 PM
Subject: constraint question
hi
I am using mysql
You'd probably be interested in PHP:
www.php.net
Tyler
- Original Message -
From: Laura Lía Marcello [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:03 PM
Subject: Connect mySQL with HTML or something
I need to know if there is a way to create a searchable
you should probably just store the images on your server, and provide the
location to the image in the table...much quicker.
Tyler
- Original Message -
From: Felicia [EMAIL PROTECTED]
To: mysql post [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 11:03 AM
Subject: inserting images in
http://mirror.sit.wisc.edu/mysql/downloads/gui-clients.html
Tyler
- Original Message -
From: John Kennedy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2001 10:31 AM
Subject: mysql GUI for windows NT/98 is it available?
I am just curious to know whether you have
Default mysql port is 3306.
Tyler
-Original Message-
From: sanborn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 9:36 PM
To: MySQL Mailing List
Subject: MySQL Port number
How is MySQL used over a network? I assume there is a port involved, and
some kind of
ideas why this happened? BTW, I'm running mysql-3.23.38 on NT4.
Thanks everyone,
--
Tyler Longren
[EMAIL PROTECTED]
Currently Unemployed
www.noworkfortyler.com
-
Before posting, please check:
http://www.mysql.com/manual.php
This post can be ignored now. Turned out the datatype for the id field was set to
tinyint, changed it to int and everything worked great.
Tyler
On Thu, 31 May 2001 00:26:12 -0500
Tyler Longren [EMAIL PROTECTED] wrote:
Hello everyone,
I have a database of alumni at school. Each alumnus
is select a
maximum of 2 entries for each artist. I've tried a few different things, but nothing
has given me what I need. Is there any way to do this?
Thanks everyone,
Tyler Longren
-
Before posting, please check:
http
Hello List,
I'm going to be storing a LOT of MP3's in a MySQL db, what's the best field
type to use? Blob?
Thanks,
Tyler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
PROTECTED]]On Behalf Of
--==[bMan]==--
Sent: Sunday, April 01, 2001 4:37 PM
To: Tyler Longren
Cc: MySQL List
Subject: Re: most viewed
You should definitely read up the manual. If you don't do this, will not do
you homework and simply expect an answer handed down to you, you might get
$genre_array[1]%' OR genre LIKE '%$genre_array[2]%' OR genre
LIKE '%$genre_array[3]%' OR genre LIKE '%$genre_array[4]%' OR genre LIKE
'%$genre_array[5]%' OR genre LIKE '%$genre_array[6]%' OR genre LIKE
'%$genre_array[7]%' OR genre LIKE '%$genre_array[8]%'
a field for a
string of text?
Any replies are welcome, thanks,
Tyler Longren
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Well, since you're running a P4, I don't think you should be using this:
mysql-3.23.33-unknown-linux-gnu-alphaev6
That's for Alpha processors.
Instead, get this:
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.33-pc-linux-gnu-i686.ta
r.gz
Compile the above. It should work better for you.
52 matches
Mail list logo