Hi,
I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32).
We have an client server application, server is located at another end of an
intranet and the nodes are connected from different ends of intranet.
In this modal, I need to store image of the student from one node that
Dear Walter Heck,
I am happy to receive immediate response from you.
I am not clear with your answer, can you please explain it?
Thank you
From: Walter Heck wal...@openquery.com
To: Vikram A vikkiatb...@yahoo.in
Cc: mysql@lists.mysql.com
Sent: Sat, 30
On Sat, Jan 30, 2010 at 19:03, Vikram A vikkiatb...@yahoo.in wrote:
I am not clear with your answer, can you please explain it?
Well, MySQL (as most databases) is not really suited for storing
images. If you create a networked storage that you can share between
both locations, that would solve
Bad idea. Sotring images is what a file system is for. Create an NFS
or other networked storage and store your images there. I don't see
the problem?
good luck,
Walter Heck
Engineer @ Open Query (http://openquery.com)
On Sat, Jan 30, 2010 at 18:54, Vikram A vikkiatb...@yahoo.in wrote:
Hi,
I
Dear Sir,
Let me explain what i understood,
1. I have to create a shareable folder among the network.
2. The image files has to be kept at share machine
3. Then the path (share machine) of the file has to be stored in the DB
4. When we want it has to be taken from the share
Is it So? then i
Martijn Tonies wrote:
database. I would also bet that 80% of the people who are actually
writing queries with that many joins don't have a solid grasp of the
fundamental principles of relational database design.
Why not? Normalizing gets you -more- tables, not less.
And normalizing is a
Dear One,
I found nice solution on the following citation
http://dev.mysql.com/tech-resources/articles/vb-cursors-and-locks.html
It was really helpful to me.
Thank you
VIKKI A
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
sorry the link i given is wrong. Please follow this
http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html
- Forwarded Message
From: Vikram A vikkiatb...@yahoo.in
To: MY SQL Mailing list mysql@lists.mysql.com
Sent: Sat, 30 January, 2010 7:04:01 PM
Subject: IMAGE STORE @
Rudy Lippan wrote:
How about complex data requirements? Depending on the resolution of
your data set, I could see a simple person-type object that contained
name, address, SSN, mother, and birth_info starting to approach the limit.
Cities change, address changes, names change, and even mothers
I agree with Walter, a filesystem is far better suited for this.
That said, mysql does have the ability to do what you are saying, you would
just store it as a
binary blob which is well documented and quite easy to use.
See: http://dev.mysql.com/doc/refman/5.0/en/blob.html
Colin
On January
On Sat, Jan 30, 2010 at 01:49, Vikram A vikkiatb...@yahoo.in wrote:
Dear Admin,
I would like to share and get inputs from experts on MYSQL Db.
I request you to grant access to me.
You may not have noticed, but you're already posting to the list.
All you have to do is subscribe and you
Hi, if you did your subscription in any lists, you will automatically added
to send and receive e-mails from professionals that are connected in it.
See lists here: http://lists.mysql.com/
Wagner Bianchi
2010/1/30 Daniel Brown danbr...@php.net
On Sat, Jan 30, 2010 at 01:49, Vikram A
When I try insert NULL to VARCHAR NOT NULL column, It will shows a
warning and convert NULL to '' then insert 。
I want to MySQL raise an exception when I try do that.
How to do that?
Thank you.
Miao
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Take a look at SQL_MODE ;)
Claudio
On Jan 30, 2010 5:05 PM, Miao Jiang jiangfri...@gmail.com wrote:
When I try insert NULL to VARCHAR NOT NULL column, It will shows a warning
and convert NULL to '' then insert 。
I want to MySQL raise an exception when I try do that.
How to do that?
Thank you.
mysql SET sql_mode = TRADITIONAL;
Query OK, 0 rows affected (0.02 sec)
Then the insert query will fail and the row will not be added to the
table...see you.
Wagner Bianchi
2010/1/30 Claudio Nanni claudio.na...@gmail.com
Take a look at SQL_MODE ;)
Claudio
On Jan 30, 2010 5:05 PM, Miao
Vikram A wrote:
Is it So? then i may have the following, when ever i want the image of a i
need look for the share machine! If it is not available it may cause some
difficulties.
1) NFS sharing a file (any file) is better suited for this task.
2) The DB should only hold the file
At 3:08 PM -0800 1/29/10, Brian Dunning wrote:
Thanks for the suggestions but I couldn't find any that suited my
needs, so I made my own. Feel free to download if you can use them,
I made files with up to a million unique records.
Name, Company, Address, Phone, Email, etc., all are fake but
17 matches
Mail list logo