Hi!
Am Di, den 15.03.2005 schrieb Heikki Tuuri um 8:21:
Douglas,
- Original Message -
From: Douglas B. Jones [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, March 14, 2005 11:19 PM
Subject: compilation problems with 4.1.10a on Tru64 5.1
[[...]]
It
Dear list,
I don't understand what happens here:
shell mysql -N -e SHOW VARIABLES LIKE 'version'; test
+-++
| version | 4.0.14-log |
+-++
shell mysql -e CREATE TABLE foo (sometext VARCHAR(255)); test
shell mysql -e INSERT INTO foo VALUES('Pitt\\'s
Hello.
Use such alter statement:
alter table mytable change a a int default '1';
Every thing works fine on the MySQL 5.0.3 (from the latest bk source):
mysql CREATE TABLE `mytable` (
-
- `a` int(11) NOT NULL,
-
- `b` int(11) NOT NULL,
-
- `c` int(11) default NULL
-
- )
Hello.
the following query causes the mysqld server to close
Yes. MySQL 5.0.2 not yet stable as we want. You may look
in the error log to find the clues of shutdowns. See:
http://dev.mysql.com/doc/mysql/en/error-log.html
But I recommend you to upgrade to the latest bk source, which
Hello.
still stop at the 10M limit on memory tables anyway.
What's the value of max_heap_table_size? See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[EMAIL PROTECTED] wrote:
Thanks that gives me options, yes table was already created what I wanted
was for
Hello.
050314 1:31:06 /usr/sbin/mysqld-max: Shutdown Complete
Your error file has this record. And you said that you'd installed
only:
- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm
There are no mysqld-max in listed rpms. I
Hello.
I think that the speed of every single update which
slave get from the master will grow, and slave could
receive updates more frequently. But only practical
usage will show the influence of this option in your
case.
Andrew Braithwaite [EMAIL PROTECTED] wrote:
Hi,
I can
Hello.
libtiff.so.3: cannot open shared object file: No such file or
directory
I think, you should get the version of library which mysql-query-browser
wants.
Billy Pilgrim [EMAIL PROTECTED] wrote:
Hello, I am trying to run mysql query browser on debian, but...
#
Hello.
Using the general-log you could find if something
changes the grant tables. See:
http://dev.mysql.com/doc/mysql/en/query-log.html
Also I strongly recommend you to upgrade to the latest
release, if you don't use it already.
so whats the final solution to my problem ? :(
Hello.
You may use --default-character-set=charset command line option
for mysqldump. Without this option mysqldump uses UTF8 encoding,
which can cause a problem.
See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Javier Ballesteros Correa [EMAIL PROTECTED] wrote:
Hi! I'm
Hello.
You may use --extend-check option with myisamchk, but
usually it finds a lot of garbage, and should be used as
a last resort.
Francisco Lopez [EMAIL PROTECTED] wrote:
Hello all,
I am getting quite desperate on this, since I've been trying to recover
my diary of a whole
Hello.
You should also redirect stderr to the output file. The way it's done
depends on the used shell. But usually you should use '2' instead of ''.
[EMAIL PROTECTED] wrote:
Hi,
Thank you for your reply. I tried even with --tee option with
mysql as follows
Mysql
Hi,
What do you think about MySQL vs PostgreSQL ?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perhaps a quick search at a list archive will give you the answers you
are looking for. This was discussed at length about 6 months ago and the
messages are still at gmane. Just page through and you will find many
messages with just this subject.
mos wrote:
I've tried just about every syntax combination to try and add columns to
a table using Alter Table and I keep running into syntax errors.
Alter table MyTable add (newcol1 float after col3, newcol2 float after
col3);
or
Alter table MyTable add (newcol1 float, newcol2 float) after
Hello Users
does anyone know a tool or a way for validation sqlcode on the
command_line???
For example
./sqlsyntaxchecker select * f test
-- Error not valid sql syntax
thx christian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
List,
I'm trying to create tables that will store data temporarily, if a php
page generates data to fill the table, then any number of queries could
be run on the table, and then be automatically be deleted if it's not
queries for let's say an hour or something like that.
Can this be
hi,
i am migrating a legacy java application. so i am not
suppose to change too much things.
the problem is that the app store in multiple language
such as korean and english.
if i load again the new saved data, then korean
language will only be like ',???'
old data are ok. displayed in
Ted Toporkov [EMAIL PROTECTED] wrote on 15/03/2005 11:04:09:
List,
I'm trying to create tables that will store data temporarily, if a php
page generates data to fill the table, then any number of queries could
be run on the table, and then be automatically be deleted if it's not
queries
in addition i also need to save and load korean,
simplified chinese, traditional chinese, japanese and
english in the same record.
have any suggestion ?
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Hi
i am searching the date of the end of support for the different versions
of mysql
where can i find them?
thx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
A TEMPORARY table is visible only to the current connection,
and is dropped automatically when the connection is closed.
So, I think, they won't solve your task.
Ted Toporkov [EMAIL PROTECTED] wrote:
List,
I'm trying to create tables that will store data temporarily, if a
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat
Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI.
Currently the table size is fixed 4GB and I want to extend it 10GB. Could you
please give me perfect command to extend my table size. The is my
Stembridge, Michael [EMAIL PROTECTED] wrote on 03/14/2005 02:18:25
PM:
I noticed another listmember used COUNT(fieldname) instead of COUNT(*).
Is there a noticeable performance increase with COUNTing a column name
instead of all columns? (ie, like SELECTing specific columns instead
of
Nick Zukin [EMAIL PROTECTED] wrote on 03/14/2005 05:22:38 PM:
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the
vendors
and the products. There is
Crouch, Luke H. [EMAIL PROTECTED] wrote on 03/14/2005 09:34:02
AM:
This error message seems a bit different than others I have gotten.
it is from a ColdFusion server that uses an ODBC driver...
ODBC Error Code = S1000 (General error)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost
this query is select * from ogcount which is a table containing 1 record, so
probably not the packet size, though that's very good info to know. I'm going
to see if I get the same error if I use a JDBC driver instead of ODBC.
-L
Luke Crouch
918-461-5326
[EMAIL PROTECTED]
-Original
Naveen C Joshi wrote:
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI.
These are MyIsam, not InnoDB.
Currently the table size is fixed 4GB and I want to extend it 10GB. Could you
please give me
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23? currently in the office). The RH9 comes with some 3.2.xx
version, I try to run rpm -U to upgrade but that doesnt work, I try to
install it doesnt work and I try to remove mysql that doesnt work
either. I went to Add and
On Tue, 15 Mar 2005 18:49:38 +0900
ninjajs [EMAIL PROTECTED] wrote:
What do you think about MySQL vs PostgreSQL ?
Both are great products and have their ups and downs. On a MySQL list
you will not get an un-biases answer to this question.
If you really want to know what people on the MySQL
Luke
- Original Message -
This error message seems a bit different than others I have gotten. it
is from a ColdFusion server that uses an ODBC driver...
ODBC Error Code = S1000 (General error)
Which version of CF are you using?
If it is MX6.1, surely you can use a native MySQL
I have a table containing three columns:
Int intint
++-++
| id | serialbegin | serialend |
++-++
| 1 | 10 | 20 |
++-++
And say we have serial number 11.
Is there a way to
[snip]
I have a table containing three columns:
Int intint
++-++
| id | serialbegin | serialend |
++-++
| 1 | 10 | 20 |
++-++
And say we have serial number 11.
Is there a way
-Original Message-
From: Richard Whitney [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 10:54 AM
To: Jay Blanchard
Subject: RE: SELECT assistance
Quoting Jay Blanchard [EMAIL PROTECTED]:
[snip]
I have a table containing three columns:
Int intint
David,
According to the documentation, OPTIMIZE will also work on InnoDB tables.
Will that produce the same result as your ALTER TABLE ?
Cheers
Terry
- Original Message -
Hi Chris,
For MyISAM/BDB tables use OPTIMIZE TABLE your table name;
For InnoDB tables try ALTER TABLE your
Dear All,
I am faced with the following problem: I have got three tables - book,author
and authorbook - containing information about books and authors (some books
have multiple authors). I want to do a query that would print information
like:
Title 1 Author 1
Author 2
Title 2
Xristos Karvouneas wrote:
Dear All,
I am faced with the following problem: I have got three tables -
book,author and authorbook - containing information about books and
authors (some books have multiple authors). I want to do a query that
would print information like:
Title 1 Author 1
Hi there!
I need to do this:
From this table
+--+
|id|Data |
|--|---|
| 1|Something 1|
| 2|Something 2|
| 3|Something 3|
| 4|Something 4|
| 5|Something 5|
| 6|Something 6|
+--+
Get this query
+-+
|id|Data |id|Data |
SELECT id, id FROM data should work just fine.
On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi there!
I need to do this:
From this table
+--+
|id|Data |
|--|---|
| 1|Something 1|
| 2|Something 2|
| 3|Something 3|
|
Oh, sorry, I didn't look close enough at your question...never mind :-)
On Tue, 15 Mar 2005 16:02:59 -0800, Scott Klarenbach
[EMAIL PROTECTED] wrote:
SELECT id, id FROM data should work just fine.
On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
Hi there!
SELECT (SELECT id from data WHERE id=1), (SELECT id from data WHERE id=4);
This willl return you the 2 columns in one row.
Otherwise, if you're looking to return multiple queries into one
result set, then UNION is what you're looking for. ie (select id from
data) UNION (select id from data).
On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] wrote:
I need to do this:
From this table
+--+
|id|Data |
|--|---|
| 1|Something 1|
| 2|Something 2|
| 3|Something 3|
| 4|Something 4|
| 5|Something 5|
| 6|Something 6|
+--+
Get this query
Hi there!
The SELECTs within the SELECT didn't work. : (
I'm looking to return from one table, half on the left side, and half on the
right side. This is: from row 1 to row n on the left, and from row n+1 to
the end on the right.
TIA
Mensaje citado por Scott Klarenbach [EMAIL PROTECTED]:
Hi list,
I've been using MySQL for small databases for 6 - 7 years (if I recall
correctly), from php/web-applications to ODBC-applications in various
languages and the native C API from C and C++ applications. The
databases so far has varied from a few hundreds kbytes to a few
gigabytes.
Now I'm
I know phpmyadmin does this, but I can not find a reference to an example.
I need to allow a client daily download of very large batches of mysql
records, I would like to stream this data to a download file, perhaps even
gzip it in the process, any links?
--
Thanks for helping brian, While I was going through some sites where
people had posted some trouble, I found this guy who had successfully
installed the server, client and dev package.
All I had to do was rpm -Uvh --nodeps pkg_name
I am not sure of the --nodeps, but i think it was there, but in
---
What you really want to avoid is having the password on the commandline.
File permissions won't matter at all if you end up running a command
that puts your password in the output of 'ps'! Command lines are always
public
I got the same error when my web server and mysql server were separate. And the
error was caused bcoz of too many unauthenticated users. The reason behind it
was that the reverse dns lookup for the webserver was failing. but as soon as i
added the web server to /etc/hosts, the error went off.
Hi.
Here is a description of what looks like a serious bug.
This is related to bugs #7294 and #6247
Tested against mysql 4.1.9 and 4.1.10.
Cheers
Giuseppe Maxia
Description:
operator NOT IN fails when a subquery returns one or more NULL values.
How-To-Repeat:
simple proof of
49 matches
Mail list logo