Hello,
I want to add a new function to mysql. Because i use mysql for windows and
there is not implemented adding function through the UDF interface, i must
add native function. I did it according to manual, but when i use a new
function in select command, it generate error.
I think
a
prefix. Or use STRCMP(col_name, A) = 0 if the column value must be
exactly A.
But there is no function INDEX in mysql.
How-To-Repeat:
See manual_Problems.html
Fix:
There should be something like LOCATE(A, col_name)=1.
Submitter-Id: submitter ID
Originator:Hans Ginzel
I am trying to create a MySQL SELECT statement using PHP where I am getting
a filtered list back by a date in the database formatted as -mm-dd
where the date falls between a one week window that is in constant motion.
For example, take todays date (as a julian calendar number) and a date
At 5:03 PM -0700 9/4/01, Chad Berryman wrote:
I am trying to create a MySQL SELECT statement using PHP where I am
getting a filtered list back by a date in the database formatted as
-mm-dd where the date falls between a one week window that is in
constant motion.
For example, take todays
there are no API-function for transactions?
Heikki,
it work's as you supposed. I only send at the beginning 'set
autocommit=0'
then COMMIT and ROLLBACK works fine
Again, thank you, have a nice weekend
Andre Konopka
Heikki Tuuri wrote:
Andre,
can PHP just send the SQL string
COMMIT
Hi all.
Anybody knows a function or some way to convert a string to a integer? I've
looked in the manual and I haven't seen anything.
I need it to order a query by a column which contains numbers but the type
of the column is varchar. I want to convert the values to integer before
ordering
I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result to
a file it seems to save it as a Hex output. Is this what is supposed to
happen? Can this be used to backup a database?
Thanks in advance.
Jeff
-
Jeff Isom writes:
I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result to
a file it seems to save it as a Hex output. Is this what is supposed to
happen? Can this be used to backup a database?
Thanks in advance.
Jeff
It will save query results in a file in
function
Jeff Isom writes:
I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result
to
a file it seems to save it as a Hex output. Is this what is supposed to
happen? Can this be used to backup a database?
Thanks in advance.
Jeff
It will save query results in a file
clause. Something akin to:
SELECT ...
SUM(bool_was_connected),
COUNTNULL(bool_was_connected),
etc...
the SUM will sum up all non-null values. The COUNTNULL would sum up all
rows which have a value of 0.
Does anyone have a UDF for this function? I currently
...
the SUM will sum up all non-null values. The COUNTNULL would sum up all
rows which have a value of 0.
Does anyone have a UDF for this function? I currently don't have room on
my laptop to download the mysql source code in order to write this up. (
Also have not written a udf for mysql up
),
COUNTNULL(bool_was_connected),
etc...
the SUM will sum up all non-null values. The COUNTNULL would sum up all
rows which have a value of 0.
Does anyone have a UDF for this function? I currently don't have room on
my laptop to download the mysql source code in order to write this up
(bool_was_connected),
etc...
the SUM will sum up all non-null values. The COUNTNULL would sum up all
rows which have a value of 0.
Does anyone have a UDF for this function? I currently don't have room on
my laptop to download the mysql source code in order to write this up. (
Also have not written
all non-null values. The COUNTNULL would sum up all
rows which have a value of 0.
Does anyone have a UDF for this function? I currently don't have room on
my laptop to download the mysql source code in order to write this up. (
Also have not written a udf for mysql up to this point
Evening Jay,
I'm still abit new to MySQL. Spending the last 6 months I have worked
with it more on my CGI development, than good SQL query practicing. My
technical jargon is lacking. In laymens terms ( I know no other at this
point in time ) I have a row that has '1' or '0' in it. I'm trying to
Jeff Isom writes:
I am fairly new to MySQL and I am unfamiliar with the term escaped form.
Can anyone point me to documentation that explains what that is and how it
can be used.
Also, I am trying to perform a backup remotely. My understanding is that
the mysqldump and mysqlhotcopy
On Thu, Aug 30, 2001 at 10:22:02AM -0600, Jeff Isom wrote:
I am fairly new to MySQL and I am unfamiliar with the term escaped form.
This a Unix-ism. For instance:
this line
'this line'
this\ line
The last two are functionally equivalent. The last one has an
'escaped' space embedded
Hi,
Is there a number sequence generator/function in
MySQL such that if I were to execute:
UPDATE mytable SET id = thisfunction;
it will update the table mytable and set the column
id to a numbered sequence 1,2,3,4,5,6,7,8,9.?
currently, i have a table with 2.5 million records and
i want
Add an auto_increment column of an appropriate int size.
Jaime Teng wrote:
Hi,
Is there a number sequence generator/function in
MySQL such that if I were to execute:
UPDATE mytable SET id = thisfunction;
it will update the table mytable and set the column
id to a numbered sequence
database,sql,query,table
So sprach =BBJaime Teng=AB am 2001-08-31 um 03:53:47 +0800 :
Is there a number sequence generator/function in
you can set the INT types to auto_increment, which will do just that
when you insert rows.
Alexander Skwar
--
How to quote: http://learn.to/quote (german
: Jaime Teng [EMAIL PROTECTED]
Hi,
Is there a number sequence generator/function in
MySQL such that if I were to execute:
UPDATE mytable SET id = thisfunction;
it will update the table mytable and set the column
id to a numbered sequence 1,2,3,4,5,6,7,8,9.?
currently, i have a table with 2.5
[EMAIL PROTECTED] writes:
Description:
I am using the recommended ./configure options as specified by:
http://www.mysql.com/doc/S/o/Solaris.html. I am unsure how to
specifiy the GNU ld - the output from ./configure shows that I am
using the Solaris ld. Perhaps
-I. -I../include -I..
-I.-O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H
-I/usr/local/src/mysql-3.23.39/include -DHAVE_RWLOCK_T -c sql_lex.cc
sql_lex.cc: In function `void lex_init
Friend,
I learned that 8 + 4 = 12. Maybe you just missed that class ... :D
Before talk, think. ;)
On Thu, 26 Jul 2001 12:31:23 -0700 [EMAIL PROTECTED] wrote:
| 8.00user1
| 14.00 user2
| 160.00 user 3
|
| Now, where I went to school, this adds up to 184!
Cya
Antonio
All,
Is there any way to do the following in MySQL:
INSERT INTO TableName (rowID) VALUES ('max(rowID)+1')
(so that the next unique identifier for the table can be determined
WITHIN the insert statement?)
I know MySQL provides auto-incrementing and last_insert_id. However,
architecture
, July 27, 2001 10:37 AM
Subject: Re: possible bug in sum() function
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
the query was:
select sum(worktime),user from timecard where tcacct=project group by user;
the answer was:
8.00user1
14.00 user2
160.00 user
Bruce Ferrell writes:
I'm replying to the list because I got so many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please?
support: none
Synopsis: incorrect result from sum() function
Severity: critical
Priority: high
Category: mysql
Class:
Release: mysql-3.23.38 (Source distribution)
Server: /usr/local/mysql/bin/mysqladmin Ver 8.20 Distrib 3.23.38, for pc-linux-gnu
on i686
Copyright
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 5:31 AM
Subject: possible bug in sum() function
select sum(worktime) from timecard where tcacct=project;
The answer came back 182. Then I was asked who had spent time on
the project
[EMAIL PROTECTED] wrote:
We keep a timecard database and I was just asked how much time had been charged to a
particular project code. No problem says I and did the following:
select sum(worktime) from timecard where tcacct=project;
The answer came back 182. Then I was asked who had
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
We keep a timecard database and I was just asked how much time had been charged to a
particular project code. No problem says I and did the following:
select sum(worktime) from timecard where tcacct=project;
The answer came back 182. Then I was
[EMAIL PROTECTED] writes:
We keep a timecard database and I was just asked how much time had been charged to a
particular project code. No problem says I and did the following:
select sum(worktime) from timecard where tcacct=project;
The answer came back 182. Then I was asked who had
Hello ,
here is a strange result I obtain,
could someone tell me if it's a bug or if my request is wrong
I'd like to obtain the number of times the word 'liste' is found in
column page and the number of times the word 'piece' is found, all in
a single request...
In the last example, it look
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
the query was:
select sum(worktime),user from timecard where tcacct=project group by user;
the answer was:
8.00user1
14.00 user2
160.00 user 3
Now, where I went to school, this adds up to 184!
Suggestions?
Try a different
SixK wrote:
Hello ,
here is a strange result I obtain,
could someone tell me if it's a bug or if my request is wrong
I'd like to obtain the number of times the word 'liste' is found in
column page and the number of times the word 'piece' is found, all in
a single request...
In the
I'm replying to the list because I got so many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please? what can I say, my face is
Hehehehe.
- Original Message -
From: Geoff Blake [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 11:37 AM
Subject: Re: possible bug in sum() function
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
the query was:
select sum(worktime
Please Help!
I can't find trigger functions in the documents. Does MySQL has triggers
for preselect, preupdate, and predelete? If do, where can I find them?
Thanks,
Weiwen
Hello.
On Mon, Jul 23, 2001 at 09:34:17AM -0600, [EMAIL PROTECTED] wrote:
Please Help!
I can't find trigger functions in the documents. Does MySQL has triggers
for preselect, preupdate, and predelete? If do, where can I find them?
Please have a look at the following chapter in the fine
- Original Message -
From: Derick Dorner
To: [EMAIL PROTECTED]
Sent: Tuesday, July 17, 2001 3:11 PM
Subject: tricky RAND() function...
I am using MySQL 3.22, and need to know how to randomly select a record, therefore I
can't just use the ORDER BY RAND() clause, because of my
Subject: tricky RAND() function...
I am using MySQL 3.22, and need to know how to randomly select a record, therefore I
can't just use the ORDER BY RAND() clause, because of my version. so i do this:
SELECT field1,field2*0+RAND() as rand_col FROM TableName WHERE field3=5 ORDER BY
rand_col
);
$number = mt_rand(0,$row[0]-1);
//fetch one record randomly
$result = @mysql_query(SELECT * FROM $table LIMIT $number,1);
Of course, you could encapsulate that stuff nicely into a
function.
Derick Dorner schrieb am Samstag, 21. Juli 2001, 05:33:13:
- Original Message -
From: Derick
What can I do to fix this error or can you referance me to a point where
I can look at to try to fix the problem.
Fatal error: Call to unsupported or undefined function mysql_pconnect()
in ./db_mysql.php on line 38
Rick Makla
Digital Media
P: 803.758.4057
F: 803.779.9455
[EMAIL PROTECTED
the problem.
Fatal error: Call to unsupported or undefined function mysql_pconnect()
in ./db_mysql.php on line 38
Rick Makla
Digital Media
P: 803.758.4057
F: 803.779.9455
[EMAIL PROTECTED]
-
Before posting, please check
PROTECTED]
Subject: Small Problem with a function
What can I do to fix this error or can you referance me to a
point where I can look at to try to fix the problem.
Fatal error: Call to unsupported or undefined function
mysql_pconnect() in ./db_mysql.php on line 38
Rick Makla
Digital
mysql support should be built into php. I experienced this twice
under Winxx. The first time I found a remedy which I don't
remember. The second time I upgraded to the newest version of
php.
Fatal error: Call to unsupported or undefined function mysql_pconnect()
in ./db_mysql.php on line 38
Fatal error: Call to unsupported or undefined function mysql() in
/usr/local/share/apache/htdocs/test.php3 on line 13
axel yson [EMAIL PROTECTED] wrote:
Fatal error: Call to unsupported or undefined function
mysql() in /usr/local/share/apache/htdocs/test.php3
on line 13
This is a PHP error, not a MySQL error. PHP does not have an internal
function mysql() so unless you defined a function called mysql
Try a PHP mailing list, This is off topic.
axel yson wrote:
Fatal error: Call to unsupported or undefined function mysql() in
/usr/local/share/apache/htdocs/test.php3 on line 13
-
Before posting, please check:
http
I am using MySQL 3.22, and need to know how to randomly select a record, therefore I
can't just use the ORDER BY RAND() clause, because of my version. so i do this:
SELECT field1,field2*0+RAND() as rand_col FROM TableName WHERE field3=5 ORDER BY
rand_col;
--according to paul dubois' book I have
The table not locke error occures when you have issued a lock tables
command, and then access a table not included in the lock tables call.
You must lock all tables you intend to access between the lock and
unlock calls.
Werner Stuerenburg wrote:
As I said earlier, I have troubles with 3
, some days ago I asked about LOCK TABLE, because I wanted to
implement a function which would repair the table automatically.
And I wasn't sure if I had to use LOCK TABLE for that table to be
repaired.
Something went wrong and chances are I didn't understand the
process. I hope one of you can give
Dear Sir:
The Version of Mysql is mysql-3.23.38. The OS is Win NT SP 5.
I have a problem with below SQL Statement
Select Sum(Cost) as TotalCost from Item
All the entries for Cost Field has the Value Null. The result of this Query
is TotalCost = 0.
But is not it suppose to be Null
hi folks,
i have the following table (table_name=comment)
+-+--+--+-++
+
| Field | Type | Null | Key | Default| Extra
|
+-+--+--+-++
+
| id |
That should work.
What OS, kernel, version, compiler are you using?
kitty79 wrote:
hi folks,
i have the following table (table_name=comment)
+-+--+--+-++
+
| Field | Type | Null | Key | Default| Extra
|
I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP
4.0.5, and Apache 1.3.19.
I have found what I believe is a bug with this release of MySql. When I try
to delete an entry from a table (DELETE FROM articles WHERE article_id =
'3') the database only deletes the article_id
on 6/11/01 15:13, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP
4.0.5, and Apache 1.3.19.
I have found what I believe is a bug with this release of MySql. When I try
to delete an entry from a table (DELETE FROM
Hello,
I am trying to make a fulltext search over columns from two tables.
The queer thing is: sometimes it works, but more often I get the error message:
Got error 28 from table handler (in mysql_error output).
I am not sure what error 28 is, I checked the manual but couldnt find anything.
The
Alright alright...
I didnt want to believe it, but our disk is really full (got some funny
things going on at server terminal UGH!).
I hope my query will work okay once we get the server organized.
Thx anyways ;)
Nessi
-
Hi,
i am unsure what to put in this line, currectly i have the following line
$RS=mysql_fetch_array($RS_query);
but i get the following error message
supplied argument is not a valid MySQL result resource. so that statement most be
total wrong.
i am trying to get a result from a row when
Does anyone know of a Perl function or package that can take a
user-inputted string (like from a search form on web page) and turn it into
proper SQL.
Something that might be able to deal with quoting, parenthesis and use of
AND and OR. Perhaps also + and - syntax.
For example, if a user
I take it the Computer SQL Function is not support by MySQL and if not is
there a substitute for it?
If you are unfamiliar with the command it works like this:
SELECT type, price
FROM products
ORDER BY type
COMPUTE SUM(price)
You will get a summary of prices by type in your results.
: Monday, May 21, 2001 1:07 PM
To: [EMAIL PROTECTED]
Subject: RE: Compute SQL Function Not Supported
SELECT type, sum(price) FROM products GROUP BY type ORDER BY type
I take it the Computer SQL Function is not support by MySQL and if not is
there a substitute for it?
If you are unfamiliar
To: Chris Bolt; [EMAIL PROTECTED]
Subject: RE: Compute SQL Function Not Supported
Okay I may have been a bit vague on my description.
Is there something similar for compute?
-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 1:07 PM
To: [EMAIL PROTECTED
In your original message, you said You will get a summary of prices by type
in your results. and that is what my query gives you. It returns the sum of
the price columns from any rows that are eliminated by the GROUP BY clause.
What do you want it to return?
Please strike previous message the
Hello, everybody!
Can MYSQL understand this (GROUPing BY FUNCTION(column))?
--
Best regards,
Igor mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
: Bobby Chopra [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 2:09 PM
Subject: Using the IN function
Probably a simple question:
I am returning back to SQL after a break, and I was sure that I could do
the
following when using the IN function:
SELECT field1 FROM table1
All,
I have several scripts (downloaded) - that have a similar error
for example..
.
perl -w enter_bug.cgi
[Fri Apr 20 07:22:48 2001] enter_bug.cgi: defined(%hash) is deprecated
at CGI.pl line 121.
[Fri Apr 20 07:22:48 2001] enter_bug.cgi: (Maybe you should just
omit the defined()?)
how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date = 20010418 AND date 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() functio
Andrew Warner wrote:
how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date = 20010418 AND date 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() function.
Andrew
be to set the default of a datetime column to
whatever NOW() returns, but that doesn't seem to work as when I try to set
the default, it changes the string 'NOW()' to '-00-00 00:00:00'.
Is it possible to set the column's default to a function ?
A dirty solution would be to create 2 timestamp
order)
Siggy
- Original Message -
From: "Michael M. Ocana" [EMAIL PROTECTED]
To: "Mysql Lists" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 2:55 PM
Subject: inverse function
Subject: inverse function (database,sql,query)
hello anybody knows how to inv
ASC with DESC for descending order)
Siggy
- Original Message -
From: "Michael M. Ocana" [EMAIL PROTECTED]
To: "Mysql Lists" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 2:55 PM
Subject: inverse function
Subject: inverse function (database,sq
2001 2:55 PM
Subject: inverse function
Subject: inverse function (database,sql,query)
hello anybody knows how to invert selected records?
example :
i have selected records :
apple
mangoe
cherry
avocado
if i invert it :
avocado
cherry
mangoe
apple
how c
i remember coming across the mysql equivalent of the oracle nvl()
function which will substitute in the case of a returned null value, but
i can't seem to locate the command now...anyone know what it is?
thanks!
-
Before
nevermind...found it...ifnull()
thanks anyway!
Kris Gonzalez wrote:
i remember coming across the mysql equivalent of the oracle nvl()
function which will substitute in the case of a returned null value,
but
i can't seem to locate the command now...anyone know what it is?
thanks
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
"Rekha Das" [EMAIL PROTECTED] wrote:
What time function should I use to add 2 hours to a time value I am
getting
from the database ?
Convert the time to seconds, add 7200 seconds (2 hours), then convert back
to time format.
SELECT SEC_TO_TIME(TIME_TO_SEC(my_time_field) +7200);
--
S
e_and_time_functions
chris
-Original Message-
From: Rekha Das [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 2:52 PM
To: '[EMAIL PROTECTED]'
Subject: Time function
What time function should I use to add 2 hours to a time value I am getti
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 alternative ways
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 not found this function in libmysql.dll (ver
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 STDCALL mysql_thread_id
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(MYSQL *mysql);
char * STDCALL mysql_info(MYSQL
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'
This function is multi-byte safe
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
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 left of the final
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:
http://www.mysql.com
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
that it see
]
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 they supported asp, so I had a friend of mine set up
the
asp
code
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 and DO NOT
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
- 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 that email in a confusing manner.
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
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 start the mysql server now
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 in MySQL without using th
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
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
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 crunch to get mysql working on my site.
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,
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,
801 - 900 of 906 matches
Mail list logo