How-To-Repeat: MySql Connector J 3.x Problem
Dear Sir,
I have download MySQL Connector/J 3.x (mysql-connector-java-3.0.3-beta
mysql-connector-java-3.0.4-gamma) and well install them on my java (JSDK 1.4.1) system
(Win XP).
When I try to get the result set from the database, the result
Okay.
By the way, sorry about sending you the reply directly before.
However, I've run into a new problem new. Tried to compile mysql-4.0.9 with
linuxthreads-2.2.3_9 (the most recent from ports).
Linuxthreads was installed from ports - and for MySQL I used the following
configure-string:
You know what? You are correct on both accounts. I completely overlooked
what you had written as your SQL query and am a blind moron ;-)
Yeah, I dunno why you got whacky results then. It is true the TINYINT is
still in it's range, so that part is working, so the issue is that the
DISTINCT and/or
On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote:
Hi,
I'm running Freebsd 4.6.2 with mysql server v3.23.49
I have a little question about using Mysql on Freebsd and having a
database on a NT 4 linked drive, using Samba (the drive was mounted
on my FreeBSD system with
Dear Sr.
Sorry, but my english isn't very good.
I want to install Mysql in Aix 4.3.3 in RS-6000. First I installed mysql
3.23.49 but insn't very good. When I executed /scripts/my_install_db i
recived a lot of error like that:
Hi
we have what we think is a bug regarding an insert (or an update) during times of
heavy load on the mysql server. Our application should perform an insert in one table
and updates on two other tables but the insert is performed up to 9 times.
I'm not entierly sure that the problem is NOT in
At 23:26 14/01/2003 +0100, Guus Landheer wrote:
Hi,
I am trying to install (first-time installation) Mysqld-nt on a W2000
workgroup computer. when starting it reports system error 1067 has
occurred, process terminated unexpectedly TCP/IP is on.
The above error means that the server for any
Hi,
I am new to mySQL, so I need some help.
I have a table, which has record structure like this:
- customer
- name
- register_date
- expired
Every day, I add some records, new customers. The field 'expired' is just a flag,
either '1' or
'0'.
If register_date is 3 months ago then expired =
Did you try installing mysql4 also from ports? I didn't try 4.0.9 but
4.0.4 builded nicely this way for me.
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Wed, 15 Jan 2003, Tommy F. Eriksen wrote:
Date: Wed, 15 Jan 2003 09:23:18 +0100
From:
From ports?
This may be a dumb question, but where in the ports tree does mysql4 reside?
If I look in /usr/ports/databases, I see a lot of mysql-utilities (mysqltcl etc),
mysql323-server 323-client - but no mysql4?
Thanks,
Tommy
-Original Message-
From: Varshavchick Alexander
Hallo,
I apologize for my bad english.
Im desperate about the followwing problem :
I'm using the MySQL C-API for accesssing a database with about 1.2 Mio
SQL-Statemants.
Therefor I make a connect to the database and after that a loop
starts a Subprogram about 1.2 Mio times in which a
On Wed, 15 Jan 2003 11:02:44 +1100
vinita Vigine Murugiah [EMAIL PROTECTED] wrote:
HI
I'm not sure what is wrong with my CREATE TABLE syntax, Please advice
There is no index on ifname in table equipment_interfaces.
mysql CREATE TABLE equipment (
- equipID CHAR(20)
Hi,
I think is not a bug.The result is normal becuase function TO_DAYS() return
the daynumber and not the date.If you wish to find a date depend on the
number of days you can try(like example):
select FROM_DAYS(TO_DAYS(NOW())-3);
Read the manual about this two functions
Regards,
Gelu
Hi,
Maybe it's a good ideea to increase the value of max_allowed_packet(from
my.cnf configuration file) to 2M.By default is 1MB.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi,
Some time ago i've read that we shouldn't use myisamchk while the mysql
server was running. Now, i don't find where in the manual says something
about it.
I think you should do a FLUSH TABLES and ensure that no one touches
the tables (including mysqld) before using myisamchk.
Coudn't you use
Hi
I'm newbie
I have to find from xvalue to yvalue; I have written:
$query=SELECT * FROM inner-multipli
WHERE cod_int
LIKE ='%$cod_int1%'
AND cod_int
LIKE ='%$cod_int2'=;
This not work; how can I do?
Thanks in advance
bruper
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis: 2013 Error - DB Hanging during a Query (one line)
Severity:
Priority:
When I try to connect to the MySql server on localhost I get the
following error:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I am not quite sure what this means.
I am running Mac OS X 10.2.3. Before I upgraded from 10.1, I had no
problems, but now am unable to
Yep, you're right!
Perhaps an extra byte is automatically reserved, not only for a
null/not null status bit, but also for other internal use - eg; a
'row changed' bit, etc.
I did a quick test:
mysql create table t2 (c1 varchar(255));
Query OK, 0 rows affected (0.00 sec)
mysql insert into t2
I've wanted to post this query example a few times (and I hope I got it
right; mornings aren't my best time) ... multiple JOINs:
SELECT stuff
FROM table1
LEFT JOIN table2
ON table1.fk = table2.pk
LEFT JOIN table3
ON table2.fk = table3.pk
WHERE other_conditions
Cal Evans wrote:
Always start with a *fully* normalized design. You can always denormalize for speed but it's real hard to normalize once you are in production.
I'd rather be 'stupid' about how normalized my data is and then write
caching into my program (or use MySQL 4's query cache, which
Dear Sir/ Madam,
I noticed that the character set big5 is missing in the installation file of
My SQL
but the index file indicate that MySQL does have this character set. Is
there a place to
download it?
Please help me. Thank you in advance.
Yours,
Warren
if your using numbers , which i guess you are, you do not need to use LIKE.
$query=SELECT * FROM inner-multipli
WHERE
cod_in =$cod_int1
AND
cod_int =$cod_int2;
bruno peracchio wrote:
Hi
I'm newbie
I have to find from xvalue to yvalue; I have written:
$query=SELECT * FROM inner-multipli
That looks like a PHP problem to me. Have you tried mysql_fetch_assoc()? I
believe mysql_fetch_row() gets you an array with a numeric index (in which
case lastname would be in $line[0]).
Notice: Undefined index: lastname in E:\IIS Webs\index.php on line 29
?
PRINT HTML;
PRINT HEAD;
Thanks for your advice.
I tried it with the higher value (3M) but the program broke down
like before.
I increased the other buffer values too after that and am
testing now if this helps.
Greetings,
Daniel
Gelu Gogancea wrote:
Hi,
Maybe it's a good ideea to increase the value of
The error that you have is normally that MySQL in not running.
If it is running then MySQL client can not find the sock file.
I should not think you will have to reinstall.
Simon
-Original Message-
From: Daniel Florian [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 13:11
To: [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas Chan wrote:
How-To-Repeat: MySql Connector J 3.x Problem
Dear Sir,
I have download MySQL Connector/J 3.x (mysql-connector-java-3.0.3-beta
mysql-connector-java-3.0.4-gamma) and well install them on my java (JSDK 1.4.1)
system (Win XP).
Oh.. I see. I dont know about Linux, all I knew was that I wanted it so I
burned the necissary CD's and installed linux on my other machine. So,
you're saying I should use a mandrake-linux forum, instead of mysql?
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Tyler
Jeremy Zawodny wrote:
Add error checking to all MySQL API calls and the problem will become
apparent. Right now you're assuming they all just work (except for
the mysql_connect()) but they probably don't.
I highly recommend anyone using MySQL use either AdoDB
http://php.weblogs.com/adodb
Jeremy Zawodny wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this). PS, as with the MySQL daemon, I run my ssh
tunnel under
Can someone please guide me in uninstalling all the failed installs of MySQL
I've got? I've installed like 2 binaries, and 1 source.. none work :(
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
if I call:
my $record = $sth-fetchrow_hashref();
then:
$sth-finish();
How valid is it for me to keep referring to my $record hash pointer?
Thanks,
Jeff Snoxell
Aetherweb Ltd
http://www.aetherweb.co.uk
[SPAM FILTER FODDER: MySQL, QUERY]
I had a query that was working fine before for a
sports project .. basically, 3 tables .. one stored
goal data, one stored team data, and the other player
data. To get all the scoring data (player names,
jersey #'s), I left joined to the player table 3
different times (on GOAL, ASSIST1, and
- sql,query
On Tue, 2003-01-14 at 23:55, Jeremy Zawodny wrote:
What do the relevant sections of the my.cnf files on the master and
slave look like?
--
Hi,
I've had the same issue - but always assumed that
replication was meant to ignore create database
I've looked into it further,
Harald Fuchs wrote:
You _did_ enter some data, namely a string which just happens to be
the empty string (which in turn is different from no data, i.e. NULL).
How should MySQL know that you don't want empty strings?
I think the user expects:
INSERT INTO table (bar) VALUES (text);
to behave
dont forget mysql_fetch_object()
then you will have $line-lastname;
Maureen Roihl wrote:
That looks like a PHP problem to me. Have you tried mysql_fetch_assoc()? I
believe mysql_fetch_row() gets you an array with a numeric index (in which
case lastname would be in $line[0]).
Notice:
On Tuesday 14 January 2003 22:54, Gabe Geisendorfer wrote:
Does anyone know when MySQL 4.0.9 for Windows (bins) will be available
for download?
I've downloaded 4.0.9 for Win from one of the mirrors ..
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
On Wednesday 15 January 2003 04:26, julian haffegee wrote:
I want to insert some text into my database, but I'm worried about bad
data - metacharacters etc.
So I need to filter the input and remove bad characters. Which characters
should I remove? What is bad for mysql?
does anyone know a
On Wednesday 15 January 2003 02:02, vinita Vigine Murugiah wrote:
HI
I'm not sure what is wrong with my CREATE TABLE syntax, Please advice
[skip]
mysql CREATE TABLE equipment_interfaces (
- equipID CHAR(20) NOT NULL,
- ifName CHAR(20) NOT NULL,
-
It that does not work. You could try the following snippet:
if ($result = mysql_query ($query);)
{
while ($row = mysql_fetch_array ($result))
{
...
}
mysql_free_result($result);
}
Okay I have installed mysql on windows XP-home, and cannot get round the
Error cant connect to mysql server on localhost 10061.
I have read the manual again and again and again...I have read the public
mailing list again and again and again...I have tweaked the `ini` file using
the winmysqladmin
mysql_fetch_array() does the same thing as mysql_fetch_assoc(), both will
return the record as an associative array, which is how you're trying to
access it.
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 9:49 AM
To: 'Maureen
Massimo,
please address these general MySQL questions to [EMAIL PROTECTED] or
[EMAIL PROTECTED] I think Miguel has been fixing the stopping of
multiple servers on Windows lately. You should test the very latest
MySQL-4.0.x release.
I am Cc:ing this also to Miguel who can comment on this.
Best
At 8:21 -0500 1/15/03, Michael T. Babcock wrote:
Paul DuBois wrote:
Yes, the second edition really is 1248 pages, 50% more than the first
edition. Sorry about that.
You should rephrase that to: Yes, the second edition is 1248 pages,
that's a 33% discount over the first edition. assuming the
Hi Martin,
Replication definitely does not ignore CREATE DATABASE all the time,
just every now and then :) I had 93 databases that made it through
replication, and the 94th failed. There aren't any binlog-ignore-db
paramaters. I've dumped the binlog out, and CREATE DATABASE did make
it into
Sorry for the repost, I just want to make sure this didn't go unnoticed.
I'm having trouble on one of my SQL servers. It is the slave in a
master/slave setup. select now() returns the wrong time (+5 hours).
The systems time is in EST and show variables shows timezone=EST. This
has been very
hi all,
i know some GUI mysql client software can support SSL. Then, i try to
install mysql 4.0 with |--with-vio --with-openssl| options. i haven't
install the openssl 0.9.6 again as i found my redhat 7.3 box already has
the /usr/include/openssl and /usr/lib/libssl.a. After i followed the
docs in
I'm not sure how Perl works on variable assignment. If $sth is passing a
reference to $record finish() may kill the variable $record holds a
reference to during garbage collection. If it *assigns* the row to $record
(meaning $record holds a copy of the record data and not a reference to
where the
Hi,
I just want to inform that I´m having the same problem in a Red
Hat 8. I´ve installed this linux only with the basic packages, like gcc,
cpp, glibc, ncurses (to recompile the kernel), binutils, make and
glibc-kernel headers. And in one of the foruns I visited, somebody told
to
Let me give this a try. I've done 3 and 4 table joins, but I did a
little trial and error before I got it right.
To break it down, you want to get three things:
1) All meetings that fall under a particular event
select * from meetings where eid=2
2) All people id's that are part of that selected
Steve,
mysql create table t2 (c1 varchar(255));
Query OK, 0 rows affected (0.00 sec)
mysql insert into t2 values ('s');
Query OK, 1 row affected (0.00 sec)
And this gave table status of
Name: t2
Type: MyISAM
Row_format: Dynamic
Rows: 1
Ahh, but I didn't enter data that is the point. MySQL definitely knows
that I omitted a field, it just happens that MySQL automatically turns
the field into an empty string. In the absence of CHECK constraints
perhaps the following behavior could be implemented.
I would like to see MySQL throw an
Hi,
I've got a varchar field in a mysql table that contains 'N' numbers (each a
maximum of 4 digits, not zero padded) separated by spaces when more than 1
number is present.
eg. field content might be any of the following
''
'123 4567 1234 45 3'
'3'
'3 4 6'
I want to select only those
If you're looking to qoute strings in perl, your DBI handle has a function
called quote:
$quoted_string = $dbh-quote($unqouted string)
I believe you need to be connected to your database server in order to use
this, and I am not POSITIVE whether this works for all RDBMS servers.
Jeppe
At 14:11 +0100 1/15/03, bruno peracchio wrote:
Hi
I'm newbie
I have to find from xvalue to yvalue; I have written:
$query=SELECT * FROM inner-multipli
WHERE cod_int
LIKE ='%$cod_int1%'
AND cod_int
LIKE ='%$cod_int2'=;
This not work; how can I do?
Hard to say. Even if that syntax was legal,
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this).
Another option is CIPE, a method for secure tunnelling of any IP protocol
using virtual network interfaces. I believe CIPE comes as standard with
Description:
When trying to create a type=BDB table under NetBSD 1.6, mysql reports:
ERROR 1005: Can't create table './test/test.frm' (errno: 9)
and the error log shows:
030114 17:10:19 bdb: fstat: Bad file descriptor
030114 17:10:19 bdb:
Nice that this came up when it did.. I'm currently struggling with a
three-table join.
Table1.PK = Table2.FK1
Table3.PK = Table2.FK2
My last effort looks something like:
SELECT SomeStuff
FROM Table1 AS T1
LEFT JOIN Table2 AS T2 ON T1.PK = T2.FK1
RIGHT JOIN Table3 AS T3 ON T2.FK2 = T3.PK
WHERE
Hello:
As the root user, I created a new database and user account:
CREATE DATABASE newsletter;
GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass';
FLUSH PRIVILEGES;
I then tried to access the databse via the command-line client:
/usr/local/mysql/bin/mysql -u newsletter
Is it wise to always assume that a file content is always binary and hence store it
in a MySQL BLOB type, even if the file may be only a text file? Your thoughts on
this would be appreciated.
sql
-
Before posting, please
Hello.
On Tue 2003-01-14 at 09:32:02 -0800, [EMAIL PROTECTED] wrote:
I'm aware that NULL and are not the same thing.. I would like to
prevent the column from accepting values automatically ( with out the
presence of a DEFAULT).
[...]
The problem is: You have a DEFAULT, you just don't know
It's my understanding that embedded selects are NOT allowed in MySql. Is this correct?
Example:
SELECT t1.*
FROM table1 t1
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Doug Beyer
SAS Research and Development
503-617-7103 (Portland)
[EMAIL PROTECTED]
SAS... The Power to Know
Dear Sirs.
We are programers in Brasil and we are currently conducting tests with MySQL
version 3.23.49 Max working with Dephi 6.0. For testing purposes we
developed a very simple program that inserts 500 records into a table. The
folowing teste has been conducted: With the test program two
On Wed, Jan 15, 2003 at 09:18:50AM -0500, Michael T. Babcock wrote:
Jeremy Zawodny wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for
Dear Sirs.
We are programers in Brasil and we are currently conducting tests with MySQL
version 3.23.49 Max working with Dephi 6.0. For testing purposes we
developed a very simple program that inserts 500 records into a table. The
folowing teste has been conducted: With the test program two
On Tue, Jan 14, 2003 at 11:33:54PM -0800, Jeff Kilbride wrote:
Are there any general guidelines for optimizing ext3 for MySQL? I have a
perl script that runs 200K + updates into my database once a day and I see
pretty wildly fluctuating query/sec numbers using Jeremy Z's mytop program.
I've
Jeff Snoxell wrote:
Hi,
I've got a varchar field in a mysql table that contains 'N' numbers
(each a maximum of 4 digits, not zero padded) separated by spaces when
more than 1 number is present.
eg. field content might be any of the following
''
'123 4567 1234 45 3'
'3'
'3 4 6'
I want to
At 16:40 + 1/15/03, Jeff Snoxell wrote:
Hi,
I've got a varchar field in a mysql table that contains 'N' numbers
(each a maximum of 4 digits, not zero padded) separated by spaces
when more than 1 number is present.
eg. field content might be any of the following
''
'123 4567 1234 45 3'
On Wed, Jan 15, 2003 at 07:13:05AM -0700, Tyler wrote:
Oh.. I see. I dont know about Linux, all I knew was that I wanted
it so I burned the necissary CD's and installed linux on my other
machine.
No offense, but in that case you're probably in for a rough ride.
Jeremy
--
Jeremy D. Zawodny
On Wed, Jan 15, 2003 at 04:49:03PM -, Basil Hussain wrote:
Mostly because it can't be done (that I'm aware of).
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this).
Another option is CIPE, a method for secure tunnelling of any IP protocol
Hi.
As Jeremy said, most info can be found by reading the archives or the
manual.
On Tue 2003-01-14 at 11:41:16 +0200, [EMAIL PROTECTED] wrote:
I've asked on another list which database they recommend among MySQL and MS
SQL, and ... possibly PostgreSQL.
Most of that list members answered me
hello,
I have a list of things ('item1', 'partA', 'partB', 'partB')
which relate to catNum items in a table sys_bld_foo.
table sys_bld_foo:
component: varchar 16
catNum: varchar 16
price: decimal (10,2)
i want to return 1 row for each item:
when i use:
SELECT DISTINCT price FROM sys_bld_foo
Thanks to everyone who answered my question.
With some further reading in the searchable archives at
http://www.listsearch.com/mysql.lasso, I managed to solve the problem on my
own last night and grow up to a 9 table join.
Tab, I think you just want two left joins instead of a left join and a
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jeff Kilbride [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, January 15, 2003 10:41 AM
Subject: Re: Optimizing Ext3 for MySQL
On Tue, Jan 14, 2003 at 11:33:54PM -0800, Jeff Kilbride wrote:
Are there any
Try adding a T2.PK IS NOT NULL or T2.FK1 IS NOT NULL:
SELECT SomeStuff
FROM Table1 AS T1
LEFT JOIN Table2 AS T2 ON T1.PK = T2.FK1
RIGHT JOIN Table3 AS T3 ON T2.FK2 = T3.PK
WHERE T1.PK=999 AND T2.FK1 IS NOT NULL
Example with old tables i have:
mysql select * from t1;
+++
| id | v |
In the last episode (Jan 15), Nicolas said:
On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote:
I'm running Freebsd 4.6.2 with mysql server v3.23.49
I have a little question about using Mysql on Freebsd and having
a database on a NT 4 linked drive, using Samba (the drive was
same results and both varying between .01, .02 seconds to execute.
6 of one half dozen of another or is there an advantage to one?
My guess is that the second syntax is preferred given the reduced row count
for events in it's explain table.
The first statement uses left joins, the second use's
In the last episode (Jan 15), Doug Beyer said:
It's my understanding that embedded selects are NOT allowed in MySql. Is this
correct?
Example:
SELECT t1.*
FROM table1 t1
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Correct. Your example can easily be converted to a join,
Do you mean that you want all units to appear, even if they have items
not defined (like having 4 defined and the other 5 with no value) ?
If is that, you may try using LEFT JOIN, instead of INNER JOIN.
Columns which are not defined will appear NULL (I did not test this):
SELECT u.name,
On Wed, 15 Jan 2003 11:00:21 -0600, Neil Aggarwal wrote:
Hello:
As the root user, I created a new database and user account:
CREATE DATABASE newsletter;
GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass';
FLUSH PRIVILEGES;
I then tried to access the databse via the
How do you query the table that is the results of a query?
Must you ask MySQL to...
...create a temporary table form the results of the first query
...then query that temporary table
...then delete the temp table when you are done?
(and if so how do you ask MySQL to create a temp table from the
you are correct - subselects are NOT allowed until version 4
until then:
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 ON t1.id = t2.id
OR
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 USING (id)
-Original Message-
From: Doug Beyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January
Neil,
GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY
'testPass';
FLUSH PRIVILEGES;
I then tried to access the databse via the command-line client:
/usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter
And I get this error:
ERROR 1045: Access denied for user:
Hi,
A very evasive description.
- Original Message -
From: PC Systems [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 15, 2003 8:03 PM
Subject: error report using mysql 3.23.49 max
Dear Sirs.
We are programers in Brasil and we are currently conducting tests with
MySQL
Il mer, 2003-01-15 alle 17:48, Paul DuBois ha scritto:
Hard to say. Even if that syntax was legal, the logic doesn't
make sense. What does it mean to be greater than or less than
a pattern that has a match-anything wildcard at the beginning.
That completely negates any possible
I've got a large test database and a recent backup made
with mysqldump. I've been deleting records from it and
would like to get back where I started. The easiest way
is to drop database, create database, and then input
from the mysqldump backup file. To automate it and make
it quick I do it like
GRANT ALL PRIVILEGES ON newsletter.* TO 'newsletter'@'localhost' IDENTIFIED BY 'testPass';
Neil Aggarwal wrote:
Hello:
As the root user, I created a new database and user account:
CREATE DATABASE newsletter;
GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass';
FLUSH
Thanks, I check it out.. Any idea if this 'deficiency' is scheduled to
change?
Thanks,
Gabe
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 9:49 AM
To: Gabe Geisendorfer
Cc: [EMAIL PROTECTED]
Subject: Re: NOT NULL question
On Wed, Jan 15, 2003 at 07:18:46AM -0700, Tyler wrote:
Can someone please guide me in uninstalling all the failed installs of MySQL
I've got? I've installed like 2 binaries, and 1 source.. none work :(
Dear Tyler,
You will need to be more specific. What operating system did you do
the
Try this:
SELECT * FROM MyTable WHERE RefList not regexp (^|[^0-9])MyNum([^0-9]|$);
Regards
Salam
Jeff Snoxell wrote:
Hi,
I've got a varchar field in a mysql table that contains 'N' numbers
(each a maximum of 4 digits, not zero padded) separated by spaces when
more than 1 number is
Will PhpMyAdmin do more than simply create a MySQL db ?
Please cc me directly on any post at [EMAIL PROTECTED]
Thanks for any help.
Will
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On 15 Jan 2003, at 13:03, Stefan Hinz wrote:
I believe there is an extra byte for the 'null' flag; if you declare
this column to be NOT NULL, I'll bet the avg length will be 10.
nice bet, but you lose g:
In addition to the bitmap for which columns have null values (if
there are any
SELECT SUM( price ) from sys_bld_foo where catNum IN ('item1', 'partA',
'partB') group by catNum;
Ken Easson wrote:
hello,
I have a list of things ('item1', 'partA', 'partB', 'partB')
which relate to catNum items in a table sys_bld_foo.
table sys_bld_foo:
component: varchar 16
catNum:
Hi list,
I'd like to try out the OpenSSL support of MySQL, but I could not find
out how to enable it.
The documentation just says, Configure MySQL with --with-vio
--with-openssl.
Since I do not compile my MySQL binaries myself, this is impossible to
me...
Instead I'm using the Lnux binary RPMs
Hello,
I found more following messages in my mysql log:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning
On Wed, Jan 15, 2003 at 11:24:05AM -0800, Jeff Kilbride wrote:
By updated you mean inserts? Or are you doing a table scan for each
update (since they're not indexed)?
No, they're actual updates (UPDATE table SET field=value WHERE
primary_key=value2). The field being updated is not an
SELECT DISTINCT price FROM sys_bld_foo WHERE catNum IN
('item1', 'partA', 'partB', 'partB');
is a valid SQL statement from all i can see
my return value ignores the second partB - and my price is short.
i dont understand what you mean by 'short'
you comment that if you remove the DISTINCE
http://www.listsearch.com/mysql.lasso
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
Rafal Jank wrote:
On Wed, 15 Jan 2003 11:02:44 +1100
vinita Vigine Murugiah [EMAIL PROTECTED] wrote:
HI
I'm not sure what is wrong with my CREATE TABLE syntax, Please advice
There is no index on ifname in table equipment_interfaces.
Well.. Then how come Foreign key equipID in table
If you're in Java you can call getMetaData on the ResultSet, and then call methods on
that (ResultSetMetaData) to determine number of columns, and type of each column.
This avoids the steps of creating/deleting a temp table.
What language are you using?
From: Will Standley [EMAIL
1 - 100 of 135 matches
Mail list logo
