Visual database design system
I am looking for a tool to integrate with mysql...I have tried DBDesigner and would like to get my hands on software that is equivalent or better than DBDesigner...any suggestions? FYI: I have had some problems with importing, printing etc with DBDesigner... Thanks in advance...
Re: Visual database design system
Looked good, but does not suport MySQL 5 :( - cost is not really an issue On 2/3/06, Peter Brawley [EMAIL PROTECTED] wrote: Adi, We use Dezign from Datanamic. Not free, not expensive either. PB - Adi wrote: I am looking for a tool to integrate with mysql...I have tried DBDesigner and would like to get my hands on software that is equivalent or better than DBDesigner...any suggestions? FYI: I have had some problems with importing, printing etc with DBDesigner... Thanks in advance... -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.1/250 - Release Date: 2/3/2006 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.1/250 - Release Date: 2/3/2006 -- Take care... Adam
Re: Visual database design system
Hey Jimmy...when I reverse engineer a DB, the software does not seem to make the relationship connections between the tables...all the keys are listed, but does not illustrate them on the diagram...any tips? Cant find anything in their soft help section... Thanks... On 2/3/06, Jimmy Guerrero [EMAIL PROTECTED] wrote: Hello, Might want to check out ERStudio from Embarcadero Technologies. http://www.embarcadero.com/products/erstudio/ Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Adi [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:53 AM To: mysql@lists.mysql.com Subject: Visual database design system I am looking for a tool to integrate with mysql...I have tried DBDesigner and would like to get my hands on software that is equivalent or better than DBDesigner...any suggestions? FYI: I have had some problems with importing, printing etc with DBDesigner... Thanks in advance... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Take care... Adam
a query to insert values into two different tables using mySQL Server
in MS SQL u can do it by the following query: declare @transool varchar(20) set @transool = 'opcofficelink' begin transaction @transool insert into Table1 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec, @Sine_30_Sec) insert into Table2 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec, @Sine_30_Sec) commit transaction @transool is there any similar query that can be used in mySQL? what i want to get is insert into Table1 and update row in Table2 the same values. i can't use two querries =/ thanx for ANY help, ADI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
remote connection with JDBC
I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL, jdbc:mysql://192.168.0.10:3306/mydatabase I got the following exception (the file name is Lookup.java) : Exception in thread main java.sql.SQLException: Communication link failure: java.io.IOException at com.mysql.jdbc.MysqlIO.init(Unknown Source) at com.mysql.jdbc.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at Lookup.main(Lookup.java:16) I would very much appreciate if anybody could tell me how to connect the database from a remote machine (if possible with which library to import from). Thank you very much in advance. _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sum column in mysql
Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE condition, and after that, to make sum of values of column Duration and display it. Any Help? tx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql LIKE number
I have a table with column1 text type. I want to make a sql query: SELECT * from table WHERE column1 LIKE condition, to select all record that contain numbers(0..9), and do not select records that contain only text. Any ideas? tx in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing of MySQL
use rpm -e --nodeps ...old package rpm -i package - Original Message - From: mahdi samia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 09, 2002 3:06 PM Subject: Installing of MySQL Hello all, I am a new MySQL programmer and I have alot of problems with Installing of new version of this package. I installed Redhat 7.3 and mysql package from it. when mysql running received a message base on no access to server. I downloaded MySQL-3.23.52-1.i389.rpm and MySQL-client-3.23.52-1.i386.rpm and I tried for Installing them, but I recieved a message about confusing in order to both mysql and MySQL, then I uninstalled mysql and installed MySQL in above version, and MySQL-Max-3.23.52-1.i386.rpm and I started to working. After rebooting System returned all of things to previous situation and I had receivng the message of no access to server. When reinstalling of package I have message of package already installed and When uninstalling of package I have message of There is not package I deleted all of mysql* files and Directories for installing but the problem is not solved. please hint me for this problem. best regards for all of members in mailing-list :) M.Samee -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql increment problem
hi, I have a mysql table with a field: Field name TypeAllow nulls?KeyExtras NR int(11)NoPrimary auto_increment In table i have values for NR field: 1,2,3...50 and 88. I del that line with 88, but when i try to add a record, NR is automatically assigned with 89. I want that value 51, but somewhere MySQL has recorded the big value. How to restart increment counter to start with 51? tx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql duplicate table
How to make a table(table2) with same content of existing table(table1) in same database(database1) with mysql? tx in adv for any help adi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
script - full backup of mysql databases
There is a script for RH Linux for each day automatic full backup of mysql databases? (the results may be like: backup_mmdd.sql, so it can be easily imported) tx in adv for any help - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php +newlines+mysql
I have a problem in php page: i want to insert into mysql database value $string with newlines: $string=-line1\n -line2 \n-line3; $result2 = db_query(update table1 set column1= '$string' where ID = '$IDcurent') or db_die(); When i try to view in a textarea control the new value from column1, the newlines disappear! ps.column 1 have type text or varchar(100) Is a problem of type? tx in advance for any help adi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php +newlines+mysql
I have a problem in php page: i want to insert into mysql database value $string with newlines: $string=-line1\n -line2 \n-line3; $result2 = db_query(update table1 set column1= '$string' where ID = '$IDcurent') or db_die(); When i try to view in a textarea control the new value from column1, the newlines disappear! ps.column 1 have type text or varchar(100) Is a problem of type? tx in advance for any help adi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php +newlines+mysql
I have a problem in php page: i want to insert into mysql database value $string with newlines: $string=-line1\n -line2 \n-line3; $result2 = db_query(update table1 set column1= '$string' where ID = '$IDcurent') or db_die(); When i try to view in a textarea control the new value from column1, the newlines disappear! ps.column 1 have type text or varchar(100) Is a problem of type? tx in advance for any help adi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sorted select
Hello, If I have a table like this MYID |time | some id creation time and the following query SELECT DISTINCT MYID from Table; How can I get the results ordered by time ? Any ideas ? Thank you ! -- Adi Tofan email : [EMAIL PROTECTED] ICQ#: 98771878 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
