RE: beginners question - Not Makine Duplicate Entrys
Set a primary key / unique key on a column (s) in myTable to make that row unique. Goto mysql.com and type primary key in the search dialog. There is a wealth of knowledge there. Or use google site:mysql.com Primary Key syntax -Original Message- From: Wileynet [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 3:35 PM To: 'mysql users' Subject: beginners question - Not Makine Duplicate Entrys Is there a sql statement that would not allow the same entry twice. Something like INSERT into myTable s WHERE s != Value(?). I don't know if that makes sense but I thought I would give it a shot. Basically I want to know if it is possible and if so can you point me to a webpage or give me an example if you can? Thanks in advance - Wiley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: beginners question
actually, another member of this list has already helped me figure it out. thanks. -Original Message- From: Richard Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 3:42 PM To: Marcia Clover; [EMAIL PROTECTED] Subject: Re: beginners question show your table structures show us your data show us the commands you used to export the data show us the commands you used to import the data can't read your mind... - Original Message - From: Marcia Clover <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 12:11 PM Subject: beginners question I'm converting an Access database to mySql (finally), and I'm having some problems: #1 - I have created a text file from Access to be able to import the data into the mySQL db, that part is ok, the problem is, from my 12 records (just a sample project), mySQL is only importing 6, the odd number records... very odd! why?? #2 - how do I make mySQL understand special characters, such as é... for fiancé?? Thanks, M&M - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: beginners question
show your table structures show us your data show us the commands you used to export the data show us the commands you used to import the data can't read your mind... - Original Message - From: Marcia Clover <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 12:11 PM Subject: beginners question I'm converting an Access database to mySql (finally), and I'm having some problems: #1 - I have created a text file from Access to be able to import the data into the mySQL db, that part is ok, the problem is, from my 12 records (just a sample project), mySQL is only importing 6, the odd number records... very odd! why?? #2 - how do I make mySQL understand special characters, such as é... for fiancé?? Thanks, M&M - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Beginners Question
On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote: > Thanks Todd and Tyler for the encouragement, > > When I searched on Mysql column types, I did not find any obviously > suitable for images. I do not suppose I can use VARCHAR, can I? Use one of the BLOB types. Note that if you are running a web server, you might be better off just storing a path and filename in the database and have apache serve the image itself. > Also, I need to have very good performance on data retrieval and transport, > which means I also need to have maximum retrieval speed and minimun memory > size of my images. My images are just plain graphics, no rich colors. How > can I realize the above purposes? Photographic images should normally be stored as jpegs, line-art drawings as png. - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Beginners Question
Thanks Todd and Tyler for the encouragement, When I searched on Mysql column types, I did not find any obviously suitable for images. I do not suppose I can use VARCHAR, can I? Also, I need to have very good performance on data retrieval and transport, which means I also need to have maximum retrieval speed and minimun memory size of my images. My images are just plain graphics, no rich colors. How can I realize the above purposes? Thanks for any help. -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:41 PM To: 'Zhao, Charles'; [EMAIL PROTECTED] Subject: RE: Beginners Question Yes, mySQL is up to the task. Just make sure you design the DB with fast retrivals in mind -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:53 PM To: '[EMAIL PROTECTED]' Subject: Beginners Question Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Beginners Question
Yes, mySQL is up to the task. Just make sure you design the DB with fast retrivals in mind -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:53 PM To: '[EMAIL PROTECTED]' Subject: Beginners Question Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Beginners Question
MySQL will be good for this type of stuff. Tyler - Original Message - From: "Zhao, Charles" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 01, 2002 3:53 PM Subject: Beginners Question > Hello there, > > I am trying to find which database to use. I will have text and image data. > Lots of image data. Most of the time I am doing data retrieving, but when > updating, it will be text almost always. No enterprise use, but very busy > database hits. Could any one please educate me if mysql is a good database > for this purpose? Or anything else? > > Many thanks. > > -- charles > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php