Hi,
I have had problems reading BLOB fields using MyODBC (I can't see if this is
Your way of doing this).
I have solved reading/updating BLOB using the samples from
http://www.vbmysql.com/ -
http://www.vbmysql.com/articles/visual-basic_mysql/blobaccessvb.html
Best regards
Peter
- Origi
When a select query is run on a mysql table with text and blob fields, the
text fields return the whole text but the blob fields return only the first
4 bytes of the blob data. I use MySQL 4.0.17 with VB6.0 on Windows 2000.
What should I do to retrieve complete data from the blob field?
Any help
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid` varchar(20) NOT NULL default '',
`formid` varchar(20) NOT NULL default '',
`groupid` varchar(20) NOT NULL default '',
`clientid` varchar(20) NOT NULL default '',
`
Hello,
I'm trying to run an SQL update statement like:
UPDATE ControlTable SET @prevval := NextID, NextID = NextID
+ 1
I've tried using a range of different syntax, but nothing
seems to work. This is something that does work in another
SQL server I used to use.
Does anybody know if this is some
Can you send us the CREATE TABLE statement for this troublesome table?
Regards,
Chris
Eric B. wrote:
Sorry - forgot to mention it. I've already tried both an OPTIMIZE TABLE and
ANALYZE TABLE to try to improve performance, but with no result.
Any other ideas?
Thanks,
Eric
"Chris Nolan" <[EMA
Sorry - forgot to mention it. I've already tried both an OPTIMIZE TABLE and
ANALYZE TABLE to try to improve performance, but with no result.
Any other ideas?
Thanks,
Eric
"Chris Nolan" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hmm...if there's lots of thrashing, it might b
In the last episode (Feb 20), Matt W said:
> Can anyone tell me whether or not some kind of RAID will improve the
> seek/access times during lots of random reads from, say, MyISAM data
> files? I *do not care* about improved [sequential] transfer rates; I
> want the fastest possible random access.
Hmm...if there's lots of thrashing, it might be to do with
fragmentation. Have you tried running OPTIMIZE TABLE on the table in
question?
Does anyone on the list have anything to say about putting the MYD and
MYI files on seperate disks or using RAID MyISAM tables??
Regards,
Chris
Eric B. wr
We have a job opening at MyPoints.com in San Francisco for a MySQL
database administrator/database developer.
We are building a new system from scratch with distributed and
replicated MySQL databases, Apache, Java, Linux.
Actual duties will depend on the particular skills and interests of the
can
Help!
Okay - so I've been working around on my indexing of a table. My table is
currently over 5M rows (close to 500Mb) and growing at a quick rate. In
order to handle different types of queries, I am forced to create multiple
indexes for the table. But by doing so, I end up with an MYI index
Sasha Pachev wrote:
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional
procedural
approaches and languages, like C, are the best for 'systems
programm
Sasha Pachev wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean implementing anything with complex data struct
Hi Ted,
Heh. :-) This could be many GBs. There's no problem reading rows that
are in RAM (cached by the OS) -- can read over 10,000/second. If
there's enough RAM, the OS will take care of it (you could cat table.MYD
to /dev/null). No ramdisk necessary. :-)
BTW, this is for MySQL's full-text se
Run everything off a ramdisk ;-)
Ted Gifford
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 5:21 PM
To: [EMAIL PROTECTED]
Subject: Improving seek/access times -- does RAID help?
Hi all,
Can anyone tell me whether or not some kind of RAID will
Hi all,
Can anyone tell me whether or not some kind of RAID will improve the seek/access times
during lots of random reads from, say, MyISAM data files? I *do not care* about
improved [sequential] transfer rates; I want the fastest possible random access.
I'm thinking that RAID won't give an i
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean i
Jeremy March wrote:
> I think --with-extra-charsets=none means that no additional character
> sets will be _compiled_ into the server. Complex character sets must be
> compiled into MySQL, but simple ones can be loaded dynamically. I think
> the character sets you are seeing are ones that can be
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with co
I am running a debian linux server and I need mysqlplus installed. There
isn't a package yet for debian (at least not to my knowledge) to install it.
So, I downloaded the mysql++ 1.7.9 source to install it. I am running
version 2.95.4 of gcc. Is there something I am doing wrong? Do I need to
in
[EMAIL PROTECTED] wrote:
Hi all, I'm currently experiencing some very strange behaviour at my MySQL server.
Our production server is a Sun-E4500 (8x400 MHz 4 GB Ram running Solaris 8 and Solstice Disksuite...) and a single A5000 "Storedge" with 127 GB disk space (12x9.1GB @ 10K RPM) array connecte
Kittiphum Worachat wrote:
Hi.
How fast or what about time different between master and slave suppose
when I insert row into master and then select from slave in replication
environment. both machine have all the same specification
If your slave is able to keep up with the load, and your network
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with complex data structures and lots of
paral
António Fernandes wrote:
Hello,
I'm am trying to make MySQL Server to log connections (attempts, successes,
failures) to a Syslog. I know that it's possible to log all queries but I
just want the connections. Has anyone already done this? Is there a patch
file that I can use?
Wanring - I've never
"SELECT TABLE_NAME FROM USER_TABLES".
I found the error message on Oracle's web site, but their description of
the error doesn't help me much:
*Cause: * The buffer length was less than the minimum required or
greater than its length at bind time minus two bytes.
I don't know what buffer this is
Liying Huang wrote:
I have been struggling with one way replication for weeks, still
can't make it work.
I used windows, MySql 4.0.17 version on both. I have set bin-log option
in my.cfg in master computer, in slave computer, set master-host,
master-user=repl,master-password, replicate-do-db=test
Thanks for the posts folks. Right after I posted I re-wrote my parser to use
~ for commas and ^ for quotes. It seems to be working. I didn't want to say
I was doing that because it seemed kinda "hack" >:).
I'm not in favor of running TRIM() functions due to the overhead with so
many records.
We'l
Hi Eve,
That error is because the LOCAL part of LOAD DATA is disabled. See
here: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
Since your file is probably on the same system as the MySQL server, it
should work if you remove the LOCAL word.
Hope that helps.
Matt
- Original Message --
Chris,
The good news is that MySQL 5.0 can finally use multiple indexes per
table. I just noticed this page in the manual a few days ago:
http://www.mysql.com/doc/en/OR_optimizations.html
:-)
Matt
- Original Message -
From: "Chris Nolan"
Sent: Monday, February 16, 2004 7:13 AM
Subjec
Just use something else beside commas to delimit your file. I have a
file that I need to regularly import that has commas, tabs and returns
in the data. I delimit the fields with ^^ and the records with ~~.
You can tell MySQL what the delimiters are when you import the data.
On Feb 20, 2004, at
Hi Ronan,
Did you perhaps set MAXDSIZ is your kernel configuration above
"(2047UL*1024*1024)" ?
Ken
- Original Message -
From: "Ronan Lucio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 3:06 PM
Subject: my.cnf in MySQL-Server-4.0.17
> Hi All,
>
> I´m
On 20 Feb 2004 at 14:55, Dan Nelson wrote:
> If you need leading and trailing space stripped, you can postprocess
> the field with the TRIM() function.
But note that, unlike similar functions in some languages, the MySQL
TRIM() function removes spaces (ASCII 32 characters), not whitespace
(whic
Chris,
Another option is to use | instead of commas. Unless you have pipes in your
file. :)
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 20, 2004 2:55 PM
> To: Chris Fossenier
> Cc: [EMAIL PROTECTED]
> Subject: Re: White Space
>
> In t
In the last episode (Feb 20), Chris Fossenier said:
> What is the best way to deal with white space in a mysql database?
>
> What I'm talking about is trailing spaces in larger fields. We
> receive data in fixed width format, so when you import it, you get a
> bunch of trailing white spaces that
What is the best way to deal with white space in a mysql database?
What I'm talking about is trailing spaces in larger fields. We receive data
in fixed width format, so when you import it, you get a bunch of trailing
white spaces that take up space. Multiply these white spaces by 120million
recor
Sasha,
Thanks for the reply. It's actually during index creation (while creating a
database). I am creating the tables, loading the data, then applying the
indexes and foreign keys.
There are five or six indexes on some tables, the first taking 5 minutes,
the second taking 5:45, etc.
In this cas
In the last episode (Feb 20), Bill Marrs said:
> Looking around in the docs, I found this regarding thread_concurrency:
>
> thread_concurrency
> On Solaris, mysqld will call thr_setconcurrency() with this value.
> thr_setconcurrency() permits the application to give the threads
> system a hint fo
If you need the date like, '2004/01/01', then shouldn't it be '%Y/%m/%d'?
You still ahve the dashes (the '-' character) in your date-format, and you
need a forward-slash (the '/' character) instead.
Here's what I ran on MySQL:
mysql> select date_format(NOW(), '%Y/%m/%d');
+-
Check the max_connections variable
Mysql> show variables liks '%connection%';
-James
-Original Message-
From: Christof Egner [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 9:03 AM
To: [EMAIL PROTECTED]
Subject: Can't create a new thread (errno 11)
Hello,
I'm having problem
Looking around in the docs, I found this regarding thread_concurrency:
thread_concurrency
On Solaris, mysqld will call thr_setconcurrency() with this value.
thr_setconcurrency() permits the application to give the threads system a
hint for the desired number of threads that should be run at the
I have the following query where the user will put in a date. They will
put it in like '01/01/04'. I use this date in my WHERE clause but MySQL
needs the date like '2004/01/01'. I tried using Date_Format('04/01/01',
'%Y-%m-%d') to change the way it is formatted but I don't get the
correct data b
Quick question. I just did an upgrade from source from 3.23.x to
4.0.18. A few things came up.
1. chown -R mysql var causes my RedHat 7.3 to complain.
chown: getting attributes of `var': No such file or directory
2. Stopped mysql by typing
shell> service mysql stop
3. Tried to
carreraSC wrote:
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
job 2
B
>But how would i get something like this?
>+++
>| A | B |
>+++
>| 5 | 10 |
>+++
>Where A = the number of unique UID's (the number of rows from table 2)
>and B = the SUM of C (derived from
>"SELECT count(*) as C from table GROUP BY uid")
SELECT SU
That is SPOT on, takes 2seconds to process but thats still better than 5 :)
--
Dave
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "David Scott" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 20, 2004 5:30 PM
Subject: Re: SUM() the results of a C
David Scott wrote:
Hiya peeps...
If i have a table like this:
+++
| id | uid|
+++
| 1 | 26 |
| 2 | 26 |
| 3 | 267|
| 4 | 267|
| 5 | 269|
| 6 | 269|
| 7 | 271|
| 8 | 271|
| 9 | 271|
| 10 | 424|
+++
I could do
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
j
Hiya peeps...
If i have a table like this:
+++
| id | uid|
+++
| 1 | 26 |
| 2 | 26 |
| 3 | 267|
| 4 | 267|
| 5 | 269|
| 6 | 269|
| 7 | 271|
| 8 | 271|
| 9 | 271|
| 10 | 424|
+++
I could do this to get the cou
Hello,
I'm having problems with a 4.0.18 MySQL Server. Since this afternoon I
get the error "Can't create a new thread (errno 11)" when MySQL has
forked about 200-300 threads.
What does it mean? I'm not running out of RAM or disk space.
Best Regards,
Christof
--
MySQL General Mailing List
Fo
Egor Egorov wrote:
Colleen Dick <[EMAIL PROTECTED]> wrote:
Is it possible to JOIN the results of a DESCRIBE TABLE to some other
query? The semantics of what I would like to do is the following:
SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
desc.d_table = 'footable' AND desc.d_fi
Fabbro Alberto wrote:
Network configuration:
- Firewall connected to Internet, with two ports: LAN (protected) and DMZ
- Web server on the DMZ segment
- Internal Servers on the LAN segment.
We would like to introduce a web database application on the Web server,
using a Slave replication of a Mast
sorry, I don't know that one. Never have used any version of mysql lower
than 4.04. a suggestion might be to call your 4.0 column an unsigned
bigint, or if possible an unsigned int if the numbers can fit in 32
bits. unsigned means its always positive.
jeff
ps. you may want top "reply all" so t
David Griffiths wrote:
I was wondering what the bottleneck was. I'm adding a dozen indexes to
the same large-ish InnoDB table. Each successive index takes a bit
longer (45 seconds or so on a dual P3-933 with 2 gig of RAM).
Every time you add a new index or do any non-trivial modification to the sch
heh, sometimes the obvious is right in front of you...
I still can't get the full dataset to load with indexes on the table,
but I _can_ apply indexes after the load. the indexes apply cleanly, so
it doesn't seem to have been a data issue. in any case, I can continue
prototyping.
it remains
> I am having problem using the operator OR. when I test for condition A
> OR B in a query, the query becomes extensively slow or even fails,
> even though a test on condition A or B alone gives result right away.
I learned recently that you can often use a UNION to solve problems like this.
It's
Ronan Lucio wrote:
Hi All,
I´m trying to do some customization in a MySQL-Server-4.0.17
to gain a better performance.
We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
on a FreeBSD-5.2.1 box dedicated for MySQL.
The diagnostic error messages are a fairly strong indication that you could have
On 20 Feb 2004 at 10:57, Yun Li wrote:
> I am having problem using the operator OR. when I test for condition A
> OR B in a query, the query becomes extensively slow or even fails,
> even though a test on condition A or B alone gives result right away.
See http://www.mysql.com/doc/en/MySQL_indexe
I have a large email database that has been translated into a CSV, simply
like this:
[EMAIL PROTECTED];[EMAIL PROTECTED]; (etc.)
I need to get this into SOME format. I have tried Access, which said it was
too large - so I am trying my mysql. I created a table with fields ID, and
email. I just wan
hello, everyone
I am having problem using the operator OR. when I test for condition A OR
B in a query, the query becomes extensively slow or even fails, even
though a test on condition A or B alone gives result right away.
If you happened to know what the problem it or have any suggestion, pleas
Seems to be the binary log saves all INSERT statements, even if it is
a duplicate error. How could I restore my table using mysqlbinlog if
there
are duplicates in the log file.
Please help
Thanks,
George Mathew.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
I'm interested in trying to tune MySQL's memory usage variables in my
/etc/my.cnf file.
I'm currently using the default settings (except for max_allowed_packet,
which I've had to increase to support some large queries that I make), they
work well. Here is what I've got:
key_buffer_size
On Friday 20 February 2004 15:19, Claire Lee wrote:
> Hi All,
> I have a query problem here. Say I have a table with
> employee records of three different departments. If
> each department manager wants to see employee info of
> their own department. Three different queries will be
> needed. Is the
Hi All,
I have a query problem here. Say I have a table with
employee records of three different departments. If
each department manager wants to see employee info of
their own department. Three different queries will be
needed. Is there a way that I can write one single
query and let SQL decide wh
Currently I am working under a win32 environment developing applications to
work with mysql. I have found some inconsistencies with the newer version of
libmysql.dll versus older files that are supplied with your current package
I have found that there is no version information tied to the differen
Achuthan <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 31 lines --]
>
> hi all
> I am facing a problem in fetching the data from two different tables
> I have tables called A and B.
> Thro PHP code i am trying to connect to MySQL to fetch the desired datas frm bot
hi all
I am facing a problem in fetching the data from two different tables
I have tables called A and B.
Thro PHP code i am trying to connect to MySQL to fetch the desired datas frm both A & B
My code Goes like this
"select ename,exp,salary from A Union select ename,exp,sal from B LIMIT 0, 30"
Duncan Hill <[EMAIL PROTECTED]> wrote:
> Mysql version: 4.1.1
> Platform: Linux, pre-compiled RPMs from mysql.com
>
[skip]
>
> My problem:
> Right now, I use a routine that selects the IDs that haven't been seen, and
> promptly does an insert into notifications_seen to flag that it has been
> s
"Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> wrote:
> Dear Ladies and Sirs,
>
> is ist possible to set a default for SQL_SELECT_LIMIT ?
> I tried to put this in my.cnf but it didn't work (server didn't start).
>
> It's MySQL 4.017 on LINUX.
>
Default value for the global SQL_SELECT_LIMIT is t
We are using XSLT and XSL:FOP for our reports. We generate a simple XML
file then transform it into a nicely laid out PDF. You can layout the
pdf's easily with a nice product called XSLFast www.xslfast.com.
Joe
On Thursday, February 19, 2004, at 07:33 PM, Matt Silva wrote:
I'm looking for a
I have been struggling with one way replication for weeks, still
can't make it work.
I used windows, MySql 4.0.17 version on both. I have set bin-log option
in my.cfg in master computer, in slave computer, set master-host,
master-user=repl,master-password, replicate-do-db=test and
replicate-ign
Hello!
I´m using MySQL 4, VB6 and ODBC 3.51 and my connection is going down for some reason.
Do not know why.
Do I need to change the "Connection Pooling" at MyODBC 3.51 Driver?
I saw two options and I don´t know exactly what it means.
- Don´t pool connections to this driver
- Pool connectio
Hi List,
I'm having quite a large data file ibdata1 in \mysql\data. The file
occupies over 500 MB, while all of my databases at the moment
are fairly small (recently, i deleted some old databases).
I wonder how it is possible that this file gets so large, compared to
the space the rest of my
Hello Segismundo,
Friday, February 20, 2004, 2:45:20 PM, you wrote:
S> Hi, all.
S> Another question: IS it possible to produce on a sql consult a new
S> column that enumerate the results with order or not on the other columns?
S> What is the syntax?
S> Thanks,
S> Segismundo
SET @a=0
SELECT
> The command you're looking for that drops and recreates in one go is
> TRUNCATE (http://www.mysql.com/doc/en/TRUNCATE.html). This is
> the same as:
>
> DROP TABLE table;
> CREATE TABLE table (...);
>
> For MyISAM tables, this is likely to be much faster as MySQL can just
> delete the MYI and
Colleen Dick <[EMAIL PROTECTED]> wrote:
> Is it possible to JOIN the results of a DESCRIBE TABLE to some other
> query? The semantics of what I would like to do is the following:
>
> SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
> desc.d_table = 'footable' AND desc.d_field = Fiel
Hi, all.
Another question: IS it possible to produce on a sql consult a new
column that enumerate the results with order or not on the other columns?
What is the syntax?
Thanks,
Segismundo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
FOUND !
After many days to search the solution we found it ! The problem is solved
in the computer runnig microsoft jet 3.5.
You must change to 0 then values in the registry key
hkey_local\machine\software\microsoft\jet\3.5\engines\odbc; se the dword
ConnectionTimeout. The default is 600 in
Segismundo <[EMAIL PROTECTED]> wrote:
> Hi, all.
>
> I've a table with a varchar column, and I need replace a character on
> the column, but this character may be on someplace on the field.
> Is it possible to change or delete it? What will be the sintax?
>
If you want to replace all occurrence
Hi, all.
I've a table with a varchar column, and I need replace a character on
the column, but this character may be on someplace on the field.
Is it possible to change or delete it? What will be the sintax?
Thanks,
Segismundo
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
Dear Ladies and Sirs,
is ist possible to set a default for SQL_SELECT_LIMIT ?
I tried to put this in my.cnf but it didn't work (server didn't start).
It's MySQL 4.017 on LINUX.
thank you
Klaus
Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de
Diese Mail ist von:
Deutsch
Hi all, I'm currently experiencing some very strange behaviour at my MySQL server.
Our production server is a Sun-E4500 (8x400 MHz 4 GB Ram running Solaris 8 and
Solstice Disksuite...) and a single A5000 "Storedge" with 127 GB disk space (12x9.1GB
@ 10K RPM) array connected over a single FC-AL a
Hi.
How fast or what about time different between master and slave suppose
when I insert row into master and then select from slave in replication
environment. both machine have all the same specification
Thank.
Kittiphum Worachat.
--
MySQL General Mailing List
For list archives: http://list
Mysql version: 4.1.1
Platform: Linux, pre-compiled RPMs from mysql.com
Table 1:
CREATE TABLE `notifications` (
`recid` int(11) NOT NULL auto_increment,
`recdate` datetime NOT NULL default '-00-00 00:00:00',
`expiry` datetime default NULL,
`notify_title` varchar(150) default NULL,
`no
Hi!
I always get OperationalError: 2013 ( 'Lost connection to MySQL server
during query' ) while running a query using "mysql front end" on localhost,
after 30 seconds.
This doesn't happen, when i connect from remote hosts - using any front end
.
All "timeout" parameters are set to default.
Any id
"Scott Purcell" <[EMAIL PROTECTED]> wrote:
>
> I am trying to create some tables that I can use the delete on cascade =
> function for. This would help me code the project and ensure data =
> integrity. I am on the docs @ =
> http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html but I am
84 matches
Mail list logo
