hi,
I upgraded from the gcc-2.96 because of warnings in the notes about possible bugs, so
I got the newest redhat gcc package which is gcc-3.2.1-1.i386.rpm. I also upgraded to
glibc-{devel common utils}-2.3.1-6 and am trying to compile the new mysql-4.0.9-gamma
and am running into problems wit
On Thu, 16 Jan 2003 [EMAIL PROTECTED] wrote:
> sql,query,queries,smallint
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Licensed Texas Peace Officer
Computer Crime Investigation Consultant
Director, Software Development
Escapade Server-Side Scripting Engine Deve
hi all,
i get the following error logdid anyone try to compile mysql with ssl before?
030116 14:34:13 InnoDB: Started
/usr/local/mysql-4.0.9-gamma/libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of t
hello,
how can i view privileges for a table in a db? thank you, addison
sql,query,queries,smallint
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMA
Hi Russell,
You don¹t have a suitable compiler installed.
For everything you need to know regarding installing MySQL on OS X go to
http://www.entropy.ch/software/macosx/mysql/
Here you will find preconfigured mysql installs for OS X, plus step by step
instruction on how to get it up and running
You can use --skip-name-resolve when starting mysqld, but this is not a real
solution.
Even doing that,'I'm still having some odd problems I never had before, like
table corruption (I'm on 4.0.8 though)
- Original Message -
From: "Patrick de Kievit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
>My feeling is that MySQL shouldn't allow reserved words / characters
>like this, whether they are in quotes or not.
...
>Does anyone know the logic behind allowing reserved words when inside
>quotes like this? It clearly causes problems - especially for people
>using GUIs - and these people will b
> you can do this:
>
> mysql> set password for newsletter@localhost=PASSWORD("testPass");
>
> or
>
> mysql> update user Set Password=Password("testPass")
> -> where user="newsletter";
Don't forget the "flush privileges" thing after the update command.
> __
>/ \\ @ ____
What about just issuing a PURGE MASTER LOGS TO master-bin.007 on the master
and then starting the slave without a master.info file? I think that will
recreate it for you -- but you should research this before trying...
--jeff
- Original Message -
From: "James Fidell" <[EMAIL PROTECTED]>
T
hello,
SELECT DISTINCT price FROM sys_bld_foo WHERE catNum IN
('item1', 'partA', 'partB', 'partB');
problem --|--|
partB is duplicated in the IN list. i need IN to find a DISTINCT price for EACH
element in the list.
Gerald's solution i think gives me the same incorrect sum
Russell,
Sounds like you don't have developer tools installed. You need the developer
tools to build mysql on OSX. Though I think you can get hold of a pre-built
distro as well - try versiontracker to find the link.
Peter
> This is my first time installing MySQL.
>
> I'm attempting to install M
> >
> > 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 'supervise' so as to make sure its always there and
> > restarts if it gets killed / dies / is stupid / upgraded.
>
> Right. I sho
Keith,
> There's a formula to calculate the row length for dynamic MyISAM
> tables here:
>http://www.mysql.com/doc/en/Dynamic_format.html
Thanks for the hint, but this doesn't explain fixed length row
calculations where char(10) will give an average row length of 11
(bytes), or does it?
Rega
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 ha
Where does mysql places the databases in 4.0.9 when installing from source?
The var directory does not seem to be there anymore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
I'm trying to determine the more efficient syntax between a left join and
this other thing, maybe its a cross join or just a join. I used explain and
the left join has more NULL Keys but seemingly less rows to look at. Are
the multiplied number of rows pretty much the word on efficiency. They both
Hi all,
I'm encountering some problems with code on a PHP/MySQL driven site. It's a
long story to document, but the end result is that I have to look at my
entire code library looking for problems :)
One area that I'm seeking further knowledge about is how MySQL behaves under
load. I have a sm
If I understand you correctly you like to have the result for the specific table in
your mail to look like this:
200 <-- this is the total price of item1 (1 * 200)
150 <-- this is the total prices of partAs (2 * 75)
300 <-- this is the total price of partBs (2 * 150)
for this you are better o
For reasons too boring to warrant going into here, I have
a slave server which is synchronised with the master up to the
very start of binary log 007, but I have no valid master.info
file.
I don't want to stop the master if at all possible. All I want to
do is to re-create a suitable master.info
Hi Steven,
Shame on me, but I have no idea what the output of iostat tells me -- though
I know I should. Can you point me to a good reference to flesh out the man
page?
I have 2 18GB Seagate drives -- from dmesg:
Vendor: SEAGATE Model: ST318406LC
(scsi0:A:0): 160.000MB/s transfers (80.000MHz D
I am trying to install MySQL 4.0.9 from source on AIX 5.1. I used gcc 3.2.1
as compiler. Here is my configurations:
CC=gcc CFLAGS="-O2 -mcpu=powerpc -Wa,-many"
CXX=gcc CXXFLAGS="-O2 -mcpu=powerpc -Wa,-many -felide-constructors
-fno-exceptions -fno-rtti"
./configure --prefix=/us
On Tue, Jan 14, 2003 at 01:22:32PM +0100, harm wrote:
> Hello,
>
> Because I switched some large tables back to myisam from innodb (sorry
> Heikki) my innodb datafile has a few gig 'empty'. I would like to reclaim
> that space.
>
> Can I expect a problem if I:
> - make _all_ innodb tables myisam
Hi all,
I'm encountering some problems with code on a PHP/MySQL driven site. It's a
long story to document, but the end result is that I have to look at my
entire code library looking for problems :)
One area that I'm seeking further knowledge about is how MySQL behaves under
load. I have a sm
This is my first time installing MySQL.
I'm attempting to install MySQL on my Apple PowerBook G4 OSX 10.2.
After downloading and unpacking mysql-3.23.53.tar.gz, my attempt to
run ./configure failed.
I'm including content from config.log, any help you might have would be
appreciated.
--
I use ext3 and have a qps of anywhere from 2800-8000 and use the
defaults with no problems. Have you tried:
iostat -k 1
to look at your disk access? What kind of disks are they anyhow? IDE or
SCSI? RAIDed? In what fashion?
Lastly, you said that this is a script that is running, right? The tab
On Wed, Jan 15, 2003 at 03:47:33PM -0500, Will Standley wrote:
> Will PhpMyAdmin do more than simply create a MySQL db ?
>
> Please cc me directly on any post at [EMAIL PROTECTED]
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawo
please look at page 194 of the reference manual...
>(and if so how do you ask MySQL to create a temp table from the
> results of aquery?)
here's an example:
mysql> create temporary table tmp (name varchar(20), owner varchar(20, species
varchar(10));
mysql> insert into tmp select name, owner,
Hello.
Please start a new thread instead of replying to an existing one. Or
else, your message will be sorted with the original thread for people
with decent mail readers.
On Wed 2003-01-15 at 14:42:05 -0500, [EMAIL PROTECTED] wrote:
> How do you query the table that is the results of a query?
B
it looks as though you have created the newsletter user with plain text password.
mysql will compare the user password against the encrypted password and will fail.
you can do this:
mysql> set password for newsletter@localhost=PASSWORD("testPass");
or
mysql> update user Set Password=Password
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
> you are correct - subselects are NOT allowed until version 4
Subselects will be available in version 4.1
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Developing Dynamic Web Applications
Lynn David Newton wrote:
It's the first KEY definition it doesn't like. If I
comment out "KEY field(field)," it works, except of
course then the field called 'field' is not set as an
index. The same exact problem occurs in two places in
the mysqldump file. With them commented out the DB
reloads.
This old bug reappeared after the upgrading mysql from version 3.23.54a
(rpm provided by mysql.com) to version 4.0.8-gamma (binary provided by
mysql.com as well).
Using redhat 7.1 glibc 2.2.4-31 (which is supposed to fix this problem)
This server has glibc 2.2.4-31 installed for quite a while, a
Hi all,
Pure randomly my server tells me the its
Lost connection to MySQL server during query at ...
This all happened after my upgrade to version 3.23.54. I searched google
and read some threads here.
A possible solution is to DOWNGRADE some libc files? Tell me is this the
only solution ? I
It depends on what kind of comparing you will be doing. Text is
case-Insensitive for comparisons, blob is case-Sensitive.
Generally I find that for pure text, TEXT type is better. For files and
texts that need to be compared case-sensitively, use BLOB.
Either way, for images, and any other bin
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
> you are correct - subselects are NOT allowed until version 4
4.1 as opposed to 4.0.x.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 3.23.51
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 PROTECT
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
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]>
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 t
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
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 ha
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 (
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: varchar
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 :
In addition to the bitmap for which columns have null values (if
there are any c
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)
http
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 prese
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 i
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
Hello
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 PR
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
>
> 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 neg
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 wi
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:
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, Janua
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 r
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 t
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, item1.nam
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,
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 Bre
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
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 |
- 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:
> > A
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
righ
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 WHE
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
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 p
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. Zawod
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'
'3'
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 sel
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
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 statio
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'
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 statio
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
-
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 kno
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 check
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 -
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 T1
>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: /home/mysql/
> >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
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,
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
-Ori
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 records
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
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
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
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
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 d
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
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 tr
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 the
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 th
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 re
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
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
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);
}
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,
>
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 k
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 i
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: Undefine
1 - 100 of 135 matches
Mail list logo
