designer
Do u know any programme that can degin databases in order to design before i implement them? It ll be very useful if the design was transformed to the correspondings create syntax? Thx - Do you Yahoo!? Free Pop-Up Blocker - Get it now
RE: designer
Do u know this one? It seems to be gpl http://www.fabforce.net/dbdesigner4/ Peter Lovatt <[EMAIL PROTECTED]> wrote:Hi try DEZIGN FOR DATABASES http://www.datanamic.com/ hth Peter -Original Message- From: Alaios [mailto:[EMAIL PROTECTED] Sent: 30 November 2003 20:27 To: [EMAIL PROTECTED] Subject: designer Do u know any programme that can degin databases in order to design before i implement them? It ll be very useful if the design was transformed to the correspondings create syntax? Thx - Do you Yahoo!? Free Pop-Up Blocker - Get it now http://www.fabforce.net/dbdesigner4/ - Do you Yahoo!? Free Pop-Up Blocker - Get it now
on delete|update
Hi there. I am trying to find what these ON DELETE NO ACTION ON UPDATE NO ACTION would provide ib my db. What are the options and what each of them do? - Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: on delete|update--Disagreement
MyISAM supports foreign keys doesn't it? Martijn Tonies <[EMAIL PROTECTED]> wrote:No. MyISAM tables don't support foreign keys. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com - Original Message - From: Alaios To: Martijn Tonies Sent: Wednesday, December 03, 2003 4:57 PM Subject: Re: on delete|update axa!!! this works with myIsam tables? Martijn Tonies <[EMAIL PROTECTED]> wrote: Hi, > Hi there. I am trying to find what these > ON DELETE NO ACTION > > ON UPDATE NO ACTION > > would provide ib my db. What are the options and what each of them do? These have to do with Foreign Key Constraints. If you're using InnoDB tables, you could let MySQL automatically drop any child objects by using ON DELETE CASCADE. NO ACTION will raise an exception if there are child objects and you're trying to delete/update a parent row. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Do you Yahoo!? Free Pop-Up Blocker - Get it now - Do you Yahoo!? Free Pop-Up Blocker - Get it now
what about foreign keys?
Hi there I have some trouble with MyISAM tables. I have found that supports 3 different types of the 1:1 relation. a)1:1 b)1:1 (Non-Identyfying) c)1:1 (Descedent Obj.) What all these about? What type of tables do u use normally? I want to deploy a small application with a few tables (up to 10) in a system with 233 Mhz and 48 mb ram, so something "light" is required... Thx Suggestions plz? __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
test
test - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
plz help a newbie
Hi there just a lot lot lot of questions. Plz answer as many as you can. What do u prefer varchar(2) or tiny_text? What is the biggest size for the varchar? If I want to store a very big article. What is the biggest size for text that is being support? What is the difference between timestamp and DateTime? What do u suggest? What is the difference between Varchar and Binary Varchar? Details plz? I have these type of associations supported by mysql 1:1 1:1 (Non-Identyfying) 1:1 (Descendent Obj.) What are the differences among them? Especially the last one? - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
foreign keys plz?
Hi there. I heave heared that mysql doesnot support foreign keys? What funcionallity provides and what not? Inner Join what provides? Thx __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: foreign keys plz?
with myIsam? Does not check about integrity? Mysql 3.2? What u will use for your application Innodb or MyISAM? --- Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi, > > > Hi there. I heave heared that mysql doesnot > support > > foreign keys? > > It does, but only with the "InnoDB" table type. > > With regards, > > Martijn Tonies > Database Workbench - developer tool for InterBase, > Firebird, MySQL & MS SQL > Server. > Upscene Productions > http://www.upscene.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld dies
Hi there. I want to know what mysql provides. I want to start mysql manually so i write /etc/init.d/mysqld restart The mysql stops running succesfully but what it's time to start the mysqld i get a failed message. I am at loss because i can connect to the database remotely and insest, select records e.t.c Here is the log file less /var/log/mysqld.log "a mysqld process already exists since ." What can i do to fix it up? - Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
backup my database
Hi there. Do u know how can i backup my database? (create && insert) __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlcc syntax file?
Hi there. I am trying to create a table using the mysql control center but i am taking the error. Unable to locate syntax.txt Please locate the file. Any sugestion? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with order by .......... asc
Hi we need to order a field in a select query... The criteria is based on greek language... The problem seems to be no support for greek language I can change everything in the my.cnf so tell what to do - Do you Yahoo!? vote.yahoo.com - Register online to vote today!
select query does not work :(
Hi we need to order a field in a select query... The criteria is based on greek language... The problem seems to be no support for greek language I can change everything in the my.cnf so tell what to do ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
order by in different languages..
Hi.. Listen to a peculiar problem. We need to order by a column which includes Greek language. The order by doesnot work correctly. The reason may be the administration's installation. So we need a nice trick for doing our job as fast as we can without interacting with the admin. Nice..eh? You can propose different implementations as adding new columns or changing the query... So? Any suggestion? Thx a lot have a nice day __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: text retrieval functions
Thx for your interest.. The type of my question is for learning what to choose. I would use what u suggest me.. The only information i can provide u is that i am running linux.. If u can suggest me the version of mysql and the appropriate function and after i will continue searching... I am searching if i can implement some functionality of an information retrieval system using mysql...Do u have any resources available? --- [EMAIL PROTECTED] wrote: > You mention nothing about your environment. What OS > are you using? What > version MySQL (server and client) are you using? > > How do you intend to interact with your database? > Will you be using one of > the many tools available to directly interact with a > MySQL server or will > you be writing a script/program on your own? If you > are > scripting/programming, what language will you use > and which connection > libraries will you consider? > > Sorry to ask so many questions but your question was > so vague that it is > unanswerable. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Alaios <[EMAIL PROTECTED]> wrote on 12/15/2004 > 03:56:40 AM: > > > Hi... I need some function and the appropriate > type > > field s of a table that are able to search and > store > > big texts (such as books,magazines,articles) > > Thx a lot > > > > > > > > __ > > Do you Yahoo!? > > Yahoo! Mail - Find what you need with new enhanced > search. > > http://info.mail.yahoo.com/mail_250 > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > __ Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
text retrieval functions
Hi... I need some function and the appropriate type field s of a table that are able to search and store big texts (such as books,magazines,articles) Thx a lot __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with query comparing to a DATE on Linux OpenOffice
what a front-end is? And what OO1.1.0 provides? Marc <[EMAIL PROTECTED]> wrote:I'm using OpenOffice 1.1.0 as a front-end to MySQL 4.0.14 on Gentoo Linux and can't compare a field to CURDATE(). The error is, "The field cannot be compared with a date". The column is formatted as a DATE, and I can perform the compare fine using mysql. I realize this is probably related only to OpenOffice, and not a mysql problem, but I haven't gotten any answers on the OOo lists. So I'm hoping some kind soul on the mysql/myodbc lists might have experienced this and have an answer. Thanks for any ideas. -- Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
mysql@lists.mysql.com
Hi there . How can i passwords so i can login into myqsl. With current configuration anyone is allowded to login. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_client
Hi i have just installed the mysql_client and i am trying to remotely connect to the database of the other pc so i gave the following command mysqlshow -h 192.168.64.12 -u [EMAIL PROTECTED] mysqlshow: Host 'akroneiro' is not allowed to connect to this M What i msut do in order to gain access to the db? Hwo i can create users ? Is there any easy way for that? __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
concurrent users & sessions? !!!!!!
Do u know how many users the MySQL server v4 can't support? I am talking about the users that are currently online. I want to know the maximum number for the MyISAM tables and InnoDB Do u know any links for continue reading? Thx - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger
