Oops... forgot the subject line...
I have a complex JOIN statement that I can't seem to get to work.
Here is my schema...
I have a 'forsale' table with various colunms. Here is the query for
the data I am interested in:
SELECT
id,
clientid,
price
FROM
forsale
WHERE user_id = 152
+
I assume you are storing your dates in a char/varchar column - not a good
choice to start with... :-<
Assuming all the values are supposed to be stored as MM-DD-YY (anothoer
marginal choice, but the problem may not rear its head again for another 96+
years), you can do the following:
UPDATE mytab
All,
I want to develop application with Delphi which can connect to remote mysql server.
Whether I must install myODBC? If are there another way, please tell me? Thanks.
Best Regards,
Q.H. Liu
-
Before posting, please check:
I need to make a change to a field in a table and don't know how to
write the correct sql statement. I made an error and now have a date
field with the year repeated twice - 01-01-03-03 - there are
aproximately 100 rows like this, and maybe 20 or so that are formatted
properly. How can I remove the
There were no errors and it listed a number of rows affected and a
time. tried the command again and it said that the file already
existed. The problem was the directory path that I was looking in. I
couldn't see it in the GUI but in the terminal a find pointed me to the
file. I wasn't able to
Howdy,
I'm curious if anyone has used Visio with MySQL. I have Visio 2000
Developer edition and MySQL 3.23.54 on Win2k. Have successfully imported
two tables from my MySQL database into Visio to create a Database Model
Diagram. I then added several more tables and tried to run the Update
tool but
Hello,
I must have installed mysql incorrectly because
my suse 8.0 server does not have a mysql.sock
file at all.
I installed mysql 3.23.48 from rpm packages
I installed
server
bench
client
Max
navigator
shared
and the required perl bench
What happened.
Can anyone email me a socket file?
Thx
--
At 21:38 -0500 3/1/03, Bernardo Zuniga wrote:
Thank you Paul,
That helped to clear things up. My guess was that the book was wrong
and the path was different for OS X. The command worked fine, but
apparently the files were never created for some reason. I will try
this again.
Well, the book can
Thank you Paul,
That helped to clear things up. My guess was that the book was wrong
and the path was different for OS X. The command worked fine, but
apparently the files were never created for some reason. I will try
this again.
thanks for your help,
Bernardo
On Saturday, March 1, 2003, at 0
At 19:46 -0500 3/1/03, Bernardo Zuniga wrote:
Hello,
I'm a bit confused about where the database is located in Mac OS X.
I was following the instructions in O'Reilly's boot using and
Managing MySQL ad got to the point where I tried to do a select and
output to a file. The command I ran was as f
Hello,
I'm a bit confused about where the database is located in Mac OS X. I
was following the instructions in O'Reilly's boot using and Managing
MySQL ad got to the point where I tried to do a select and output to a
file. The command I ran was as follows:
SELECT * INTO OUTFILE 'books.dat'
FIE
On 02-Mar-2003 Steffan A. Cline wrote:
> Is there a function that I missed for calculating the number of days in a
> month?
>
TO_DAYS()
mysql> set @b:='2003-02-01';
Query OK, 0 rows affected (0.00 sec)
mysql> set @e:='2003-03-01';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT TO_DAYS(@e)
At 17:13 -0700 3/1/03, Steffan A. Cline wrote:
Is there a function that I missed for calculating the number of days in a
month?
No, but you can calculate it. One way:
- Find the first of the month
- Add a month
- Subtract a day. That gives you the last day of the month.
- Extract the day-of-the-m
Is there a function that I missed for calculating the number of days in a
month?
Steffan
MySQL
---
T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
[EMAIL PROTECTED] Phoenix,
Try ...
/usr/local/bin/mysqldump -uUserName --opt $db > $location$db.sql
- Original Message -
From: "Scott Haneda" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>; "MySql" <[EMAIL PROTECTED]>
Sent: Saturday, March 01, 2003 5:18 PM
Subject: Re: Best way to dump for daily archivin
On 28-Feb-2003 Stitchin wrote:
>
> This is so simple and basic, I must be missing something
>
> I have php code for displaying my embroidery designs on the web page. It's
> going through the mySql database and the query to pull up all the designs
> for a
> chosen category works fine. I hav
ExpiryDate
On 28-Feb-2003 Jeff Snoxell wrote:
> Hi,
>
> If I run a mysql query then work through the results of that query one at a
> time, deleting the record sometimes eg:
>
> while (my $href = $sth->fetchrow_hashref())
> {
>if ($href->{'ExpiryDate'} eq '2003-02-22 00:00:00') {
> # Do
on 03/01/2003 3:03 PM, Cal Evans at [EMAIL PROTECTED] wrote:
> use the -opt flag.
Can you tell me how to add in the username as well, I get a
./bin/mysqldump: invalid option -- o error
Here is the pertinent line
/usr/local/bin/mysqldump -uUserName $db > $location$db.sql
---
On 01-Mar-2003 Scott Haneda wrote:
> I wrote a sh script to use mysqldump to iterate through my databases and
> dump them to .sql files, I am supplying no flags to mysqldump, and wonder,
> is there a "best way" to dump your files, if the idea is they are backups
> and to be used in the case of eme
use the -opt flag.
=C=
* Cal Evans
* Stay Plugged Into Your Audience
* http://www.christianperformer.com
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 4:27 PM
To: MySql
Subject: Best way to dump for daily archiving
I wrote a sh script t
John,
> I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box
> using RPMs. The install seems to go well, but the log file
> contains:
> mysqld: Can't find file: './mysql/host.frm'
> From the docs, I understand this happens because I haven't set up
> the grant tables, but how can I
Hello, Uttam;
We can simplify this, actually... any time L.idFilm is NULL (i.e., no
row in Loans is found), L.dateReturn will have to be NULL as well. So,
specifying the L.idFilm IS NULL condition is redundant. It's sufficient
to look only at L.dateReturn IS NULL in the WHERE clause.
Yours i
I wrote a sh script to use mysqldump to iterate through my databases and
dump them to .sql files, I am supplying no flags to mysqldump, and wonder,
is there a "best way" to dump your files, if the idea is they are backups
and to be used in the case of emergency.
---
Ryan McDougall wrote:
when I do this this is what I get:
starting mysql with databases from /var/lib/mysql
This may be your culprit right here... not sure where the mysql_install_db
defaults its installs to, but I'm guessing its not /var/lib/mysql. And you
installed everything into /usr/local/mysq
On Sat, Mar 01, 2003 at 05:11:29PM -0500, Jeff Mao wrote:
> Greetings all,
>
> May be a dumb question,...if I have a text file generated from
> mysqldump, how do I reload that file into mysql? In the past I've
> always copied and pasted it into mysql, but that takes a lot of
> time,...especiall
Greetings all,
May be a dumb question,...if I have a text file generated from
mysqldump, how do I reload that file into mysql? In the past I've
always copied and pasted it into mysql, but that takes a lot of
time,...especially as the databases grow! I do not have local access
to the server, bu
hi
have you run mysql_install_db ?
this sets up the mysql database initially
Peter
-Original Message-
From: John Almberg [mailto:[EMAIL PROTECTED]
Sent: 01 March 2003 20:44
To: [EMAIL PROTECTED]
Subject: Can't start mysql
I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0
I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0 box using RPMs. The install seems to go well, but the log file contains:
mysqld: Can't find file: './mysql/host.frm'
From the docs, I understand this happens because I haven't set up the grant tables, but how can I do that if I can't
Thanks for the clarification.
Is the MySQL list down? I was getting constant email before, and now I've
received nothing for almost 12 hours.
- Sheryl
- Original Message -
From: "Uttam" <[EMAIL PROTECTED]>
To: "'Sheryl Canter'" <[EMAIL PROTECTED]>; "'Juan Nin'"
<[EMAIL PROTECTED]>;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Holger Wiechert wrote:
This is a reposting since I haven't got any answer yet.
It is about the NullPointerException in class Connection
of MySQL Connector/J 2.0.14.
I just changed the driver to MySQL Connector/J 2.0.14.
But I'm still getting this NullPo
Hello,
Please do you know about any good solution for data mininig (clustering,
decision trees ..) that works fine with MySQL.
Thank you
With regards,
Pavel Kusch
-
Before posting, please check:
http://www.mysql.com/m
>Description:
Dear sir,
When I execute the command "select * from user_info where regdate < now()- interval
9 day and phone_confirmed is null and email is null and last_onlineHow-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | l
>Description:
Dear sir,
When I execute the command "select * from user_info where regdate < now()- interval
9 day and phone_confirmed is null and email is null and last_onlineHow-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [
This is a reposting since I haven't got any answer yet.
It is about the NullPointerException in class Connection
of MySQL Connector/J 2.0.14.
I just changed the driver to MySQL Connector/J 2.0.14.
But I'm still getting this NullPointerException once in
a while. The new StackTrace is:
java.lang.Nu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
Hi there!
Sorry, cause I didn't copy-n-paste those so there were typos, actually I
created the table in console:
1) create table test (id INTEGER NOT NULL AUTO_INCREMENT, name
V
$result=mysql_query("SELECT
items.*, city.City
FROM
items, city
WHERE
items.Category='$Category'
AND items.CityID='$CityName'
AND items.CityID=21
ORDER BY
City
");
while ($row=mysql_query($result)) {
Dear Mysql guru's
I have a sneaky suspision that the my current problem is related!
I want to display
There are '$number of records' in '$the city you have selected'
However this is proving to be beyond my brains capacity to deal with :p
So,if any of you can spot what the obvious mistakes I am
hi there my sql slave server cannot replicate as its getting permissions
errors dont know what happened but its not happy now
030302 7:09:24 Slave I/O thread killed while connecting to master
030302 7:09:24 Slave I/O thread exiting, read up to log 'FIRST', position
4
030302 7:09:29 Slave I/O
here's my version of the answer:
SELECT
F.idFilm, F.title
FROM
Films F LEFT JOIN Loans L ON F.idFilm = L.idFilm
WHERE
(L.idFilm IS NULL) OR (L.dateReutrn IS NULL)
;
regds,
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 200
*DISTINCT omits data bases on selected fields only. i.e. if you have
thousand rows having different dates in 'mydate' but all having year 2002,
then SELECT DISITNCT YEAR(mydate) will return only 1 row i.e. 2002.
* DISTINCTROW omits data based on entire duplicate records, not just
duplicate field
40 matches
Mail list logo
