I'm really just currious as to WHAT you would want to see as opposed
to NULL?
How could you have a field that has no value? What would it mean?
NULL is the answer to this. It is recording the absence of
something. So, I would say that this is an expected behaviour of any
database
Actually, i'm sorry. I don't know why i didn't put a little more thought into
what i was writting. another late night i guess. That wasn't very cool of
me at all. My appologies, seriously.
Though, the time was not wasted, i've been were you seem to be before, and
none of the time anyone
Hi,
I'm trying to dig a bit deeper into mysql queries... I've come across an
application that i'm building which requires (it would seem on the surface)
many queries, do to the relational nature of the data.
The actual app is way too complex to explain, but I've come up with a
reasonably simple
Hi,
1) try this: GRANT SELECT, RELOAD ON *.* to dump@%
IDENTIFIED BY password;
2) in the backup file insert this line above all: SET
FOREIGN_KEY_CHECKS = 0; ... and all will be ok!
regards
--- Glenn Ticket [EMAIL PROTECTED] ha
scritto:
I have 2 questions concerning mysqldump.
1) What
I use XFS. Though my benchmarking is incomplete, it appears that it
outperforms ReiserFS and Ext3 on large files. This is probably due to the
fact that XFS was developed by SGI, whose systems work on large
Audio/Visual files.
Beware that you'll need to spend more time on your kernel once you
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB, but cannot
use rollback on it.
the error i get in my jsp is transactions not
supported.
please advice me on how i
This works perfect. Thanks !
Hi,
1) try this: GRANT SELECT, RELOAD ON *.* to dump@%
IDENTIFIED BY password;
2) in the backup file insert this line above all: SET
FOREIGN_KEY_CHECKS = 0; ... and all will be ok!
regards
I have 2 questions concerning mysqldump.
1) What grants does the user
Hello guy !
The limitations about InnoDB on replication is present in = 4.0.9 release
?
* THE LOAD TABLE FROM MASTER DOES NOT WORK ON INNODB TABLES
* THE TABLES ARE LOADED AUTOMATICALLY ON SET REPLICATION
is true this limitations on = 4.0.9 ?
sql,query
Dear Sir/Madam,
I can't able to do following things with MySQL 3.23.54.
Sub-selects
SELECT INTO TABLE
Transactions
Stored Procedures and Triggers
Foreign Keys
Views
But, what can I do if I can't do anything without Transaction Support,
Stored
Maximo,
have a look at config.log and the configure script after line 14585. That
will tell you what goes wrong.
Thomas Spahni
--
filter: sql, query
On Mon, 20 Jan 2003, Maximo Migliari wrote:
Hello there,
I'm trying to compile MySQL 4.0.9-gamma under FreeBSD 4.7-Stable with
linuxthreads.
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 12:13 PM
Subject: Limitations of InnoDB about REPLICATION
Hello guy !
The limitations about InnoDB on replication is present in =
Hello,
I'm using MySQL 4.0.1 with Tomacat 3.3 JSP.
I'm getting this error every time i access my jsp
page:
javax.servlet.ServletException: No suitable driver
Can anybody help me out..
i tried to download from download/J but it's not
gettin opened ...
its urgent ..
Thanks
Hi, David
On Tue, 21 Jan 2003, David T-G wrote:
% Are you sure that smallint is enough for your index? Do you really need to
I've thought about that a bit, but don't know if there is a more 'right'
answer that comes with experience... In this case and other cases I've
had so far, it is;
Norris,
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I remember this well but I don't remember what I did to fix it.
Not to be impolite, but I'd say you should simply start the MySQL server
:)
Check system control administration services if there is a service
called
Hi Shripal,
your requests were:
I can't able to do following things with MySQL 3.23.54.
Sub-selects
Thats right , subselects come with version 4.1 (out for a view days).
About 99% of all subselects are can be done with the right JOIN.
SELECT INTO TABLE
Try: INSERT INTO Table_Name SELECT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% Hi, David
Hi!
%
% On Tue, 21 Jan 2003, David T-G wrote:
%
% % Are you sure that smallint is enough for your index? Do you really need to
%
% I've thought about that a bit, but don't know
Hi,
I'm not sure my reply will be of any use to you, but here it goes..
I've recently had problems with a perl driver (DBD::mysqlPP) with regards
to, amongst other things, large BLOB data entries. My short-term work-around
is simply to handle all BLOBs on the client side, i.e. split up all long
Hi,
I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt.
I ve setup a replication between these two servers as discribed in tha
manual and some small problems comes up.
May some can give me some help.
1.) On the Master I create a user repl with the rights 'replication slave'.
On the
hello . . .
did you install the necessary mysql driver you call in your jsp
ClassForName-statement?
you can find mm.mysql at sorceforge.net
regards,
henning
nitsy wrote:
Hello,
I'm using MySQL 4.0.1 with Tomacat 3.3 JSP.
I'm getting this error every time i access my jsp
page:
On Wednesday 22 January 2003 19:39, Bill Rausch wrote:
I've inherited a busted database and need to clean it up. I can't
figure out how to do something which seemingly should be simple.
For example, I've got two tables:
Table One
id int primary key auto_increment not null
...other data
On Wednesday 22 January 2003 21:10, Norris Joseph wrote:
Hello,
I have the following in my SQL:
update call_center set call_center.who_for_id = activeemployees.hr_emp_no
where call_center.who_for_id = activeemployees.id;
This is something I think that I should be able to do, but I get an
On Thursday 23 January 2003 02:55, Norris Joseph wrote:
I have been running mysql on windows 2000 for about 8 months. Now I have to
install it on a new win2k box.
I get everything installed and go to get into mysql and I am getting this
error:
ERROR 2003: Can't connect to MySQL server on
On Wednesday 22 January 2003 19:24, Valdir Stiebe Junior wrote:
Creating a table with a not null field, and then trying to insert it
doesn't raise an error 'Column XXX cannot be null'
Well, this was the steps (sql to bypass filter) i did:
1. create table TEST ( id_test integer, name
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 12:31 PM
Subject: Re[2]: Limitations of InnoDB about REPLICATION
Dobrý den,
quinta-feira, 23 de janeiro de 2003, 08:28:43, napsal jste:
HT Dyego,
...
Hi Josh,
As I mentioned elsewhere, you're very welcome, happy to help.
To answer your next questions as best I can (if I make any errors I'd be
grateful if someone else on the list would highlight them):
Let's imagine you have two tables, 1 table contains employees, the other
table contains the
* Justin French
I'm trying to dig a bit deeper into mysql queries... I've come across an
application that i'm building which requires (it would seem on
the surface)
many queries, do to the relational nature of the data.
No. SQL was created to do queries on data of a relational nature, thus
Hi.
On Wed 2003-01-22 at 23:07:24 -0800, [EMAIL PROTECTED] wrote:
I'm really just currious as to WHAT you would want to see as opposed
to NULL?
Well, you asking the wrong guy, because I did not need that feature,
but I'll try to explain anyhow.
They want to see an error instead. It is the
Hope everyone's having fun at LinuxWorld.
I couldn't find any discussion of a solution for this (according
to Google, mysql.com search), other than at least a dozen reports
from people having trouble with it. The bug is that the proper error
is not reported and at least I was sent on a wild
Hello All,
For some time I've been wondering if it's possible to write a program
that can automatically check my local MySQL server, create a recordset
containing any new or updated records found in my local table(s) since
the last check, and upload those new / updated records to the MySQL
server
Hello All,
For some time I've been wondering if it's possible to write a program
that can automatically check my local MySQL server, create a recordset
containing any new or updated records found in my local table(s) since
the last check, and upload those new / updated records to the MySQL
server
On Thursday 23 January 2003 05:12, George Toft wrote:
I have discovered an exposure in the history recall functionality of
MySQL Monitor. When a user uses MySQL monitor authenticated as the
database root user to issue commands, such as changing user passwords or
database table creation, that
Hello
I'm new to MySQL and struggling with all sorts of things.
First things first: (hope someone can help)
I'm running MySQL 3.23.53, PHP 4.2.3, Apache 1.3.27 and phpMyAdmin 2.3.2 on
Solaris 8.
All seemed ok until the site administrators tried to upload a csv file into
the database through
- Original Message -
From: [EMAIL PROTECTED]
To: Doug Coning [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 9:15 AM
Subject: Re: Is this possible?
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
We have a table in the database holding session data. The data is updated
rather oftenly using REPLACE INTO query with primary key. Table structure
is:
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
Hello there,
I have moved from a Dual PIII--866 Server with linux redhat and 384MB of
RAM, to a dual Athlon 1.5Ghz with FreeBSD 4.7-Stable installed and 1 GB of RAM.
Something I noticed, with the help of a few of you on the list, is that the
configuration options I had done in my.cnf,
Stefan,
I have checked these things. To re-state the problem. I already have mysql
up and running
on several servers with apps accessing them from my web site. This is just a
new install
but it has been so long that I have forgotten what to do about this
localhost situation.
Thanks.
hello dear all,
i have a problem updating tables:
in my queries i try to use REPLACE but is same like INSERT command.
...i need only to refresh table_1 with new entries from table_2.
any ideas?
TIA
fabrizio
-
Before
On Wednesday 22 January 2003 16:34, rick wrote:
I'm running mysql 3.23.42 on multiple machines (Solars 8, 32 bit) and on a
couple of the machines I see the following in the .err log: ..
030120 9:11:10 Warning: Got signal 14 from thread 4
030120 9:11:10 Warning: Got signal 14 from thread 4
Hi everybody:
I 'm actually having an problem trying to mygrate to mysql. it's true
that mysql does not support bind variables ? . Actually the development
in my company is over Centura team developer connected to Centura
Sqlbase , and the code of the aplications is widely using bind variables
I would like to know which Linux Distribution is best suited to run MySQL
4.0.9. I was thinking of Red Hat or Mandrake so if someone could tell me
which of these is better for a production system or if there is a better
distro other than these two
Your comments are really appreciated.
Thank
hi all,
i have a table trans with this structure:
today(date) | heure1(time) | amount(double) | client(varchar 30)
Now i need to write a query that would take the start date and time, end
date and time, and return all the records between the two.
So for example, the query should return all
Correct me if I am wrong, but I believe mysql 3.23.54 does not support
transaction support, version 3.23.54 has row locking only. Transaction
feature starts with version 4.0.x.
Bob
- Original Message -
From: Nirmal Shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
MySQL support: none
Synopsis: Server crashes on remote connection
Severity: serious
Priority: high
Category: mysql
Class: Bug / Local Problem?
Release: mysql-3.23.54 (Source distribution)
mysql-server-3.23.54a-4
mysql-3.23.54a-4
mysql-devel-3.23.54a-4
(used rpms
As the person who's asking a question and just had it rejected twice,
here it is again ... sql, query, blah, blah.
I have three InnoDB data files that I've created as time has gone on;
100M, 250M and 1G (autoextend). I would like to create a new data file
on a new raid partition and make it
Hello there,
I have moved from a Dual PIII--866 Server with linux redhat and 384MB of
RAM, to a dual Athlon 1.5Ghz with FreeBSD 4.7-Stable installed and 1 GB of RAM.
Something I noticed, with the help of a few of you on the list, is that the
configuration options I had done in my.cnf,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote:
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB, but
hello people,
I want to construct a table, and in this table I have a column (date type)
that if I insert blank date, the MySQL automaticly insert the current date
of system.
How do I do it?
Thanks,
Elby.
_
MSN Messenger:
Jeremy Zawodny wrote:
Now, I just have to remember to push out mytop 1.3 so that folks can
shake out any new bugs I've introduced...
Just make it one binary that recognizes its argv[0] calling (like gzip)
and also supports command-line options. The two data collection methods
are the same
I have been trying, for the past two days, to successfully build MySQL
3.23.54 using LinuxThreads on a FreeBSD 5.0-RELEASE SMP box.
Unfortunately, I have been unable to get a successful, working build.
Some of the failed builds I have had:
* Successfully compiles and installs, but gets a signal
hi all,
i have a table trans with this structure:
today(date) | heure1(time) | amount(double) | client(varchar 30)
Now i need to write a query that would take the start date and time, end
date and time, and return all the records between the two.
So for example, the query should return all
Is this possible in MySQL without using a temporary table with multiple SQL
commands:
I am trying to SELECT the results of multiple columns into 1 column or
Alias,
group them and sort them.
So if I had a table with 4 fields: Cat1, Cat2, Cat3, Cat4 like such:
+-+--+-+--+
| Cat1|
Hi,
I looked a lot and I couldn't find a solution to this problem:
Ex: I have 5 queries. I run them and one of them fails. The rest are ok.
So 4 tables are affected and one is not. Is there a way of testing the
queries if they will be successful and only if all of them are then they
should be
Hi,
I looked a lot and I couldn't find a solution to this problem:
Ex: I have 5 queries. I run them and one of them fails. The rest are ok.
So 4 tables are affected and one is not. Is there a way of testing the
queries if they will be successful and only if all of them are then they
should be
hi all,
i have a table trans with this structure:
today(date) | heure1(time) | amount(double) | client(varchar 30)
Now i need to write a query that would take the start date and time, end
date and time, and return all the records between the two.
So for example, the query should return all
Hi Jeremy,
My only concern with LinuxThreads is building MySQL 4.0 or 4.1 with
them as there is still not a FreeBSD port for MySQL 4 !!! I had alot
of trouble making Linux Threads work initialy. If people want to use
MySQL 4 and want to build from ports (the recommended method) I think
they
Description:
I installed MySQL-3.23.54a from source on AIX 5.1. It works fine
when I connect the server through unix socket as localhost. But whenever I tried to
connect the server though TCP/IP port, the server shutdown.
How-To-Repeat:
I tried :
./bin/mysql -u
Hi,
IMHO:
I think if you use autoheader it's possible to fix that according with your
glibc/compiler version.Also (...from what i remember what i saw in the
source code) is used macros for checking GLIBC2 style.
Regards,
Gelu
_
G.NET SOFTWARE
Hi ! this question is very relevant for me !!!
The speed of InnoDB is more fast if the raw device is specified
with
/dev/hda1:20Gnewraw
or with created using /dev/hda1 ? ex:
bash# cd /dev
bash# sh MAKEDEV raw
bash# raw /dev/raw1 /dev/hda1
in my.cnf
/dev/raw1:20Gnewraw
The speed is more
Does anyone have a list of manufactures of financial packages that will
run with MySQL?
We need to move from Intuit Quickbooks to something that can
potentially scale to as many as 200 users. Greatplains and Solomon
appear to only run on SQLServer.
Any suggestions or past upgrade experiences
Does anyone have a list of manufactures of financial packages that will
run with MySQL?
We need to move from Intuit Quickbooks to something that can
potentially scale to as many as 200 users. Greatplains and Solomon
appear to only run on SQLServer.
Any suggestions or past upgrade experiences
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Tam wrote:
Correct me if I am wrong, but I believe mysql 3.23.54 does not support
transaction support, version 3.23.54 has row locking only. Transaction
feature starts with version 4.0.x.
Bob
You're corrected :)
3.23.54 supports InnoDB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fernando --
...and then Fernando Grijalba said...
%
% I would like to know which Linux Distribution is best suited to run MySQL
% 4.0.9. I was thinking of Red Hat or Mandrake so if someone could tell me
% which of these is better for a production
I'm pretty sure that I have two queries that could be combined
into one query using a JOIN, but I can not figure out how to do
it. Basically, I need all the rows from TABLE1 that are either
NOT in TABLE2 or IN TABLE2 BUT have been marked as voted by a
user id. Yes, that makes no sense, I'll try
Hi,
IMHO:
I think the better way is to use replication between your local MySQL server
and MySQL from the Web Server.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Heya thar:
Take the file that you have as autoextend right now, round it down to the
nearest meg, and enter this value as the size (without autoextend).
Then make the new file autoextend.
Peter
^_^
-Original Message-
From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
I am trying to compile Solaris 8 (mysql 3.23.51)
configure works fine, when I get to the yacc part ...
yacc -d sql_yacc.yy mv y.tab.c sql_yacc.c
yacc goes fatal saying an invalid escape at line 71 (pure_parser)
So, I try bison, but I get the following complaints ...
sql_yacc.yy:(some
I had this problem with my new install on windows. In my case in turned out
to be that the tables were not created as innoDB even though I had specified
type=innoDB. I'm not sure why this happened but I fixed the problem by
recreating the tables after I made sure that I have innoDB server
On Thu, Jan 23, 2003 at 12:55:33PM -0500, Jonathan Disher wrote:
I have been trying, for the past two days, to successfully build MySQL
3.23.54 using LinuxThreads on a FreeBSD 5.0-RELEASE SMP box.
Unfortunately, I have been unable to get a successful, working build.
FWIW, my FreeBSD 4.x
I have just set up MySQL and the phpmyadmin script and I would like to add
some users and do some other administrative tasks to assure security. Above
all, I want to make sure no user (or php script) will have access to any
databases without a user name and password.
Right now if I look at
Elby,
I want to construct a table, and in this table I have a column (date
type)
that if I insert blank date, the MySQL automaticly insert the current
date
of system.
You can use a TIMESTAMP column for this. If you insert NULL (or even
nothing at all) it will be set to the current date and
Fabrizio,
please send the table structures of table_1 and table_2 (DESCRIBE ...)
so we can do more for you than just guess what the problem might be.
REPLACE seems good in the first place, but if it just INSERTs then
there's a problem with the (primary) keys.
Regards,
--
Stefan Hinz [EMAIL
Joseph,
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
Okay, if MySQL is up and alive, you should check on which port it is
listening. For instance, you could (in a DOS window) do:
mysqld --print-defaults
to find out if there are some strange configuration settings. If the
Martin, Larry,
Synopsis: Server crashes on remote connection
I'm not a Unix guru but I experienced the same sympton on SuSE Linux
8.0/8.1, and I heard of people reporting the same of Red Hat Linux
7.x/8.x.
MySQL runs stable, you can connect from localhost via socket and tcp/ip,
but as
Thanks Stefan - I found the problem in my my.ini file. Fixed and on.
Thanks for the help.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 3:15 PM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: Re: Install on WIN2k
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am preparing to migrate a client from using a large MS-ACCESS database to
using a linux hosted MySql as the datasource. Or at least I'd like to be able
to export tables as a backup.
Please tell me where I can get a driver.
Thanks,
- --
Jeff
jihad
Gentoo (www.gentoo.org)
/jihad
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: Fernando Grijalba [EMAIL PROTECTED]
To: MySQL Help [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 10:32 AM
Subject: Red Hat/Mandrake or Other
I would like to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Darren,
I can input Japanese text using Netscape 7.01 on a Linux PC I use a PHP script
to write the submitted information to the database. Here is a dump from the
select * query.
3
Eiji Goto
0
D
0
米沢
The Netscape-PHP-MySQL-PHP-Netscape path is
A guess...
select t1.cat1 as result from t1
union
select t2.cat2 as result from t1
union
select t3.cat3 as result from t1
union
select t4.cat4 as result from t1
group by result
order by result
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: Doug Coning
See interleaved comments below.
Subject: solution for opposite of this join / join from this subselect
To: [EMAIL PROTECTED]
From: Josh L Bernardini [EMAIL PROTECTED]
Date: Wed, 22 Jan 2003 11:23:44 -0800
thanks to brent, bob and M wells for their contributions to this solution
and to m
Hi!
Thank you for bugreport. This bug is fixed now. Here is patch for it:
diff -Nrc a/sql/sql_table.cc b/sql/sql_table.cc
*** a/sql/sql_table.cc Fri Jan 24 01:54:55 2003
--- b/sql/sql_table.cc Fri Jan 24 01:54:55 2003
***
*** 1432,1437
--- 1432,1439
}
On Thu, Jan 23, 2003 at 01:47:43PM -0500, Ken Menzel wrote:
Hi Jeremy,
My only concern with LinuxThreads is building MySQL 4.0 or 4.1 with
them as there is still not a FreeBSD port for MySQL 4 !!! I had alot
of trouble making Linux Threads work initialy. If people want to use
MySQL 4 and
In my case also I failed to set the charset to Shift-JIS though I put some
stuff in my *my.cnf.*
So I am now controlling the entire thing using my application. my charset is
still latin1. I just get the input string from the user, convert it to a
binary and store it in mysql. To display back I use
This would be called transactions: your're looking for COMMIT/ROLLBACK. As
far as I know, transactions are only available on BDB and InnoDb table
types. See
http://www.mysql.com/doc/en/Transactional_Commands.html
http://www.mysql.com/doc/en/InnoDB_overview.html
At 12:24 AM
I believe a sub-select with the DISTINCT command would do it.
You would have to look up the syntax.
Also, it seems that some people seem to be having a problem with
sub-selects but
I don't have any direct experience to convey.
At 01:12 PM 1/23/03 -0600, Doug Coning wrote:
Is this possible in
Darren,
This sounds like a character set mis-match. I am wondering what character
set the user is using and which OS.
If the user is using Netscape to enter their data, then I am assuming they
are using an OS that supports the hira/kata/kanji character sets. What do
they have their OS set to,
sorry for the ambiguos subject, but not sure what terms to use!
I have four (relevant) tables:
category
partner(pid,pname,etc)
service(sid,sname,cid)
sid2pid(sid,pid)
This works fine, listing all services available within a category:
SELECT service.sid,service.sname
FROM service
WHERE
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 10:35 PM
Subject: The diferences about /dev/hda1 and access via raw device
Hi ! this question is very relevant for me !!!
The speed
Dear sir,
I am looking for a function which returns the column type in MySQL in C
API.
Is there one? I found in the document it describes the column types
like:
FIELD_TYPE_BLOB
FIELD_TYPE_DATE
FIELD_TYPE_VAR_STRING
... ...
Could you please get
88 matches
Mail list logo