We have a MySQL database where every second couple of tens of kilobytes to a couple
hundred kilobytes of data is inserted into the database. Note here that largest chunk
of the data is consisted of a Blob. This data (including the blob) is continuously
queried by an application which displays
Hi all,
This is my first post on MySQL.
Wondering if someone could help me with an sql statement
MySQL version 4.0.18
I have three tables:
1. visitor_data (Visitor_ID, IP Address)
2. visit_data (Visit_ID, Visitor_ID)
3. page_data (Page_ID, Visit_ID, Visitor_ID, URI, Page_Time)
If y
Use INNODB and use FK constraints / cascades.
> -Original Message-
> From: LastingImages [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 6:33 PM
> To: [EMAIL PROTECTED]
> Subject: Creating Relationships
>
> OK I am a umber newbie. And I have decided to change that. I was
> w
You can always go to a mirror.
http://mysql.mirrors.pair.com/
Even though Jim, I think that's his name would probably like to know about
the problem.
Donny
> -Original Message-
> From: Brad Teale [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 7:37 AM
> To: 'Peter Burden'; L
OK I am a umber newbie. And I have decided to change that. I was
wondering how do you create relationships between tables? If you know
where it talks about it in the MySQL reference manual you can direct me
there. But I have not been able to find it. So this is my first
question. Thank you!
Bryan
This might work for you although I would just fix my connection ;)
http://freshmeat.net/projects/mysql_proxy/
> -Original Message-
> From: Alexander Newald [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 5:36 PM
> To: [EMAIL PROTECTED]
> Subject: unstable mysql connection
>
I am not sure if I got the address correct to submit questions so I
decided to try it out. I will see if I have it together.
At 13:38 -0700 4/21/04, John Mistler wrote:
When issuing commands through the terminal (in Mac OS 10.3) to MySQL, I
understand that if you surround a variable with "\\`" it will allow for
characters such as - and space. Will it also allow for all other
non-alphanumeric characters such as / and * a
At 18:51 +0200 4/21/04, Jacek Jaroczynski wrote:
Is there possibility to first LIMIT and then ORDER records?
Not with a single SELECT. ORDER BY occurs before LIMIT.
You could use LIMIT and select into a temporary table, then
select from the temporary table with ORDER BY.
Using simple query I can
At 18:43 -0400 4/21/04, Brad Tilley wrote:
Hello Mysqlers,
I have a few small DB's (less than 10,000 entries per table) that track
computer inventory in a mid-sized organization. Currently, all of the tables
are MyISAM. Is there any compelling reason to convert these to InnoDB? We're
not having an
Hello,
I've an application client that stores it's data in a mysql server. Client
and server (Both linux) are on diffrent hosts, I can't change the
application but I have root access on both server and client.
The problem: Sometimes the lan connection has paket drops (about 1%) and the
connection
At 15:42 -0700 4/21/04, cristopher pierson ewing wrote:
Apologies if this is an easy one, I'm stumped!
I'm having some trouble with syntax running MySQL from the command line.
I'm running MySQL 4.1.1-alpha from the OS X standard installer package on
a G5 running panther.
I have logged into MySQL
http://dev.mysql.com/doc/mysql/en/News-4.0.x.html
> -Original Message-
> From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 4:45 PM
> To: Dathan Vance Pattishall; [EMAIL PROTECTED]
> Subject: RE: ERROR 1030: Got error 127 from table handler
>
> At 04:42 P
At 04:42 PM 4/21/2004 -0700, Dathan Vance Pattishall wrote:
There is a delete bug where frequent deletes can cause table corruption.
Upgrade to 4.0.18 -- I believe its been fixed by now.
Is there a bug fix list that I can lookup on the net to make sure that this
error has been fixed?
thanks
bha
No, there is no reason to covert them to INNODB unless you want an ACID
compliant table format, and have disk space to spare.
MYISAM support a wide variety of mySQL featured, such as full text searches,
a key buffer, and a few other nice things such as a being able to get a row
count in ms time.
Left click on the binary and look at the access permissions.
> -Original Message-
> From: vasanthsena x [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 2:50 PM
> To: [EMAIL PROTECTED]
> Subject: Uninstall mysql
>
> Hi,
>
> I tried to uninstall mysql from win Xp.however it did
If I'm reading my Spanish correctly
http://www.mysql.com/products/mysql/
Its not going to get much better then this.
> -Original Message-
> From: María de los Angeles Vargas [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: bajar mysql
Depends on your result set size and your query cache hit rate, which all can
be figured out from a show status command.
--
DVP
> -Original Message-
> From: Mark [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 3:43 PM
> To: [EMAIL PROTECTED]
> Subject: 64M too much?
>
> Hello,
Use explain [INSERT YOUR SELECT STATEMENT]
Verify your using keys and if you are using keys ensure that the join say
eq_ref and the first key is const. If this is the case then this is the
fastest possible join you can do for the statement below.
--
DVP
> -Original Message-
> From: kamle
A couple of days ago we just started experiencing slow MySQL responses
to queries. We upgraded to php 4.3.4 and apache 1.3.29 on our web
environment and ever since then we have experienced this. Our Database
server is seperate from our web environment however, and no changes were
made to it.
Store the result set in a array of hashes and loop through that array to
build the rest of the form.
--
DVP
> -Original Message-
> From: Scott Swaim [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 12:17 PM
> To: Mysql
> Subject: reuse results set
>
> I have a form that does
Hello,
Just a quick question: running MySql 4.0.18, is a 64M query cache too large?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You need to flush privileges to get the new ones active or restart mysql.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 12:55 PM
> To: [EMAIL PROTECTED]
> Subject: problem
>
> hi,
> I reinstalled mysql again and did what
There is a delete bug where frequent deletes can cause table corruption.
Upgrade to 4.0.18 -- I believe its been fixed by now.
> -Original Message-
> From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 1:30 PM
> To: [EMAIL PROTECTED]
> Subject: ERROR 1030: G
De donde puedo bajar la ultima versión de mysql.
The only other thing I can think of off the top of my head is Crystal's very
poor handling of prefix and postfix data in sub-reports. If you are using
sub-reports make sure a field in the table in question is at least
referenced on the main report.
Sorry I couldn't be more help.
Pat...
- Or
Hi,
I tried to uninstall mysql from win Xp.however it did
not remove everything completely.I tried to remove the
files manually but specifically it does not let me
delete mysqld.exe.it says access denied.
Can anyone help me?I would to reinstall mysql.
S.
Apologies if this is an easy one, I'm stumped!
I'm having some trouble with syntax running MySQL from the command line.
I'm running MySQL 4.1.1-alpha from the OS X standard installer package on
a G5 running panther.
I have logged into MySQL as the root user, providing the correct password,
and I
Hello Mysqlers,
I have a few small DB's (less than 10,000 entries per table) that track
computer inventory in a mid-sized organization. Currently, all of the tables
are MyISAM. Is there any compelling reason to convert these to InnoDB? We're
not having any performance or size issues... everythi
You don't mean at the Discovery Cove near the "Jimmy Buffet" cover band
do you?
Speaking of which, Lars... there's an English expression that uses the
word Cluster...but has nothing to do with databases... :)
(Kidding! Just kidding!)
Robert Reed wrote:
Yes, I'm anxious to get my hands on so
Yes, I'm anxious to get my hands on some of the
presentations myself. I think I saw a couple of brief
mentions of a url but it wasn't written down anywhere.
I'd also like to see some of the pictures I saw David
snapping everywhere. :)
--- David Perron <[EMAIL PROTECTED]> wrote:
>
> Does anyon
I generally set an array if I'm going to reuse a result. In your example, I
would do something like the following:
first_name, $speaker->last_name);
i++;
?>
Ok, what is the recommended way of handling Unicode data with version 4.0.
I believe I read that it doesn't support utf8 so how do people with version
4.0 deal with it? Do they store is as a binary object perhaps?
Looking for techniques and ideas so I'll be able to see how much work is
involved wo
Thank you Chris for that answer. I did not know if it was a mysql problem
or php problem.
Again I apologize (especially to Mike Johsnon) for the multiple request. I
was getting a return error on the list and I thought it was a configuration
error on my part. I did not mean to upset anyone. Th
From: Scott Swaim [mailto:[EMAIL PROTECTED]
> I have a form that does the following
>
> mysql_fetch_object($qid_speaker)) { ?>
>
> pv($speaker->first_name) ?> last_name) ?>
>
>
This is a PHP question, not MySQL.
http://www.php.net/mysql_data_seek
-Original Message-
From: Scott Swaim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 2:47 PM
To: Mysql
Subject: re-using a results set
I have a form that does the following
I have a form that does the following
first_name) ?> last_name) ?>
$qid_speaker = db_query("SELECT first_name, last_name FROM people WHERE speaker = 'Y'
ORDER BY la
I have a form that does the following
first_name) ?> last_name) ?>
$qid_speaker = db_query("SELECT first_name, last_name FROM people WHERE speaker = 'Y'
ORDER BY la
Is there possibility to first LIMIT and then ORDER records?
Using simple query I can first ORDER and then LIMIT like that:
SELECT id, name FROM table ORDER BY name LIMIT 20,10
Maybe should I use procedures ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
Well, in traditional SQL you'd use a sub-query for this type of operation.
In MySQL 4.1+ you could do this:
SELECT t1.myindex, t1.myval, t1.mycat
FROM mytest t1
WHERE myindex = (SELECT max(t2.myindex) FROM mytest t2 WHERE
t2.mycat=t1.mycat);
once again, just illustrating the theory,
Hi
I have been using MySQL server version 4.0.14 for the last six months in
our project and it was running just fine. We use Linux AS 3.0 (kernel
version 2.4.21-4.0.1.EL #1)
However, since last week we started to get the following error : ERROR
1030: Got error 127 from table handler ( please l
Is there possibility to first LIMIT and then ORDER records?
Using simple query I can first ORDER and then LIMIT like that:
SELECT id, name FROM table ORDER BY name LIMIT 20,10
Maybe should I use procedures ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Does anyone know if the presentations from the User Conference are available
online?
Thanks
dp
Hi,
I'm new to mysql.
I have two big tables ,tableA>4GB and tableB>1GB.
both tables around 10 million rows,each.
tableA has following two cols.
user_id(varchar(255) PRIMARY KEY
user_data1(MEDIUMTEXT)
entries looks like
user1 xyz
user2 x1..
table
The problem you are running into is that you are getting the max of one
field and grouping by another. But then you want to get a third field
that changes within the grouping.
Perhaps this might work
SELECT myindex, myval, mycat
FROM `mytest`
GROUP BY mycat
ORDER BY myindex DESC;
hi,
I reinstalled mysql again and did what the website said.
C:\> C:\mysql\bin\mysql -u root mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin -u root password "newpwd"
C:\> C:\mysql\bin\mysqladmin -u root -
Lou,
I normally download the html version of the manual and have a little search
feature just for it. And you are correct, I've looked for a few of your
examples and can't find any information on them besides you can turn them on
or off basically. Not in the mood to bust out the code to figure ou
Wouldn't it be faster to simply try this than wait on people here to notice
your question and write a reply?
Have you checked the manual? It may answer your question too
Rhino
- Original Message -
From: "John Mistler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Apri
On Wed, 21 Apr 2004 14:07:48 -0500, Mark Matthews wrote:
>> I have set the default charset to utf8. When I view my variables they all
>> show that utf8 as their value. My URL is as follows:
>
> What does the JDBC connection _itself_ show? Execute the following query
> on a java.sql.Statement, and
When issuing commands through the terminal (in Mac OS 10.3) to MySQL, I
understand that if you surround a variable with "\\`" it will allow for
characters such as - and space. Will it also allow for all other
non-alphanumeric characters such as / and * and >, etc.?
Thanks,
John
--
MySQL Gener
I use the online docs extensively as I am still very much in learning mode with MySQL.
However, I've been frustrated recently because it appears I cannot search for an
EXACT string literal, which brings me back a ton of hits I don't want. For example,
I'm trying to search for the dynamic syste
I have a form that does the following
first_name) ?> last_name) ?>
$qid_speaker = db_query("SELECT first_name, last_name FROM people WHERE speaker = 'Y'
ORDER BY la
I have a form that does the following
first_name) ?> last_name) ?>
$qid_speaker = db_query("SELECT first_name, last_name FROM people WHERE speaker = 'Y'
ORDER BY la
I think what is happening is that you are getting the max value for one
field, but the "first" values for the other fields. Try ordering you
group by:
SELECT max(myindex), myval, mycat
FROM `mytest`
GROUP BY mycat DESC;
On Apr 21, 2004, at 1:35 PM, Noah Spurrier wrote:
I'm having trouble with "
I'm attempting to put an image into a BLOB field. I'm using Visual Basic 6
with ADO, although I wouldn't think that's making a difference.
I create a string that contains the binary representation of the file. At
this point the string is 5064 characters long. I call mysql_escape_string
and the
Peter J Milanese said:
>
> The lack of error checking on the server side means better
> performance in my opinion.
Does it? Or does client side error checking use server resources as well?
Lets suppose that we want to validate a new message that is entered
into a thread on a messageboard. Then we
[EMAIL PROTECTED] wrote:
> hi,
> I am having problems with mysql.
> 1. I downloaded mysql on to my system.
> 2.installed it
> 3. ran the server using the command prompt
> C:\mysql\bin\mysqld --console
> it gave me the results that i could start using the service.
> 4. i started mysq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stormblade wrote:
> On Wed, 21 Apr 2004 10:35:16 -0500, Mark Matthews wrote:
>
>
>>Stormblade,
>>
>>If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_
>>charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a
>>propert
hi,
I am having problems with mysql.
1. I downloaded mysql on to my system.
2.installed it
3. ran the server using the command prompt
C:\mysql\bin\mysqld --console
it gave me the results that i could start using the service.
4. i started mysql on another command prompt.
what i am
On 21-Apr-2004 Alex croes wrote:
> I'm trying to select specified data from a field in a table.
> The field from which the data has to come contains the following:
> 'something;else;anything;everything;name;my' (and so on), it's a long
> text.
>
> I need in the case just 'my' from the field, th
From: Don Dachner [mailto:[EMAIL PROTECTED]
> Is it possible to do something like this?
>
> If(select * from xxx, "if record found"..update it, "if
> record not found" ..insert it)
Try the REPLACE INTO syntax:
http://dev.mysql.com/doc/mysql/en/REPLACE.html
--
Mike Johnson
Web Developer
Sma
Is it possible to do something like this?
If(select * from xxx, "if record found"..update it, "if record not found" ..insert it)
Thanks,
Don
At 11:29 -0400 4/21/04, Chris Stevenson wrote:
I'm working through a self study book and I am trying to learn how to do
a "load data local infile". I downloaded a sample database and I have
the txt file but each time I type in the command LOAD DATA LOCAL INFILE
'member.txt' INTO TABLE member; I ge
You aren't making any mistakes, it's just not possible to do. You can't rely
on which row MySQL will return when using a GROUP BY clause.
The standard method would be to do something like this:
CREATE TEMPORARY TABLE mytemptable
SELECT max(myindex) as myindex, mycat
FROM `mytest`
At 11:57 -0500 4/21/04, Carl Karsten wrote:
I am sure that i used mysqldump to create a script that had both CREATE TABLE
and GRANT commands, but now I can't figure out how.
mysqldump doesn't generate GRANT statements.
Perhaps you are thinking of some other program.
--
Paul DuBois, MySQL Documentat
I'm trying to select specified data from a field in a table.
The field from which the data has to come contains the following:
'something;else;anything;everything;name;my' (and so on), it's a long text.
I need in the case just 'my' from the field, thus between the ';'. This
time there are only
I'm having trouble with "max()" and "group by".
It seems pretty simple. I hope someone can point out my mistake.
I want to select the max index of a group.
In other words, I want to find the last record added for each group.
The problem I'm having is that the columns of the resulting rows
are mix
Hi,
is there a way i can make a restriction for inserting
data on a table?
I'll expose this idea with a simple (not real)
example.
Suppose i got table EMPLOYEE, wich has an attribute
called FLG_HAS_DEPENDENTS. I also have a table called
DEPENDENTS, wich has data for the dependents of some
employe
I am sure that i used mysqldump to create a script that had both CREATE TABLE
and GRANT commands, but now I can't figure out how.
Carl K
http://www.personnelware.com/carl/resume.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Sure.. checkout this article:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
Very fast mysql storage implementation in PHP, port the design to
whatever lanaugage suits you.
On Wed, 21 Apr 2004, adrian Greeman wrote:
> Please excuse a very simple inquiry from a near beginner
>
> If I wish t
Chris Stevenson wrote:
I'm working through a self study book and I am trying to learn how to do
a "load data local infile". I downloaded a sample database and I have
the txt file but each time I type in the command LOAD DATA LOCAL INFILE
'member.txt' INTO TABLE member; I get the following messa
Add this in your my.cnf slave file:
slave-skip-errors = 1062
Marc.
-Message d'origine-
De : Georg Horn [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 21 avril 2004 17:31
À : [EMAIL PROTECTED]
Objet : Replication problem
Hi,
i'm new to this list, but i use mysql for years an are very happ
adrian Greeman said:
> Please excuse a very simple inquiry from a near beginner
>
> If I wish to store a complete Word file or similar (Open Office perhaps)
> or an archive file - is that possible and what kind of field do I need
> for it? How do you insert a file into a table if so?
>
> I know th
On Wed, 21 Apr 2004 10:35:16 -0500, Mark Matthews wrote:
> Stormblade,
>
> If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_
> charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a
> property to your JDBC connection string.
I have set the default charset to ut
I have a form that does the following
first_name) ?> last_name) ?>
$qid_speaker = db_query("SELECT first_name, last_name FROM people WHERE speaker = 'Y'
ORDER BY l
Why doesn't the MySQL binary distribution include the shared libraries?
(At least, the Mac OS X version does not) I'd prefer to use this
distribution, but I have to roll my own in order to get shared libs to
use with PHP, Perl (for mytop), etc.
- Gabriel
--
MySQL General Mailing List
For list
I'm actually i deep doubts with this.
Price is not a thing itself, good point. But in my
case, it was the best way i found out to model.
Suppose you got a company the rents a place (just a
big room, or a party house) for any kinda envents
you'd to make. The company is clear an entity, and the
pric
Please excuse a very simple inquiry from a near beginner
If I wish to store a complete Word file or similar (Open Office perhaps)
or an archive file - is that possible and what kind of field do I need
for it? How do you insert a file into a table if so?
I know that you can store pictures - what
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stormblade wrote:
> Thanks. I'd read that already but I re-read it and noticed this part here:
>
> "When a client connects, it sends to the server the name of the character
> set that it wants to use. The server sets the character_set_client,
> charac
I'm working through a self study book and I am trying to learn how to do
a "load data local infile". I downloaded a sample database and I have
the txt file but each time I type in the command LOAD DATA LOCAL INFILE
'member.txt' INTO TABLE member; I get the following message ERROR: File
'member.txt
Hi,
i'm new to this list, but i use mysql for years an are very happy with it.
However, today i ran into a problem that i couldn't find a solution for:
I set up database replication with a master and one slave, and it works
fine so far. I rewrote my application (web based written in php) so that
On Tue, 20 Apr 2004, Emmett Bishop wrote:
> Howdy all,
>
> Quick question about what I'm seeing in the BUFFER
> POOL AND MEMORY section...
>
> I've configured the innodb_buffer_pool_size to be 128M
> and when I do a show variables like 'innodb%' I see
>
> | innodb_buffer_pool_size | 134217728
I am developing a php/mysql web application, and I am facing the task of
storing application settings. Because it is web based, I will need to
read the app settings on a per-session basis.
I see one of two choices here - store each setting as a separate record
in the table, with the value always s
Arun,
Unfortunately, that link contains the exact same info
as does the mysql.com page. There's almost no
explaination there of what any of the output means.
I'm sure that it's really useful stuff but I don't
have a starting point. Can someone point me in the
right direction (a book or website) or
Hi,
I am hoping to get some advice on a problem I have.
I have a table that have 109 million records and is about 30 G in size. I need to
rename a column, because it seem that localtime have become a reserved word. The alter
table statement makes mysql generate a tmp table and regenerate the i
FYI...
Just connected to the www.mysql.com site this morning with no problems :)
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAI
On 21 Apr 2004 at 9:14, Lou Olsten wrote:
> I have not been able to access the mysql.com server for about a day and a
> half now from my office. From home, it's fine. There have been rare
> occasions in the past when our provider had dropped (or very slow)
> connectivity with certain nodes on th
The good, bad, and the ugly of it? We're debating if we should use it on
our INNODB tables or use a script to do a hotbackup.
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
> Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D. Zawodny | Perl
> At 16:03 -0500 4/20/04, Dirk Bremer (NISC) wrote:
> >I have a couple of questions concerning the MySql client program.
> >
> >1. Are the option for the client program, i.e. --auto-rehash, etc.
> >documented anywhere? I searched the included HTML file and could not find
a
> >reference to the clien
I too cannot get the site correctly.
I am using IE. If I wait long enough (about 2 min) text will appear but
the images never seem to make it.
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2287
M: (713) 252-4688
-Original Message-
From: An
Here's my tracert:
325 ms25 ms29 ms 65-86-11-209.client.dsl.net [65.86.11.209]
423 ms29 ms24 ms unknown.Level3.net [209.247.230.161]
528 ms25 ms26 ms so-5-0-0.bbr2.Chicago1.Level3.net
[4.68.112.209]
623 ms25 ms25 ms so-7-0-0.edge1.Chicago
I have not been able to access the mysql.com server for about a day and a
half now from my office. From home, it's fine. There have been rare
occasions in the past when our provider had dropped (or very slow)
connectivity with certain nodes on the Internet. My understanding there is
limited, but
"JR" <[EMAIL PROTECTED]> wrote:
> I am getting the following error when trying to dump my DBs.
>
> /usr/bin/mysqldump: Got error: 1103: Incorrect table name
> '/home/jr/backups/20040420/wcp.sql' when doing LOCK TABLES
>
> Version is: 4.0.18-standard
>
> These DBs where on another box running th
I suspect you want 'IS NULL' rather than '= NULL'. :)
I always find it best to think of NULL as "undefined value" rather than "no
value" - which is why you need to check for it especially (using IS rather
than = or other operators).
Cheers,
Matt
> -Original Message-
> From: Yonah Russ
I appreciate the reply, I do plan on expanding this to make the use of flash
and a flash server at some point, but I want to offer the option of HTML
auctions as well. I will look into summary tables as it is not something I
am familiar with.
Btw, I'm not sure why you sent me a link on "How To As
Yonah Russ <[EMAIL PROTECTED]> wrote:
> Hi,
> I have two tables- books and copies
>
> every book has an id in the books table
> every copy of a book has the books id and a copy id in the copies table
> (1 row per copy)
>
> I want a list of all the books that don't have any copies meaning all
>
I got a response off the list suggesting writing a function to go over
the query results- it's not hard but I'd rather do this in sql if possible.
I came up with this:
select books.bookid,books.title,copies.copyid from books left join
copies on books.bookid=copies.bookid where copies.copyid=NULL
It appears to be the web server. I can reach mysql.com just fine in a
traceroute, but can't get a HEAD or webpage to come up!
traceroute to mysql.com (66.35.250.190), 30 hops max, 38 byte packets
1 cdm-208-180-236-1.cnro.cox-internet.com (208.180.236.1) 18.963 ms
10.260 ms 12.200 ms
2 cdm-2
Lehman, Jason (Registrar's Office) wrote:
I should have been clearer. I can't reach the website. I can get to
lists.mysql.com with no problem except for the fact that images won't
pull form www.mysql.com but I definitely come to a grinding halt when I
try to reach www.mysql.com. I can't do a tr
1 - 100 of 125 matches
Mail list logo
