If it truly ran fine for a few days and then you couldn't run the client,
you may have another problem.
If you rebooted the box, mysqld may not have automatically started.
So, all of the sudden, the client can't connect to the socket since it is
not there as the server is not running.
You can
From you example, not quite sure what you are trying to do (I could if, for
example generic tree was 0199, and 01 was tree and last two characters were
color or something like that)
At any rate, you can use string functions to pull data from portions of
fields to build whatever you want to search
Refer to http://www.mysql.com/doc/en/LOAD_DATA.html for doc on LOAD DATA
INFILE command and syntax.
-Original Message-
From: Gman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:45 AM
To: [EMAIL PROTECTED]
Subject: Question or Wish feature
How easy is it to import a CSV
I just got done playing with this same scenario.
If the task finishes locally OK, but totally dogs on the network, then you
may have a network issue, NOT a MySQL issue.
1) Make sure that the switch and boxes are set to full duplex operation.
This will eliminate collisions. Make sure that
I didn't see anyone else reply, so I will give you my thoughts.
I thought one of the list gurus would give you a much better answer than I
could so I waited.
Assuming that with two decimal places, you are doing something monetary.
But this applies whenever you want fixed decimal places, too.
I
Mediumint refers to the fact that it is three bytes long rather than a
regular 4 byte, 32 bit integer. It's range is like +/- 8,000,000 or so
(look it up for sure)
The 6 just has to do with how many digits will be displayed when you invoke
the MySQL client for the row - spacing will be a
also wrote back and asked if he thought I was a complete idiot...
Unfortunately, you may be.
Now he has your e-mail address.
As my father always sez, smooth move Ex-Lax
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:12 AM
To:
Our experience has been totally the opposite.
We recently ported a Delphi application from MS-SQL to MySQL.
The MySQL server was a less powerful box than MS-SQL was running on.
I will not go into great detail because some of the software is proprietary
and we make $$$ providing the service.
It should be in mysql.h
Check your installation and make sure it was installed.
Our sysadmin originally installed MySQL without it - after all, he didn't
need it so it must not have been important ;)
Also, you will need to be sure and install the libmysqlclient and link with
it.
Regards,
Ken
I am assuming this is not a MySQL question since MySQL interacts with SQL
commands that are all in characters.
try using strstream. You can poke just about anything into it and get a
string out.
If you must have a char*, then use the c_str() function of the string class.
The best
The real answer, yes. It has a limit of several GB, depending on your OS.
It can take a huge string containing MBytes of BLOB data.
Just for grins, I loaded several MB of image data this way just to prove to
myself that you could do it.
The practical answer is then pretty much no. (Probably
What version of the ODBC Drivers are you using?
I had a VB app using the 3.5x versions of the ODBC driver manipulating very
small tables and it was absolutley painful to run.
I stepped back to the version 2.x drivers (2.9, I think - anyhow, the driver
information is available on the web site)
Howdy -
Am I missing something? Why would you have to create all of your columns as
BIGINT?
Whether the has pool column is a TINYINT, BIGINT, or whatever, the SELECT
statement would be the same, wouldn't it?
Won't SELECT blah blah blah FROM HOMES WHERE HasPool = 1; return houses
with pools
You are 100% correct.
Since MySQL does not support cursors, I always put an auto_increment
column in my tables for just this purpose.
(This is what other DBMS' do, they just do it behind your back)
Unfortunately, the way MySQL really handles result sets doesn't lend itself
to simply adding a
Well, I haven't kept up on the Cobalt product line, but, I wasn't aware that
they had intel based offerings.
I thought they were all RISC chip based.
That probably explains why I86 binaries won;t install..
If they don't have a binary for Cobalt Cube/RaQ systems, it's compile
Howdy All -
I am using MySQL 3.23.46-Max under Red Hat 7.2
I am trying to use DECIMAL type columns to work with huge numeric (monetary)
values.
I figured out how to get large numbers into DECIMAL types by passing them as
strings:
mysql insert into khtest set k1=1,t1=123456789012345678.10;
Okay, here's a hint...
4.2.9 in the manual (;o)
Basically, if you encrypt the password, then you have to look it up using
the password function, too.
Ken Hylton
Programmer Analyst IV
LEC Systems Programming
Billing Concepts, Inc.
7411 John Smith Drive
San Antonio, Texas 78229-4898
(210)
multiple commands Not as far as I know, you need to open your file, read
the commands and process them one at a time.
The C API is not magic and has no more capability than you do setting down
and typing in the commands yourself.
What you can do is build one HUGE insert command from lots of
I don't think MySQL has a mechanism for doing any sort of stored procedure,
but, I just saw this earlier today and went adn looked at it.
It may help you, but I know nothing about it and con offer no further
advice.
Ken Hylton
Programmer Analyst IV
LEC Systems Programming
Billing Concepts,
I read your article and found it to be interesting and overall, quite
accurate.
I do have one bone to pick with you however.
I know the MySQL staffer who worked the MySQL portion of the test. I had
occasion to meet him and talk briefly about the PC Magazine test in Houston
the week following
Howdy -
You are trying to telnet to the MySQL server.
3306 is the MySQL Server default port, not the telnet port.
If you are trying to run the MySQL client, then:
1) telnet mysqlserverhostname
2) run the Mysql client within your telnet session (mysql -uroot -proot, for
example)
If you are
Howdy -
I've posted this twice before - third time might be the charmer...
Can anybody help me?
I am using the C API and am returning a result set from a table with a BLOB
type item in it.
When I populate the BLOB fields initially (with all the same data) the
length is returned properly when I
The best book for c programming I found is the O'Reilly book, MySQL mSQL
. It has a good example of using the C API and even builds some simple C++
classes.
The book, MySQL by Paul DuBois is the best overall MySQL book I found.
Plus, Paul is a regular responder to this list, so I would buy
Howdy -
I am using the C API and am returning a result set from a table with a BLOB
type item in it.
When I populate the BLOB fields initially (with all the same data) the
length is returned properly when I issue SELECT * FROM table and decode
the result set column metadata.
Meaning, that if I
]
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
-Original Message-
From: Kenneth Hylton [mailto:[EMAIL PROTECTED]]
mailto:[mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 03, 2002 1:19 PM
To: '[EMAIL PROTECTED]'
Subject:C API BLOB type field lengths returned
Howdy -
I
Hi Justin -
I have run into the same issues and have given up on using MySQL++ interface
for that reason, plus it doesn't have the ability to update tables
dynamically.
That is, if you need to update anything, you have to define the table to a
macro at compile time! Change a table, recompile
Howdy -
I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly
book and can't find an example of how to do column level security.
We are running 3.23.46-Max on Red Hat 7.2
Here is what I am trying:
mysql GRANT ALL (BatchControlUri, IndustryId, UpdateId) ON
Howdy -
I looked in the doc @ mysql.com and the New Riders and O'Reilly MySQL books.
Plus, I consulted the archives as best I could and did not see an answer for
this:
How do you insert binary data using the C API?
I know you need to use mysql_real_query method and pass length, but how do
-
From: paradoxix [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 3:04 PM
To: Kenneth Hylton
Cc: [EMAIL PROTECTED]
Subject:Re: INSERT blob data in C
just some code I did some time ago
Hi Robert -
The only way I have found to get this sort of stuff (as well as security
info) out is to use mysql_query (or mysql_real_query) and issue the query
just like you would at the mysql client.
Then you can interpret the results that are returned.
I am having to do that with column
Hi Robert -
Not an MySQL expert, but, I think what you are describing is a perfect use
of MERGE tables. They take up basically no space (except to contain the
names of the tables that are merged) and allow for you to merge these two
tables logically and then just do whatever queries you want
31 matches
Mail list logo