MYSQL RSS

NAVIGATION

SQL Syntax Errors

"Siegfried Heintze" <siegfried (AT) heintze (DOT) comwrote on 06/29/2005 03:09:28PM:671 Did not find any old versions with SELECT cJobTitle FRMjobtitlecountWHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt toinsertone: INSERT INT jobtitlecount (fkJobPosting, dtSnapS...

0 answers | 4357 bytes |

SQL Syntax Errors

671 Did not find any old versions with SELECT cJobTitle FRM jobtitlecountWHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to insertone: INSERT INT jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES(209689,'2005-06-26',1)671 Did not find any old versi...

0 answers | 2827 bytes |

Ordinal number within a table

It's probably much faster to do this in perl, since the use of @rowmeans MySQL can't use its query cache....

0 answers | 119 bytes |

bk commit into 5.0 tree (heikki:1.1981) BUG#11633

Below is the list of changes that have just been committed into a local5.0 repository of heikki. When heikki does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeCh...

0 answers | 6337 bytes |

effective handling of fuzzy dates (MySQL/PHP)

Hello,Please excuse me if this has been posted in the wrong spot.I'm storing historical information in a MySQL database and am using the datefield formatted in YYYY-MM-DD.For the most part, the data entered is correct and uses the full YYYY-MM-DDformat, however, I've got numerous dates...

1 answers | 1262 bytes |

bk commit into 5.1 tree (joreland:1.1916)

Below is the list of changes that have just been committed into a local5.1 repository of jonas. When jonas does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeChan...

0 answers | 4498 bytes |

Square brackets

I am trying to connect through to the Mysql DB from Montageusing Mysql DBC drivers. Whilst connects to Mysql no problem,it fails when trying to obtain metadata. This is because it is usinga form of SQL which puts square brackets around the table names.An example would be "select latitude from [G...

1 answers | 933 bytes |

bk commit - mysqldoc@docsrva tree (jon:1.2908)

Below is the list of changes that have just been committed into a localmysqldoc repository of jon. When jon does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeCha...

0 answers | 4693 bytes |

bk commit - mysqldoc@docsrva tree (Mike.Hillyer:1.2907)

Below is the list of changes that have just been committed into a localmysqldoc repository of root. When root does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeC...

0 answers | 768 bytes |

R: field_num("pippo") = ????

Paoletti Vincenzo wrote:the ref manual advices against uses it of "lookup_by_name" to cause its inefficiency .lookup_by_name() is inefficient because it's built on field_num().If efficiency is a concern, you shouldn't be looking up fields by nameat all. You should be using hard-coded i...

0 answers | 514 bytes |

bk commit - mysqldoc@docsrva tree (Mike.Hillyer:1.2901)

0 answers | 1217 bytes |

Retrieving entire columns from a resultset

Hi John,Thanks a lot for that detailed reply!I am not going planning to do any kind of sorting / searching activitieson the data retrieved columnwise.To give you an idea of what I wish to do - I have a few tables in thedatabase. I have one class that reflects one specific table from thedatabase....

0 answers | 3574 bytes |

QUESTION ON "MYSQL"

EMSDN.COM

Home- About Us- Contact- Privacy Statement- Link Exchange- Bookmark- Map.XML- Rss.Xml
0.359