My site now contains a usable Java code wizard. Those familiar with the VB
and VBScript versions on my site, simply change the applied language to
'Java' and it will spit out a work-alike.
The java class that is generated can be used for applications, applets, jsp
and chili!beans for Chilisoft AS
Hi John,
I had faced a similar problem earlier, I solved it my instaling MySQL-devel package
and include the libmyclient library stored in /usr/lib (not in /usr/lib/mysql/)in the
compile command.
Best of Luck,
Shambhu.
- Original Message --
john1 <[EMAIL PROTECTED]> wr
On Fri, 2 Mar 2001, Nathan Clemons wrote:
>
> Can't you do something with SUM() to get the results, possibly in
> coordination with GROUP BY?
>
> --Nathan
>
Not to my knowledge/imagination. What are you going to group by? You want and
incremental grouping or better you want a dynamic calcul
öÅÌÁÀ ÷ÁÍ ÐÒÉÑÔÎÏÇÏ É ÕÓÐÅÛÎÏÇÏ ÄÎÑ!
üÔÏ ÚÁÒÁÂÏÔÏË ÂÅÚ ÏÔÒÙ×Á ÏÔ ÍÏÎÉÔÏÒÁ;-)
åÓÌÉ ÷Ù ÐÒÏÑ×ÉÔÅ ÎÅËÏÔÏÒÙÊ ÉÎÔÅÒÅÓ É ÔÅÒÐÅÎÉÅ (Á ÇÌÁ×ÎÏÅ, ÒÁÚÂÅÒÅÔÅÓØ, ËÁË
üôï ÒÁÂÏÔÁÅÔ), ÷Ù ÍÏÖÅÔÅ ÈÏÒÏÛÏ ÚÁÒÁÂÏÔÁÔØ (ÄÏ 50.000$ É ÂÏÌÅÅ!!!, ÜÔÏ ÚÁ×ÉÓÉÔ
ÔÏÌØËÏ ÏÔ ÷ÁÓ) × ÔÅÞÅÎÉÅ ÓÌÅÄÕÀÝÉÈ 90 ÄÎÅÊ. ëáöåôóñ îå÷ïúíïöîùí??
öÅÌÁÀ ÷ÁÍ ÐÒÉÑÔÎÏÇÏ É ÕÓÐÅÛÎÏÇÏ ÄÎÑ!
üÔÏ ÚÁÒÁÂÏÔÏË ÂÅÚ ÏÔÒÙ×Á ÏÔ ÍÏÎÉÔÏÒÁ;-)
åÓÌÉ ÷Ù ÐÒÏÑ×ÉÔÅ ÎÅËÏÔÏÒÙÊ ÉÎÔÅÒÅÓ É ÔÅÒÐÅÎÉÅ (Á ÇÌÁ×ÎÏÅ, ÒÁÚÂÅÒÅÔÅÓØ, ËÁË
üôï ÒÁÂÏÔÁÅÔ), ÷Ù ÍÏÖÅÔÅ ÈÏÒÏÛÏ ÚÁÒÁÂÏÔÁÔØ (ÄÏ 50.000$ É ÂÏÌÅÅ!!!, ÜÔÏ ÚÁ×ÉÓÉÔ
ÔÏÌØËÏ ÏÔ ÷ÁÓ) × ÔÅÞÅÎÉÅ ÓÌÅÄÕÀÝÉÈ 90 ÄÎÅÊ. ëáöåôóñ îå÷ïúíïöîùí??
Can't you do something with SUM() to get the results, possibly in
coordination with GROUP BY?
--Nathan
On 2001.03.01 23:49:28 -0500 Thalis A. Kalfigopoulos wrote:
> Now that I notice more closely the numbers, my answer was obviously wrong
> with regard to the 3rd column :o)
>
> Very interestin
Now that I notice more closely the numbers, my answer was obviously wrong with regard
to the 3rd column :o)
Very interesting question...but I doubt there is a SQL way to do that.
Looking fwd to what the rest will sugest.
cheers,
thalis
On Fri, 2 Mar 2001, Richard Vibert wrote:
> Hi,
> At 01
Hi,
At 01:52 pm 2/03/2001, Thalis A. Kalfigopoulos wrote:
>On Fri, 2 Mar 2001, Richard Vibert wrote:
>
> > Hi,
> >
> > I having trouble working out how to get a result set similar to the
> > following where I select from a table with Date & Sales column.
> >
> > My specific question is can I have
Hello there.
I'm writing these lines because I'm having a weird problem with mySQL
3.23.33 (also with 3.23.32) on servers running RedHat 7.0.
Each time that I run my SQL based applications, I start getting the
following errors on mySQL:
010302 0:45:59 Aborted connection 10207 to db: 'db201' u
- Original Message -
From: "Jim Ray" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:46 AM
Subject: Aphace and MySql
> Will MySQL work with Aphace for windows?
>
> Thank you
>
> Jim Ray
>
Work perfectly here.
Now I'm using Apache 1.3 + MySQL 3.23 + PHP4
On Fri, 2 Mar 2001, Richard Vibert wrote:
> Hi,
>
> I having trouble working out how to get a result set similar to the
> following where I select from a table with Date & Sales column.
>
> My specific question is can I have a column that accumulates values, if so
> could I have some guidance
Will MySQL work with Aphace for windows?
Thank you
Jim Ray
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mai
Quentin,
Thanks for all your help! I ran isamchk for the third time, and finally it
pooped out the errors I needed. I was able to repair, but I unfortunately
lost all of the data from today. I'm guessing when the server crashed
yesterday, it left MySQL hanging, and thus caused the problem. Since
Why can't you do something along the lines of:
select count(*) from pollResults where dayofyear(now()) =
dayofyear(dateEntered) and year(dateEntered) = 2001;
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:51 PM
To: Daren Cotter
Cc: Quentin
Hi,
I having trouble working out how to get a result set similar to the
following where I select from a table with Date & Sales column.
My specific question is can I have a column that accumulates values, if so
could I have some guidance on how to express this in a select statement please.
+
mysql> select count(*) from members where signup_date = '2001-03-01';
ERROR 1032: Can't find record in 'members'
Indicates a problem with the table structure; the result would be
+--+
| count(*) |
+--+
|0 |
+--+
If there was a problem with the data.
I suggest r
On Thu, 1 Mar 2001 19:32:54 -0800, "Daren Cotter" <[EMAIL PROTECTED]>
wrote:
>>So, the question is, why does this not return 400, like it should???
>>
>>OK, weird! Now I am getting this error...
>>
>>mysql> select count(*) from members where signup_date = '2001-03-01';
>>ERROR 1032: Can't find re
Hello,
I have mysql-3.23.33 installed, when trying to add BDB support using
db-3.23.33 I get the message below
after doing "make install" from /usr/src/mysql-3.23.33.
Note: I had no problem with "make" or "configure" and I did follow all
installation steps explained on www.mysql.com website.
. .
On Thu, 1 Mar 2001, Daren Cotter wrote:
> Ok, here goes...
>
> mysql> select member_id, signup_date from members order by member_id desc
> limit 410;
> +---+-+
> | member_id | signup_date |
> +---+-+
> (here's the last 20 or so rows)
> | 0120472 | 2001-0
> Ok, I am new in the IT world, and I just want to set up a mySql server.
> I installed mySql on the WinNt server (on the lan in my office) with
> mysqladmin running, and i installed myODBC on my win98 computer, with
> settings that would match the server.
> How can i test if this is working witho
I should note, however, that this query works FINE:
mysql> select count(*) from members where signup_date = '2001-02-28';
+--+
| count(*) |
+--+
| 732 |
+--+
This APPEARS to work, but the "127" should be more like 420
mysql> select count(*) from members where signup
On Thursday 01 March 2001 13:32, Quentin Bennett wrote:
>
>
>After the patch, MySQL still passes our test suite, which is a good sign.
>
>
>
>But how come it passed the test suite with the bug in place ?? ;-)
It does not any more, with the bug not fixed, that is. We update the test
suite every
Ok, here goes...
mysql> select member_id, signup_date from members order by member_id desc
limit 410;
+---+-+
| member_id | signup_date |
+---+-+
(here's the last 20 or so rows)
| 0120472 | 2001-03-01 |
| 0120471 | 2001-03-01 |
| 0120470 | 2001-03-0
I'm just setting this up myself and there is a program called admndemo (or
something like that) that comes with myodbc that will allow you to check if
things are working or not without having to create a program.
- Original Message -
From: "Katelyn Sweet" <[EMAIL PROTECTED]>
To: <[EMAIL P
Can you post some of the data - e.g the first 500 rows of the 'order by'
select, and the results of the select with signup_date='2001-03-01'.
Also, how about
Select now(), signup_date from , to see what things are being compared.
Regards
Quentin
-Original Message-
From: Daren Co
> Hi,
>
> I've installed MYSQL on Red hat.
>
> I'm trying to run the command
>
> mysqlaccess
>
> It asks for the Password for MySQL superuser root:
> Can anyone tell me the password for this?
>
>
> Thanks
> Sandeep
mysqlaccess is a perl script to check the access priviliges of a user:d
Quentin,
that does not work either, I still get the 125 number, when there are
actually 500 records =(
I am using version 3.22.32
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:18 PM
To: 'Daren Cotter'; [EMAIL PROTECTED]
Subject:
Hi,
Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that
gives.
Also, what version are you on - I have had some date problems where the end
of one month and the begining of another get confused (usually when doing a
UNIX_TIMESTAMP).
Maybe then use mysqlbug to report the is
Hi,
I've installed MYSQL on Red hat.
I'm trying to run the command
mysqlaccess
It asks for the Password for MySQL superuser root:
Can anyone tell me the password for this?
Thanks
Sandeep
-
Before posting, please check
Hi All,
Does anyone have any ideas on this one? Could I maybe try to install a
newer version of whatever package installs libstdc++? Anyone know what
package installs this file?
Thanks for the help,
Shawn
- Original Message -
From: Shawn Heeley <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED
okay, this is a follow-up to my past email...
since I KNOW more than 122 people have signed up today, I did the following
query:
SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit
200;
there are at LEAST 200 people that have signed up today. however, when i do:
SELECT cou
Getting the above error message on one of our servers using mySQL. Went to
go and set up WebCalender on it and tracked an issue down to mySQL. If I
execute the query of:
mysql> SELECT * FROM webcal_entry, webcal_entry_user WHERE
webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_
I had the same problem. Ensure the permissions for /var, /var/lib, and
/var/lib/mysql are set to: drwxr-xr-x
-Original Message-
From: Ben Kennish [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:56 AM
To: [EMAIL PROTECTED]
Subject: PHP and MySQL
Who would've thought it woul
When you specify now it is giving a date and a time. So if you do your query
it may be checking the date and time in the signup_date field and if it
doesn't find a time it just matches the date. What I would do if you want
results for the day and not the exact time is to change the query so that i
I have used it on a Win98 systems to access a MySQL DB on a Linux
server. I found it highly unreliable. I would get a whole record
entered before, as often as not, it would get kicked back with an
error message, saying it could not save the (new) record, because
someone else was accessing that
After the patch, MySQL still passes our test suite, which is a good sign.
But how come it passed the test suite with the bug in place ?? ;-)
Quentin
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
reci
Hi,
Would
ALTER TABLE mytable ADD INDEX (somecol, othercol), ADD INDEX (othercol);
do this in one sweep of the table, creating one temporary copy, or go
through the table twice, one for each index?
Quentin Bennett
Transport Systems Division
Infinity Solutions
web http:\\www.infinity.co.nz
ma
I have a field in my table that stores the date a member has signed up...i
run a query using distinct to show me how many members signup each day.
Yesterday, our server crashed, and today i am seeing weird behavior with
mysql:
SELECT count(*) FROM members WHERE signup_date = now();
122
SELECT cou
> Did you change the permissions of the files after starting
> the sever, or before?
>
> Did you read the GRANT section of the manual.
> Does your user have the UPDATE privilege?
>
>
> Raman Aggarwal wrote:
> >
> > Dear Sir
> >
> > I am a regular user of MySql. I will be obliged if you help
I'd love to here an answer to this one too. Exact same scenario.. exact same problem.
--- "Lucy" <[EMAIL PROTECTED]>
> wrote:
>Hi
>1. I'm working in Windows 2000, intending to run MySQL to localhost on same
>laptop.
>2. I've edited "my.cnf" to change to d: wherever it said c:, place
Hey guys, I've got a question regarding a search engine I have to write
Basically what I have is this.. This is for a web page BTW.
I have a table with a TEXT field in it. I'd like to take that field
and search for keywords... I've got a mySQL database and this is how I'm
doing it...
SELECT
Did you also install the mysql client rpm?
"K.K" wrote:
>
> Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I
> actually upgraded mysql to the newest version and everything went fine and
> it verified after the installation was done.
>
> The problem that I have is that I c
Your Apache must be configured to support perl cgi scripts.
Is it?
What is in the Apache error log?
[EMAIL PROTECTED] wrote:
>
> Hi,gurus,
> I am a novice at MySQL. When I try to run a sample program in the book of
> "MySQL & mSQL" I get a error message from my apache server as follows,
> *
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
Ben Kennish wrote:
>
> HOORAY! It's finally working.
>
> However, I'd prefer to have my mysql.sock socket file in /tmp/
>
> Anyone know how to change the settings for MySQL (and also PHP4 and
> phpMyAdmin) so that it looks in /tmp/ instead?
>
> Cheers.
>
> Ben
>
> Rick Emery wrote:
> >
> >
My question is about indexes...basically, I'm wondering how many indexes is
too much, and what the drawbacks are of having more indexes on a table? I'm
guessing INSERT and UPDATE queries probably take longer?
My table has the following fields:
member_id, first_name, last_name, username, password
Okay, I get it. The problem comes from the statement below,
wen> $db = param('test') or die("Could not find database!");
After I revised it to "my $db = "test" or die("Could not find database!");"
I get expected result.
Thanks for your consideration.
Regards,
--Wen
[EMAIL PROTECTED]
-
On Thu, Mar 01, 2001 at 11:47:41AM -0500, Joe Kislo wrote:
> > I´m currently working on system for Managing http Session and would like
> > to use a heap table for storing the session information. Session
> > information is only of temporary intrest. But still I need an unique
> > ID for reference
> > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is
> > closest to the boolean type
>
> ShortInt: 0 == FALSE, <> 0 == TRUE
> That's how I do it anyway.
>
> Or maybe combine multiple bool fields to one and use binary logic.
Or quoting from http://www.bitbybit.dk/mys
OK, I admit it, I'm stumped. I've done this before, but I've lost the
script that used to do this.
All I'm trying to do is build a simple MySQL client program under AIX 4.3
with gcc, and I can't seem to get the link libraries right (the worst part
of porting!). Any help appreciated.
I've done t
iii> You will get errors like these if your script does not print out a header
iii> before spitting out other information. It is usually best to print the
iii> header in the very beginning of the script so you do not have to worry about
iii> it. You dont have to wait until you are about to print o
If all you need is a count of the items why not issue
Select count(distinct threads) as ctr from messages
Jack ;-)=
- Original Message -
From: "Ed Lazor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 11:53 PM
Subject: how do you format this query?
> Hi =)
Laurent Oget writes:
> I am not sure this will solve your probleme but you need to add -lnsl and -lsocket
>to the compile command line.
>
> On Thu, Mar 01, 2001 at 11:03:11PM +0800, john1 wrote:
> > dear Sir :
> >
> > MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> >
Sinisa, i thought i pointed out that mysql ALWAYS
crashes on any single INSERT DELAY anytime,
any database, under any conditions and during any
weather. NO single INSERT DELAY can be executed
successfully.
Regards,
Artem
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
>On 28.02.2001 13:13:05 Bob Hall wrote:
>
> > >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen
> > >til at spørge på dansk... ;-)
> >
> > Det er alltid hyggelig å se på andre språg på internettet, men hvis
> > du skriver på dansk, så skal de aller fleste taper sjans
Artem Koutchine writes:
> Hello again!
>
> In the prev episode i said that when i do INSERT DELAYED
> mysql just catches sig 11, crashes and restarts. No record
> inserted whatsoever. Nothing is written into the update log.
>
> Here is a sample (even though it says 1 row affected, it is
You will get errors like these if your script does not print out a header
before spitting out other information. It is usually best to print the
header in the very beginning of the script so you do not have to worry about
it. You dont have to wait until you are about to print out some html.
$outp
They didn't work 'onsite'/live, or when downloaded. They *used* to work
for both.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
Hi
1. I'm working in Windows 2000, intending to run MySQL to localhost on same
laptop.
2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3
places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I
unzipped binary directly to d:
3. None of these have worked:
d
when do configure:
--with-charset=win-1251
It is clearly explained in the manual. READ THE MANUAL!
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "Vitaly Dugaev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 6:59 PM
Subject: Re: Use Ukrainian l
Hello again!
In the prev episode i said that when i do INSERT DELAYED
mysql just catches sig 11, crashes and restarts. No record
inserted whatsoever. Nothing is written into the update log.
Here is a sample (even though it says 1 row affected, it is
actually not affected. nothing is inserted):
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I
actually upgraded mysql to the newest version and everything went fine and
it verified after the installation was done.
The problem that I have is that I cannot log into mysql now. I have tried
to located mysqladmin anywh
Todd A. Jacobs writes:
> I downloaded and compiled the latest version of MySQLGUI and am connecting
> to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the
> following ssh tunnel:
>
> ssh -x -g -L 3306:localhost:3306 mysql
>
> I get this error message from the MySQL
On Thu, Mar 01, 2001 at 12:04:27AM -0500, [EMAIL PROTECTED] wrote:
>
> I've replicated this problem on 3 different machines, and
> on 3.23.33 and 3.23.32. I had been using BDB tables for a
> couple weeks now in testing, without a hitch until the above
> query starting being used. I also tried to
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL & mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please
Dual PIII half gig ram.
VaLinux 6.2.3
When running configure, It checks size of char and says 0.
it fails and says that a static libm.a is not found. It is in /usr/lib,
but it says to install a static version.
Is there any other workaround for this.
-
> I´m currently working on system for Managing http Session and would like
> to use a heap table for storing the session information. Session
> information is only of temporary intrest. But still I need an unique
> ID for reference with some other Tabels storing dtaa for the session.
> All these t
Ok, I am new in the IT world, and I just want to set up a mySql server.
I installed mySql on the WinNt server (on the lan in my office) with
mysqladmin running, and i installed myODBC on my win98 computer, with
settings that would match the server.
How can i test if this is working without makin
Joe and Nancy M wrote:
>
> Thanks to everyones help, I have my webpages using php to read my mysql
> table and presenting the appropriate information. I upload and refresh my
> table via telnet when the whole thing needs refreshing.
>
> I would like to give my end user a tool to change the tabl
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
I am not sure this will solve your probleme but you need to add -lnsl and -lsocket to
the compile command line.
On Thu, Mar 01, 2001 at 11:03:11PM +0800, john1 wrote:
> dear Sir :
>
> MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> a simple C API programe which catched from
Hi all.
I've compiled mysql 3.23.33 with support for DB-Berkeley. After it when I
try to launch mysqld it gave me a segmentation fault. Anybody has a similar
problem?
Note: I use Slackware 7.1 in a PC.
Thanks in advance.
Iago.
-
HOORAY! It's finally working.
However, I'd prefer to have my mysql.sock socket file in /tmp/
Anyone know how to change the settings for MySQL (and also PHP4 and
phpMyAdmin) so that it looks in /tmp/ instead?
Cheers.
Ben
Rick Emery wrote:
>
> I hd this same problem. Ensure that /var, /var
Is there reasonably current version of mysql that I can install or
compile under aix4.2.1. I have been unable to compile 3.23.33 because of
size limitations.
--
Mike Klein
Manager, System Services
Information Technology
Loyola University New Orleans
6363 St. Charles Ave.
New Orleans, LA 70118
50
[EMAIL PROTECTED] wrote:
>
> On 01.03.2001 13:51:58 Robert Vetter wrote:
>
> > ENUM("no","yes")
>
> I always wondered: How much space does this take?
1 or 2 bytes, depending on the number of enumeration values (65535
values maximum). I've read this in the _MANUAL_ !
Robert
I have never tried changing the default language myself but a suggestion
only is that are your columns of the right type?
- Original Message -
From: "Vitaly Dugaev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 19:32
Subject: Use Ukrainian lenguage.
Dear sup
HI, I sent this note a couple days ago and no one has commented. I am
trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz
Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed
successfully byt the Mysql-modules failed druing the 'make test' step.I
am using mysql ve
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL & mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please
Well, for starters, I would say you need
> Table_B.Cnty="US" AND Table_A.ID="*";
not
> Cnty="US" AND ID="*";
- Original Message -
From: "soon chee keong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 20:16
Subject: Error 1052:Query problem
> Table_A: I
There is entirely unexpected behavior here.
If you have gone to the trouble of defining a column in your database as
an auto_increment field
it should not simply stop working because you enter a negative number.
What we saw yesterday was the addition of a row with a negative number in
the auto_i
On Thu, Mar 01, 2001 at 02:37:30PM +0100, Entryon Corp., Chief Technical Officer - P.
Hasenfratz wrote:
> > > Why not use a timestamp column to guarentee the order in which rows get
> > > inserted into the table? You can then order on the timestamp column.
> >
> > Hmm, timestamp, ie. seconds as f
Broadly speaking, I would agree with Cal becasue MySQL is, by its very
nature, a server application..
However, you can easily emulate it being an application by adding net
start(s) and net stop(s) to the beginning and end of your application - you
may have timing issues, however, with the start a
Yeah, except when the RPMS were created with an error. MySQL should not
require Perl to be installed in order for it to work, so in this case, yes,
use no dependancy flag. Have a look at the archives around november,
december last year. Heaps of info in regards to this.
- Original Message
Gerald,
I've written to them asking your question.
I'd like to point out that I just got an empty record set when it is running
under ASP.
The query runs successfully through phpMyAdmin 2.0.5. I realized that the
query
(select count(*) as quantity from person;) works well in ASP so that I think
i
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
[EMAIL PROTECTED] writes:
> Hi folks, I'm having a hard time using bdb tables. Here are the
> details...
>
> I've create a few BDB tables, which are causing me great amounts
> of grief. The tables worked fine for a while, then suddenly
> started crashing mysqld. I decided to drop the offend
marsha writes:
> Hi guys,
>
> I am part of a team developing an interface from Microsoft Access on a
> Windows environment to mySQL on a Cobalt RAQ server (LINUX).
>
> When you say the software mySQLgui is in "beta testing", what level is
> that? Is alpha a step higher than beta, as in th
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
On 01.03.2001 13:16:47 soon chee keong wrote:
> Table_A: ID APPL
>
> B BI
> A BII
> * *
> * *
> C BII
> * *
> D BI
>
> Table_B: Cnty ID
>
>
DUAL is a dummy table in oracle ... !
In mysql you have two way to set variables:
1. set them directly via SET @variable={ integer expression | real
expression | string expression }[,@variable= ...].
2. or do something like select @variable:={ integer expression | real
expression | string expre
Did you change the permissions of the files after starting
the sever, or before?
Did you read the GRANT section of the manual.
Does your user have the UPDATE privilege?
Raman Aggarwal wrote:
>
> Dear Sir
>
> I am a regular user of MySql. I will be obliged if you help me.
>
> 1. The path of
I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have
permissions set to: drwxr-xr-x
This cured the problem for me.
rick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:19 AM
To: Ben Kennish
Cc: [EMAIL PROTECT
[EMAIL PROTECTED] wrote:
>
> On 01.03.2001 11:55:40 Ben Kennish wrote:
>
> > "Warning: MySQL Connection Failed: Can't connect to local MySQL server
> > through socket '/var/lib/mysql/mysql.sock' (111) in
> > /var/www/html/index.php on line 5"
>
> Are you sure that your MySQL installation create
Hi,
> How do I set up a field called Minutes which has the (default) value, where
>
> round((SessionTime+30)/60) = Minutes
>
> Is it possible to set this up? In other databases (Alpha Five) I would have
> used a Calculated Field attribute to achieve this.
>
> Can MySql handle it.. ???
These libraries should be on Debian installation CD.
You just need to install them.
"Mark R. Martinez" wrote:
>
> Hello,
> Our problem concerns an abnormal abort of:
> ./configure --prefix=/usr/local/mysql
>
> error messages show that lncurses, lcurses, ltermcap, could not be found.
> W
They replaced your MySQL with a new version.
Did they re-compile Apache and PHP to use the new MySQL libraries,
or is it trying to use the now missing ones?
Celso Pires wrote:
>
> Hi there,
>
> I've got a site hosted at an ISP and everything was going well when they
> decided to upgrade the sof
Since you did not
./mysql_install_db --user=mysql
the files are owned by the wrong id.
chown -R mysql /usr/home/treebc.com/mysql/var
if that is the correct location for the database directories.
nirmala wrote:
>
> Hi,
> We have installed Mysql on our server(UNIX) . When I am telnet into
My greetings.
Please forgive me for my bad English and please help me with my problem.
Solution of that problem i didn't find in mailing list, in manual and in others
sources. I was working and searching hard, but i can't find it.
My problem is: i want to create databases for my
1 - 100 of 144 matches
Mail list logo
