Hi there,
On Fri, 8 Mar 2002, Paul DuBois wrote:
> At 21:14 +0100 3/8/02, Roger Baklund wrote:
> >* Paul DuBois
> >> At 17:00 + 3/8/02, Corin Hartland-Swann wrote:
> >[...]
> >> >This works for a varying number of rows (usually 5,000 to 10,000) before
> >> >it silently exits the loop. I'
On Fri, Mar 08, 2002 at 05:10:02PM -0800, Jeremy Zawodny wrote:
> >
> > I have tracked down and fixed the assertion failure issue. However,
> > I am still not certail why the sql thread does partial reads. I have
> > pushed my fix into the public tree, so let's have you pull it and
> > try again.
Hi,
I¡¦m a new user of MySQL verison 4.01 and found that the following
statement not working:
CREATE TABLE test TYPE = HEAP SELECT * FROM customer
If omit TYPE = HEAP, or using TYPE = INNOB or TYPE = MYISAM will work, is
it a bug?
___
where? wich is a good example?
On Fri, 8 Mar 2002, Gelu wrote:
> Date: Fri, 8 Mar 2002 14:04:29 +0200
> From: Gelu <[EMAIL PROTECTED]>
> To: Oscar Colino <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Datawarehousing
>
> Yes
> - Original Message -
> From: Oscar Colino <[EMAI
Hi,
To give you all an idea, i have a script named editform01.php that first
displays the data in a table. ThenI have this link called "Edit" in which it
goes to another script called editform02.php which is where the data is
displayed and then you can edit it there. My problem is I cannot procee
> I'm using php and mysql as my server, when I'm updating a large
> page on my database using a browser I get
> "Request-URI Too Large
> the requested URL's length exceeds the capacity limit for this server.
> request failed: URI too long"
> Why is this so? Do I need to adjust something on mysql
Hi,
I'm using php and mysql as my server, when I'm updating a large
page on my database using a browser I get
"Request-URI Too Large
the requested URL's length exceeds the capacity limit for this server.
request failed: URI too long"
Why is this so? Do I need to adjust something on mysql or
On Fri, Mar 08, 2002 at 03:14:31PM -0700, Sasha Pachev wrote:
> On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote:
> > The 4.0.x slave I had just rebuilt the other day died about 40 minutes
> > ago and produced a core file each time. ?It got caught in the cycle of
> > "core dump, restart, c
I've been poking around some more online, and I've found a very nice
session module, that can easily be expanded to handle user logins. Check
it out at http://www.php.lt/sqlsession/
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Matthew Walker
Sent
Dan,
Have you taken a look at phpMyAdmin? This very good tool not only
administers your MySQL databases, but their php code is a good teaching
tool, as well. Simply drop the whole thing into an apache-served directory,
and you're off to the races!
It's on Sourceforge, and anyone on this list c
At 21:14 +0100 3/8/02, Roger Baklund wrote:
>* Paul DuBois
>> At 17:00 + 3/8/02, Corin Hartland-Swann wrote:
>[...]
>> >This works for a varying number of rows (usually 5,000 to 10,000) before
>> >it silently exits the loop. I'm using MySQL 3.23.49a
>[...]
>>
>> That's also your problem.
I have, but I'd rather not reinvent the wheel if I don't have to, though
I'm almost to the point where I'm going to need to.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 3:51
On 8 Mar 2002, at 15:52, Steve Buehler wrote:
> I have some fields set up in my MySQL database table as tinyint(5)
> The problem is that it will not except a NULL unless I specifically tell it
> NULL. I have a form that allows for input. When submitted, it updates the
> database. If the fiel
Matthew...
Did you look into the session variables
Session_start()
Session_register()
Mysql, query
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 4:49 PM
To: [EMAIL PROTECTED]; mysql list; Siulun A Sze
Subject: RE: login and logout
T
The problem with that is, it doesn't allow logout.
Siulun, if you /do/ find some good sample code, clue me in. I'm in the
market myself. I'm using apache's basic auth right now, but I need to
add logout support.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote:
> The 4.0.x slave I had just rebuilt the other day died about 40 minutes
> ago and produced a core file each time. ?It got caught in the cycle of
> "core dump, restart, core dump, restart..."
Jeremy:
I have tracked down and fixed the asse
Don't know what web server your using, but I use apache's .htmaccess feature
to control user access. Works good for me, and its pretty easy to setup.
Mike
- Original Message -
From: "Siulun A Sze" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 08, 2002 4:04 PM
Subject: lo
I have some fields set up in my MySQL database table as
tinyint(5)
The problem is that it will not except a NULL unless I specifically tell it
NULL. I have a form that allows for input. When submitted, it updates the
database. If the field on the form is empty, it still puts a "0" (zero)
int
> On Fri, 8 Mar 2002 12:33:24 -0800 (PST), Margie New <[EMAIL PROTECTED]> wrote:
>
> >>Is there a Perl function similar to php's phpinfo()
> >>that echos or returns a complete synopsis of the Perl
> >>configuration core? We are trying to determine whether
> >>the MySQL DBI/DBD module is accessi
mm.mysql.jdbc-1.2c.tar.gz
mm.mysql-2.0.4-bin.jar
Which of these two database driver for MySQL is better?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Does anyone have a php sample code handling login and
logout using cookie?
I tried to use SESSION, but when I click back on the
browswer, it lost all the data I previously entered in
a form.
I want to have a section on the website that is only
used by registered users. The site developed using
I just tried something and would a second opinion:
I re-configured my MySQL server on my RH Linux machine using the following :
CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure
and ran the following SQL:
CREATE TABLE FOO (foo int NOT NULL DEFAULT 5, foo1 INT NULL);
INSERT INTO FOO (foo1) VALUES
Hi!
Thanks for your help!!!
OS: W2K nt
Server: MySQL 4.0.1 Max nt
Mysql ODBC driver 3.51
Power Builder 8.0.1.
I have 2 main problems:
1. I have a datawindow with 2 arguments, in preview mode works just
fine...but inside a window it doesn't retrieve data atall...even if
I put values ins
On Fri, 2002-03-08 at 14:21, Rolando Morales wrote:
> Does anyone know the ETA for MySql having
> sub queries capabilities?
Hi,
Basic Sub-Selects are schedule to appear in the alpha release of 4.1.
Which should be in about 1-3 months.
Matt
--
For technical support contracts, visit ht
On Fri, 8 Mar 2002 12:33:24 -0800 (PST), Margie New <[EMAIL PROTECTED]> wrote:
>>Is there a Perl function similar to php's phpinfo()
>>that echos or returns a complete synopsis of the Perl
>>configuration core? We are trying to determine whether
>>the MySQL DBI/DBD module is accessible to Perl
for $key (sort keys %ENV)
{
print "$key = $ENV{$key}\n";
}
Page 155 of learning perl 1st (purple) edition.
Curtis
Margie New said:
> Is there a Perl function similar to php's phpinfo()
> that echos or returns a complete synopsis of the Perl
> configuration core? We are trying to determine
On Fri, 2002-03-08 at 14:19, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message,
Is there a Perl function similar to php's phpinfo()
that echos or returns a complete synopsis of the Perl
configuration core? We are trying to determine whether
the MySQL DBI/DBD module is accessible to Perl on a
Linux server.
Will appreciate any help on this.
-- Margie New
=
Margie New
5503
Every time I run safe_mysqld, I get the following
error message:
# ./safe_mysqld
chown: unknown user id mysql
Starting mysqld daemon with databases from
/usr/local/mysql/var
Killed
020308 22:12:04 mysqld ended
#
How do I handle this?
__
Do Y
Does anyone know the ETA for MySql having
sub queries capabilities?
Rolando
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
* Paul DuBois
> At 17:00 + 3/8/02, Corin Hartland-Swann wrote:
[...]
> >This works for a varying number of rows (usually 5,000 to 10,000) before
> >it silently exits the loop. I'm using MySQL 3.23.49a
[...]
>
> That's also your problem. With mysql_use_result, it's *required*
> that you compl
Sounds like a transaction server to me.
Curtis
John Masterson said:
> Situation: mass virtual website hosting, with php/perl/python. One
> master mysql server, one or more replicated slaves.
>
> Question: would it be possible/feasible to write a daemon that accepts
> connections on behalf of m
At 17:00 + 3/8/02, Corin Hartland-Swann wrote:
>Hi there,
>
>I have a medium-size table (3 million rows) with several pieces of data
>including an ID and a number (called id and num below). I have a program
>which builds a hash in perl from a data file of the 'new' numbers for each
>id, only s
On Fri, Mar 08, 2002 at 02:35:59PM -0500, Bob Hall wrote:
> On Fri, Mar 08, 2002 at 04:21:09AM +0200, savaidis wrote:
> > Is MySQL a relational database?
> > If yes, how is implemented a "one to one" and "one to many" relation?
>
> Sir, there is no such thing as a one-to-one or one-to-many relati
On RedHat try with GnoRPM or the rpm command line.
Philippe
Olav Drageset wrote:
>Hi
>I have installed RedHat 7.2 . with Apache and DNS as default. When trying to install
>MySQL with kpaackage manager I get
>rpmdepCheck() fialed. I cannot see any required modules missing. Can anyone tel me
On Fri, Mar 08, 2002 at 04:21:09AM +0200, savaidis wrote:
> Is MySQL a relational database?
> If yes, how is implemented a "one to one" and "one to many" relation?
Sir, there is no such thing as a one-to-one or one-to-many relation.
Those are joins, and they are implemented in
queries, as is th
On Fri, Mar 08, 2002 at 10:41:32AM -0700, Sasha Pachev wrote:
> On Thursday 07 March 2002 11:39 pm, Jeremy Zawodny wrote:
> > 020307 21:39:03 ?Error in Log_event::read_log_event(): 'read error',
> data_len=193,event_type=2
> > 020307 21:39:03 ?Slave SQL thread: I/O error reading
> event(errno=-1
Hi!
> Our (MySQL AB) recommendation is to NOT compile
> *mysql* with RedHat's 2.96 compiler. Instead,
> in the case of RedHat, you should use 2.91
> EGCS or 2.95 GCC compilers.
Your (MySQL AB) source rpm does not build at all with
the egcs/gcc 2.91 compiler. In fact, it gives this error:
[..sni
You can include constants and functions on your select e.g.
insert into table1_archive select *,now(),'thisuser' from table1
Of course, if you are using something like php or perl, then 'thisuser' could
just as easily be HTTP_AUTH_USER etc.
BD wrote:
> I have 2 tables, table1 and table1_ar
[EMAIL PROTECTED] wrote:
> Is this correct?...how MySQL calculate this?...
Yes.
Std. Dev = Math.sqrt(sum((val[i]-avg)**2) / count(i));
Verified with a trivial program.
>
> mysql> select * from temp;
> +--+
> | cal |
> +--+
> | 00029.9
I have 2 tables, table1 and table1_archive. The archive table has identical
columns as table1 except it has a few extra columns like a log_date,
user_id. I would like to copy the corresponding columns from table1 to
table1_archive. Sounds simple, right?
Example:
insert into table1_archive sele
If you're going to post this much information please use:
mysql> SELECT * FROM user \G
so that this is actually readable.
Thanks
# Nathan
- Original Message -
From: "Brian Warn" <[EMAIL PROTECTED]>
To: "'Daniel Negron/KBE'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March
Along the same lines, I have run some scripts that give a similar error
that time out is there something in php.ini or mysql that will alow the
timing to not stop after 60seconds or 30seconds or something.
Had a script to run and pull keywords from a massive db, and it kept
timing out.
Hope that
On Fri, 2002-03-08 at 10:02, Ireneusz Piasecki wrote:
> Hi,
>
> It is very interesting, what are you wwriting, but:
>
>
> " To determine if you should be concerned about this compiler issue,
execute
> gcc -v from the command prompt on your system. If the compiler reports
> version 2.96, then th
Michael Stassen <[EMAIL PROTECTED]> writes:
> On Fri, 8 Mar 2002, Trond Eivind Glomsrød wrote:
>
> > On Fri, 8 Mar 2002, Ireneusz Piasecki wrote:
> >
> > > Hi,
> > >
> > > It is very interesting, what are you wwriting, but:
> > >
> > >
> > > " To determine if you should be concerned about this c
Did you check the mysql db, host, and user tables to make sure that
'localhost' and 'administrator' have appropriate permissions to use your
desired database? This issue caused me much frustration until I had
things set right. You should see something like the following. I'm
assuming that your
On Fri, 8 Mar 2002, Trond Eivind Glomsrød wrote:
> On Fri, 8 Mar 2002, Ireneusz Piasecki wrote:
>
> > Hi,
> >
> > It is very interesting, what are you wwriting, but:
> >
> >
> > " To determine if you should be concerned about this compiler issue, execute
> > gcc -v from the command prompt on yo
On Thursday 07 March 2002 11:39 pm, Jeremy Zawodny wrote:
> 020307 21:39:03 ?Error in Log_event::read_log_event(): 'read error',
data_len=193,event_type=2
> 020307 21:39:03 ?Slave SQL thread: I/O error reading
event(errno=-1,cur_log->error=57)
> assertion "mi->io_thd == thd" failed: file "slave.
Is the syntax of the statement correct ?
>> if (!($mylink = mysql_connect
("localhost","administrator","")))
{
print "could not connect to database\n";
exit;
}
mysql_select_db("mytest");
?>
Thank You
<><><><><><><><><><><><><><><><>
Daniel Negrón
Lotus
Daniel,
Usually in PHP there are some sort of syntax error before the line that
says failed.
-Original Message-
From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: Some PHP - mySQL help please ... new to both
I am v
I am very new to both PHP and mySQL. Any help would be greatly
appreciated.
While running this code I get following fatal error.
PHP is installed and running correctly on the server.
mySQL I THINK is running properly. I created a table and this code is from
a tutorial I am trying to run throu
Hi there,
I have a medium-size table (3 million rows) with several pieces of data
including an ID and a number (called id and num below). I have a program
which builds a hash in perl from a data file of the 'new' numbers for each
id, only some of which have changed (5-10%).
To update the table
try starting it with /usr/bin/safe_mysqld &
Ken
Jianping Zhu wrote:
>
> I installed the binary version of mysql on my linux system. After i
> started the server, It seems the sysem get stuck. I can see the command
> line sign and the cursor.
> When I open another console I can find out that the
--- Jarkko Toivonen <[EMAIL PROTECTED]> wrote:
> I was just wondering that how to add date/time to every report run in
> MySql.
> I've got a database that contains everything about my home-made
> beers. I run
> a select-query sometimes and I want to include the time when it was
> run in
> it.
* Jarkko Toivonen
> I was just wondering that how to add date/time to every report
> run in MySql.
> I've got a database that contains everything about my home-made
> beers. I run
> a select-query sometimes and I want to include the time when it
> was run in it.
Add "now() as report_time" to your
On Fri, 8 Mar 2002, Ireneusz Piasecki wrote:
> Hi,
>
> It is very interesting, what are you wwriting, but:
>
>
> " To determine if you should be concerned about this compiler issue, execute
> gcc -v from the command prompt on your system. If the compiler reports
> version 2.96, then there is a
I use Outlook 2000 to read my email. I subscribed to the Mysql
digest list. Each message is attached to the digest as a separate
message, the subjects unsorted. Is there a way to sort the
subjects so I can find the right message number associated with
the message in the table of contents in the em
Hi,
It is very interesting, what are you wwriting, but:
" To determine if you should be concerned about this compiler issue, execute
gcc -v from the command prompt on your system. If the compiler reports
version 2.96, then there is a problem (this is the case, for example on RH
7.x series or Ma
Hi,
I am also facing the same problem...in Win2K
When i try to run in from the service, it says some
error
so i referred to some sites...and just using the
command line as standalone
Also i acould not run apache as a service...
I could not see it under services...
Any way to start thes
We have Solaris 2.8 and here is what we did to create the mysql
user and group:
- First add the group: groupadd mysql
- Next add the user: useradd mysql -g mysql
This also adds the user to the group mysql.
- Put the user root in the mysql group: usermod -G mysql root
Hi. We have Solaris 2.8 and just got Mysql 3.23. We installed the
files and are now trying to run the mysql/configure or
mysql/scripts/mysql_install_db scripts but I get an error
"Command not found." I logged in as "chuck", then did "su" and
logged in as superuser before running this command. I al
"Ireneusz Piasecki" <[EMAIL PROTECTED]> writes:
> Hi.
> I have question.
> U have RH6.2
> Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
>
> can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must i
I was just wondering that how to add date/time to every report run in MySql.
I've got a database that contains everything about my home-made beers. I run
a select-query sometimes and I want to include the time when it was run in
it.
So, any ideas?
Thanks!
Josiah..
I think you are asking the wrong mailing list for this... I am assuming
you are using PHP correct? Your explanation isn't all that clear, but I
can guess what you are trying to do. You want to have a drop down list,
but don't know what data type..
You can use VarChar or text for this
The following queries worked with the 3.22.32 version and not with the
3.23.47 and 3.23.49a versions.
select field1,field2,locate(ifnull(field3,'N'),'N') from mytable where
field3 not in ('N') order by 3, field1
select field1,field2,locate(ifnull(field3,'N'),'N') from mytable where
field3 not in
> So I do:
> SELECT * FROM table1 WHERE datum BETWEEN ('-00-00' + INTERVAL 1 DAY)
AND '2002-03-10';
> MySQL returns an empty result set, but it shouldn't (the table contains
dates year 2000 and up.
MySQL refers to the date -00-00 as null. Null+1 is null. Why don't you
rewrite the query
I installed the binary version of mysql on my linux system. After i
started the server, It seems the sysem get stuck. I can see the command
line sign and the cursor.
When I open another console I can find out that the server in running by
using the command bin/mysqladmin version.
Why?
Any suggest
Hi,
regarding the size, I would be more interested on the space in Gbytes
I am use to work with Oracle,Teradata, DB2 ... and they all handle
partitioning in different ways, when it comes to a big datawarehouse ( and I
am talking about Terabytes), there are two key features that need to be
hand
I just installed mysql-3.23.43-sun-solaris2.7-sparc, but I can not get it to
start up. Here's the error I'm getting:
>./bin/safe_mysqld --log --log-update &
Starting mysqld daemon with databases from
/koz/mysql-3.23.43-sun-solaris2.7-sparc/data
./bin/safe_mysqld: /koz/mysql-3.23.43-sun-solaris2.
The client has to be able to search var/lib/mysql and read and write the
var/lib/mysql/mysql.socket.
It is probably not able to do one of the above due to imprpoer
privileges at the filesystem level.
Doug Thompson wrote:
>Egor:
>
>Yesterday, I wrote and described that my fix for a single cpu,
Install your ncurses rpm.
Paul Warren wrote:
>I've been frustrated with this for the past I-donno-how-many days. Has
>anyone been able to get MySQL to work on Red Hat 7.2?
>
>I've been getting multiple errors. The First was the resolveIP() right from
>the beginning. I follwed what the mysql webs
Hello everybody, there is a table containing a date field named "datum".
I want to find out the rows containing a date BETWEEN two given dates.
And I do:
SELECT * FROM table1 WHERE datum BETWEEN '-00-00' AND '2002-03-10';
This one does what it's supposed to do.
But now I need to add one day t
On Fri, 8 Mar 2002, Sommai Fongnamthip wrote:
> If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting,
> MySQL db) lost?
>
> Sommai
No, they should be fine.
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Befo
Erminio Efisio Riezzo writes:
> Dear Sinisa,
> I have this error compiling code that uses the mysql++-1.7.9
> I am using
>
> gcc-3.0
> mysql-3.23.48
> mysql++-1.7.9 with patch for compiling with gcc-3.0
> under Tru64 Unix v.4.0f
>
> thanks in advance payment for the aid.
>
> Erminio Riezzo.
>
Okay, I'm a Lasso person who has been lurking on this list for some
months now because I'm learning MySQL. I'm learning it because Blue World
was cool enough to adopt MySQL in their latest version of Lasso
Professional 5 (LP5). This is a great list and I'm learning a ton of
stuff here without ever
Hi, Im running Linux 7.0 with mysql 3.23.35 installed via rpm. I have
some very strange problems where web forms submitted to my php insert
page seems to trigger an insert but only the new row's id gets inserted
and nothing else. I have tried everything to reproduce the error from my
side ( ov
what is the size of the warehouse?
how do you handle partitioning logic on the database?
>From: "Gelu" <[EMAIL PROTECTED]>
>To: "Oscar Colino" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: Datawarehousing
>Date: Fri, 8 Mar 2002 14:04:29 +0200
>
>Yes
>- Original Message -
>F
Yes
- Original Message -
From: Oscar Colino <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 08, 2002 11:52 AM
Subject: Datawarehousing
> Anybody out there using Mysql as a Datawarehouse?
>
> _
> Get your
Dear Sinisa,
I have this error compiling code that uses the mysql++-1.7.9
I am using
gcc-3.0
mysql-3.23.48
mysql++-1.7.9 with patch for compiling with gcc-3.0
under Tru64 Unix v.4.0f
thanks in advance payment for the aid.
Erminio Riezzo.
-
Hi.
> Reading specs from
/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> can i build mysql 3.23.49 from src.rpm with this gcc ?
No, definitely
> Or i must it do with 2.96
You need at least gcc 2.95. Follow the instructions
[MySQL 3.22 / MySQL 3.23] Does anyone know what the maximum length for a
query string is?
I've searched the docs/archives, but could not find an answer. I'm also
using PHP4, so if there is a different limt in that respect I would like any
help there also.
Thanks in advance
---
> I want rebuild source rpm: MySQL-3.23.49-1.src.rpm with rpm 4.0.2
> But it fails.
You need the rpm-build-4.0.2-6x.i386.rpm package to use
the --rebuild option.
You need gcc >= 2.95 to build MySQL (look at the "Why v3.23.49
does not build on RedHat 6.2 ?" thread)
Anybody out there using Mysql as a Datawarehouse?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
-
Before posting, please check:
>Description:
Core dump of mysql client program with segmentation violation.
Recently when upgrading php I had to have our sysadmin apply a patch
to fix problems with weak symbols in gcc-3. Secifically, they related
to problems with the variables _S_max_si
Hi everybody.
I want rebuild source rpm: MySQL-3.23.49-1.src.rpm with rpm 4.0.2
But it fails.
I type: rpm --rebuild MySQL-3.23.49-1.src.rpm
and i see: all options for RPM.
What is wrong ??
In MAN for RPM is:
REBUILD AND RECOMPILE OPTIONS
There are two other ways to invoke building with r
Hello everybody,
I could not find any documentation about the BETWEEN function. Am I just
blind? Please point me to it. Or is it not stable yet? How does it
perform in comparison to "field1 >= x AND field1 <= y"?
Thanks,
Felix
sql, query
-
Hi, I'm trying Mysql with various Java application Server.
I've started with Sun Refernce implementation.
What are the params to set in resourse config file?
and what type of jdbc drivers can i use?
Thank.
Luca
-
Before postin
Hi.
I have question.
U have RH6.2
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with
2.96
?
Thanks a lot.
I. Piasecki.
- Original
Month ago I posted question about embedded database feature missing from
MySql 4.0.1 Windows build. It seems that the feature is still not out there.
Are there any news regarding this?
Regards,
Miroslav Rajcic
-
Before post
Neil Silvester wrote:
>The server is a lightning fast Pentium Pro 90 with 32 MB EDO RAM and
RedHat
>7.0. So anyone who still says that the MySQL database can't cut the
mustard,
>obviously hasn't tried.
>Mysql 3.23.43
>Up 212 days,
>Processed 199,654 queries (average = 0.01/sec)
For comparison:
Hi,
On Fri, 2002-03-08 at 17:07, Pramod_Chakravarthy wrote:
> I am looking out some information on the features My SQL freeware version
> and the Enterprise version. So I would be very happy if you could put on a
> table with the comparison of Mysql freeware version vs Mysql enterprise
> version.
senthil,
Friday, March 08, 2002, 10:51:51 AM, you wrote:
s> pls. help me , how to update 2 tables like this sql
s> update table1 set table1.fld2 = table1.fld2 where table1.fld1 = table2.fld1
MySQL doesn't currently support multi-table UPDATE statement. It is in
our plans to support this in fut
amol,
Friday, March 08, 2002, 9:53:04 AM, you wrote:
as> I am very much new to mysql. We have installed it in machine but I
as> don't know how to start it and what's it's default user to connect. I
as> am still stuck at $ prompt..entering command
It is covered in the manual, please check the
Alex,
Thursday, March 07, 2002, 7:18:13 PM, you wrote:
AL> I have just installed MySQL recently. I already set the root password and
AL> some databases testing and everything worked fine. However, I accidentally
AL> changed the root to anonymous yesterday. After that, I couldn't add new
AL> user
savaidis,
Friday, March 08, 2002, 4:21:09 AM, you wrote:
s> Is MySQL a relational database?
s> If yes, how is implemented a "one to one" and "one to many" relation?
To define the relation between tables use foreign keys:
http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html
http://www
David,
Thursday, March 07, 2002, 7:22:49 PM, you wrote:
DMP> Is there a way for me to NOT have a default value for a column in a table
DMP> that I define as NOT NULL?
DMP> EXAMPLE SQL:
DMP> mysql> CREATE TABLE FOO (foo1 int NOT NULL);
DMP> Query OK, 0 rows affected (0.05 sec)
DMP> mysql> DESCR
Hi
> If I'd like to upgrade LH 6.2 to LH 7.0+. Would my
> old data (LH setting, MySQL db) lost?
No, but it is mandatory to make a backup (you
should do on a regular basis even for a normal
use, and obviously you MUST do it before a major
upgrade - dump your databases and tar your /etc
dir, al
hi
pls. help me , how to update 2 tables like this sql
update table1 set table1.fld2 = table1.fld2 where table1.fld1 = table2.fld1
senthil.r
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Is MySQL a relational database?
If yes, how is implemented a "one to one" and "one to many" relation?
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
99 matches
Mail list logo
