Raj,
Yup. It's that bug.
I got the row size to below 8K and the insertion takes place fine.
Thanks for pointing me in the right direction.
Kyong
On Wed, Oct 14, 2009 at 10:31 AM, Raj Shekhar wrote:
> Kyong Kim gmail.com> writes:
>
>> For sure all of our columns combined do not exceed 64K. We're
Victor,
again, your question has more to do with python usage than MySQL
per-se.. you would be better off pursuing these questions in a python
forum.
- michael dykman
On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey wrote:
> "Image in string form" Â sounds like you're not inserting binary data, r
"Image in string form" sounds like you're not inserting binary data, rather
some sort of encoded data. Even if it is binary, you'll have to escape at
least end quote characters, you can see clearly at the top of your data there
is :
'ÿÃÿà JFIF ÿÃC "" $(4,$&1'
Another thing to think abo
The first thing I think I have to sey is "it´s not a good idea to save image
data in a mysql table field", the best way is to save the file in your file
system and the file name in the table field, but, if you like to do that,
it´s better to be a blob field.
"Victor Subervi" escreveu na mens
Hi;
I have successfully inserted images, like yesterday, before into MySQL with
the following code:
sql = 'update productsX set pic1="%s" where ID=2;' % pic1
cursor.execute(sql)
where pic1 is simply an image uploaded through a form then sent over without
any alteration to another (pyth
A HUGE thank you to Michael and John.
There were a couple of things going on but I do not know why things
got the way they were can only assume the client files had some issue.
I pulled the file into text wrangler and removed
, `20` , `21` , `22` , `23` etc.
Then counted the num
Thanks for all the feedback. Going to download all of these and see which
best suits our needs.
Neil
On Thu, Oct 15, 2009 at 2:56 AM, Ye Yuan wrote:
> Hi Neil,
> You can try toad for mysql. It is free.
>
> --
> Thanks,
> YY
>
Those converters aren't all that great . I think its best to stay away from
them. If a csv is too complex for a 'LOAD DATA INFILE' command then why not use
an etl tool like talend to load the data?
Its easy to see where your converter has gone wrong but to 'fix' the query I'd
need the table inf
If you could show us the table structure (SHOW CREATE TABLE
membership), we could easily correctly the query.. you seems to have
some data among your field names...
If the question is about the CSV converter, you will have to ask them.
- michael dykman
On Thu, Oct 15, 2009 at 11:26 AM, Patric
Newbie question, please.
I have a csv file of 950 records, 20 fields.
I used this converter
http://csv2sql.evandavey.com/
and copied/pasted insert code into SQL in phpMyAdmin
and got this error
SQL query:
INSERT INTO membership( `members_ID` , `updated` , `notes` ,
`preferred_mail_stre
Do your realy need to know the differenz ? take everything as "string".
(breaks with pics/geodata but helps a lot).
re,
wh
sangprabv schrieb:
> Hi,
> I found no built in function in mysql to check whether a record is
> numeric or string. Is there any trick to do so? Many thanks.
>
>
>
>
> Wi
Only in the case you want to know the datatype and not the actual type of
information in a char field!
If you issue:
show fields from MyTable like 'FName';
you get:
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--
> From: sangprabv
> Subject: is_string or is_numeric
> To: mysql@lists.mysql.com
> Date: Thursday, 15 October, 2009, 10:34 AM
> Hi,
> I found no built in function in mysql to check whether a
> record is
> numeric or string. Is there any trick to do so? Many
> thanks.
You could use some regex to d
Hi,
I found no built in function in mysql to check whether a record is
numeric or string. Is there any trick to do so? Many thanks.
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> What are the best MySQL GUI tools available at the moment, for example
> SQLyog.
You could start with our AnySQL Maestro (free version available).
http://www.sqlmaestro.com/products/anysql/maestro/
Sincerely yours,
SQL Maestro Group Team
http://www.sqlmaestro.com
--
MySQL General Mailing List
Thanks.
Yes it's a delicate construct but tables like 'IP2Location' give me a
headache as NDB tables.
Yet I have to test if 7.0.X can handle it.
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Mittwoch, 14. Oktober 2009 17:33
To: Christian Meisinger
Cc: mysql@li
What are the best MySQL GUI tools available at the moment, for example
SQLyog.
Have you tried Database Workbench (Pro) yet? See www.upscene.com
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywher
17 matches
Mail list logo
