Hello,
I am writing this e-mail just to ask about the following:
I plan to implement some data storage in flat ASCII files. I want to work with SQL in
order to automate requests from/to the files. Can I use MyODBC in order to work
against flat files? If yes, what do I need to install (can I just
Zeno wrote:
Thanks, Brent. I did read about the REPLACE command, but I only want
to change one field (a simple flag) in the main_table. With REPLACE,
I cannot even copy the rest of the fields into the new record because
it does not offer any access to the existing fields.
It may seem strang
Then this should work.
SELECT remote_user, substring_index(remote_host,'.',3)
AS ip_subnet
FROM password_log LEFT JOIN exclude_log ON
substring_index(password_log.remote_host,'.',3) =
exclude_log.ip_block
WHERE remote_user != '-' AND status=200 AND
ip_block IS NULL
GROUP BY ip_subnet
ORDER BY rem
Hallo.
What is faster:
1) Making about 80 different(!) updates
2) Making one REPLACE kinda REPLACE INTO table VALUES (a,b),(c,d)...
on a MYSAM table.
P.S. Of course i'm locking table :)
P.S.P.S.
--
Have a nice day.
-
Befor
Play with the --batch and --skip-column-names options to the mysql client:
# mysql -uroot -p -h`hostname` --batch --skip-column-names
Enter password:
show databases;
mysql
Hope this helps.
Atle
On Thu, 19 Dec 2002, Scott Haneda wrote:
> And finally, the main question,
> mysql> show databas
- Original Message -
From: "Fabiana Garfunkel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 20, 2002 7:18 AM
Subject: question: saving a file into a field of a table
> Hello, my name is Fabiana Garfunkel, and I´m new in MySQL developing.
>
> I have a punctual questi
Have you checked that your network/database administrator has given you
write access to this database?
Phil.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 6:48 PM
To: [EMAIL PROTECTED]
Subject: Tables read only
i cant create
Having built several Linux boxes on slower macs I can atest that linux on a slower mac
(uing linuxppc or one of the other variants) is way faster than my terminal window is
on my dual 1.25 gig processor G4. Just accessing commands are slower on the new mac.
This surprises me as unix is the base
I'm trying to figure out how can I do this:
I'm designing a mysql db for a delivery service, and I encounter a problem
each item delivered has a code associated
and it also does some querys in other associated tables, I mean:
Prod ID = 11 Prod = PizzaRecipeID=01 REcipe has the ingredi
At 19:54 19/12/2002 -0400, Adolfo Bello wrote:
Hi,
There is not link to download the Windows version.
http://www.mysql.com/Downloads/MySQL-Max-4.0/mysql-max-4.0.6-gamma-win.zip
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]>
/
anyway to solve this SQL problems?
-
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]>
To un
i cant create SQl tables andoso cant del the tables.. it always shows
table is read only.. anyway to solve?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
I guess you need something like
SELECT * FROM password_log t1 LEFT OUTER JOIN exclude_log t2 ON
t1.remote_host=t2.ip_block WHERE t2.ip_block IS NULL;
I am just guessing that both tables are related through remote_host and
ip_block,
Adolfo
On Thu, 2002-12-19 at 17:31, Eric Anderson wrote:
> If I'
Actually, I think the behavior comes from the components used to connect
to MySQL. Delphi doesn't really care one way or the other.
Dan Cumpian
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 1:41 PM
To: [EMAIL PROTECTED]
Cc: Dan Cumpia
platform: windows 2000 pro, mysql default table type myIsam, non-binary
distribution (install version).
I am still getting very slow query results when I join multiple tables
together. I have been trying to figure this out for days and am at a loss. I
added an index to my cross reference table
mysql client connectiosn work fine on localhost, but connections
from other hosts on local area network fail with the following error:
ERROR 2013: Lost connection to MySQL server during query
This is an existing installation. I had mysql-3.23.33 working
and was trying to upgrade to a more curr
I am looking for an expert opinion on the speed difference between fetching
related data from 2 tables with a join and fetching them in to single
selects.
The scenario is kind of the following:
SELECT a , b, c FROM table1 WHERE a='x'; # gets b='y'
SELECT b, d , e, f FROM table2 WHERE b='y';
inst
Hello,
I working on a small my project to learn more about joins. I have three
tables here is what they look like
CREATE TABLE `album` (
`album_id` smallint(3) NOT NULL auto_increment,
`name` text NOT NULL,
`description` text NOT NULL,
`img_id` smallint(5) NOT NULL default '0',
PRIMARY KEY
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002, Maximo Migliari wrote:
> I would like to know where I can find the change log for the new versions
> of MySQL.
> For example, just recently .54 was released, and then .54a. There is a
> ChangeLog file in the distribution, but at
There is not link to download the Windows version.
Any date for the Windows version to be published?
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I lister was kind enough to show me
echo "show databases" | mysql -N
But there are still some remaining questions I have been searching for
answers to for a long time. Any help appreciated,
Hello all, I have dug through the archives to no avail, the archives point
to many ways to back up your dat
Well, thanks to all of your great help! I am able to
speed up the query {select count(*) from NEW_Sequence
s left join NEW_Sequence_Homolog h on s.Seq_ID =
h.Seq_ID;} from 1 min 52.61 sec down to 20.62 sec now.
The only thing I changed so far was the Seq_ID from
type varchar to bigint. The Seq_ID w
Hello, my name is Fabiana Garfunkel, and I´m new in MySQL developing.
I have a punctual question: I need to save a zipped file into a field of a
table. The question is:
1- is it possible to save a file into a field of a a table ?
2- if the answer is YES, which is the proper type of field for this
btw, regarding my last post, i'm running mysql 3.23.53-max-nt...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-
I'm not surprised OSX is slower than Linux. Apple still has a way to go
toward fully optimizing the Unix underpinnings for their hardware. They
are also a few versions behind in the BSD they are using. I'm presuming
you have similar settings for each setup.
As for the "processes" you see on Lin
hi, wonder if the sql gurus can help with this one. i have two tables
(simplified), tblAccounts and tblAccountsServices. tblAccounts has an ID
(PK) and an accountNumber, and tblAccountsServices has an ID (PK) and
accountID (FK to tblAccounts.ID). i want to run a query that gives me a row
for eac
Does any one have any advise about clustering and replication
with of course mysql. Are there any third party products?
Sam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
On Thu, 19 Dec 2002 15:50:18 -0500, Brent Baisley wrote:
Thanks, Brent. I did read about the REPLACE command, but I only want
to change one field (a simple flag) in the main_table. With REPLACE,
I cannot even copy the rest of the fields into the new record because
it does not offer any access to
>
> At 8:06 -0800 12/19/02, mustakim abas wrote:
> >Hello, i am new in mysql. I got a problem. I try write
> >my C program with mysql API.I have 5 field in
> >table.No,Name,Phone,Date,Time. How can i take one row
> >where the No is bigger?
> >Thanks for help.
>
> Bigger than what?
>
Maybe
SEL
If I've got the following two tables:
CREATE TABLE password_log (
time_stamp int(11) unsigned NOT NULL default '0',
remote_host char(15) NOT NULL default '',
remote_user char(50) NOT NULL default '',
status smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (remote_host,remote_user
Hi:
I know how to save a query using mysqlgui. How do I load a query?
Thanks.
EV
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I guess you're not a subscriber of the MySQL Newsletter. Subscribe to it -
it's very useful!
Your question was answered a couple of days ago in ta newsletter article:
http://www.mysql.com/newsletter/2002-12/a91.html
Regards,
Iikka
On Th
Have you tried looking into the REPLACE command? It basically does an
update if the record is present or an insert if it's not, but all in one
command. Since MySQL won't update a record if you are trying to update
it with data that is unchanged it should be pretty fast.
On Thursday, December 19
On Sunday, December 15, 2002, at 03:43 PM, Helmuth Lutz wrote:
First, from where did you install MySQL? Are you using OS X Server? If
so, MySQL came installed with your system and you shouldn't have a
problem with it. So I'm assuming you're using the client.
Does anybody have an idea:
- WHY do
Yes, that's intentional - we have changed this in 4.1, but it's not
documented in the manual yet. A quote from the developer working on that
code:
So, the PASSWORD() function is now not to be used for passwords? The
problem is that I have built at least a few applications that use
PASSWORD() as
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 19 Dec 2002, Maximo Migliari wrote:
> So if I just untar the new .54a release, and just copy the safe_mysqld
> script to my current .54 release, it will work fine?
Yes, that is sufficient.
> Or do I have to re-install everything?
No, t
Michael,
> InnoDB: Error: table ./m4m4sex/Pilot has no primary key in InnoDB
> InnoDB: data dictionary, but has one in MySQL!
these messages below derive from this bug fix:
"
MySQL/InnoDB-3.23.54, December 12, 2002
...
Fixed a bug: ORDER BY could fail if you had not created a
primary key to a ta
Select max(No) from table
Marcos Henke
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "mustakim abas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, December 19, 2002 1:51 PM
Subject: Re: help me, please
> At 8:06 -0800 12/19/02, mustakim abas wrote:
> >Hell
I want to run mysqldump through a batch process, in
order to do that what prive do i need to give to the
user. It will be running as a cron job, i don't want
to give any creation or deletion authorization. Your
help will be greatly appreciated.
Regards
Arun
___
Hi!
InnoDB is a MySQL table type which provides to MySQL transactions, row level
locking, foreign key constraints, and a non-free hot backup tool.
InnoDB is included in all MySQL-4.0 downloads and MySQL-Max-3.23 downloads.
You can download them from http://www.mysql.com.
MySQL AB decided to rele
I upgraded a very high load site from 3.23.51 to 3.23.54a.
The upgrade seems to have gone fine, but some really odd
messages appeared in the error log:
InnoDB: Error: table ./m4m4sex/Pilot has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
InnoDB: Error: table ./m4m4sex/Pi
Greetings
What do you mean server part of MySQL. SQLyog allows you to perform almost
all operation which MySQLAdmin does except starting and shutting down a
MySQL server, which probably SQLyog will have in one of its future releases.
Insane
- Original Message -
From: "Stan Sebastian" <[E
On 19 Dec 2002, at 12:19, Andrew Kuebler wrote:
> When I run an INSERT. SELECT query and I am inserting the records into a
> new table that has a UNIQUE key, the statement will fail as soon as it
> hits a "Duplicate entry" error.
You probably want to use "INSERT IGNORE":
http://www.mysql.com/
>Description:
After ugrading from MySQL-Max-3.23.53 to 3.23.54, mysqld failed to start.
Error message was:/usr/sbin/mysqld-max: unrecognized option
`--innodb_log_files_in_group=3'.
This option required for Innodb Hot backup!
>How-To-Repeat:
Just upgrade MySQL-Ma
At 20:21 +0100 12/17/02, Csongor Fagyal wrote:
Hi,
I have two tables: one holding bids for an auction (table bids) and
one holding user data who placed the bids (users). I would like to
get the highest bid, the user who placed the bid and the number of
bids placed, so I use the following query
At 8:12 -1000 12/17/02, <[EMAIL PROTECTED]> wrote:
Hello all,
I have checked the mailing list and the documentation but have been
unable to find any information regarding the level of support for
MySQL on the MacOS 10.2 platform. After moving a production database
from a linux to MacOS 10.2
At 12:19 -0500 12/19/02, Andrew Kuebler wrote:
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a "Duplicate entry" error. No further entries will be inserted. The
only way I know to get around this
At 13:23 -0500 12/19/02, <[EMAIL PROTECTED]> wrote:
Well, the only basis I have is personal experience from connecting to a local
MySQL database. The components I use for connecting to MySQL with Delphi does
cache the records as the server returns them. However, not all the records are
returned at
At 13:08 +0100 12/19/02, Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Dyego Souza do Carmo <[EMAIL PROTECTED]> writes:
Dobrý den,
quarta-feira, 18 de dezembro de 2002, 13:10:07, napsal jste:
MTB> Qunfeng Dong wrote:
Another thing, with some linux system, there is a size
limit for
I am looking at an application that will be could be potentially
writing hundreds of records a second (syslog) to a MySQL database.
I expect to reach millions of records (if not billions) in time.
I will be doing a variety of types of queries on the data which
will be anything from summarization
Well, the only basis I have is personal experience from connecting to a local
MySQL database. The components I use for connecting to MySQL with Delphi does
cache the records as the server returns them. However, not all the records are
returned at once. As I said, it depends on how one connects to
At 11:01 +0100 12/19/02, Gianluca Carnabuci wrote:
Hi,
I've been trying to import a huge .txt file into a MySql table. In
the .txt file, missing values are recorded as empty cells (it might
be that there's some hidden character instead, but I wouldn't know
how to figure that out). When I LOAD
At 15:00 -0300 12/19/02, Maximo Migliari wrote:
Hello there,
I would like to know where I can find the change log for the new
versions of MySQL.
For example, just recently .54 was released, and then .54a. There
is a ChangeLog file in the distribution, but at least to me, it is
TOTALLY incompr
In the last episode (Dec 19), Neal Dawson said:
> We are currently running MySQL on RedHat Linux with great success.
> However, we are upgrading our Netware servers to Netware 6. I know
> MySQL ports to Netware 6, but I am wondering how MySQL actually runs
> on Netware 6. Is there anyone out the
At 9:36 -0800 12/19/02, Troy Kruthoff wrote:
> At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
> >Description:
> Invalid reporting of date calc
>>How-To-Repeat:
> note: SESSIONTS is TIMESTAMP type
>
> SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
What leads you to expect that t
Couldn't figure out what the option "FOR UPDATE" does in a SELECT
statement unless it's just to lock the table. Spent the last few
hours trying to get subqueries to work only to find that the reason
they're not working is not just due to my abominable syntax.
What I'm doing is getting messages fr
Neal,
- Original Message -
From: ""Neal Dawson"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, December 19, 2002 7:04 PM
Subject: MySQL Netware vs Linux
> Hi,
>
> We are currently running MySQL on RedHat Linux with great
> success. However, we are upgrading o
Hello.
I am setting up a quad xeon server that is dedicated for mysql. All
access will be via jdbc.
Are there any gotchas or performance bottlenecks in the configuration that
I can change to insure that the full capabilities of this hardware are
available for mysql?
Thanks!
Phillip
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Bigger than what?
---
On Wednesday 18 December 2002 16:49, Alexis Antonakis wrote:
> I posted this a few days ago, but haven't seen a reply as yet, and I'm
> getting quite desperate now!!
>
>
> I've managed to delete all the records in a table, well haven't we all done
> it sometime!, and was wondering whether it's pos
On Wednesday 18 December 2002 17:18, you wrote:
> At 16:57 18-12-02 +0200, you wrote:
> >On Wednesday 18 December 2002 11:36, Wico de Leeuw wrote:
> > > I've setup replication with a master-slave.
> > > But i only want to replicate some databases so i'd put in my.cnf on the
> > > slave (it's being
At 10:35 -0500 12/19/02, Deepa wrote:
While creating InnoDB tables, I was not able to specify a "fulltext "
column in the table creation sql. Is this a bug or a limitation with InnoDB
? There could be quite a few users who need FULLTEXT feature with InnoDB.
It's like the manual says: FULLTEXT i
> > At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
> > > >Description:
> > > Invalid reporting of date calc
> > >>How-To-Repeat:
> > > note: SESSIONTS is TIMESTAMP type
> > >
> > > SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
> >
> > What leads you to expect that this should yield any
At 13:08 +0100 12/19/02, Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Dyego Souza do Carmo <[EMAIL PROTECTED]> writes:
Dobrý den,
quarta-feira, 18 de dezembro de 2002, 13:10:07, napsal jste:
MTB> Qunfeng Dong wrote:
Another thing, with some linux system, there is a size
limit for
At 15:13 + 12/19/02, Jeff Snoxell wrote:
At 09:46 19/12/02 -0500, you wrote:
Jeff Snoxell wrote:
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
Are you using InnoDB tables? You'll have to do something akin to
ALTER TABLE my_table AUTO_INCREMENT=1 ... at least accordin
The way I do it is to call mysqldump.exe from perl, granted it's not the most elegant
way but it's certainly the fastest (to code). Just do:
---
# name or IP address of dbmachine
my $DB_server = localhost.localdomain.tld
# db login authorised to do db dump
my $DB_User = sa
# location and name
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a "Duplicate entry" error. No further entries will be inserted. The
only way I know to get around this is to pull the entire column(s) into
memory and
Jeff,
Here is a piece of my backup script. Its been modified from Unix world to
windoze world ( because at this point I
am working in that environment - seeking to return to Unix if anyone has a
gig )
=pod
=head1 Script: mysql_backup.pl
=head2
=over 4
=item 1
This script builds a db dump fil
On Thu, 19 Dec 2002, mustakim abas wrote:
> Hello, i am new in mysql. I got a problem. I try write
> my C program with mysql API.I have 5 field in
> table.No,Name,Phone,Date,Time. How can i take one row
> where the No is bigger?
> Thanks for help.
Provided I understand your question, then I would
On Thu, 19 Dec 2002, Deepa wrote:
> While creating InnoDB tables, I was not able to specify a "fulltext "
> column in the table creation sql. Is this a bug or a limitation with InnoDB
> ? There could be quite a few users who need FULLTEXT feature with InnoDB.
It's a feature :-(
FULLTEXT has not y
select * from your_table order by no desc limit 0,1
> -Original Message-
> From: mustakim abas [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 19, 2002 12:07 PM
> To: [EMAIL PROTECTED]
> Subject: help me, please
>
>
> Hello, i am new in mysql. I got a problem. I try write
> my C p
Hello there,
I would like to know where I can find the change log for the new versions
of MySQL.
For example, just recently .54 was released, and then .54a. There is a
ChangeLog file in the distribution, but at least to me, it is TOTALLY
incomprehensible. Isn't there a simple file that says s
> I'm a lurker on this list but I have decided to come out of my shell for a moment. I
>a previous job I was the Oracle DBA for my development team. We had a persistent
>problem with Oracle corrupting the development database. Oracle had no idea with the
>problem was even after I sent them a cop
Hi all,
I've some problem with my Mysql servers since the beginning of this week.
I've got plenty of error like this :
Failed to connect to database: Error: Access denied for user:
´[EMAIL PROTECTED]´ to database ´DB1´
MySQL server has gone away
Error Nø1, please contact webmaster ...
In fact, c
hi,
here is the problem ...
think about this :
serverR1 / serverR2 : replication servers
serverWWW : webserver
serverWWW reads/writes data from/to serverR1
serverR2 replicate serverR1 data
serverR1 crashes
serverWWW reads/writes data from/to serverR2
serverR1 (up) replicate serverR2 data
the go
Hi,
We are currently running MySQL on RedHat Linux with great
success. However, we are upgrading our Netware servers to Netware
6. I know MySQL ports to Netware 6, but I am wondering how
MySQL actually runs on Netware 6. Is there anyone out there running
MySQL on Netware 6? If so, how's goi
Hi,
is there an easy way to programmatically backup MySQL database tables using
Perl? My Perl code will be running on a machine remote to the MySQL server.
Ta,
Jeff
-
Before posting, please check:
http://www.mysql.com/manua
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Afforda
Hi Guys,
I'm a lurker on this list but I have decided to come out of my shell for a moment. I a
previous job I was the Oracle DBA for my development team. We had a persistent problem
with Oracle corrupting the development database. Oracle had no idea with the problem
was even after I sent them
While creating InnoDB tables, I was not able to specify a "fulltext "
column in the table creation sql. Is this a bug or a limitation with InnoDB
? There could be quite a few users who need FULLTEXT feature with InnoDB.
-
Before
replace missing value (NULL) as \N in your .txt file
--- Gianluca Carnabuci <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've been trying to import a huge .txt file into a
> MySql table. In the .txt file, missing values are
> recorded as empty cells (it might be that there's
> some hidden character inste
At 09:46 19/12/02 -0500, you wrote:
Jeff Snoxell wrote:
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
Are you using InnoDB tables? You'll have to do something akin to ALTER
TABLE my_table AUTO_INCREMENT=1 ... at least according to Paul ... :)
No, I'm using MyISAM I belie
When you mentioned the number of bytes, is that just the data part of the
table, or the index as well? You didn't mention if your schema was indexed
one way or another.
Cheers.
-Dana
> -Original Message-
> From: Joseph Bueno [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, December 19, 2002 8:
You can specify a varchar field as binary, for instance: field1 varchar(50)
binary
query, sql
Mike
-Original Message-
From: asp52 [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:50 AM
To: Mike Grabski; [EMAIL PROTECTED]
Subject: Re: Case sensitivity
Thanks,
Just worked
See http://www.mysql.com/doc/en/CHAR.html or
http://www.mysql.com/doc/en/BLOB.html .
If your column types are CHAR or VARCHAR insert BINARY.
If your column type is TEXT, change to BLOB.
--
You said
Hi,
I have been search
Thanks,
Just worked it out with binary statement in my query.
all fine.
Would it be wise to use binary type table?
didnt try that as i wanted a flexible table of type varchar to perserve
space.
what would be its impact?
cheers.
Adamji
From: "Mike Grabski" <[EMAIL PROTECTED]>
To: "'asp52'" <[EMA
mysql needs a few more bytes per record for its internal use.
Since you use a VARCHAR, you have dynamic length records;
this is described in the manual:
http://www.mysql.com/doc/en/Dynamic_format.html
Regards,
Joseph Bueno
Andrew Kuebler wrote:
> I have a table with 17,168,035 records. I have the
You have two choices, you can use a binary datatype for the field, or force
a binary comparison using the BINARY operator.
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
http://www.mysql.com/doc/en/Column_types.html
query, sql
Mike
-Original Message-
From: asp52 [mailto:
Hello ... my name is Brent ..and im using the latest version of mysql
on a Freebsd box with apache & php3 & php4. My problem is that ive set a
password for the root mysql user by doing:
/usr/local/bin/mysqladmin -u root password 'x'
then i installed phpMyAdmin ..and set the correct username &
Hi,
I have been searching tables based on search values which turn up tobe fine,
however the results dont reflect case sensitivity.
what i mean,
if i run following query
select field1 from table1 where name='text1';
this works fine but returns the same result set with text1 values of 'USER'
or
Why isn't Seq_ID not an unsigned int? Primary key should always be
something generated by the system that has no other significance than
being a primary key. If there actually is a seq_id piece of data that
has some other significance, I wouldn't use it to link all your data.
Then you don't hav
I guess 'new' is a relative term. I started using it in 1995 or so. It's
true that Oracle and DB2 have been around a lot longer, but MySQL isn't a
spring chicken.
Cheers.
-Dana
> -Original Message-
> From: Michael She [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, December 18, 2002 2:36 PM
Did you optimze the table first?
warning optimize could take long (and i think the table is locked while
doing it)
Gr,
Wico
At 08:26 19-12-02 -0500, Andrew Kuebler wrote:
I have a table with 17,168,035 records. I have the following column
types and I read about the following storage requiremen
I have a table with 17,168,035 records. I have the following column
types and I read about the following storage requirements for each
column:
(1) INT Column - Should take up 4 bytes each
(1) MEDIUMINT Column- Should take up 3 bytes each
(1) DATE Column - Should take up 3 byte
Hi!
Mark> Hi,
Gary> I'd like to add to the "security flaw" thread with my own experience.
Gary> I have been hosting MySQL databases for over 2 years and on a few occasions
Gary> have had user databases disappear.
Gary> Last month one of my admin databases was dropped. The only user
Hi,
The performance problem on his query was due to the missing index on join
columns.
However I was assuming using table1 INNER JOIN table2 ON condition would
have helped the optimiser to choose the tables on which it had to perform
the join.
Regards,
Jocelyn
- Original Message -
From
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Nicholas Gaugler wrote:
> Thanks, I downloaded it and it all works fine now, the whole bin
> directory is statically linked.
Thanks for the confirmation! Glad it works now.
Bye,
LenZ
- --
For technical support contracts
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002 [EMAIL PROTECTED] wrote:
> >Description:
> with the latest 4.1 tree (from today) the PASSWORD() function returns random
>alpha-numeric text /[a-f0-9]/
> 45 characters in length (which is too long for a password string)
mysqlhotcopy always worked fine with perl 5.6.1 (debian woody), but i had
to upgrade to perl 5.8 and now it croaks and dies with a segfault.
the problem exists only with mysqlhotcopy; other db-connections with
perl 5.8 and DBI/DBD::mysql are no problem.
at http://volltext.net/mysql/strace.txt yo
> Mysql server is working good for 5-10 minutes and then changes
> directory to /tmp - it starts telling ERROR 1049: Unknown database
> 'test'.
>
> Restarting the server helps for next 5-10 minutes. There are no errors
> in error-log, query log etc.
> SHOW VARIABLES still telling datadir from cnf
1 - 100 of 111 matches
Mail list logo