Sorry, let me try and explain a bit better:
Table:
Field1 Field2 Field3
annetypist good
betty reception fair
sandy typist excellent
elise pa bad
danareception excellent
cindy
Hello,
I want to delete the duplicate email addresses from a single table, called contact,
containing the field called yemail datatype varchar. What is the best way to remove
this data when copying the table. The original table had no unique index requirements,
but now I want the new table to h
Is there a way to specify that the files in /usr/local/mysql/data should be
written to /var/lib/mysql instead when installing from a tarball?(I have
these files from a previous installation there and am upgrading)
I use 4.0.3
Thanks,
S.Alexiou
---
Benjamin Pflugmann wrote:
>
> Hello.
>
> On Wed 2002-09-11 at 12:48:02 -0400, [EMAIL PROTECTED] wrote:
> > Is there a MySQL command that will return the amount of disk space used
> > by a particular database? I find lots of references to size limits on
> > tables / databases etc. but nothing on
Hello.
On Wed 2002-09-11 at 12:48:02 -0400, [EMAIL PROTECTED] wrote:
> Is there a MySQL command that will return the amount of disk space used
> by a particular database? I find lots of references to size limits on
> tables / databases etc. but nothing on the actual 'disk usage'.
You can use
Point taken..., maybe because, err..., uh, nobody told me not to?
Yeah, that's it, that's the ticket. Well, now I know. Much kudos to
you and yours.
Anyway, here's what I did in case others need explicit guidance.
Installation (Souce tarball only):
- cd to the directory that you want to
On Thursday, September 12, 2002, at 09:58 PM, Clayburn W. Juniel, III
wrote:
>
> On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote:
>
>> hi all,
>>
>> i am running OS X 10.2 and
>> this version of mysql:
>>
>> mysql> status
>> --
>> ./bin/mysql Ver 11.18 Distrib 3.
Mark,
Mark Matthews wrote:
> Richard S. Huntrods wrote:
>
>> I have been running MySQL on a W2K platform for over a year now. The
>> system is normally accessed through servlets, using the "mm" jdbc
>> driver.
>>
>> I have a number of standalone java programs that also access the
>> database
On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote:
> hi all,
>
> i am running OS X 10.2 and
> this version of mysql:
>
> mysql> status
> --
> ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
>
> Connection id: 117
> Current database:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On September 10, 2002 23:25, Zak Greant wrote:
> On September 10, 2002 22:32, Paul DuBois wrote:
> ...
>
> > You can't refer to aliases in WHERE clauses. Aliases refer to columns
> > that have been selected, WHERE clauses determine which columns sho
Richard S. Huntrods wrote:
> I have been running MySQL on a W2K platform for over a year now. The
> system is normally accessed through servlets, using the "mm" jdbc driver.
>
> I have a number of standalone java programs that also access the
> database using the "mm" driver. These have alway
Which C compiler version are you using?
> -Original Message-
> From: Bhanu Prasad Rekapalli [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, September 13, 2002 2:23 AM
> To: [EMAIL PROTECTED]
> Subject: Problem with installation of mysql 3.23.52 on solaris 9
>
> Hi,
> The error is as foll
Alex Waltrip wrote:
> make[1]: Entering directory
> `/home/alex/work/apps/pocket-web-apps/install-platform/mysql-3.23.52/mysql-test'
> ...snip...
> mkdir -p /home/alex/work/apps/pocket-web-apps/install-platform/mysql-3.23.52
> - cd /home/alex/work/apps/pocket-web-apps/install-platform/mysql-3
At 12:16 +1000 9/13/02, Campbell McLeay wrote:
>Hi,
>
>I was wondering whether if anyone knew the method by which
>data can be extracted from a backup of a mysql data directory
>done with tar. The files I currently have are a copy of the
>whole mysql directory tree (done with tar). What I want to
Hi,
I was wondering whether if anyone knew the method by which
data can be extracted from a backup of a mysql data directory
done with tar. The files I currently have are a copy of the
whole mysql directory tree (done with tar). What I want to do
is somehow extract the information from these file
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: alex
To: [EMAIL PROTECTED]
Subject: Getting 'are the same file' both sql-bench and mysql-test targets.
>Description:
Hello,
At 12:59 +0300 9/12/02, Fam. Tarniceru wrote:
>Dear Sirs,
>
>How can I handle with this situation?
>I need a special column in a SELECT statement - with LIMIT clause -, that
>can index my rows from 1 upward in the result set, and I don't know how to
>make it in MySQL. It is known that Oracle have
At 10:54 +1000 9/13/02, Richard Pfeil wrote:
>Hi,
>
>I am new to MySQL and am in the process of installing 3.23.52 on Red Hat
>Linux 7.3. The installation appears to have been successful but the post
>installation section of the documentation refers to mysqladmin which appears
>to be absent.
The
I have been running MySQL on a W2K platform for over a year now. The
system is normally accessed through servlets, using the "mm" jdbc driver.
I have a number of standalone java programs that also access the
database using the "mm" driver. These have always worked quite well,
until today.
One
Pada Thu, 12 Sep 2002 22:22:24 +
"Inandjo Taurel" <[EMAIL PROTECTED]> menulis :
> sqlsqlsqlsqlsqlsqlsqlsqlsql
>
>
> hi ,
>
> I've been having a constant nightmare for the past 2 weeks: a particular
> table gets corrupted every at least twice.
> Am using the 3.23.49 windows version and Myis
Awal dari pesan yang diforwardkan :
Tanggal: Thu, 12 Sep 2002 15:44:13 +0200
Dari: hans schneidhofer <[EMAIL PROTECTED]>
Untuk: [EMAIL PROTECTED]
hi list,
have got an error in trying to install MySQL-bench-3.23.52-1
rpm says, that the file MySQL-DBI-perl-bin is reqired, but
MySQL-DBI-perl-bi
Hi,
I am new to MySQL and am in the process of installing 3.23.52 on Red Hat
Linux 7.3. The installation appears to have been successful but the post
installation section of the documentation refers to mysqladmin which appears
to be absent.
Is mysqladmin supposed to be present in a Linux instal
At 0:47 -0500 9/13/02, [EMAIL PROTECTED] wrote:
> > > 2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory
>> > PREFIX. MySQL would then assign values that start with the prefix,
>> > followed by a sequential number.
>>
>> This works already for MyISAM and BDB tables. From the man
>FYI -
>Be careful using dbh->quote with inserts and updates. If you feed dbh->quote a
>variable that has
>no value, it will return '' (tick tick). If the column is a date the
>value will
>be set to -00-00 and
>if the column is numeric it will be set to 0 instead of NULL . You can either
>ch
I have been running MySQL on a W2K platform for over a year now. The
system is normally accessed through servlets, using the "mm" jdbc driver.
I have a number of standalone java programs that also access the
database using the "mm" driver. These have always worked quite well,
until today.
O
> > 2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory
> > PREFIX. MySQL would then assign values that start with the prefix,
> > followed by a sequential number.
>
> This works already for MyISAM and BDB tables. From the manual:
>
> CREATE TABLE animals (
> grp ENUM('f
At 16:21 -0400 9/12/02, Edward Peloke wrote:
>Forgive me for getting off topic but I am thinking of buying a new laptop.
>Which brands do you all trust? I don't have much to spend at all. I am
>leaning towards a compaq since they are offering an upgrade to xp pro for
>free (which I will need) an
I would write this in this way:
select * from table where (field = "x" and ($field = "y" or field = "z"))
or (field = "x" and (field = "a" or field = "b" or field = "c"));
assuming that you want a record with "x" in field having either
y or z in field or a or b o c in field
HATH
-Original
sqlsqlsqlsqlsqlsqlsqlsqlsql
hi ,
I've been having a constant nightmare for the past 2 weeks: a particular
table gets corrupted every at least twice.
Am using the 3.23.49 windows version and Myisam table types on Win2k, and
the operation crashing the database seems to be an update.
I get an erro
On 12 Sep 2002, at 23:48, Petre Agenbag wrote:
> select * from table where field1 = "x" and ((field2 = "y" or field2 =
> "z") or (field3 = "a" or field3 = "b" or field3 = "c"));
>
> But this syntax is not returning what I expect.
The syntax looks fine (though the inner sets of parentheses aren'
Hi
I would like to issue a logical query as follow:
select * from table where field1 = "x" and ((field2 = "y" or field2 =
"z") or (field3 = "a" or field3 = "b" or field3 = "c"));
But this syntax is not returning what I expect.
Plz help me with syntax
---
At 14:37 -0700 9/12/02, Norris, Joseph wrote:
>-Original Message-
>From: Norris, Joseph
>Sent: Thursday, September 12, 2002 12:39 PM
>To: Mysql_List (E-mail)
>Subject: questions about IF(expr1,expr2,expr3)
>
>
>Hello,
>
>Can any one give me some examples of how they have used this function
..If(qualify = true,'Qualified','Not Qualified') as Whatever ...
-=Bryan=-
> -Original Message-
> From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 2:37 PM
> To: Mysql_List (E-mail)
> Subject: FW: questions about IF(expr1,expr2,expr3)
>
>
>
>
> ---
-Original Message-
From: Norris, Joseph
Sent: Thursday, September 12, 2002 12:39 PM
To: Mysql_List (E-mail)
Subject: questions about IF(expr1,expr2,expr3)
Hello,
Can any one give me some examples of how they have used this function in a
practical way? I would like to get a better un
"Peter Goggin" <[EMAIL PROTECTED]> writes:
> So far as I can tell the mysql files included in the CD set are:
> mysql-3.23.49-3.i386.rpm
> mysqlclient9-3.23.22-6.i386.rpm
> mysql-devil-3.23.49-3.i386.rpm
> mysql-server-3.23.49-3.i386.rpm
>
> Do these files include Innodb support?
Yes.
> Are th
Viewing the /var/log/system.log file, it only shows that the command executed;
CRON[699]: (root) CMD (/agate/import_agate)
Is there a way to get a more detailed log of what cron is doing?
> --
> From: walt
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, September 12,
"Warren, Keith" wrote:
> I've created a mysql database solutions that works perfectly in Mac OS X 10.1.4.
>However, I've purchased a new G4 running 10.1.2 (Jaguar) and I'm having one problem.
>
> I need to update the database every 5 minutes with sports scores that are exported
>from another sy
On Thursday, September 12, 2002, at 05:03 PM, Brent Baisley wrote:
> While OSX is slower than I would like it to be on a 333Mhz G3, it's
> very workable.
What version of OS X are you running? Jaguar (10.2.0) is noticeably
faster. You can do an upgrade, but a fresh install is better.
> The
Could you pls send me answer of my question
1.How to convert this "10-Sep-2003" in a -MM-DD sql format effeciently.Like it
should be 2003-09-10.
Thanks,
Abhi
-
Before posting, please check:
http://www.mysql.co
Gerald Clark wrote:
> in perl you would do
> my $qselcat=$dbh->quote($selcat);
> $whichpart = "AND key1=$qselcat";
>
> René Fournier wrote:
>
> > Hello everyone,
> >
> > I'm trying to Select on a field that contains a doublequote, and can't
> > figure out how to pass it throught the Select statem
Hi,
The error is as follows
sql_lex.cc: In function `void lex_init()':
sql_lex.cc:84: `symbols' undeclared (first use this function)
sql_lex.cc:84: (Each undeclared identifier is reported only once for each
function it appears in.)
sql_lex.cc:86: `sql_functions' undeclared (first use this fun
I guess I'm a switcher.
I've had my iBook for almost a year (running OSX, now 10.2), and just
absolutely love it. For the web development I do (MySQL, PHP, Apache),
it's just great.
...Rene
On Thursday, September 12, 2002, at 02:44 PM, Christian J Hedemark
wrote:
> Apple. I spent the extr
Soheil Shaghaghi wrote:
> Hello everyone,
> I have my MySQL database n the var partition of a FreeBSD server.
> The problem is that the partition is almost full, and now I can't start the
> SQL server!
>
> I am thinking of moving the MySQL data directory to another partition, but I
> don't know h
Apple. I spent the extra $$ for a Titanium PowerBook G4 800MHz but you
don't need to spend that much for stellar performance.
For about a grand you can get the iBook which runs OS X (a BSD-flavored
UNIX), it comes with PHP and Apache already installed, and there is an
easily installed binary
in perl you would do
my $qselcat=$dbh->quote($selcat);
$whichpart = "AND key1=$qselcat";
René Fournier wrote:
> Hello everyone,
>
> I'm trying to Select on a field that contains a doublequote, and can't
> figure out how to pass it throught the Select statement (couldn't find
> anything in the
Forgive me for getting off topic but I am thinking of buying a new laptop.
Which brands do you all trust? I don't have much to spend at all. I am
leaning towards a compaq since they are offering an upgrade to xp pro for
free (which I will need) and a free wireless card. I am looking for a
decen
Hello everyone,
I'm trying to Select on a field that contains a doublequote, and can't
figure out how to pass it throught the Select statement (couldn't find
anything in the docs either...)
-=-=-=-=-
This doesn't work...
$whichpart = "AND key1='$selcat'";
$result = mysql_query("SELECT * FROM
Forgive me for getting off topic but I am thinking of buying a new laptop.
Which brands do you all trust? I don't have much to spend at all. I am
leaning towards a compaq since they are offering an upgrade to xp pro for
free (which I will need) and a free wireless card. I am looking for a
dece
I'd use the InnoDB table type and establish a primary key/foreign key
relationship (parent-child) between the two. That way referential integrity
will be done for you by the database.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Chris Burger [mailto:[EMAIL PROTECTED]]
Sent:
I've created a mysql database solutions that works perfectly in Mac OS X 10.1.4.
However, I've purchased a new G4 running 10.1.2 (Jaguar) and I'm having one problem.
I need to update the database every 5 minutes with sports scores that are exported
from another system. I'm using the mysqlimport
I have I hope a simple query question.
I have two tables
1 One has customer id and a store id and transaction information
2 Second has a store id and store information
There is multiple transactions in the first table, however there is
only one record for each store id in the second t
Richard,
- Original Message -
From: ""González Fernández, Richard"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 12, 2002 2:33 PM
Subject: HP-UX problem
> Hi to all,
>
> I just downloaded MySQL 3.23.52 for HP-UX, but I´m having some problems.
Once ins
Have tried compiling 3.23.51 with gcc 2.95.2 on both solaris x86
2.7 and
solaris sparc 2.7. on both systems configure is fine (using
both my own
configuration and that recommended in your README for solaris
2.7) but
when compiling sql_lex.cc compilation fails when
At 12:15 -0700 9/12/02, PR wrote:
>I noticed in the changelog for mysql 4.0.2 that it now
>
>Use index for ORDER BY in queries of type: SELECT * FROM t WHERE
>key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC
>
>Very cool, I need this. Question though, when creating indexes, do we need
>to someh
I noticed in the changelog for mysql 4.0.2 that it now
Use index for ORDER BY in queries of type: SELECT * FROM t WHERE
key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC
Very cool, I need this. Question though, when creating indexes, do we need
to somehow specify desc in the index or does my
THANKS!!
that works!
- hcir
> I have had luck by removing the word LOCAL from the statement.
>
> -=Bryan=-
>>
>> from the mysql command line, load data local infile DOES
>> work, am trying to get this to work from Perl
>>
>> $sth = $dbh->prepare("load data local infile
>> '/users/hcir/desktop
In the last episode (Sep 12), compo guy said:
> What is the difference between the following sql queries written to
> extract tuples with the field amount having non null value:
> select loan_number from loan where amount <> null (It returns
> an empty set)
> select loan_number from loa
On Thu, Sep 12, 2002 at 11:46:40AM -0700, Kip Krueger wrote:
>
> I need to query a mysql db in the following fashion ...
>
> "find me all records whose column 'n' have the letters 'XY' as the first two
> characters." where column 'n' is just a short string
>
> to clarify ...
>
> if column 'n'
Try leaving out the word local. This corrected the same problem on XP Prof.
BobJ
- Original Message -
From: "nellA hciR" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, September 12, 2002 2:32 PM
Subject: load data local infile
> i have read several archives/doc
I need to query a mysql db in the following fashion ...
"find me all records whose column 'n' have the letters 'XY' as the first two
characters." where column 'n' is just a short string
to clarify ...
if column 'n' has the value "YR12345" don't get that record.
if column 'n' has the value "XY
I have had luck by removing the word LOCAL from the statement.
-=Bryan=-
> -Original Message-
> From: nellA hciR [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 11:33 AM
> To: MySQL List
> Subject: load data local infile
>
>
> i have read several archives/docs on this
mysql
All:
Here is a snippet I am using in a Select Statement using VB with ADO
... Entry_Date, CONCAT_WS( ' -
',Employee_Number,CONCAT_WS(',',last_name,first_name))
AS Employee,Cat_Description,Stat_hours,If(EXCLUDE_FTEX = 'FALSE',
'YES','') ..
It works fine when run from the comma
i have read several archives/docs on this but still can not get this to
work
from the mysql command line, load data local infile DOES work,
am trying to get this to work from Perl
$sth = $dbh->prepare("load data local infile
'/users/hcir/desktop/t2/0001' into table s0001");
$sth->execute() or
Hello,
First shutdown mysql. The move or copy databses to new directory.
Restart server using --datadir=/my/path/for/data or place info in
my.cnf file. (See examples provided with MySQL code).
Ken
- Original Message -
From: "Soheil Shaghaghi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
http://www.mysql.com/documentation/mysql/full/manual_toc.html#Working_with_NULL
On 12 Sep 2002, compo guy wrote:
> What is the difference between the following sql queries written
> to
> >extract tuples with the field amount having non null value:
> > select loan_number from loan where
>Description:
After downloading and installing MySQL 4.0.3, I've downloaded and installed Apache,
mod_ssl and PHP, all latest versions. I particularly made sure that PHP is linked
against MySQL's new libraries in order to use the new structures.
Then I set up php.ini file and httpd.conf. I also
Hello everyone,
I have my MySQL database n the var partition of a FreeBSD server.
The problem is that the partition is almost full, and now I can't start the
SQL server!
I am thinking of moving the MySQL data directory to another partition, but I
don't know how I should do this.
Can anyone please
What is the difference between the following sql queries written
to
>extract tuples with the field amount having non null value:
> select loan_number from loan where amount <> null (It
>returns
>an empty set)
> select loan_number from loan where amount is not null(It
>returns the exp
> I want to have manual startup/shutdown but still am not sure of the
> appropriate way to do this.
Change the startup type from "Automatic" to "Manual".
> The "Computer Management" utility allows me to stop the service and/or
> change the service startup type to manual or "disabled." Is "disabl
philipp,
Wednesday, September 11, 2002, 8:10:04 PM, you wrote:
pr> i am running OS X 10.2 and
pr> this version of mysql:
pr> mysql> status
pr> --
pr> ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
pr> my problem is the following:
pr> let's say i want to add t
Andreas,
Thursday, September 12, 2002, 3:56:58 PM, you wrote:
AM> After a query
AM> SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
AM> ENCLOSED BY '"' FROM testtable
AM> the following error occurs:
AM> Error writing file 'test.csv' (Errcode: 28)
AM> The file was written pa
perror 28
Error code 28: No space left on device
Andreas Metzner wrote:
>Hi All,
>
>After a query
>SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
>ENCLOSED BY '"' FROM testtable
>
>the following error occurs:
>Error writing file 'test.csv' (Errcode: 28)
>
>The file was w
On 12/9/02 13:03, "philipp ringli" <[EMAIL PROTECTED]> wrote:
> hi all,
>
> i am running OS X 10.2 and
> this version of mysql:
>
> mysql> status
> --
> ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
[...]
> my problem is the following:
>
> let's say i want
I just finished installing RedHat 7.3 on two computers. One a server install, the
other a laptop install.
I proceeded at that point to install MySQL 3.23.52( the RPMs from www.mysql.com) on
both.
MySQL had been started on both after the install (which is pretty normal).
I rebooted both, MySQL s
Hi
I have MySQL (version 3.23.38) installed on Win 98 running locally as
mysqld-opt which I am calling from a Java app using the mm.mysql-2.0.4 JDBC
driver. I've also tried the new Connector/J but the same problem exists.
When I try to have more than 30 or so open connections at a time from the
Hi All,
After a query
SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' FROM testtable
the following error occurs:
Error writing file 'test.csv' (Errcode: 28)
The file was written partially indeed, but not including all records
matching the query.
Help would
Hello list!
I would like to propose a feature for MySQL that would solve the
multiple master replication problem.
Unless I miss some important information, there is currently a
limitation to the use of master-master replication which concerns
AUTO_INCREMENT columns (which are usually used as PRI
Hi All,
After a query
SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' FROM testtable
the following error occurs:
Error writing file 'test.csv' (Errcode: 28)
The file was written partially indeed, but not including all records
matching the query.
Help would
hi all,
i am running OS X 10.2 and
this version of mysql:
mysql> status
--
./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
Connection id: 117
Current database: mysql
Current user: root@localhost
Current pager: stdout
Using outf
How can i change the floating point '.' to ',' as a
decimal separator in MySQL 3.23... in Linux RH 7.2?
Nikos
-
sql, query
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&e
If you set it to 'Manual', then you should be able to start/stop the service
with the appropriate NET START/STOP MYSQL command.
- Original Message -
From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
To: "Gerald R. Jensen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
"Ed Carp" <[EMAIL PROTECTED]>;
Hi to all,
I just downloaded MySQL 3.23.52 for HP-UX, but I´m having some problems. Once
installed, when I try to start the daemon, I get the following error on the data
directory (*.err):
020912 13:14:51 mysqld started
/usr/lib/dld.sl: Can't open shared library:
/my/gnu/lib/gcc-lib/hppa1.1-
Using WinXP Home's "Computer Management" utility (which you get via:
Start / Settings / Control Panel / Administrative Tools / Computer
Management),
I can see, under
"Services and Applications" / Services,
that MySQL's "startup type" is "Automatic". I didn't set this so apparently
this is what
>Description:
Server hang when trying to test field=AES_DECRYPT(filed, key)
in case when filed contain garbage.
>How-To-Repeat:
CREATE TABLE atest(
id int(11) NOT NULL auto_increment,
tmp text NOT NULL,
KEY id (id)
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
Thomas,
Thursday, September 12, 2002, 9:58:00 AM, you wrote:
TW> I've a very dirty bug costing me hours uptill now; maybe it is related
TW> with the AND/OR-behavior described in the releasenote of 3.23.52/53;
TW> A query once runs with release 3.23.53 (my own PC); same query don't
TW> work with
Peter,
Thursday, September 12, 2002, 3:35:26 AM, you wrote:
PG> So far as I can tell the mysql files included in the CD set are:
PG> mysql-3.23.49-3.i386.rpm
PG> mysqlclient9-3.23.22-6.i386.rpm
PG> mysql-devil-3.23.49-3.i386.rpm
PG> mysql-server-3.23.49-3.i386.rpm
PG> Do these files include Inno
Peter,
Thursday, September 12, 2002, 3:35:26 AM, you wrote:
PG> So far as I can tell the mysql files included in the CD set are:
PG> mysql-3.23.49-3.i386.rpm
PG> mysqlclient9-3.23.22-6.i386.rpm
PG> mysql-devil-3.23.49-3.i386.rpm
PG> mysql-server-3.23.49-3.i386.rpm
PG> Do these files include Inno
Hi All,
SciBit would like to announce the latest release of Mascon for Linux 0.03.
For those interested please check:
http://www.scibit.com/Products/Software/Mascon4Linux
Kind Regards
SciBit MySQL Team
http://www.scibit.com
---
You can try this:
set @index = 0;
select @index:=@index+1 'index', myfield from mytable limit 100
Danilo
Happy MySQL user
-Messaggio originale-
Da: Fam. Tarniceru [mailto:[EMAIL PROTECTED]]
Inviato: giovedì 12 settembre 2002 11.59
A: MySQL Mailing List
Oggetto: Indexing Column for a
You can use the auto increment column. However, you have to add it to
the table.
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-AUTO_INCREMENT
On Thu, 12 Sep 2002, Fam. Tarniceru wrote:
> Dear Sirs,
>
> How can I handle with this situation?
> I need a speci
Dear Sirs,
How can I handle with this situation?
I need a special column in a SELECT statement - with LIMIT clause -, that
can index my rows from 1 upward in the result set, and I don't know how to
make it in MySQL. It is known that Oracle have a special function (RowNum)
for this problem.
Best
1. IN 4.0.3 I CREATE 3 USERS using 3 different clients and get
slightly different results when I then run
SHOW GRANTS FOR XXX;
The user created by MySQL Front has a slightly different set of
privileges even though the GRANT displayed by MyS
Hi,
I am developing a web-based application using java + tomcat + mysql in Win
2000.
When the application is running,I try to view the processlist in MS-DOS
using the commad "show processlist".
mysql> show processlist;
+--+--+-++-+
94 matches
Mail list logo
