Re: insert random number into table

On October 16, 2009 12:29:42 pm Jerry Schwartz wrote: > >-Original Message- > >From: Ray [mailto:r...@stilltech.net] > >Sent: Friday, October 16, 2009 1:10 PM > >To: mysql@lists.mysql.com > >Subject: Re: insert random number into table > > > >On October 16, 2009 10:57:48 am Jerry Schwartz w

Re: inserting csv - solved, but more to the puzzle

Thank you for the confirmation, Andy. I appreciate your patience with such a newbie who is just trying to learn. Andy Wallace wrote: I've run into similar situations w/regard to Mac vs PC CSV files, it usually has to do with the EOL character sequence. Macs use LF (chr(10)), while PCs use CRLF

Re: inserting csv - solved, but more to the puzzle

I've run into similar situations w/regard to Mac vs PC CSV files, it usually has to do with the EOL character sequence. Macs use LF (chr(10)), while PCs use CRLF (chr(13)chr(10)). andy Patrice Olivier-Wilson wrote: In case anyone might find this of the least interest, probably not, but I always

inserting csv - solved, but more to the puzzle

In case anyone might find this of the least interest, probably not, but I always hope to add to discussion just as part of the thank you for help. Further work with same issues found that a file received from a PC based client, if opened in PC environment, didn't have the same problems (so far

Re: insert random number into table

I always maintain a timestamp in my random numbers. As long as my precision is higher than my requests per second, wouldn't I be safe from collisions? Assuming a time machine is not invented. -- Scott Iphone says hello. On Oct 16, 2009, at 11:29 AM, "Jerry Schwartz" > wrote: JS] Just remem

Re: insert random number into table

In addition to what Gavin said. You seem to want some form of key perhaps to be able to identify the authenticity of your contest winner. An auto increment ID won't be very secure for that, but you still need it. Take a known combination of perhaps the key, name, email address, etc, and r

RE: insert random number into table

>-Original Message- >From: Ray [mailto:r...@stilltech.net] >Sent: Friday, October 16, 2009 1:10 PM >To: mysql@lists.mysql.com >Subject: Re: insert random number into table > >On October 16, 2009 10:57:48 am Jerry Schwartz wrote: >> There is a RAND function in MySQL, but if you need to guara

RE: insert random number into table

Don't try to give them a random number, instead use a table with a primary key that is AUTO_INCREMENT. Then you just insert the record, and afterwards SELECT LAST_INSERT_ID(); to retrieve the id for the record created. With random numbers, you're going to have more collisions when you add more

Re: insert random number into table

On October 16, 2009 10:57:48 am Jerry Schwartz wrote: > There is a RAND function in MySQL, but if you need to guarantee that the > identifiers are unique you should consider using an auto-increment field. > > If that isn't unique enough, you can use the UUID or UUID_SHORT functions. > Theoretically

RE: insert random number into table

There is a RAND function in MySQL, but if you need to guarantee that the identifiers are unique you should consider using an auto-increment field. If that isn't unique enough, you can use the UUID or UUID_SHORT functions. Theoretically, those should return values that are unique across the Inter

Re: Inserting an Image

Well, I've spent the last 2 days chasing my tail just to discover that there was some screwy python deal going on. The following code works: sql = "update productsX set Name='%s', Title='%s', Description='%s', Price='%s', Bedrooms='%s', Bathrooms='%s', Conditions='%s', Acreage='%s', Construc

insert random number into table

Hello All, I am trying to insert a unique random number* with each row when inserting into a table. I can do it in the application layer (php) but just wondering if there is an easier way in the database layer. Thanks Ray * for example, when registering a person for a contest, I want to give th

deleting the node, and child nodes/leafs for a db/tbl..

Hi. I've got a situation where I have a couple of tables. The relationship between the tables is one of parent/child. I'm trying to figure out the best approach to being able to delete the associated children in the child tbls, of a given parentID in the parentTBL... I've checked into various sit

Re: Change clock/timezone time without restart mysql

Jonas, your information is somewhat incomplete, but still: Jonas Silveira wrote: > Hi, > > > > I need to change the computer clock (changing the /etc/zoneinfo) but I would From the file name, I assume it is some Unix platform. > not restart de MySQL service. The NOW() still returning the o

Change clock/timezone time without restart mysql

Hi, I need to change the computer clock (changing the /etc/zoneinfo) but I would not restart de MySQL service. The NOW() still returning the old time... Thanks, Jonas

Performance tuning a group by with percentage

Running MySql 5.0.85, I need to be as efficient as possible about a few queries. If I could get a little review, I would appreciate it. I collect data in the millions, and need the top 50 grouped by one field, with a percentage of how much those top 50 occupy. Here is what I have come up wi