What time function should I use to add 2 hours to a time value I am getting
from the database ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Edward Smirnov writes:
> Hello Sinisa,
>
> Saturday, March 31, 2001, 3:45:27 PM, you wrote:
>
> SM> There is no such function in mysql.h.
>
> Small piece from mysql.h is below:
> **
> char * STDCALL mysql_error(MY
Hello Sinisa,
Saturday, March 31, 2001, 3:45:27 PM, you wrote:
SM> There is no such function in mysql.h.
Small piece from mysql.h is below:
**
char * STDCALL mysql_error(MYSQL *mysql);
char * STDCALL mysql_info(MYSQL *mysql);
unsigned long STDC
mySQLDAC writes:
> Hello John,
>
> We are developing the next version of MySQLDAC (MySQL Direct access
> components for Delphi/C++ Builder).
>
> We've found
> const char * STDCALL mysql_character_set_name(MYSQL *mysql) in mysqlh.h
>
> But we've no
Hello John,
We are developing the next version of MySQLDAC (MySQL Direct access
components for Delphi/C++ Builder).
We've found
const char * STDCALL mysql_character_set_name(MYSQL *mysql) in mysqlh.h
But we've not found this function in libmysql.dll (ver.3.23.33)
Is ther alternati
3.23.35-log reports it correctly.
Cal
http://www.calevans.com
-Original Message-
From: Gordon Werner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: mySQL INSTR function problem
Hi there ...
I am running mySQL Ver. 9.33 Distrib
I'm going to jump in here and give a little more information.
The password() function is in fact a one way encryption. For a two way
encryption use the encode() function. But beware, any data stored with the
encode() function is only as secure as the master password you assign it.
You c
Hi there ...
I am running mySQL Ver. 9.33 Distrib. 3.22.25 and I have run into the
following problem.
When I type:
mysql> select INSTR('foobarbar', 'bar');
it outputs
+---+
| INSTR('foobarbar', 'bar') |
+---+
| 7 |
+
You can use either ucase() or upper() functions.
ucase(str) or upper(str)
Seung-woo Nam
Zhu George-CZZ010 wrote:
> There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know the syntax or
On Tue, 27 Mar 2001 11:22:20 -0600, Zhu George-CZZ010
<[EMAIL PROTECTED]> wrote:
I believe it's upper(col_name)
>>There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know
http://www.mysql.com/doc/S/t/String_functions.html
UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase according to
the current character set mapping (the default is ISO-8859-1 Latin1):
mysql> select UCASE('Hej');
-> 'HEJ'
T
There's a function in SQL to convert strings to upper case (sounds like to_upper()? ),
I don't have the reference book at hand, does anyone know the syntax or that function?
Thank you very much in advance.
-
Befo
well, as easy as is: store the original password, or use a php/your
programming_language_specific function like encrypt() and decrypt().
password function is (and should be) irreversable, like a md5 hash. that's
where it's ment for.
- Original Message -
From: "Kevin Wi
You can't. You'll have to regenerate a new, random password and send that
out.
- Original Message -
From: "Kevin Williams" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 7:27 AM
Subject: Password
Hi Kevin,
On Tue, Mar 27, 2001 at 02:27:55PM +0100, Kevin Williams wrote:
> Peeps,
>
> My problem is this. I'm not happy about storing plain text passwords in my database
>for users, so was considering using the password () function in order to store a hash
>of
Peeps,
My problem is this. I'm not happy about storing plain text passwords in my database
for users, so was considering using the password () function in order to store a hash
of the password instead.
sample SQL.
$sql = "SELECT login,IPaddress,password,administrator,va
Hi there !
I wanna know if the reverse of the function SUBSTRING_INDEX exists or
not.
--DESCRIPTION---
==
>SUBSTRING_INDEX(str,delim,count)
>Returns the substring from string str before count occurrences of the
delimiter delim.
>If count is positive, everything to the le
an index on an self defined function?
- Can I even define my own function without compiling mysql?
Because my Provider wouldn't let me do this.
Thank for answering
Gunnar von Boehn
-
Before posting, please check:
Hi!
I've compiled the udf_example.cc file into an so, copied it to /usr/lib, but
when i issue a
CREATE FUNCTION lookup RETURN STRING SONAME "udf_example.so";
I get: Error 1041: Out of memory.
I've searched the mailing list and the web, and all the information I get is
t
olf Hopkins" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 20, 2001 21:04
> Subject: Re: need mysql sample to accomplish existing asp function
>
> > Rolf,
> >
> > Sorry I worded that email in a confusing manner.
>
> You most certainly were! Now I get your meani
Rolf Hopkins wrote:
>
> >
> > My ISP told me they supported asp, so I had a friend of mine set up the
> asp
> > code for me and he tested it on his server. When I put the code in my
> > pages, it did not work. I called my ISP back and found out the first
> person
> > was wrong. They run Unix a
lt;[EMAIL PROTECTED]>
Cc: "Joe and Nancy M" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 15:25
Subject: Re: need mysql sample to accomplish existing asp function
> Rolf Hopkins wrote:
> >
> > >
> > > My ISP told me
Rolf Hopkins ([EMAIL PROTECTED]) writes:
> Well now, that depends on what you want to use. You can use java, php, or
> perl and there are others but make sure your ISP supports the language you
> choose. I recommend php as it is the easiest of the three. Their web site
> is www.php.net and www
- Original Message -
From: "Joe and Nancy M" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 21:04
Subject: Re: need mysql sample to accomplish existing asp function
> Rolf,
>
> Sorry I worded th
Hello,
Can any of you explain me why, when i do this request :
select count(*)
from OBJET as t1 left join COLLECTION as t2
ON t1.numColl = t2.numColl
where t2.numSupp = 0;
I've got an error saying : Field numObj not found
note that numObj is the Key of table OBJET...
Thank's
--
Best regards
started for the change to take effect.
Reboot now? [OK]
- Original Message -
From: "Joe and Nancy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 12:15
Subject: need mysql sample to accomplish existing asp function
> I am in a time
Joe and Nancy ([EMAIL PROTECTED]) writes:
> I am in a time crunch to get mysql working on my site. I export inventory
> records out of my Peachtree software into Excel and planned to use that .xls
> table to show product pricing and availability on my web pages. Below is
> sample asp code that
I am in a time crunch to get mysql working on my site. I export inventory
records out of my Peachtree software into Excel and planned to use that .xls
table to show product pricing and availability on my web pages. Below is
sample asp code that works. My ISP had told me they support asp, but af
Look up skip grants in the manual.
- Original Message -
From: "root" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 16:09
Subject: password() function not used when creating root password
> I have just created a root password i
I have just created a root password in MySQL without using the PASSWORD
function.
In the user table i put in a root password, like this.
mysql> UPDATE user SET Password='new_password' WHERE user='root';
mysql> FLUSH PRIVILEGES;
Now i am denied access. How do
Hi,
I was wondering if there is a way I can do this in MySQL as a one line
command:
SELECT COUNT(*) as Qty, Name, 100 * Qty/(SELECT COUNT(*) from Table1) as
Percent from Table1 GROUP BY Name;
Currently I have to do this in two lines:
SELECT COUNT(*) from Table1;
SELECT COUNT(*) as Qty, Name
On 08.02.2001 15:09:47 Christian Ribeaud wrote:
> would like that the table put automatically the today's date for every INPUT
as
> default value. What is wrong?
Uhm, why don't you use a timestamp column type then? Okay, it will also save
the time, but it's easy to extract only the date, if th
zeroed date
instead.
Secondly, MySQL does not accept functions as default values.
You should use the function only on INSERT.
> Another question, 'showIt ENUM('TRUE') DEFAULT ERROR' did not
> work but 'showIt ENUM('TRUE','FALSE') DEFAULT FALSE' w
Christian,
a DEFAULT value in a CREATE (or ALTER) statement must be a static value, try
using a TIMESTAMP field instead.
To use 'ERROR' in as an 'ENUM' DEFAULT it must be included in the definition,
i.e. ENUM('ERROR','TRUE')
Hope this helps...
John
On Thursday 08 February 2001 09:09, Christi
Hi,
I tried the following code:
CREATE TABLE news (... published date DEFAULT 'NOW()' NOT NULL, ..., showIt
ENUM('TRUE') DEFAULT ERROR, ...);
and I was surprised to get an '-00-00' as date after doing a SELECT. I would like
that the table put automatically the today's date for every INPUT
Hi
I'm doing a simple query using the function STD but I'm getting zeros as
answer. I know that zero is a perfectly good answer for standart
deviation but in this case I should get some positive values :-)
Is there something wrong with this function ?
My sql string is the folowi
EMAIL PROTECTED]]
Sent: 19. janúar 2001 18:37
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: The function of auto_increment and Premier Key?
> Hi I'm relatively new to MySQL though I familiar to other simple
> databases.
Ahem... [takes Sumarlidi aside and explains very carefully how the
mysql> select name from tableName
-> where month(birthDate) = 7;
-Original Message-
From: Sharif Islam [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 8:56 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date function.
This is a simple mysql question i am having problm
doing well understanding
> the function
> of auto_increment and Premier Key.
>
> Lets say I have a table with a few columns. One of them is an ID with
> auto_increment. It has 1000 rows. If I delete row #500 to #599 (total of
> 100), will the MySQL update the ID value for row #60
Hi I'm relatively new to MySQL though I familiar to other simple databases.
I have been reading the manual but not doing well understanding the function
of auto_increment and Premier Key.
Lets say I have a table with a few columns. One of them is an ID with
auto_increment. It has 1000 rows.
Hi!
> "Matt" == Matt Wagner <[EMAIL PROTECTED]> writes:
Matt> Paul Wisén writes:
>> This works:
>>
mysql> select trim('foo' FROM 'foobaar');
>> ++
>> | trim('foo' FROM 'foobaar') |
>> ++
>> | baar |
>> +-
I think it would have to be considered a simple bug. If you're not
convinced by the 'both' example he gave, here's one that's even more
obviously a bug:
mysql> select trim(leading 'foo' from 'foo');
++
| trim(leading 'foo' from 'foo') |
!
> >>
> >> mysql> select trim('foo' FROM 'foo');
> >> ++
> >> | trim('foo' FROM 'foo') |
> >> ++
> >> | foo
+
>> | foo|
>> ++
>> 1 row in set (0.00 sec)
If all you want to do is remove any occurance of 'foo' in a string or column
value then I'd recommend you look at the REPLACE() function in the manual.
Reg
Paul Wisén writes:
> This works:
>
> mysql> select trim('foo' FROM 'foobaar');
> ++
> | trim('foo' FROM 'foobaar') |
> ++
> | baar |
> ++
> 1 row in
This works:
mysql> select trim('foo' FROM 'foobaar');
++
| trim('foo' FROM 'foobaar') |
++
| baar |
++
1 row in set (0.00 sec)
This do
> > okay, with gdb i can see that this column becomes a blob (thereby
> > not allowing heap tables to be used - which has got to be costing
> > me speed), is there any function i can use to 'cast' this column
> > to a fixed length?
>
> hrm, apparently L
" +
"maxY BETWEEN " + r.y + " AND " + r.height + " AND minX < " + r.x +
" AND maxX > " + r.width + " OR " +
"minX < " + r.x + " AND maxX > " + r.width + " AND minY < " +
> okay, with gdb i can see that this column becomes a blob (thereby
> not allowing heap tables to be used - which has got to be costing
> me speed), is there any function i can use to 'cast' this column
> to a fixed length?
hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())),
es to be used - which has got to be costing
me speed), is there any function i can use to 'cast' this column
to a fixed length?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
this is curious:
the table:
CREATE TABLE inbw_day_diffs_2001_Jan_02_10 (
hostname char(20) NOT NULL default '',
variable_name char(64) NOT NULL default '',
variable_index_value char(114) NOT NULL default '',
variable_index_label char(50) NOT NULL default '',
variable_result_value_numer
901 - 951 of 951 matches
Mail list logo
