Visual database design system

2006-02-03 Thread Adi
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

2006-02-03 Thread Adi
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

Re: Visual database design system

2006-02-03 Thread Adi
[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

a query to insert values into two different tables using mySQL Server

2004-12-01 Thread ***ADI***
, @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

remote connection with JDBC

2003-03-17 Thread Erwin Adi
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

sum column in mysql

2002-09-18 Thread adi
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

mysql LIKE number

2002-09-18 Thread adi
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

Re: Installing of MySQL

2002-09-09 Thread adi
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

mysql increment problem

2002-08-13 Thread adi
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,

mysql duplicate table

2002-08-02 Thread adi
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

script - full backup of mysql databases

2002-07-10 Thread adi
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:

php +newlines+mysql

2002-07-08 Thread adi
, 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

php +newlines+mysql

2002-07-08 Thread adi
, 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

php +newlines+mysql

2002-07-08 Thread adi
, 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

sorted select

2001-05-05 Thread Adi Tofan
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