I am having trouble compiling a custom mysqld (version 4.0.10) under Red
Hat 8.0 - I did email this list a few weeks ago and I have tried a few
things since then but I am asking again in the hope that someone more
knowledgeable might be able to help.
As far as I can tell this is a compiling or lin
query database
On Fri, Feb 14, 2003 at 11:17:22AM +1100, Daniel Kasak wrote:
> You have to use the visual basic constant: vbCrLf
Or vbNewLine.
Bob Hall
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
I need to delete duplicate rows. Each row that is in the table has an
exact duplicate of itself. There are four columns. No one column could be
defined as a primary key; however, two columns together could. What's
going to be the best way to do this?
Thanks.
Lewis
mysql, thanks
-
Hello
When I use the Alter table structure command to alter any field, it comes
up with an error
stating that Error number 7 - error in renaming of table "table name.myi" to
"sql-208..." and so on with (Errorcode 13). Thus I am unable to change the
structure of any table.
I am using MySQL ver 3.
mysql:ÄúºÃ!
ÇëÔÊÐíÎÒÏòÄú½éÉÜ´ó·ͨϵÁÐÍøÂçÓªÏúÈí¼þ¡£
ÉÌÕ½²Ð¿á£¬ËÓ®µÃ¸ü¶à¿Í»§Ë¾ÍÓÐÁËÉú´æµÄȨÀû£¬µ«ÄúµÄ¿Í»§ÔÚÄÄÀïÄØ£¿Ñ°ÕÒÄúµÄ¿Í»§ÊÇÃæÁÙÉú´æµÄµÚÒ»²½¡£
ÏÖÔÚÓµÓдó·ͨϵÁÐÓªÏúÈí¼þÒ»ÇбäµÃ¼òµ¥£¬Ö»ÐèÄúÌîÉÏËùÐèÒª¿Í»§µÄÃû³ÆÈç"óÒ×¹«Ë¾""»¯¹¤ÆóÒµ""ÂÃÓÎÒµ""±±¾©
µØÇøÍâó½ø³ö¿Ú¹«Ë¾"µÈµÈ..¿É¸ù¾ÝÐèÒ
I posted this to the win32 list and didn't get a response yet. Hopefully
someone can help me.
Config information:
Hardware: P3-500
Software:
Windows 98
cygwin / bash 2.05b.0(8)-release (i686-pc-cygwin)
g++ using gcc version 3.2 20020927
mysql 3.23.55-max-debug for Win32/Win98 on i32 (executa
I came to the same conclusion today after reading the docs again. I would
prefer the des_encode if I need to get things back out of it, but since I'm
running 3.23.55, the des_encode function is not available to me. I have a
need to encrypt data and then retrieve it later (credit card data). I
Hi,
I have an idea to reduce the interdependencies between my various databases as far as
one database needing to be down for
maintenance is affecting other databases on the same server.
If I run one mysqld instance for all the databases on a server (the standard setup),
all the databases become
I've gone over 60 million (per table and there are 4 of them) , had the
indexes sorted and it was a fast machine.
4 reference tables (foreign keys) then a counter which made a massive hash.
I'm starting to run into system and hard ware problems, more like open
files/inodes/through put, opposed to
Hi,
I have a question about using myisamchk and mysqlchk.
I am running myisamchk -s on a certain table and get this error:
/usr/local/mysql/bin/myisamchk: MyISAM file /usr/local/mysql/var/db1/my_table.MYI
/usr/local/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed the table
prope
Hi
Im using MYSQL and ASP
Im trying to implement a Search cross ALL 40 Fields in the table I have
tried lines like
b_search = b_search & "[AGENOTES] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[MARITALSTATUS] LIKE '%" & pSearch & "%'
OR "
b_search = b_search & "[C
At 0:44 +0100 2/15/03, Jose Luis Pérez wrote:
We have developed an application with Visual Basic 6 managing through
myoledb some mysql server tables.
Perhaps it´s basic, but we have seen that the client application runs much
more slower in a point separated
through 2 routers and with 2 Mbps circu
>
> We have developed an application with Visual Basic 6 managing through
> myoledb some mysql server tables.
>
> Perhaps it´s basic, but we have seen that the client application runs
> much more slower in a point separated
> through 2 routers and with 2 Mbps circuits than in the vlan where the
> m
We have developed an application with Visual Basic 6 managing through
myoledb some mysql server tables.
Perhaps it´s basic, but we have seen that the client application runs much
more slower in a point separated
through 2 routers and with 2 Mbps circuits than in the vlan where the mysql
server is
Hello,
We are running MySQL server Ver 3.23.8 on a Linux system.
We have a table that contains a field whose type is
MODIFIED | timestamp(14)
We would like to find out if there an easy way in MySQL to convert
the date that is on the MODIFIED field (timestamp)
to GMT time without an external prog
On Fri, Feb 14, 2003 at 01:04:00PM -0500, Luc Foisy wrote:
> I didn't say it had nothing to do with the data, I said it had
> nothing to do with the data in the database. The data in the
> recordset returned from the database referenced by row is important.
[...]
> 1. There are a lot of function
Jerry,
> Any one gone over 1000 million rows ? or any where near ?
I saw something like 4 terabytes of data in a table on this list.
Maybe I was too tired by the time I read this, or even asleep already.
As MySQL doesn't impose limits to the table size, you're in for a
fight with file size limi
RBE,
> I just got a copy of MySql and am trying both SqlGui and MySqlcc. In
> desperation, I also tried the command line. When I finally got it
> started, it fails to connect, refuses every password and I find I am
> unable to set a user and a password.
It bit more information could help to t
At 16:53 -0600 2/14/03, Webmaster MBT wrote:
Haven't been able to identify it yet... I'm attaching the file so maybe
someone can help me with this.
Well, it's your data file. You should know what the line terminators are.
BTW, how do I tell the command what is the ending symbol?
Add a LINE
The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?
This is typically a problem of not having the line-ending terminator
specified
Hi List.
I have been working on a problem that is driving me crazy.
I have to create a process in which I upload some info to a table. Since I
have to add some different information to that table, I decided to do it
like this.
1.I create a temporary table copying the structure of my final table.
I grabbed MySQL-3.23.55-1.src.rpm to build on my box, due to all the
problems I'm seeing with the RPMs from mysql.com But *that* isn't
working, either...
+ automake
configure.in:7: your implementation of AM_INIT_AUTOMAKE comes from an
configure.in:7: old Automake version. You should recreate acl
thanks for the thoughts guys...we've already taken steps to validate on the client
side. I just never knew about this aspect of date columns and it struck me as odd that
a database would allow invalid data to go in...interesting feature. Personally I place
a higher premium on data integrity over
I'm with you for sure...client processing is the way to go...fat servers
suck.
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROT
At 16:55 -0500 2/14/03, Peter Grigor wrote:
Yep, you're right. Never noticed that before :)
I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.
It can be argued either way. You could just as well consider it a
bug that you try to
hello,
does anyone know of a good mysql-matlab release 13 interface? the
standard database connection capability within matlab is a really poor
implementation based on JDBC. JDBC is fine, but not how the matlab
people use it.
thanks
jeff
--
Jeff Mathis, Ph.D. 505-995-1434
Yep, you're right. Never noticed that before :)
I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Origina
On 14 Feb 2003, at 16:43, Don Vu wrote:
> Is it just me, or does Mysql allow invalid dates to be entered into
> columns with date datatype?
See the documentation (http://www.mysql.com/doc/en/DATETIME.html):
The MySQL server only performs basic checking on the validity of
a date: days 00-
At 16:43 -0500 2/14/03, Don Vu wrote:
Is it just me, or does Mysql allow invalid dates to be entered into
columns with date datatype? I found some data that blew up in a perl
script when doing some date manipulation, and it turns out I have
invalid dates in my database, such as June 31, 2003. O
Is it just me, or does Mysql allow invalid dates to be entered into columns with date
datatype? I found some data that blew up in a perl script when doing some date
manipulation, and it turns out I have invalid dates in my database, such as June 31,
2003. Of course June never has 31 days.
Is th
Hi,
Any one gone over 1000 million rows ? or any where near ?
Pref. in ver 4+ with a MyISAM table.
Cheers
-
Jerry @
MetalCat.Net
-
SQL
-
Before posting, please check:
ht
I've narrowed it down a lot. We have two different PHP interfaces for the
database. One is for employees to access the data, and the other is for
customers. The UPDATEs and INSERTs on the system that customers use is not
being replicated, but the one that employees is working perfectly.
Th
Hi!
[skip]
> When running a query like:
> LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS
> TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'
> (list_id,email,f1,f2,f3)
[skip]
Thank you for your bugreport. Now bug is fixed, here is patch:
diff -Nrc a/sql/sql_load.cc
Hi ,
I have a problem with the mysql database restore. When I take a backup of
a database and try to restore it on a particular server(Production) , I
get the following error message.
ERROR 1005 at line 12: Can't create table
'./CloneTracking/HitPickFileMaster.frm' (errno: 150)
But the same work
Really, for non-administrative tasks, you should look at the two sections in
the manual that deal with data definition (create, drop, etc) and data
manipulation (insert, select, delete)...you're after the data definition
stuff.
Peter
<^_^>
-
Peter Grigor
On Fri, Feb 14, 2003 at 12:01:32PM -0600, RBE wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I just got a copy of MySql and am trying both SqlGui and MySqlcc. In
> desperation, I also tried the command line. When I finally got it
> started, it fails to connect, refuses every pass
>
> On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> > >That means no field exists or should exist in the
> database. I only want to
> > >generate at query time.
> > >I can't use an autoincrement field since that wont work
> very well with
> > >results that are returned out of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I just got a copy of MySql and am trying both SqlGui and MySqlcc. In
desperation, I also tried the command line. When I finally got it
started, it fails to connect, refuses every password and I find I am
unable to set a user and a password.
I ins
On Fri, Feb 14, 2003 at 05:01:01PM +0200, Egor Egorov wrote:
> On Friday 14 February 2003 01:06, John Oliver wrote:
>
> > I removed the Red Hat MySQL RPMs (which worked fine, other than not
> > supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When
> > I try to start it:
> >
> >
On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote:
> >That means no field exists or should exist in the database. I only want to
> >generate at query time.
> >I can't use an autoincrement field since that wont work very well with
> >results that are returned out of order and maybe not
Hi,
I have problems inserting records to a table with a date field. If I
do not include the field in the form, the record is inserted
succesfully with a default value for the date, but if I enter the date
from de form, I get an error from the application. As long as I know,
MySQL date format
You need the zlib library...that's where compress is defined.
It can be found at http://www.gzip.org
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "Ron Sorber" <[EMAIL PROTECTED]>
To: <[EMA
> ./libmysqlclient.a(my_compress.o): In function `my_uncompress':
>
> my_compress.o(.text+0xaa): undefined reference to `uncompress'
>
> ./libmysqlclient.a(my_compress.o): In function `my_compress_alloc':
>
> my_compress.o(.text+0x13c): undefined reference to `compress'
>
> collect2: ld retur
Using MySQL 4.0.10-0 on Redhat linux 7.3
./libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0xaa): undefined reference to `uncompress'
./libmysqlclient.a(my_compress.o): In function `my_compress_alloc':
my_compress.o(.text+0x13c): undefined reference to `compre
mmh, in the beginning i had never used any database except access (is
one? :-)), i learned rapidly by reading the docs - hope that will be
good for you too - because external howtos often come to an end sooner
than you want, the docs on the other hand will answer all your
questions. if not you
Hi,
I have had this type of problems. Under Oracle, the CONNECT BY statement was
done for such queries if I can remember. But I don't know if mysql can
handle this statement, or has an equivalent.
Erwan
- Original Message -
From: "Peter Grigor" <[EMAIL PROTECTED]>
To: "Lars Rasmus
I wanted to use the Views feature that is available in Oracle which is the
counterpart of Queries available in MS Access.
mySQL does not support views at the moment. Is there a way I can achieve my
goals ?
The purpose of having a view/query is that I want to access data from that
view/query throug
This probably isn't best handled by mysql...use associative arrays to store
members of members in the hierarchy, then print out the associative array's
contents in order.
Peter
<^_^>
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
- Orig
BTW, exactly how did you acquire, install and execute mysql without visiting
mysql.com?
:)
Peter
<^_^>
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL"
Hi Richard,
Do you think the following links may help? I got them from the online
manual:
[1] http://www.mysql.com/doc/en/CREATE_DATABASE.html
[2] http://www.mysql.com/doc/en/CREATE_TABLE.html
[3] http://www.mysql.com/doc/en/CREATE_FUNCTION.html
[4] http://www.mysq
On Friday 14 February 2003 17:57, Richard Nagle wrote:
> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensive user manual on how to,
> say in .pdf format out there ?
>
> if not, a on-line link maybe ?
Please, check the following link:
Richard,
what exactly do you mean?
guidelines to good database engineering? which data how an where to
store? intelligent table structures?
or technical instructions related to mysql? -> documentation, see
message attachment
cherio,
henning
Richard Nagle wrote, On 2/14/2003 4:57 PM:
Okay,
Its a lot easier asking people than trying to look for yourself isn't it?
Well, that is frowned uppon over here. You should ask us questions when
you have attempted to find the solution yourself first.
http://www.mysql.com
click on the documentation link on the header.
See, it wasn't so hard!
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 10:57 AM
Subject: New Database,
> Okay,
> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensi
Yes, there are, many :)
Jerry
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 3:57 PM
Subject: New Database,
> Okay,
> I have installed, mySQL, ( all is well )
> and now looking to build my first datab
Okay,
I have installed, mySQL, ( all is well )
and now looking to build my first database,
is there a comprehensive user manual on how to,
say in .pdf format out there ?
if not, a on-line link maybe ?
Thanks-
Richard
-
Before
On Friday 14 February 2003 01:06, John Oliver wrote:
> I removed the Red Hat MySQL RPMs (which worked fine, other than not
> supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When
> I try to start it:
>
> [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start
> [joliver
Hi,
There is problem with include files. include/raid.h is installed as for
example /usr/local/include/mysql/raid.h and it includes my_dir.h which
is not installed in /usr/local/include/mysql/ and thus is not usable.
This patch fixes that:
diff -urN mysql-4.0.10-gamma.org/include/Makefile.am
If your're using some other programming language to fetch the results,
maybe it should be better to do it with that language.
Otherwise, if you really need it to be in SQL you can, for example, use
variables like this:
SET @c:=0;
SELECT @c:=@c+1, Name, St, PNumber FROM TABLE;
On Fri, 2003-02-14
Hello
Query:
SELECT Name, St, PNumber
>From TABLE
WHERE St = FL
ORDER BY PNumber
Would like output to be:
1 Joe Jones 123-123-1234
2 Mary Adams 123-123-4567
3 Ted Smith 145-456-8974
etc
How can I generate a record number
SELECT recnu(), Name, St, PNumber ??
thanks
jrt
--
Hej all,
I have a really kinky mysql problem.
Well lets start,
I have a table that looks like this
++--+-+
| id|title |subid|
++--+-+
| 1| MAIN | 0 |
++--+-
Scott Wong writes:
> Hi sinisa,
>
> I tried this patch.
> It came up with undefined symbol for ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB on
>compile
> so i went ahead and added to include/mysqld_error.h for testing.
> i'm not sure if it's the right place or the right error code but it made mysql
Ingo,
> als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
> Beschreibung.
> Leider kann ich diese nicht in der Doku finden.
The list language is English. Anyway, here's what you're looking for.
English manual: http://www.mysql.com/doc/en/Column_types.html
German manual:
http:/
http://www.mysql.com/doc/en/Column_types.html
- Original Message -
From: "n etman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 9:13 AM
Subject: Datentypen
> Hallo Liste,
>
> als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
> Beschreibun
Paul,
Thanks for the explanation!
Best Regards,
Viktor Vasiliou
- Original Message -
From: Paul DuBois
To: Viktor Vasiliou ; [EMAIL PROTECTED]
Sent: Friday, February 14, 2003 12:05 AM
Subject: Re: Re: Strange sorting in table
At 0:01 +0100 2/14/03, Viktor Vasiliou wrote:
>Ok, I g
Hi,
I am wondering if the MySQL staff have been working on a way to
circumvent the current 2G ram usage limit for MySQL under LInux for
maybe the 5.0 release?
Did a list search but did not find a thread regarding this matter so I
want to get this question out of my system.
With the rising nee
Leider kann ich diese nicht in der Doku finden.
how in the world did you manage to miss that one?
http://www.mysql.com/doc/en/Column_types.html
Regards
Roland
-
Before posting, please check:
http://www.mysql.com/manual.php
Hello Ingo,
n etman wrote:
als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
Beschreibung.
this is an english list.
dies ist eine englischsprachige Liste.
--
Manuel Kiessling
-
Before posting, please check
Hallo Liste,
als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit
Beschreibung.
Leider kann ich diese nicht in der Doku finden.
Schon mal vielen Dank im vorraus.
Ingo Döring
-
Before posting, please check:
http:
When I faced the same problem, I was suggested to use MySQL Front. I have
(Bbeen also using phpMyAdmin.Both work fine.
(B
(BHope this will help u
(B
(Bregards
(B- Original Message -
(BFrom: "srinath sundarrajan" <[EMAIL PROTECTED]>
(BTo: <[EMAIL PROTECTED]>
(BSent: Friday, February
70 matches
Mail list logo
