ds, 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; [EMAIL PROTECTED]
> &g
ebprojectassign 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 Se
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
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
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
[
Here's what I do:
Insert their post into the database at the very top of the page. Then use
php's header() function to forward them to another page after the post has
been put into the database. This way, they can reload all they like because
they'll no longer be on the page that puts the post
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: Authentic
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
&
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 i
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
Subjec
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 i
ewall? If it is, you
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
your help!
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:5
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, Febr
;t get
executed properly. It only works correctly when issuing the query from the
mysql command line client. :)
Tyler
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, Febr
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
S
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 boa
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 PR
mysqldump -hhostname -uuser -ppassword database table > table.sql
That will dump the structure and data of the table to the file table.sql
Tyler
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 17, 2002 10:02 AM
Subject: How to save the table
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 m
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]&
name='$username' 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
n" <[EMAIL PROTECTED]>
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 de
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
odes'. The
passcodes table has 2 fields: 'id' and 'passcode'. I run this:
LOAD DATA INFILE 'Sheet1.txt' INTO TABLE passcodes FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n';
Nothing gets inserted into the &
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]&
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: Wedn
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, pl
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 MyS
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.
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
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
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?
>
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
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
$ 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
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 A
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 selecti
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
---
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 o
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
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 could
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 d
just do:
mysqldump 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 3.2
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 ha
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
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 a
t because phpMyAdmin can't even change the id.
Anybody have any 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
---
I need to do 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, p
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)
http://lists.mysql.
EMAIL 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
elect the top 2 most viewed bands(which would be WISH &
Deftones)? I've tried a few things, but haven't gotten anything to work
correctly for me. Thanks.
Tyler Longren
-
Before posting, please check:
http://www.
nre 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]%' ORD
ver find 'Classical'. So, how can I search 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.m
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.
57 matches
Mail list logo