I would like an integer field to capture the current date as a Unix
Timestamp by default.
But this will not be accepted at all.
I get the error "invalid default value for [field name]"
Is there a workaround?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
That is exactly the issue.
Also if you use the real address to determine the lat/lon instead of the zip
code, the result will be different.
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 6:55 PM
To: [EMAIL PROTECTED]; Daevi
I think I said that earlier, but the distance between two zip codes deal is
inaccurate, yet useful, for instance on a Classified Ads Web site.
As for the Zip+4, I do not know of any database that gives the latitude and
longitude for them specifically. But I am certain it has to exist.
The US Post
I'm so confused. I'm finally getting around to needing to do a 'store
locator' thing.
I procured myself some zip/lat/long databases from various places. Then I
noticed that for the same zip code, I got different values in different
databases??!!!
So for a sanity check, I decided to look "online
i have three Values in each row of my MySQL database, im needing to sum
them in the table as they are displayed per Row ?? how do i do this ?
Projectname Elecremain Controlremainotherremain
Project1 2300 1600
250
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to upgr
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to upgr
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to upgr
n copy/paste it here that way we'll see
what is wrong.
Maybe the $id variable is not replaced with the proper content.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 2:31 PM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't wor
I change something it outputs Changed:
2, for the case of 2 records in the table.
>>From: "Nicolas Verhaeghe" <[EMAIL PROTECTED]>
>> Normal. MySQL returns 0 changes when the data before and after the
>>UPDATE
>> is
>> the same.
>
> --
> -Rows ma
I change something it outputs Changed:
2, for the case of 2 records in the table.
>>From: "Nicolas Verhaeghe" <[EMAIL PROTECTED]>
>> Normal. MySQL returns 0 changes when the data before and after the
>>UPDATE
>> is
>> the same.
>
> --
> -Rows ma
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't work
Writing echo
"-".mysql_error()."--".mys
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't work
Writing echo
"-".mysql_error()."--".mys
can someone please just send me or post a example of editing feilds of a
mysql database within an html form and then updating the values thanks alot
here is a small database u can use i can expand on your example as needed
/*
""RedRed!com IT Department"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jay Blanchard wrote:
>> [snip]
>> I read this as a SQL syntax question, not a math word problem. As in
>>
>> SELECT ..., (some expression equaling sq ft) AS sqft... [/snip]
>>
>> Cool, then do it!
>>
>
>
>
MySQL does seem to have a row number function and the purpose of this is
because it increases the processing time, as you have seen with your
workaround.
I would instead create a temp table with an autoincremented ID, insert the
content of your record set into it and use this autoincremented ID as
I guess the CD could be mounted on MacOS and Unix to be treated as a true
drive but I am confident it would not work on Windows, knowing how every
application has to embed itself with the registry and the system files,
usually register DLLs and what not.
But whatever happens, the CD should never b
I am slowly considering leaving GoDaddy, who has a very good bandwidth and
ok tech support (I have seen better but much much worse) and acceptable
prices, but unfortunately does not support MySQL 5 and PHP 5 either.
I wonder if I could give these people a chance but one thing I'd like to do
is see
Robert,
A RIGHT JOIN would potentially return more results than an INNER JOIN.
I do not see how it could be, in the absolute, be faster.
How large were the tables and how did you do your testing? What platform
did you use and were you InnoDB or MyISAM?
-Original Message-
From: Robert Di
I use Navicat on my dev machine, which is an XP as well.
Navicat backups my live server daily on my dev machine, as well as my
local DBs, in case I screw up.
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 11, 2006 3:49 AM
To: mysql@lists.mysql.com
Can you run without the Order By at all? If not, you may need to
properly join the tables.
I could reproduce the issue with MySQL 4.1 as well and I would go around
it myself by creating a temporaty table, populating it with the
aggregate, doing a select on the temp table and then of course droppin
That SQL 101.
It's a basic INSERT / SELECT.
http://dev.mysql.com/doc/refman/4.1/en/insert-select.html
Scroll down for the examples.
-Original Message-
From: clint lenard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 8:54 PM
To: mysql@lists.mysql.com
Subject: Need help with
Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
I myself make my SQL 3.23 compatible.
Yes, it is too new, and it is sad, because stored procedures will make
our job much easier.
I also program for MS SQL and use SPs extensively for all the good
reasons.
-Original Mess
Error message?
Also you seem to take save date from a HTML form.
How do you treat quote signs? And entries too large for a field?
-Original Message-
From: Kleiton L R Soares [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:45 AM
To: mysql@lists.mysql.com
Subject: Not Saving
Error message?
Also you seem to take save date from a HTML form.
How do you treat quote signs? And entries too large for a field?
-Original Message-
From: Kleiton L R Soares [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:45 AM
To: mysql@lists.mysql.com
Subject: Not Saving
In this case, cnelson, you can only have a one to one relationship.
He wants to allow a one to many relationship.
Using one field to store all the attribute ids in the product table is
what he is trying to do and it is not the best idea. Better use a table
in the middle, with product ids and attr
Your method is wrong because if you are looking for "5", then "56" will
match and also everything that has "5" in it.
Unless you include the spaces and look for : '% 5 %' but then you need
to add a space at the beginning and at the end of your attributes field.
That method is way too cumbersome a
Is it normal for MySQL to not update fields that are already identical?
I am talking about an INNER JOIN UPDATE, when copying from table A over
table B.
My count did not match at the first run and when I did the second run, I
go a zero rows updated...
--
MySQL General Mailing List
For list arc
You're very helpful, thanks.
Problem already taken care of but thanks for the lesson.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 10:55 PM
To: Nicolas Verhaeghe
Cc: mysql@lists.mysql.com
Subject: Re: How can I isolate the in
l the displacement fields will work fine.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 10:11 PM
To: George Law
Cc: Nicolas Verhaeghe; mysql@lists.mysql.com
Subject: Re: How can I isolate the integer part of a varchar field and
use i
--
From: George Law [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 8:14 AM
To: Nicolas Verhaeghe; mysql@lists.mysql.com
Subject: RE: How can I isolate the integer part of a varchar field and
use it in an ORDER BY?
Nicolas,
Not sure when the "replace" function was introduce
man/5.0/en/adding-functions.html
http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Nicolas Verhaeghe wrote:
> A client of mine sells motorcycle parts and the motorcycle models are
> for instance:
>
> YZ85
>
A client of mine sells motorcycle parts and the motorcycle models are
for instance:
YZ85
YZ125
WRF450
YZF450
Etc...
If you know motorcycles, you know that the number is always the
displacement in cc.
What I am looking to do here is make it so that the models are sorted
properly according to the
I am trying to see if I can communicate with a MySQL on Free BSD from the
MySQL GUI client on my Windows NT.
The GUI client cannot connect because the MySQL seems to be refusing this
connection. This does not seem to be server-related, but related to MySQL
itself, since, when I try to telnet in p
34 matches
Mail list logo
