Re: open source shema relationship diagram tool

Hi Daniel, sorry for mistaken your request. So I guess you are a developer and want to modify and create your own source code ? 2003年 6月 13日 金曜日 15:[EMAIL PROTECTED] さんは書きました: > none of these are open source and its under windows > > http://www.minq.se/products/dbvis/images/screens/graph.html >

tables locked during connection failure & processes not auto killed after timeout

Am I missing a configuration setting somewhere? I have been working on a MySQL Max (3.23.52-max-nt) database running on W2K Server. I am using a MySQL client remotely over a VPN but unfortunately the client's internet connection is severely overloaded and the connection dies on occasion. When th

Re: open source shema relationship diagram tool

none of these are open source and its under windows http://www.minq.se/products/dbvis/images/screens/graph.html this is what i want to do , except its on myisam tables not inondb so there is no foreign key relations i join them in the query or can i still do this ? > Hi Daniel, > > The question

Re: open source shema relationship diagram tool

Hi Daniel, The question was asked many times within the last 24 hours. look for these threats - Open-Source/Freeware Tool To Generate ER Diagrams From SQL Sc ripts ? - ImportER (ER Tool: Dezign) - mysql GUIs - www.datanamic.com/download/index.html www.minq.se (DbVisualizer -c harting

RE: Native MS Access 97 Searches from an Access Form

do not use Ctrl-F, it will retrieve all the records and then try to find the specific record. Instead change the form record source property dynamically with SQL statement having appropriate where clause, result will within eye blink. regds, -Original Message- From: Sean Meegan [mailto:[

Re: odbc.ini

On Thu, 2003-06-12 at 17:29, David Crowley wrote: > Please change the comments at the top of the example odbc.ini file to > start with "#" instead of ";" characters.. It took my 2 hours to find > out why unixODBC was choking... Thanks, will be taken care. -- Regards, Venu For technical support

RE: Thousands of users? Newbie question

Look into mod_auth_mysql -- this module rocks and I use it all the time. > -Original Message- > From: Curtis Maurand [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2003 3:33 PM > To: 2Hosts.com > Cc: [EMAIL PROTECTED] > Subject: Re: Thousands of users? Newbie question > > > > >

Re: soft real-time database

At 05:03 PM 6/12/2003 -0600, Chris Webster wrote: Curtis Maurand wrote: I'd write a perl script to pool the device and send the data to the database. Sorry for not being clearer. I can get the data into the database fine. Assuming new values or rows are added once per second, how would a client

Slow Connection to MySql 4 Host

My MySql4.1 run on RH Linux 9. I found when I coonect to MySql Host, it take so long. How to fine tune it. Thanks.

open source shema relationship diagram tool

hi there i was wondering if there was a table relationship diagram open source tool around anywhere ? i am trying to document a project at the moment please let me know thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

odbc.ini

Please change the comments at the top of the example odbc.ini file to start with "#" instead of ";" characters.. It took my 2 hours to find out why unixODBC was choking... Thanks!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: FULLTEXT Search and Charsets

> > ... > >The FULLTEXT search only seems to find words in the latin charset. > > > >Does anyone have any guidance on how I can get it working with other > >charsets? > > FULLTEXT currently works only with single-byte character sets. And UTF-8 makes it easy to handle latin as if it were single-by

Re: soft real-time database

> Assuming new values or rows are added once per second, how > would a client program go about polling the database to see when a new > value was ready? Check # of rows for a column and when it's > incremented grab the latest value? Use an id field as the primary key with a statement like this: S

Re: Native MS Access 97 Searches from an Access Form

Sean Meegan wrote: I'm running Access 97 as a front end to a MySQL ODBC linked table. Everything is working fine with the exception of "long searches" from within Access. In the past we would be able to go to any one of the fields from within the Form, and then do a Ctrl + F to find a record by

Re: sum on counts

At 18:31 -0400 6/12/03, Becoming Digital wrote: > >>select SUM(IF(C=1,1,0)) AS VIEW_1, SUM(IF(C=2,1,0)) AS VIEW_2, >>SUM(IF(C=3,1,0)) AS VIEW_3, count(*) as C from object_hist where >>type_id=5879 group by object_id and it complains about unknown column C. Anyone have any insite on how to do

Re: How can I get the number of entries retrieved by a "SELECT - FROM"

At 17:57 -0400 6/12/03, ed anderson wrote: Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30, httpd_2.0.44 1. How do I trap or collect or save the digit "3" generated the mysql "SELECT COUNT(*)" statement below? 2. The PHP "SELECT FROM" below (before snip) listed the

RE: sum on counts

I tried that way also Unfortunately I get ERROR 1054: Unknown column 'C' in 'field list'. Btw... In case it matters ver4.0 -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 5:31 PM To: Christopher Knight; MySQL List Subject: Re: sum on cou

Re: again with SELECT

SET is limited to 64 bit values (i.e. only 64 possible colors). Solution given by Kevin Fries [EMAIL PROTECTED] (with unique color/item having count query) seems very efficient. Thank you all for taking time to ponder my question. - Original Message - From: "Mike Hillyer" <[EMAIL PROTEC

Re: soft real-time database

Curtis Maurand wrote: I'd write a perl script to pool the device and send the data to the database. Sorry for not being clearer. I can get the data into the database fine. Assuming new values or rows are added once per second, how would a client program go about polling the database to see whe

RE: again with SELECT

Rather than using primes, you could use the SET datatype http://www.mysql.com/doc/en/SET.html This allows for a color to be zero or more values at the same time. SELECT * FROM tbl_name WHERE color = '1,2,3,n' Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Kevin Fries [m

Re: soft real-time database

Becoming Digital wrote: If I interpret correctly, you'd like to to read sensor data (not in ASCII format) as FLOATs and insert it into a database on the fly without an intermediary. While this may be possible, perhaps there's a better solution. There is an intermediary which is doing the inserting

Re: mySQL GUIs

For Mac OSX try - http://cocoamysql.sourceforge.net Not bad at all :) regards Brynley At 12:22 PM -0400 12/06/2003, Ed Leafe wrote: On Thursday, June 12, 2003, at 10:44 AM, Justin wrote: Anybody have any recommendations for one that runs on Mac OS X? I use phpMyAdmin to manage several MySQL

RE: again with SELECT

I think you can get those rows that have multiple colors, if you know the list of colors to check for... Maybe this can help... SELECT itemID from theTable Where colorID in (1,2,3,4,...N) Group by itemID Having count(*) = N; This will only return the itemID if it appears in all of the colors lis

Re: soft real-time database

I'd write a perl script to pool the device and send the data to the database. Curtis On Thu, 12 Jun 2003, Becoming Digital wrote: > If I interpret correctly, you'd like to to read sensor data (not in ASCII > format) as FLOATs and insert it into a database on the fly without an > intermediary.

Re: Which version do I install?

x86 IA64 is Itanium. Curtis On Thu, 12 Jun 2003, Jason wrote: > I am used to using P3 and P4 machines with the "x86" download. > > I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the "x86" > download, or is there a better binary to use (ie > IA64)? > > Any other tips for

Re: again with SELECT

On 13 Jun 2003 at 4:02, gamin wrote: > To each colorID you assign a unique prime number (maintain this in a > table). For each itemID now you have a unique colorPRODUCT (product of > the prime numbers coressponding the various colorIDs for this itemID). > To add a colorID to an itemID simply mulip

Re: mySQL GUIs

PHPMyAdmin Support for MySQL 4.1 is starting to appear. Runs on a webserver and just gets it done. (Though I still use mysqlcc, too.) I find that mysqlcc runs better if you compile it yourself. You also get more themes. ;-) Curtis On Thu, 12 Jun 2003, Justin wrote: > Anybody have any re

Re: soft real-time database

If I interpret correctly, you'd like to to read sensor data (not in ASCII format) as FLOATs and insert it into a database on the fly without an intermediary. While this may be possible, perhaps there's a better solution. I would suggest reading the data to a file (which you must be able to do any

Re: again with SELECT

> thats effectively an OR statement, isnt it? > > how would i select the itemsIDs that have all the requested colors? > > for example if data was: > id:colorID:itemID > - > 11 1 > 21 2 > 3

Re: Thousands of users? Newbie question

I think that I would code it into my application. Essentially, I would set up Agents on your end so that your customer service folks can set up companies and administrative users for those companies. Then let the companies handle their own users. Each company would have a database password

Re: sum on counts

> >>select SUM(IF(C=1,1,0)) AS VIEW_1, SUM(IF(C=2,1,0)) AS VIEW_2, > >>SUM(IF(C=3,1,0)) AS VIEW_3, count(*) as C from object_hist where > >>type_id=5879 group by object_id > > and it complains about unknown column C. Anyone have any insite on how to > do this? Syntax, my dear boy. It's just a h

Re: again with SELECT

Ah, I see what you mean, I misunderstood before. In this case, I would tend to reevaluate my table structure since you're inherently giving a key (colorID) more than one possible value (1 or 2) at the same time. There could be something you could do with DISTINCT but I can't think exactly how

RE: How can I get the number of entries retrieved by a "SELECT - FROM"

Change you SQL statement as follows. "SELECT Count(*) as Cnt FROM" Then use "Cnt" as your "variable" like you would "h_id" Roger. > -Original Message- > From: ed anderson [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2003 5:58 PM > To: [EMAIL PROTECTED] > Subject: How can I

Re: again with SELECT

thats effectively an OR statement, isnt it? how would i select the itemsIDs that have all the requested colors? for example if data was: id:colorID:itemID - 11 1 21 2 31

Re: again with SELECT

Hi, > how do I select all itemIDs that have colorID = 1 and colorID = 2 and > colorID = 3 ... and colorID = N ? > Try this SELECT itemID FROM theTable WHERE colorID IN (1,2,3,...,N); G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

How can I get the number of entries retrieved by a "SELECT - FROM"

Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30, httpd_2.0.44 1. How do I trap or collect or save the digit "3" generated the mysql "SELECT COUNT(*)" statement below? 2. The PHP "SELECT FROM" below (before snip) listed the expected data. Is there a way to get

Re: again with SELECT

danchik wrote: coming back to my earlier question but much more simplified portion of it :) I the following table : theTable --- ID | int (key) colorID | int itemID | int --- how do I select all itemIDs that have colorID = 1

Re: DATE

At 16:43 -0500 6/12/03, Wong Zach-CHZ013 wrote: Hi How do I rename a new column ? How do I drop a column ? From MySQL documentation, it refers to rename/drop table. I dont want to do that. Use the ALTER TABLE statement: http://www.mysql.com/doc/en/ALTER_TABLE.html Thanks Paul for your aid. -- P

RE: DATE

Use the ALTER TABLE syntax, see http://www.mysql.com/doc/en/ALTER_TABLE.html Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:43 PM To: 'Paul DuBois'; [EMAIL PROTECTED] Subject: DATE Hi How do I r

DATE

Hi How do I rename a new column ? How do I drop a column ? >From MySQL documentation, it refers to rename/drop table. I dont want to do that. Thanks Paul for your aid. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: DATE

At 16:23 -0500 6/12/03, Wong Zach-CHZ013 wrote: Hi 1 - I have a column whose datatype is longtext. Its content is 08/06/2003; I created a new column whose datatype is DATE. Its content is null now. How do write a SQL statement that inputs each row from 08/06/2003 in the old column to 2003-08-06 in

Re: Bug with MySQL (was Re: Problem with MAX())

At 16:09 -0500 6/12/03, Chris Boget wrote: > CREATE TABLE do_deductibles ( currency varchar(10) NOT NULL default '', assets int(20) NOT NULL default '0', deductible int(10) NOT NULL default '0', do_deductibles_id int(5) NOT NULL auto_increment, PRIMARY KEY (do_deductibles_id), U

Re: FULLTEXT Search and Charsets

At 14:13 -0700 6/12/03, Peter Bryant wrote: Hi. I have a table with a fulltext search index on a field. I am inserting text using UTF-8 characters (with the JDBC driver). That includes words in English, French, Russian and Greek. The FULLTEXT search only seems to find words in the latin charset.

DATE

Hi 1 - I have a column whose datatype is longtext. Its content is 08/06/2003; I created a new column whose datatype is DATE. Its content is null now. How do write a SQL statement that inputs each row from 08/06/2003 in the old column to 2003-08-06 in a new column ? Eg: old column name - my_date ne

FULLTEXT Search and Charsets

Hi. I have a table with a fulltext search index on a field. I am inserting text using UTF-8 characters (with the JDBC driver). That includes words in English, French, Russian and Greek. The FULLTEXT search only seems to find words in the latin charset. Does anyone have any guidance on how I ca

Bug with MySQL (was Re: Problem with MAX())

> CREATE TABLE do_deductibles ( > currency varchar(10) NOT NULL default '', > assets int(20) NOT NULL default '0', > deductible int(10) NOT NULL default '0', > do_deductibles_id int(5) NOT NULL auto_increment, > PRIMARY KEY (do_deductibles_id), > UNIQUE KEY do_deductibles_idx (currency

Re: Problem with MAX()

> > What's going on with the MAX() function? Why did it return NULL > > in the first query above. There were no adding/deleting data between > > the above queries and yet MySQL didn't pull the MAX from the table > > until I added the "AND assets IS NOT NULL" to the query. And yet > > after I ran

Linking libmysqld.a Error (Embedded Server)

I'm writing an application that uses the MySQL embedded server as the datasource but for some reason, I can't link in the mysqld library. I'm using the following command: [EMAIL PROTECTED] dbil $ gcc -g -o test `mysql_config --cflags --libmysqld-libs` dbiltest.c where

Re: Which version do I install?

> I am used to using P3 and P4 machines with the "x86" download. > > I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the > "x86" download, or is there a better binary to use (ie IA64)? > > Any other tips for someone new to the Xeon chip family with linux would > be nice too. >

again with SELECT

coming back to my earlier question but much more simplified portion of it :) I the following table : theTable --- ID | int (key) colorID | int itemID | int --- how do I select all itemIDs that have colorID = 1 and colorID

Re: DATE - longtext

At 14:44 -0500 6/12/03, Wong Zach-CHZ013 wrote: Hi I have a database whose table has a column, which has a datatype longtext. I then try a query mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND '10/21/2 003'; I thought it would fail since the datatype isnt DATE nor TIMEST

Which version do I install?

I am used to using P3 and P4 machines with the "x86" download. I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the "x86" download, or is there a better binary to use (ie IA64)? Any other tips for someone new to the Xeon chip family with linux would be nice too. -- MySQL G

DATE - longtext

Hi I have a database whose table has a column, which has a datatype longtext. I then try a query mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND '10/21/2 003'; I thought it would fail since the datatype isnt DATE nor TIMESTAMP. But from the result, it seems to work. 1

sql Query problem?

Hi, I have a sql query problem... user points table, which I am sorting(order by) points. Now if I want to have some 5 records above and below a certain member, how could I write the sql query for the same? say I want 5 records above and below NICKNAME_14! thanks and regards, point nickname -

Re: Open-Source/Freeware Tool To Generate ER Diagrams From SQL Sc ripts ? - ImportER (ER Tool: Dezign)

* Eldrid Rensburg ([EMAIL PROTECTED]) wrote: > Apparently, the reverse engineering add-on utility, ImportER, for the ER > Tool, Dezign, see Free evaluation versions: > www.datanamic.com/download/index.html can import MySQL tables directly. Having looked at that, it only runs on Windows. It also lo

Re: Open-Source/Freeware Tool To Generate Entity Relationship Diagram s From Text File Containing SQL Scripts ?

* Eldrid Rensburg ([EMAIL PROTECTED]) wrote: > I have exported tables from MySQL 3.23 to a text file script containing all > its 'create table', indexing, etc, statements. > Is there an open-source / freeware tool to generate Entity Relationship > Diagrams from this script file ? > If not what oth

Re: Replication problems

On Wed, Jun 11, 2003 at 05:22:50PM +0530, Mithun Bhattacharya wrote: > I am frequently getting errors as given below on my slave server. > > - > 030605 3:27:19 Slave: did not get the expected error running query > from master - expected: 'Got erro

Re: mysql and clustering

On Wed, Jun 11, 2003 at 12:21:17PM +0200, Roberto Barbieri wrote: > > They're completely different clustering solution. What, exactly, are > > you trying to acheive? LVS is primarily for load balancing and > > possibly fail-over. OpenMosix is a different beast entirely. > > > > Jeremy > > Than

Re: mySQL GUIs

* Rodolphe Toots ([EMAIL PROTECTED]) wrote: > hi! > > i am looking for a good mySQL gui for windows > i have used mySQL front, which was an excellent free program, but i did not handle > relations and diagrams. also the program is no longer being developed > Try MySQL's own MySQL Control Center

RE: query question

Thank y'all very very much. Each day I learn something new ;) susan -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 1:35 PM To: Susan Ator; [EMAIL PROTECTED] Subject: RE: query question [snip] Is there a way to check if a field has x number

Reply-All (RE: mySQL GUIs)

> > I understand what you are saying, but all I did is was a > standard "all reply". > > So there is nothing I can do from my side ;-), thats either > the way you have > setup your e-mail client (reply to adress) and /or how the > mailing list > works. I've noticed that some messages from t

RE: query question

[snip] Is there a way to check if a field has x number of characters in it? I have a table with a column (phone) which, for the moment is varchar(25). I need to find those entries which have less than 10 characters. [/tuck] http://www.mysql.com/doc/en/String_functions.html mysql> SELECT LENGTH

RE: query question

SELECT * FROM mytable WHERE LENGTH(phone) < 10; http://www.mysql.com/doc/en/String_functions.html Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Susan Ator [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 11:23 AM To: [EMAIL PROTECTED] Subject: query question I

RE: Open-Source/Freeware Tool To Generate Entity Relationship Diagram s From Text File Containing SQL Scripts ?

WebObjects (30 day demo or $699) has a tool called Enterprise Object Modeler which reads in a database schema directly from the database and generates all the database diagrams, etc. and can generate Enterprise Objects in java to interact with the database. Might be worth playing with the demo to g

query question

Is there a way to check if a field has x number of characters in it? I have a table with a column (phone) which, for the moment is varchar(25). I need to find those entries which have less than 10 characters. Can this be done? Thanks susan -- MySQL General Mailing List For list archives: http

RE: "in" in where

Subselects such as this are only available in MySQL 4.1 and higher. You can upgrade, or rewrite this query as follows: SELECT tblSiteConfig.fldSiteID FROM tblSiteConfig, tblServerConfig WHERE tblSiteConfig.fldServerName = tblServerConfig.fldServerName Regards, Mike Hillyer www.vbmysql.com -

"in" in where

My first day with MySQLworking with a Access to MySQL project... when I try to execute the query: SELECT tblSiteConfig.fldSiteID FROM tblSiteConfig WHERE tblSiteConfig.fldServerName in (SELECT fldServerName from tblServerConfig) I get: [My_MYSQL] ERROR 1064: You have an error in your SQL syn

Re: Weird problem with differences MySQL 3.23.38 und 4.0.12

Some of the values passed to the CASE expressions are NULL. There was a bug in handling NULL in CASE that was fixed in MySQL 4.0.8: http://www.mysql.com/doc/en/News-4.0.8.html Note the last item on the page. I believe this explains the differences that you are seeing. At 16:28 +0200 6/12/03, Axel

left join

Hi there... I have this situation: table_A table_B id name id name 1 A 1 A 2 B 2 B 3 C If i run this statement : SELECT table_A.* FROM table_A outer join table_B ON table_A.id=table_B.id WHERE table_B.id is null and I got: id name 3C But now i wa

LEFT JOINs on link tables

Hi, I have a database which keeps track of STUDENTS doing CLASSES. Each CLASS has a list of ASSESSMENTs and the database stores a GRADE for each each STUDENT in the CLASS. The table structures are as follows: class: CID(*), Title, CourseCode, Year student:SID(*), FirstName, SecondName,

Re: mySQL GUIs

On Thursday, June 12, 2003, at 10:44 AM, Justin wrote: Anybody have any recommendations for one that runs on Mac OS X? I use phpMyAdmin to manage several MySQL databases, both on my LAN and over the internet. Way cool and powerful! ___/ / __/ / / Ed Leafe http://leafe.com/

Re: 4.1 character set documentation

At 15:05 +0900 6/12/03, Joel Rees wrote: Paul DuBois advised us that Alexander Barkov and Peter Gulutzan have written up some documentation on the new character set support in MySQL 4.1, which has now been added to the online manual. You can read it here: http://www.mysql.com/doc/en/Charset.ht

Re: newbie question

Well, for the image type at least, the blob type would be appropriate. -justin v7rg8 wrote: Hi all, my table is like this: professor (name, gender, bodyImage) Could anyone guide me how to deal with this image type data? Another question is how to implement "weak entity" in mysql. Thanks, A

Re: Open-Source/Freeware Tool To Generate ER Diagrams From SQL Sc ripts ? - ImportER (ER Tool: Dezign)

Apparently, the reverse engineering add-on utility, ImportER, for the ER Tool, Dezign, see Free evaluation versions: www.datanamic.com/download/index.html can import MySQL tables directly. QED -Original Message- From: Eldrid Rensburg [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 200

Re: mySQL GUIs

Just wanted to throw in my vote for phpMyAdmin. It requires that PHP and a webserver be installed... but EXTREMELY easy to use and actively updated. Currently supports MySQL 3. and 4.0.xxx, supposedly 4.1 support is on the way. www.phpmyadmin.net Later. Quoting Karam Chand <[EMAIL PROTECTED]

soft real-time database

Greetings, I'm new to databases, but I am considering one for soft real-time data recording of scientific data. Then any client/display program can grab data. I'll be recording 300-500 variables/columns per second for about 10 hours at a stretch. All variables are floats. a) Is there a wa

Re: mySQL GUIs

Hi Jim, Mysql members, I understand what you are saying, but all I did is was a standard "all reply". So there is nothing I can do from my side ;-), thats either the way you have setup your e-mail client (reply to adress) and /or how the mailing list works. You can unsubscribe from the mailing

Re: mySQL GUIs

Try SQLyog at http://www.webyog.com/sqlyog Its FREE and very powerful Karam --- Nils Valentin <[EMAIL PROTECTED]> wrote: > Hi Jim & Mysql List members, > > sad to hear that there are still people around not > using a propper OS ;-) - > like a Linux, BSD or Unix based OS. > > Anyway as you as

RE: delete record

hehe... been there... if there isnt a way if you have logging turned on, you might be able to find the insert and following updates statements in the log to rebuild the row. good luck chris -Original Message- From: Arcangelo [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 10:2

Re: mySQL GUIs

I like PremiumSoft's MySQL Studio (now called Navicat, I believe). Very clean, easy to use interface. You can get a trial here: http://www.mysqlstudio.com/ --Scott Brown At 01:16 PM 6/11/2003 +0200, Rodolphe Toots wrote: hi! i am looking for a good mySQL gui for windows i have used mySQL fron

RE: delete record

That depends, do you have a backup tape? ;) Unfortunatly a DELETE is a one-way trip. In theory the data is still there is the spot on the hard-drive has not been overwritten, but there are no tools (that I know of) to retrieve that row. Regards, Mike Hillyer www.vbmysql.com -Original Message-

RE: mySQL GUIs

Nils, and other well meaning members who mail me directly: (B (BI subscribe to the digest for a reason, please do not copy me directly on replies. (BYes, I'm guilty of doing this myself... Live and learn. (B (B (B-Original Message- (BFrom: Nils Valentin [mailto:[EMAIL PROTECTED] (B

sum on counts

Can you sum on counts? What I want is the # of objects with a freq of 1, freq of 2, freq of 3... and then total # of objects. >>select object_id from object_hist where type_id=5879; +---+ | object_id | +---+ | 2121 | | 3234 | | 2121 | | 4876 | | 4876 | |

Looking for a parseInt() / str_to_int() function...

Is there any built-in funtion at all, that allows us to parse number values from strings? This would be a huge aid in getting numeric sorting of results; something like: select scene, take from movie_table order by parseint(scene[,10]), scene, --> sc:8 | tk: sc:a9 | tk: sc:9 | tk

Open-Source/Freeware Tool To Generate Entity Relationship Diagram s From Text File Containing SQL Scripts ?

I have exported tables from MySQL 3.23 to a text file script containing all its 'create table', indexing, etc, statements. Is there an open-source / freeware tool to generate Entity Relationship Diagrams from this script file ? If not what other tools exist ? This message and any attachment

delete record

Hi, I've done these operations: - I deleted one record - I didn't execute "optimize table" Do you know if it's possible to undelete the record? Many thanks Arcangelo

Re: mySQL GUIs

Hi Jim & Mysql List members, sad to hear that there are still people around not using a propper OS ;-) - like a Linux, BSD or Unix based OS. Anyway as you asked about the best GUI for accesing MySQL - and as you asked the question you know there is only one best GUI ;-). Anything mentioned

Re: tables

Hi Edward, thanks a lot for your hints. I will try it as soon as possible. Best regards, Glenn "Becoming Digital" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > SQL isn't a spreadsheet program. It's a database programming language. As > such, it's not going to output tables i

Installation: mysqladmin and mysqlshow missing

All- I have had a problem with my install of MySQL on Rehat7.0 and I wonder if anyone has any advice. Here is what I have done. 1. When I installed RedHat, I installed the MySQL libraries from the RedHat CD. I think it was version 3.23 2. I installed the shared compat lib using rpm 3. I upgrade

Re: tables

At 12:25 +0200 6/12/03, Glenn wrote: Hi, I have this: ++---++ ¶ Jahr ¶ Name ¶ Budget ¶ ++---++ 2003 Hans 2000 2003 Fritz 5000 2004 Hans 1500 2005 Pia 3500 How is it possible to make this in sql? +-+ ¶ 2003 Hans

Re: my.cnf

At 10:22 +0200 6/12/03, Jon Haugsand wrote: * Paul DuBois You can relocate the data directory at server startup time with a --datadir option. But when looking for my.cnf files, the server will continue to look in the hardwired directory, if it exists. That's what that sentence means. (The se

newbie question

Hi all, my table is like this: professor (name, gender, bodyImage) Could anyone guide me how to deal with this image type data? Another question is how to implement "weak entity" in mysql. Thanks, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: mySQL GUIs

Anybody have any recommendations for one that runs on Mac OS X? Thanks! Justin On 6/12/03 9:21 AM, "Adam Nelson" <[EMAIL PROTECTED]> wrote: > I like MySQL Manager - it costs a bit of money, but I find it > indispensible. > > www.ems-hitech.com > > It runs on Windows AND Linux. I'll be switchi

RE: mySQL GUIs

I wrote my own admin tool. It runs in a browser under a Tango Application Server. It doesn't have all the features of some of the gui interfaces, but it has some features none of them have. I have the flexibility to add any new features I need, and I can access my client's databases from 2000 miles

Weird problem with differences MySQL 3.23.38 und 4.0.12

Hi everyone... I actually have two servers: 1. Server: MySQL 4.0.12 2. Server: MySQL 3.23.38 This query: SELECT o_obj, MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431, MAX(CASE WHEN o_key = '69B96431' THEN o_typ END) AS T_69B96431, MAX(CASE WHEN o_key = 'AA0

Re: about replication

I've written my own MySQL specific connection pool for load balancing connections across a single master multi-slave setup. You get a handle to a Connection object by calling 'checkout' or 'checkoutReadonly' where 'checkout' returns a read/write connection to the master and 'checkoutReadonly' re

RE: mySQL GUIs

I like MySQL Manager - it costs a bit of money, but I find it indispensible. www.ems-hitech.com It runs on Windows AND Linux. I'll be switching to the linux version in about two weeks, so I'll tell you how well it works. > -Original Message- > From: Knepley, Jim [mailto:[EMAIL PROTECTED

Visual Foxpro

Are you still using VisualFoxPro as the programmig language in your project? If so, you can use SQL functions from VisualFoxPro to connect to mySQL using ODBC Install mySQL (if you have not allready do it ) Then install MyODBC-3.51.06.exe (downloadable from mySQL page) Create the ODBC bridge to my

RE: Table design suggestions?

This wouldn't work for a member belonging to several groups. 3 tables is the way to go. Cordialement, Damien COLA -Original Message- i'd set it up like this Table Group id int auto_increment name char Table Member userID int auto_increment name char groupID -- MySQL Gen

Instant Messaging

Sehr geehrte MySQL Mitarbeiter, Da ich aktuell an einer Diplomarbeit im Bereich Corporate Instant Messaging arbeite und dazu eine Umfrage gestartet habe, bitte ich Professionals die Instant Messaging einsetzen, implementieren oder administrieren, an meiner Umfrage teilzunehmen. Sie dauert keine

  1   2   >