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
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:
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
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:
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
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
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
Beschreibung.
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:
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
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 |
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
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,
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
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
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
-
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 database,
is
- 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 comprehensive user
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!
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,
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:
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]
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 [EMAIL
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
-
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
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 Rasmussen
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
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
./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 returned 1
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: [EMAIL
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
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 with
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:
-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
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
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 password
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
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
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
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.
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:
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
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.
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
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
- Original
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
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
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 PROTECTED];
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
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
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
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
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
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
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
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 functions
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
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
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
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
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 [CHILDREN] LIKE
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
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
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
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
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
mysql:ÄúºÃ!
ÇëÔÊÐíÎÒÏòÄú½éÉÜ´ó·ͨϵÁÐÍøÂçÓªÏúÈí¼þ¡£
ÉÌÕ½²Ð¿á£¬ËÓ®µÃ¸ü¶à¿Í»§Ë¾ÍÓÐÁËÉú´æµÄȨÀû£¬µ«ÄúµÄ¿Í»§ÔÚÄÄÀïÄØ£¿Ñ°ÕÒÄúµÄ¿Í»§ÊÇÃæÁÙÉú´æµÄµÚÒ»²½¡£
ÏÖÔÚÓµÓдó·ͨϵÁÐÓªÏúÈí¼þÒ»ÇбäµÃ¼òµ¥£¬Ö»ÐèÄúÌîÉÏËùÐèÒª¿Í»§µÄÃû³ÆÈçóÒ×¹«Ë¾»¯¹¤ÆóÒµÂÃÓÎÒµ±±¾©
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
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
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
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
70 matches
Mail list logo