beginners question - Not Makine Duplicate Entrys

2003-03-26 Thread Wileynet
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

RE: beginners question - Not Makine Duplicate Entrys

2003-03-26 Thread Dathan Vance Pattishall
] 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

beginners question

2002-04-15 Thread Marcia Clover
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

Re: beginners question

2002-04-15 Thread Richard Emery
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

RE: beginners question

2002-04-15 Thread Marcia Clover
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

RE: Beginners Question

2002-04-05 Thread 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

Re: Beginners Question

2002-04-05 Thread Christopher Thompson
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

Beginners Question

2002-04-01 Thread Zhao, Charles
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

Re: Beginners Question

2002-04-01 Thread Tyler Longren
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

RE: Beginners Question

2002-04-01 Thread Todd Williamsen
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