Jim,
Situation.. main table in a relatively small database. Table contains
approx 370K rows. Table is indexed on the unique identifier. New table,
fresh import of clean data.
Querying on a single field... run from the command line, returns 3 rows,
run from phpMyAdmin, returns 3 rows.
Grant,
I need help. I am building a database for a small college that wants to be
able to update their program information for each department through an
web/gui program.
I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
web page this way)
Here's my QUESTION!
Tim,
Normally PHP/MySQL doesn't run as mine, even if that is your Windows login
name - but it is possible...
Use command line.
Log on as root.
Check localhost privileges for user mine.
(good coverage in the manual)
Regards,
=dn
I have been trying to get mysql db to run but keep
getting access
Chandra,
I need some help in finding the time/day difference
as i want to know the session times
is there a way/function to calculate time difference
in mysql
Self help - from the foot of each list msg:
-
Before posting,
hi,
anyone has informations about any program that
implementing load balancing and hotswapping in a mysql
cluster system?
Thanks
__
Per te Blu American Express è gratis!
At 16:50 26/11/2002 +, [EMAIL PROTECTED] wrote:
Hi,
I'm running MySQL as a service on win2k and trying to insert data into a
database. Each time I try to do this I receive the following error:
ERROR 2013: Lost connection to MySQL server during query
The following error was shown when I
I running from the command line and using MySQL version 3.23.53. I've also
tried through .NET using MySQLDriverCS and have the same problem. I'm not
running WinMySQLadmin, I didn't know it existed I might have to look
into that!
Mark
-Original Message-
From: DL Neil [mailto:[EMAIL
Miquel,
Using version 3.23.53. Don't know what version the db I'm trying to access
was created on, but the tables are MYISAM. Example below. I also get the
same error using LOAD DATA and through .NET using MySQLDriverCS.
--
mysql describe main_categories;
Hi, All.
How can I add additional characters (Ukrainian alphabet) to the source code
for parse?
Thanks, Nick.
database,sql,query,table,handler,compile,ChangeSet
-
Before posting, please check:
This is correct, only two types of queries. Updating and Deleting.
=Can I assume that the information doesn't change frequently?
This is correct. The plan is to stream line the web site and get the
information out faster and cut out the red tape. We were thinking intern's
from each department,
Here's my QUESTION! Because some of the program information is
large I don't
want to query the data base everytime do I?
Define large? Are we talking mixed media types (PDF/Word/PowerPoint) or
plain text/HTML? As someone has already suggested, you might be better to
save the files on the
Grant,
This is correct, only two types of queries. Updating and Deleting.
=deleting is a trivial exercise, whether the data is held in a db or file.
=updating is more of an exercise for the content managers than it is for
you...
=Can I assume that the information doesn't change frequently?
I have a master/slave setup using MySQL 4.0.5beta on Solaris 2.8. I received the
following error on the slave :-
/usr/local/mysql_4.0.5beta/bin/mysqld: ready for connections
021126 18:48:19 Error in Log_event::read_log_event(): 'Event too big',
data_len=1297040128,event_type=111
Does anybody
* vinita vigine Murugiah
I'm using ver 3:23:49 3:23:53, I thought
A LEFT JOIN B USING (c) is Identical to A LEFT JOIN B ON A.c = B.c
I think it is...
It seems it is NOT the case if you are joining more that ONE table one
of them is EMPTY. Please see the following Example
[... excelent
Hello all,
I'm using mySQL for many databases, now I want to test innoDB so I have
created another DB (on the same machine) and I have populated it with the
same data of the first DB (via: insert into table_name select * from
db1.table_name);
I have this tables:
tableA: 80.000 recs
tableB,
I need to create a database with tables that can contain either Russian or
Latin1 characters.
Is it right that version 3.23.53 does not support Unicode? If so, how can I
get around this problem. Can I create 2 databases one using the Latin1 and
the other using the Russian character set?
Hi ! :D
I would like you help me to solve the following problem:
Suppose the tables below:
create table book
(
Bk_Id integer(4) unsigned not null auto_increment primary key,
Bk_Name varchar(20)
) type = innoDb;
create table page
(
Pg_Id integer(4) unsigned not
Is there a website, book, or tips to secure and optimize MYSQL?
This is what my users look like:
Host Users PasswordPrivileges
localhost administratoryes has all priv.
localhost root yes has all priv.
Is
Hejsan MySQL,
Vi sitter med en MySQL-server 3.23.lagom sent som vi skulle behöva
dokumentation till, men den enda dokumentation jag kan hitta är för
version 4.
Iom. att version 4 börjar skilja sig en del så känns behovet av en
3.23-manual större och större iom. att det kommer att dröja ett tag
Is there a way to create constraints that implements the rules I
need?
Not really. You would have to use deferrable constraints (checked at commit,
not after statement) like in Oracle. For now Innodb doesn't support it.
P.S. query,sql
--
_/_/ _/_/_/ - Rafa Jank
Hi,
I am using MySql 3.22 on a server with code page set to Japanese.
I am using MM JDBC driver. I insert english and Japanese data into a few tables, when
i query for the data from MySql i get junk characters in place where Japanese
charaters need to appear. How can i enable MySql for Non
On Wed, 27 Nov 2002 11:53:25 +0200
Nick Kostirya [EMAIL PROTECTED] wrote:
Hi, All.
How can I add additional characters (Ukrainian alphabet) to the source
code
for parse?
Thanks, Nick.
database,sql,query,table,handler,compile,ChangeSet
Just add a charset.
Take a look at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
Hi,
I am using MySql 3.22 on a server with code page set to Japanese.
I am using MM JDBC driver. I insert english and Japanese data into a
few tables, when i query for the data from MySql i get junk
characters in place where
I'm having a rather bizarre problem...at least, it seems bizarre to me.
We have a small MySQL database that was running great for about a month.
Last night, I rebooted the system it runs on. Now I can connect locally,
but remote connections fail. The server disconnects during the query and I
On Tue, Nov 26, 2002 at 10:38:56PM -0800, Grant Cooper wrote:
Here's my QUESTION! Because some of the program information is large I don't
want to query the data base everytime do I?
Profile it first. You may find MySQL handles the load just fine on the hardware
you're using and you don't
Never mind, I found the answer to my own question when I got the archive
search engine to respond. (It's *very* slow from here, for some reason --
about 10 minutes per query.) I installed a newer version of the glibc fix
and all is well now.
Sorry for wasting everyone's time.
-Original
Hi,
I've been trying to determine the difference between MySQL 4.0.5 and
4.0.5a. I can't seem to find any documentation relating to the change.
Can someone point me to the documentation or tell me what has changed?
Thanks,
Ray
In 3.23.x versions of MySQL the actual binary log file sizes stayed
fairly consistent. An 'empty' log file for instance on 3.23.53a is 73
bytes. I have a situation where I'm doing a roll-your-own replication
from many sites to one central server where the remote sites are on
everything from dialup
This problem's similar to one I posted earlier re Russian and English
characters in a database. I'm using the .net MySQLDriverCS driver. Are you
saying that MySQL tables can hold unicode? If so, how do I set it up to do
so? If not, how can I store Russian and English characters in MySQL? Will
Hi,
MySQL-4.0.5a is compiled again a new patched glibc library, to prevent from
MySQL having any load issues (which was the case on some systems).
Features are exactly the same between 4.0.5 and 4.0.5a.
Regards,
Jocelyn
- Original Message -
From: Ray Elenteny [EMAIL PROTECTED]
To:
Hi everyone, I'm trying to setup a mysql base upon a RH7.3 server. The mysql
version is the 3.23.52. I'm trying to re-install it from the sources (as
already did)... Mysql used to run, but i tried to install the perl::dbi and
i did things that might not have done good to the thing... So I decided
For a good choice of Mac sql GUI's, search Google for mysql gui.
W Johnson
-
This message sent using EMUmail -- http://www.emumail.com
-
Jumping through hoops to get E-mail on the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
This problem's similar to one I posted earlier re Russian and English
characters in a database. I'm using the .net MySQLDriverCS driver.
Are you
saying that MySQL tables can hold unicode? If so, how do I set it up
to do
Thanks for the response!
On Wed, 2002-11-27 at 09:44, Jocelyn Fournier wrote:
Hi,
MySQL-4.0.5a is compiled again a new patched glibc library, to prevent from
MySQL having any load issues (which was the case on some systems).
Features are exactly the same between 4.0.5 and 4.0.5a.
Hi,
my name is Ocke Janssen. I'm one the developers of OpenOffice and we
have a little problem.
When we try to get the privileges from MySQL it may happen that the user
hasn't the right to access these. Neither MyODBC nor Connector/J3 can
give us the necessary information we need to allow the
Hi All
how can i know if my mysql is pro or classic?
-
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
ok guyz i need some inside info .
plz help me with:
1. there aint no foreign keys in mysql then what can i do about cascading
updates, deletes and all
2. if i ve to conver a db in foxpro to mysql or sql which one should i
preffer and y
3. and while im converting the foxpro db to
Does anyone know a good graphical mysql client for windows and linux?
Massimo Bandinelli
System Administrator
mob +39 335 7324615
-
Register.it S.p.A. - Gruppo DADA
tel +39 199 REGIST (+39 199 734478)
fax +39 035 3230312
http://we.register.it
div class=moz-text-flowed style=font-family: -moz-fixedI have
created a Web application for a client that uses MySQL for the
DB. Most of my experience has envolved writing a front end in Delphi
and using ODBC to give a client an ability to administer the DB (e.g. do
queries to get lists, etc.).
Just to contribute our anecdotal experience, we also found a 2x increase
in space required when we converted our MyISAM tables over to InnoDB.
While it was surprising, it wasn't unexpected. We just had to go buy
another 60GB of disk space (luckily we had planned for this). :)
Owen
On Wed,
check mysql site at
http://www.mysql.com/downloads/index.html
Bye
--- Massimo Bandinelli
[EMAIL PROTECTED] ha scritto: Does
anyone know a good graphical mysql client for
windows and linux?
Massimo Bandinelli
System Administrator
mob +39 335 7324615
charitha,
Wednesday, November 27, 2002, 7:40:07 AM, you wrote:
c In mysql tables if i want to exclude some tables to do myisamchk how can i
c do that.
c As if i use myisamchk *.MYI it is taking too much time to check all the
c tables. For that i can exclude some previous days dynamic tables
ajitdixit,
Wednesday, November 27, 2002, 7:04:51 AM, you wrote:
aasdcdi Result for Show Grants is as under
aasdcdi SQL result
aasdcdi Host: localhost
aasdcdi SQL-query: SHOW GRANTS FOR aldixit@localhost;
aasdcdi Grants for aldixit@localhost
aasdcdi GRANT CREATE TEMPORARY TABLES, LOCK TABLES
MarkH,
Wednesday, November 27, 2002, 2:18:24 PM, you wrote:
MaAdn I need to create a database with tables that can contain either Russian or
MaAdn Latin1 characters.
MaAdn Is it right that version 3.23.53 does not support Unicode?
Yes.
MaAdn If so, how can I
MaAdn get around this problem.
John,
Wednesday, November 27, 2002, 2:50:09 PM, you wrote:
JC This is what my users look like:
JC Host Users PasswordPrivileges
JC localhost administratoryes has all priv.
JC localhost root yes has all priv.
Hi,
I keep getting error 1100 (table [table name(s) was not locked with LOCK
TABLES) but I am definitely locking them with LOCK TABLES...
here's examples of what i'm doing...
i have 2 tables i'm trying to work with...jobs and mechanics
i do
lock tables jobs read
everything seemed ok so then i
On Wed, Nov 27, 2002 at 04:26:21PM +0100, Massimo Bandinelli wrote:
Does anyone know a good graphical mysql client for windows and linux?
If you have a webserver with PHP, I'd highly recommend phpMyAdmin.
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation,
I personally prefer MySQL-Front, even though its development has been
suspended. You can get it here:
http://mysqlfront.venturemedia.de/index.php?act=STf=2t=328
MySQLCC is ok: http://www.mysql.com/downloads/gui-mycc.html
SQLyog seems ok: http://www.webyog.com/sqlyog/index.html
As to connecting
This is the query that was given to me:
SELECT e.*, c.* FROM
correspondence e, certificate c, logins l WHERE
c.void1 AND
c.uid = l.uid AND
l.parent = wd001 AND
e.invoice_num = c.invoice_num AND
e.to_uid = wd001 AND
e.actioned= 0
ORDER BY e.message_num
Pretty
Yes, thank you it helps !
Regards,
Jacek.
I'm not sure if you've gotton your answer or not yet... (i have 150 more
mailing list messages to go!)
Try http://www.mysql.com/doc/en/Resetting_permissions.html
On Monday 25 November 2002 06:05 pm, Jacek Mach wrote:
Hello,
I have made the
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same machine):
Is there a way to get data statistics (bytes in/out) per
thread/connection with the MySQL C API? I would be interested in
generating statistics for the amount of transmitted data (over the
network) in my program. Thanks.
-
i am using vb,ado,myodbc,mysql
i have some values in longblob,mblob fields
when i read it with ado , if the data is less than 1o
kb then the field having the value otherwise it shows
the null
for ex.
select image from stumaster where id=12
if the image is of = 10 kb then it returns value
Hi
Postgre might be a better bet, as it supports more of the features you are
looking for.
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel.
Hi Grant:
The answer to your question depends on a lot of details. In most cases, the
solution you have chosen is just fine. The real question you need to answer
is, Does your solution meet your needs? If you can answer yes to this
question, your solution is fine.
Your solution gives you a
I really like SQLyog. You can find it at http://www.webyog.com/
JFernando
** sql **
-Original Message-
From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]]
Sent: November 27, 2002 10:26
To: [EMAIL PROTECTED]
Subject: Graphical client
Does anyone know a good graphical mysql client for
Hello John,
Wednesday, November 27, 2002, 7:26:09 PM, you wrote:
JC So does that mean it is a good or bad way of doing it?
The short answer - depends on ..
The bad way is to give all prvileges for the user that can connect from
any host ('%').
JC At 06:06 PM 11/27/2002 +0200, you wrote:
John,
Chris,
Wednesday, November 27, 2002, 6:24:12 PM, you wrote:
CB I keep getting error 1100 (table [table name(s) was not locked with LOCK
CB TABLES) but I am definitely locking them with LOCK TABLES...
CB here's examples of what i'm doing...
CB i have 2 tables i'm trying to work with...jobs and
Try SQLyog - A Windows based Front End for MySQL.
http://www.webyog.com/sqlyog/download.html
Rgds
Insane
- Original Message -
From: Natale Babbo [EMAIL PROTECTED]
To: Massimo Bandinelli [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, November 27, 2002 9:27 PM
Subject: Re:
Hi ,
Thanks for reply
I had earlier downloaded mysql-4.1.1 development branch source code and had
noticed that This bug is also present in 4.1.1 development tree source code
I had downloaded mysql-4.0 development source code as mentioned in mysql
documentation but could not compile it as innodb
Hi ,
At present I am using phpMyAdmin for my mysql data management
Though it is an excellent front end interface , I feel the interface designed
for multitable select quiries by phpMyAdmin is not very good. It is faster to
write query by hand than generate the query by that interface
I have
On 28 Nov 2002, at 3:24, Chris Barnes wrote:
i do
lock tables jobs read
everything seemed ok so then i do
lock tables mechanics read
again no errors so i guess it worked..now i'm expecting to have my 2
tables locked for read only.
In the documentation it says
Matt,
thank you for the bug report.
I do not have C# in my computer. Did I understand correctly the bug does not
appear if you use the Embedded Server Library inside C++?
My first note is that you should define USE_TLS in all MySQL modules, like
Monty instructed a week ago. But I guess that
I am looking into USE_TLS. But yes, I see that mysql_real_data_home is
not corrupted, only mysql_data_home is.
Thanks for your response.
-- Matt
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 11:40 AM
To: Matt Solnit; [EMAIL
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Mysql maillist [EMAIL PROTECTED]
Sent: Wednesday, November 27, 2002 2:44 PM
Subject: constraints and InnoDB
Hi ! :D
I would like you help me to solve the following problem:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 27 November 2002 16:11, Inbal Ovadia wrote:
how can i know if my mysql is pro or classic?
By connecting to it using the MySQL client - the server will tell you what
version it is. Example:
./bin/mysql
Welcome to the MySQL monitor.
Hi,
I am using Slackware distribution of Linux. Someone
has already installed MySQL binary as well as source
distribution. I would like to un-install that and
reinstall. But I already have the webserver running
where MySQL is the database used. If I un install
MySQL, will I be able to retain the
i'm trying to install MySQL 3.23.53 on OS X.
It seemed pretty easy as i followed the directions on the devshed
website, but when i to make (for the compile) it all came to a halt.
i have included the entire install session below: from decompressing
the .tar.gz file, to the completion of the
Hi.
On Tue 2002-11-26 at 22:38:56 -0800, [EMAIL PROTECTED] wrote:
I need help. I am building a database for a small college that wants to be
able to update their program information for each department through an
web/gui program.
I've decided to use, MYSQL, Apache, PHP and FreeBSD as the
Dear Sirs,
I installed the Mysql 3.23.51 in my Windows NT 4.0 with service pack 6. The
directory that I used was c:\mysql. After that I saw that the C:\mysql was
to small. I uninstalled using the command mysqld-max-nt --remove and after
that I used the option add/remove program from control panel
Hi.
On Wed 2002-11-27 at 12:30:05 -0800, [EMAIL PROTECTED] wrote:
Hi,
I am using Slackware distribution of Linux. Someone
has already installed MySQL binary as well as source
distribution. I would like to un-install that and
reinstall. But I already have the webserver running
where MySQL is
Why? (Note the extra space after me in the second select)
Your MySQL connection id is 6021 to server version: 3.23.41-log
mysql select contact from options where member='me';
+-+
| contact |
+-+
| me |
+-+
1 row in set (0.00 sec)
mysql select contact from options
I am trying to create a new db in phpmyadmin with
MySQL 3.23.53a running on localhost.
SQL-query :
CREATE DATABASE `` gulf ``
MySQL said:
You have an error in your SQL syntax near 'gulf``' at
line 1
Why am i getting this?
__
Do you
At 14:48 -0600 11/27/02, [EMAIL PROTECTED] wrote:
Why? (Note the extra space after me in the second select)
Hardly enough information to go on. Apparently you're using a
column type like BLOB or TEXT for which trailing spaces are not
removed?
Your MySQL connection id is 6021 to server
member varchar(16) NOT NULL default '',
PRIMARY KEY (member),
On Wed, Nov 27, 2002 at 03:28:15PM -0600, Paul DuBois wrote:
At 14:48 -0600 11/27/02, [EMAIL PROTECTED] wrote:
Why? (Note the extra space after me in the second select)
Hardly enough information to go on. Apparently you're
At 15:06 -0600 11/27/02, [EMAIL PROTECTED] wrote:
member varchar(16) NOT NULL default '',
PRIMARY KEY (member),
Huh. That is weird, then. What does LENGTH(contact) return?
On Wed, Nov 27, 2002 at 03:28:15PM -0600, Paul DuBois wrote:
At 14:48 -0600 11/27/02, [EMAIL PROTECTED] wrote:
On 11/27/02 1:24 PM, Tim V [EMAIL PROTECTED] wrote:
I am trying to create a new db in phpmyadmin with
MySQL 3.23.53a running on localhost.
SQL-query :
CREATE DATABASE `` gulf ``
MySQL said:
You have an error in your SQL syntax near 'gulf``' at
line 1
Why am i getting
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.5, a new version of the world's most popular Open Source Database,
has been released. It is now available in source and binary form for a number
of platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
On Wed, Nov 27, 2002 at 09:39:52PM +0100, Benjamin Pflugmann wrote:
5. Another hybrid: Do not create the cache pages yourself. Simply
build the back-end as in solution 1. and put a caching proxy
(e.g. squid) before it. The main drawback in comparison with.
Depending on proxy, may
At 19:10 27/11/2002 -0200, Marco Querini wrote:
Hi,
When you install MySQL in another directory than the default
C:\mysql, you need to create the c:\winnt\my.ini file and to
edit the variables:
[mysqld]
basedir=d:/mysql #for example
datadir=d:/mysql/data #for example
Dear Sirs,
I installed
In the last episode (Nov 27), [EMAIL PROTECTED] said:
Why? (Note the extra space after me in the second select)
Your MySQL connection id is 6021 to server version: 3.23.41-log
mysql select contact from options where member='me';
+-+
| contact |
+-+
| me |
mysql select LENGTH(contact) from options where member='me ';
+-+
| LENGTH(contact) |
+-+
| 2 |
+-+
1 row in set (0.01 sec)
On Wed, Nov 27, 2002 at 03:36:03PM -0600, Paul DuBois wrote:
At 15:06 -0600 11/27/02, [EMAIL PROTECTED]
Tim,
[returned the conversation to the list, so that others may benefit]
Right now in the config.inc.php file i have it set as:
### MySQL data
$mysql_host = localhost; // localhost name
(usually:localhost)
$mysql_user = mine; // MySQL username
$mysql_pass = mine2; // MySQL password
Ach. I was misreading the original message the entire time.
The reason you see the behavior below for the second query is that
the comparisons are done without regard for trailing spaces.
If you change the column type to TEXT, the second query will
return nothing. (On the other hand, another
Thanks you very much for all your suggestions. I really appreciate it.
Grant Cooper
- Original Message -
From: Matthew Baranowski [EMAIL PROTECTED]
To: Grant Cooper [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 27, 2002 9:23 AM
Subject: Re: Data base driven web page idea
Thanks!
From http://www.mysql.com/doc/en/Bugs.html:
* All string columns, except BLOB and TEXT columns, automatically
have all trailing spaces removed when retrieved. For CHAR types
this is okay, and may be regarded as a feature according to ANSI
SQL92. The
where member='me ' is not the same as where member='me' ('me ' != 'me')
I've noticed this as well with just about any mysql version, on any
platform.
The tables / columns really isn't important here IMHO... From what I can
see, trailing spaces are always droped, which shouldn't be.
-
I've recently started to use accented characters in MySQL--
nothing extremely fancy, just the usual things in the
ISO-8859-1 character set, mainly just the vowels with acute,
grave, circumflex, and umlauts.
Originally, everything was working fine; things got entered
correctly, and I could search
Does InnoDB support ALTER TABLE ... ORDER BY ...? If it weren't for this
command, we would never get the continuous great performance we get from
MySQL. And it keeps us from ever really considering InnoDB. :(
Sincerely,
Steven Roussey
http://Network54.com/
On Wed, 27 Nov 2002 07:56:42 -0800, Todd Cary wrote:
Most of my experience has envolved writing a front end in Delphi
and using ODBC
I just wrote a short program in Delphi (using MyODBC) to pull
information from an Access MDB and update a MySQL table. Worked fine.
Uploading from the
I use the binary from :
http://www.entropy.ch/software/macosx/
Christophe
On Wed, Nov 27, 2002 at 12:35:45PM -0800, Chris Herold wrote:
i'm trying to install MySQL 3.23.53 on OS X.
It seemed pretty easy as i followed the directions on the devshed
website, but when i to make (for the
I need help. I am building a database for a small college that wants to be
able to update their program information for each department through an
web/gui program.
I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
web page this way)
Here's my QUESTION! Because
On Wed, Nov 27, 2002 at 03:04:25PM -0800, Steven Roussey wrote:
Does InnoDB support ALTER TABLE ... ORDER BY ...?
No.
If it weren't for this command, we would never get the continuous
great performance we get from MySQL. And it keeps us from ever
really considering InnoDB. :(
Records in
you won't get a large blob back in one piece. to
retrieve blobs, you need to use the getchunk
method.
refer to getchunk in the vb documentation. it
also has an excellent example.
i am using vb,ado,myodbc,mysql
i have some values in longblob,mblob fields
when i read it with ado ,
On Wed, Nov 27, 2002 at 01:26:42PM +0100, [EMAIL PROTECTED] wrote:
Anyone knows the reason of this disk usage of innoDB (it's 2 time
bigger than myISAM)
InnoDB has larger per-record overhead (row headers and such).
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL
You cannot get a BLOB back in one piece. I wrote an article at
www.dynamergy.com/mike/blobaccessvb.html that describes how to use the
adodb.stream object to access MySQL BLOB data through VB.
Mike Hillyer
-Original Message-
From: Lalit Chandwani [mailto:[EMAIL PROTECTED]]
Sent:
Here's the question, as succinctly as I can formulate it:
The documentation seems to say that one can load a tab-delimited text
file located in the current directory of the client host into a
database by running the client mysql and executing the following
command:
mysql LOAD DATA
I knew i was doing something stupid :p
I did actually look through the documentation but i had no luck. I also
have a MySQL book (Core MySQL by Leon Atkinson) but I couldn't find
anything in there to help me.
Thanks for your help.
On Thu, 2002-11-28 at 05:06, Keith C. Ivey wrote:
On 28 Nov
What would cause the MySQL server to just shutdown, apparently on its own?
This server is running on a Linux (RH 7.3) (Dell) box with 512mb RAM and a
SCSI RAID array. The MySQL version is 3.23.53, installed from RPM's. The
RPM's were downloaded from a MySQL mirror (did not install the versions on
Hello all, I wonder if you can help me?
Background:
I have two databases (on different machines).
I have a requirement to move to having multiple slaves to do the queries
involved, at the moment we have data on both machines and our apps choose
the machine that has the necessary data to satisfy
1 - 100 of 108 matches
Mail list logo