Re: simple data GUI editor?

2005-06-18 Thread Karam Chand
I have been using and would highly recommend SQLyog from http://www.webyog.com Regards, Ritesh --- D_C <[EMAIL PROTECTED]> wrote: > i was wondering if people can recommend a simple > Excel like tool for > editing data? > > MySql control center - seems to have limitations > (unicode, not in dev

Re: simple data GUI editor?

2005-06-18 Thread Karam Chand
Have you tried SQLyog? Somehow I prefer it more then MySQL-Front. Regards, Karam --- Carl <[EMAIL PROTECTED]> wrote: > We use MySQL-Front from Star-Tools GmbH > (www.mysqlfront.de)... works pretty > much like you have asked. > > Thanks, > > Car > - Original Message - > From: "Berman, M

Re: SQLyog Enterprise

2005-07-20 Thread Karam Chand
Hello, I find SQLyog Enterprise an indispensable tool. Your $49 will be saved within the first 3 days of use because of improved productivity with MySQL. Karam --- Scott Hamm <[EMAIL PROTECTED]> wrote: > I'm contemplating buying SQLyog Enterprise for $49 > dollars (non-commerical) > for perso

Re: migrate Access to MySQL

2005-07-31 Thread Karam Chand
http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027&showtopic=1536&view=getnewpost Karam --- Bing Du <[EMAIL PROTECTED]> wrote: > Hello, > > I've been looking around for a while. Seems there > are many options and > tools that can help do it. Guidance and directions > ar

ALTER TRIGGER in MySQL

2005-08-04 Thread Karam Chand
Hello, I was reading the docs on Triggers at: http://dev.mysql.com/doc/mysql/en/using-triggers.html Looks like there is no support for Alter Trigger. So if I want to change a trigger, I have to first drop the existing one and recreate another? Am I correct? Karam ___

DROP VIEW Syntax

2005-08-05 Thread Karam Chand
Hello, In the MySQL Docs at http://dev.mysql.com/doc/mysql/en/drop-view.html, it says: "RESTRICT and CASCADE, if given, are parsed and ignored." I am not sure if I understood this? Regards, karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has

Case issue in Information_schema

2005-08-10 Thread Karam Chand
Hello, I was just checking INFORMATION_SCHEMA in 5.0.10. All the tables, columns and values are given in CAPS lock. The case is not important in Windows but it is in Linux. Do I assume that even in Linux it will be in CAPS and the case is not going to change in near future? Karam

MYSQLDUMP and Triggers, Functions and SP

2005-08-10 Thread Karam Chand
Hello, mysqldump bundled with 5.0.10 does not seem to support the above features. Any plans when they will be supported? Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL Gen

mysql 5.0.10 compilation error

2005-08-10 Thread Karam Chand
Hello, I am trying to compile 5.0.10. While compiling i am getting the following error: e:\mysql5010abetasrc\extra\yassl\src\yassl_imp.cpp(393) : fatal error C1001: INTERNAL COMPILER ERROR (compiler file 'msc1.cpp', line 2701) Please choose the Technical Support command on the V

Re: mysql 5.0.10 compilation error

2005-08-10 Thread Karam Chand
I plan to modify mysqldump and mysql import utility to support SP, Triggers etc and plan to send a patch to the MySQL development tree. Thus downloading the binary does not seem to be option :) --- Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > I am trying to compile 5.0.10. While compiling i

RE: [SPAM?]: Case issue in Information_schema

2005-08-10 Thread Karam Chand
ROM > INFORMATION_SCHEMA.TABLES WHERE table_schema = > 'test';" it would return > "foo" - not "FOO". > > HTH > > Mark > > Mark Leith > Cool-Tools UK Limited > http://www.cool-tools.co.uk > http://leithal.cool-tools.co.uk >

Error no: 12 (

2005-08-11 Thread Karam Chand
Hello, I am running MySQL on a WinXP box. I am getting the following error: Error no: 12 can't read dir of './tablename/' (errorcode: 2) What does this error mean? Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection a

Re: Data sync offline

2005-08-24 Thread Karam Chand
http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent SJA is available for both Linux and Windows. Karam --- Alex Greg <[EMAIL PROTECTED]> wrote: > Hi, > > > Our company is considering migrating some tablesfrom > MyISAM to InnoDB, > as it has row-level locking and other improvements >

Re: Migrating MySQL users

2005-09-05 Thread Karam Chand
Hello, First all it is not recommended at all to dump and import user information. Secondly the user authentication system has changed between 4.0 and 4.1 so old passwords from 4.0 wont work. Its given in the docs. Thirdly, MySQL does not store the actual password in its database. It always kee

RE: Mysql to Oracle migration

2005-09-05 Thread Karam Chand
I have been using SQLyog's ODBC Import tool for quite some time now. http://www.webyog.com Karam --- "Nguyen, Phong" <[EMAIL PROTECTED]> wrote: > > Look at http://www.ispirer.com > > It is free and very good tool to do it. I did it > from Oracle to MySQL, but > you can do it from Mysql to ora

Re: converting access (.mdb) files...

2005-09-18 Thread Karam Chand
If you can catch hold of a windows box then there is tool called SQLyog that has a great migration tool. I was able to import a clients MDB database with all the FKs directly from Access to MySQL. You dont need to go thru Access -> Script -> MySQL. You can download it from http://www.webyog.com

Table design question

2005-11-02 Thread Karam Chand
Hi, A very simple question. I have two products at our website and i would like to keep track of how many of each softwares were downloaded daily. I am planning to create the following table: id - auto_incr date_of_download - data product_name - enum value containing the two products Then I pla

Re: SSH tunnel for Mysql

2005-12-08 Thread Karam Chand
If you are looking for a client to connect to MySQL using SSH tunnel, try out SQLyog. It has SSH Tunneling. Karam --- Jerry Swanson <[EMAIL PROTECTED]> wrote: > How to create ssh tunnel for Mysql? > TH > __ Do You Yahoo!? Tired of spam? Yahoo!

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Karam Chand
SQLyog Enterprise's Database Sync Tool is the answer for your queries. www.webyog.com Rgds, Karam --- Paul Godard <[EMAIL PROTECTED]> wrote: > Hi > > I use mysql/php on several client web sites (each > client has its own > db). For development purpose, I have a local web > server with > php/

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Karam Chand
Well I know about it and I am working on MySQL Replication, the point is that you dont have control over replicatation when your MySQL server is installed by your ISP on shared server, In that case it is simply not possible :) Moreover, the simple setup I have, I prefer this then the nittygrittie

Re: How to send queries to a database periodically

2005-02-24 Thread Karam Chand
SQLyog (www.webyog.com) has an option called SQLyog Notification Services. It can execute a set of queries and even send you the report over email. Using this you can schedule it to run a set of queries anytime you want. Karam --- Peter PeterDresden <[EMAIL PROTECTED]> wrote: > Hi, > > is there

Re: Remote Connection via Toad for MySQL

2005-02-25 Thread Karam Chand
You can try SQLyog (www.webyog.com), it supports 3.23.x to 5.0. Lightweight and very fast! Karam --- [EMAIL PROTECTED] wrote: > Good good. > > On 24 Feb 2005, at 20:46, > [EMAIL PROTECTED] wrote: > > BINGO!!! > Thanks Dan! > Kelly > > > > Daniel Walker <[EMAIL PROTECTED]> > What vers

Re: MySQL and phpMyAdmin

2005-03-19 Thread Karam Chand
Even I had the same problem so I moved to using SQLyog and its an awesom client. http://www.webyog.com Karam --- Asad Habib <[EMAIL PROTECTED]> wrote: > I just installed phpMyAdmin, made the appropriate > changes in the > config.inc.php file, and got the following error > when accessing it via >

Re: How to import data from Dbase3?

2005-03-23 Thread Karam Chand
If Dbase3 has an odbc driver then you can use SQLyog (www.webyog.com) to import data to MySQL. Karam --- "Peter L. Berghold" <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > BG Mahesh wrote: > > Actually I prefer to dump the dbase file on a > Linux machine and dire

Re: Need help coverting MDB > SQL

2005-03-27 Thread Karam Chand
I have been using SQLyog for quite some time now to import data from Access and SQL Server database. www.webyog.com Regards, Karam --- Ricky Groleau <[EMAIL PROTECTED]> wrote: > > > Hello, > > I have tried and i have failed. I am trying to help > out a non-profit site in their move. The old s

Re: backup databases one to another

2005-04-13 Thread Karam Chand
This option involves two steps. First you have to export complete data and then import it again. You can do this more efficiently by using a sync tool like Webyog (www.webyog.com). It will sync any two MySQL databases with changes only done to modified rows/columns. YOu can probably mail their su

Re: C API: Storing is easy; How do you retrieve?

2005-05-01 Thread Karam Chand
The docs should have it. Basically these API is what you require (in order): mysql_init(); mysql_real_connect(); mysql_real_query(); mysql_store_result() or mysql_use_result(); mysql_fetch_row(); mysql_free_result; mysql_close (); HTH --- Matthew Boehm <[EMAIL PROTECTED]> wrote: > Hey guys, >

Re: Work / Home DB synchronization

2005-05-05 Thread Karam Chand
You require SQLyog's Data Sync Tool. Download it from http://www.webyog.com You can find an article on it at: http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent Karam --- Scott Purcell <[EMAIL PROTECTED]> wrote: > Hello, > > I am developing a web application in which I have > been work

Re: How to backup and restore database

2005-05-05 Thread Karam Chand
I prefder to use a FREE GUI like SQLyog found at http://www.webyog.com Karam --- Gary Richardson <[EMAIL PROTECTED]> wrote: > try mysqldump -keq SDN > SDN.sql > > Then you can import it on another instance using > mysql -u root > new_instance < SDN.sql > > On 5/5/05, zlf <[EMAIL PROTECTED]> wro

Re: How to export a table to a CSV file?

2005-05-05 Thread Karam Chand
If you are windows then I prefer to use SQLyog at http://www.webyog.com to do the job. ITS FREE! Karam --- "Homam S.A." <[EMAIL PROTECTED]> wrote: > NOTE: I sent this message yesterday, but for some > reason it didn't show up in the list. If you've > already received it, I apologize for the > inc

RE: Work / Home DB synchronization

2005-05-06 Thread Karam Chand
program. But do not know if this is valid? > > > > Thanks, > Scott > > > > > -Original Message- > From: Karam Chand [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 05, 2005 12:08 PM > To: Scott Purcell; mysql@lists.mysql.com > Subject: Re: Work /

Re: Restoring mySQL dump

2005-05-18 Thread Karam Chand
Since I am on Windows, I prefer to use a GUI tool like SQLyog (www.webyog.com) Karam --- Adrian Cooper <[EMAIL PROTECTED]> wrote: > Hello, > > I need to restore a mySQL dump file but cannot find > the right syntax. > > I have root access and have used: > > mysql -u root -p account_databasename

Re: Export from Access

2005-05-18 Thread Karam Chand
If you are on Windows then you can directly import data using SQLyog's ODBC Import Tool. www.webyog.com Regards, Karam --- "S.D.Price" <[EMAIL PROTECTED]> wrote: > Hi, > can anyone explain how I would export a database > created in Access to > MySQL using PHPMyAdmin - I can't seem to import the

Re: Mysql Backup/Dump

2005-06-14 Thread Karam Chand
If you are on Windows then you can use a GUI like SQLyog (www.webyog.com) to do the job. I think it will be the easiest way to do that. Karam --- Kory Wheatley <[EMAIL PROTECTED]> wrote: > I want to backup our entire Mysql database structure > for > mysql 3.23.58 and dump it in the newly insta

Re: Migrating from IBM Universe to mySQL

2005-06-14 Thread Karam Chand
Hello, I guess IBMs Universe Database will be having an ODBC interface. Then you can use a GUI like SQLyog (www.webyog.com) to do an ODBC Import from IBMs database to MySQL. Regards, Karam --- Rahul Bollampally <[EMAIL PROTECTED]> wrote: > Hi, > > Has any body migrated an IBM's Universe databa

MySQL 4.1.1 Download

2003-12-04 Thread Karam Chand
Are binaries of MySQL 4.1.1 available or we need to compile it from the source. Karam __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

How MySQL is handling unicode() some doubts

2004-02-04 Thread Karam Chand
Hello I am going thru the source code of MySQL client. I am not able to understand in general how MySQL is handling unicode characters. All the function take (char*) as arguments? Is it expecting all the data to be UTF8-encoded and before executing the queries (i was looking into the batch file

Result returned by "show index from"...

2004-02-05 Thread Karam Chand
Hello I am executing show index from tablename to get index information. The following columns are returned ... Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed NullIndex_type Comment In the docs at http://www.mysql.com/doc/en/Show_database

Re: Result returned by "show index from"...

2004-02-05 Thread Karam Chand
;>>>>>>>>>>>>>> Original Message > <<<<<<<<<<<<<<<<<< > > On 2/5/04, 1:58:43 AM, Karam Chand > <[EMAIL PROTECTED]> wrote > regarding Result returned by "show

How MySQL is handling unicode...some questions?

2004-02-05 Thread Karam Chand
Hello I am going thru the source code of MySQL client. I am not able to understand in general how MySQL is handling unicode characters. All the function take (char*) as arguments? Is it expecting all the data to be UTF8-encoded and before executing the queries (i was looking into the batch file

Re: oracle to mysql

2004-02-10 Thread Karam Chand
SQLyog - www.webyog.com is NOT FREE but has a very good ODBC import tool for $49 and it includes lot of other poerful tools. You might check it out. You can try it out for 30days before purchasing it. karam --- "Ansari, Raza (GEI, GEFA)" <[EMAIL PROTECTED]> wrote: > Does anyone know any FREE tool

Re: Query to another server

2004-02-16 Thread Karam Chand
I dont think so :( Karam --- [EMAIL PROTECTED] wrote: > Is it possible to query one server from another even > if those servers are > in diferent machines at diferent locations? > > for example: > > select * from localtable left join > remoteserver.remotedatabase.remotetable > > where localta

Want to understand MySQL Code? Where to start...

2004-02-22 Thread Karam Chand
Hello I am CS student. I want to understand the architecture and code of MySQL (guess the subjects says it all)...What do you think will be the best place to start off? Any docs on the architecture of MySQL? Karam __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read on

Re: Transfering from access to MySQL?

2004-02-25 Thread Karam Chand
I use SQLyog - http://www.webyog.com/sqlyog It has a pretty good ODBC Import Wizard. Karam --- Jonas_Lindén <[EMAIL PROTECTED]> wrote: > Hello, Could someone help me with a tip on how I can > convert my old Access DBs to MySQL? > > Regards > /Jonas __ Do you Yah

Re: Import Access DB into MySQL

2004-02-26 Thread Karam Chand
Hello I use SQLyog (http://www.webyog.com/sqlyog) to import data from my access db to MySQL. Karam --- Jacque Scott <[EMAIL PROTECTED]> wrote: > I have a .mdb file which I need to import into > MySQL. This needs to be > done behind the scenes and with code. Can I use > LOAD DATA INFILE where >

charset=latin1 problem

2003-05-31 Thread Karam Chand
Hello I have two MySQL 4.1 servers installed. One at home and at my work. Both run WinXP. I used mysqldump to export my database at work and tried to import it at my home server, I am getting the following error in one of the - create table defintaion Error Code : 1064 You have an error in your

Cant connect with SSL support

2003-05-31 Thread Karam Chand
Hello I have a MySQL 4.0.3 server with SSL option. I know that the SSL option is runnish coz when I do show variables...i am getting the value for ssl to be true :) I am writing a C app to connect to the MySQL server to do some jobs. I am using the mysql_real_connect() function to connect. The

result returned from query 'show fields from .....'

2003-06-02 Thread Karam Chand
Hello It seems that an extra column has been added to the column information returned from the query] show fields from `dbname`.`tablename` the column is called collation and gives some extra information. Can somebody tell the exact version of MySQL from which this extra information was added.

Cant connect with SSL support

2003-06-02 Thread Karam Chand
Hello I have a MySQL 4.0.3 server with SSL option. I know that the SSL option is runnish coz when I do show variables...i am getting the value for ssl to be true :) I am writing a C app to connect to the MySQL server to do some jobs. I am using the mysql_real_connect() function to connect. The

Re: mysqlclient.exe

2003-06-03 Thread Karam Chand
Hello MySQLGUI has been deprecated for long. If you are on Windows then you can try out another client called SQLyog from http://www.webyog.com/sqlyog which I find more powerful and easy to use. Karam --- Mark Matthews <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1

Field Information from 'show fields from...'

2003-06-03 Thread Karam Chand
Hello It seems that an extra column has been added to the column information returned from the query] show fields from `dbname`.`tablename` the column is called collation and gives some extra information. Can somebody tell the exact version of MySQL from which this extra information was added.

Re: SQLyog can not insert/update Table w/o Primary Key

2003-06-03 Thread Karam Chand
Hello I belive this is not the correct place to ask the question. You can try your discussion forums at http://www.webyog.com/forums for SQLyog specific questions. Karam --- William IT <[EMAIL PROTECTED]> wrote: > Why SQLyog can not insert/update Table w/o Primary > Key? Is there additional sett

Re: SQLyog can not insert/update Table w/o Primary Key

2003-06-03 Thread Karam Chand
Probably this is what you want http://www.webyog.com/forums/index.php?act=ST&f=5&t=351&s=7cd9c97584811d72b9305d3e691ab28f Karam --- Daniel Crompton <[EMAIL PROTECTED]> wrote: > Out of interest is there any advantage of using a > primary key?, or is it > perfectly ok/normal not to specify one?. >

Re: database copy

2003-06-04 Thread Karam Chand
Hello I use SQLyog at http://www.webyog.com/sqlyog. It has a great facility to do exactly what you want. Just connect to two differt servers and choose DB->Copy Database To Another Host/DB option...and wholla you are done. Karam --- Paul Najman <[EMAIL PROTECTED]> wrote: > Fabio, > > I have had

Re: Loading database information from a text file.

2003-06-07 Thread Karam Chand
Greetings If you are on Windows then you can try out SQLyog at http://www.webyog.com/sqlyog . It has GUI interface for many ways to import data in MySQL whether CSV, SQL Batch file etc. Karam --- JeRRy <[EMAIL PROTECTED]> wrote: > Hi, > > I have a text file with all my database information > to

Starting MySQL with SSL

2003-06-07 Thread Karam Chand
Greetings I have MySQL 4.0.13 installed on WinXP machine. From the DOCS I read that support for SSL is provided with MySQL 4.x. The doc says that I need to install the library from openssl.org ( which I did ) and then configure mysql with --with-vio and --with-openssl? Does it mean that I have co

Re: mySQL GUIs

2003-06-11 Thread Karam Chand
Greeting I find SQLyog ( http://www.webyog.com ) the best of all. You will find lot of articles and tutorials on it on various MySQL/PHP site. It is comparable to any MySQL GUI in the market and is FREE!!! I think you should definately take a look at it. MyCCI dont like...coz its bloated and

Re: mySQL GUIs

2003-06-12 Thread Karam Chand
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

SQLyog 3.51 has been released

2003-06-27 Thread Karam Chand
SQLyog v3.51 - The definitive Windows Front End for MySQL, has been released. SQLyog is a superfast, compact and easy to use Front End for MySQL. Some of the new features added in SQLyog 3.51 are - -- Complete support for MySQL 4.1. -- Improved SQL Editor. -- Improved ODBC Import Tool. -- BLOB

Anomaly in resultset

2003-07-25 Thread Karam Chand
Greetings I have a table with the following table structure - FieldType Collation NullKey Default Extra --- - - -- -- --- -- emailchar(75) latin1_swedish_ci is_sent e

Re: how to convert SQL Server 2000 database to MySQL?

2003-07-26 Thread Karam Chand
Greetings What you need is a tool called SQLyog ( it has the best ODBC import utility in the market ). A very good tutorial can be found at http://www.devshed.com in the MySQL section. Do tell me how was your experience? Karam ( A satisfied user of SQLyog ) --- kumar mcmillan <[EMAIL PROTECTED]

Anomaly in ResultSet

2003-07-26 Thread Karam Chand
Greetings I have a table with the following table structure - FieldType Collation NullKey Default Extra --- - - -- -- --- -- emailchar(75) latin1_swedish_ci is_sent e

Cant duplicate table???

2003-07-28 Thread Karam Chand
Greetings I have a table and I want to make a copy of it in the same database. I only keep the structure and indexes and not the data. I issue a command - create table `aimdb`.`mtv20030105spots_copy` ( primary key ( AdInstanceID ) ,FULLTEXT KEY `KeyNumber` ( `KeyNumber` ), FULLTEXT KEY `Advertis

Deleting duplicating records

2003-07-28 Thread Karam Chand
Greetings I manage a website wherein i keep track of the people email who have downloaded my software and the version number. the structure is like - id int auto_increment primary key, email char, version now the same person can download different version therfore my table has data like this -

RE: Deleting duplicating records

2003-07-28 Thread Karam Chand
mp;& ID <> 1 > > Jeff > > -Original Message- > > From: Karam Chand [mailto:[EMAIL PROTECTED] > > > Sent: Monday, July 28, 2003 10:33 AM > > To: [EMAIL PROTECTED] > > Subject: Deleting duplicating records > > > > > > Greetings >

Re: Deleting duplicating records

2003-07-28 Thread Karam Chand
ame the new one > > Regards, > Venelin > > Karam Chand wrote: > > >Well that is OK if I have only one email. > > > >What if if I have thousands of users duplicated... > > > >Do I need to write SQL query 1000 times > > > >

Why the query is not using index?

2003-07-28 Thread Karam Chand
Greetings Having a table with the following structure - +-+---+---+--+-+-+-- --+ | Field | Type | Collation | Null | Key | Default | Extra | +-+---+---+--+-+---

How to know the maxmimum length of data in a perticular column?

2003-07-28 Thread Karam Chand
Greetings Is there any query to know the maximum string length of data in every column of the table? For eg, if I have data - 1,[EMAIL PROTECTED],2000-12-12 20,[EMAIL PROTECTED],NULL ... It will return me 2,15,10 I hope I make myself clear. Thanks in advance. Karam __

Re: How to know the maxmimum length of data in a perticular column?

2003-07-28 Thread Karam Chand
Great. That does it. Thanks. Thanks. Thanks. Karam --- Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Jul 28), Karam Chand said: > > Greetings > > > > Is there any query to know the maximum string > length > > of data in every column of the ta

How can I make this query more optimised?

2003-07-29 Thread Karam Chand
Greetings I have a table with the following table structure - mysql> desc email_table; +-+---+---+--+-+-+---+ | Field | Type | Collation | Null | Key | Default | Extra | +-+---+---+-

Why LIKE not using INDEX?

2003-07-30 Thread Karam Chand
Hello I have a table with an intger column called ID. I have an index on it. Now I want to get a result with all the rows whos ID values start with lets say 12i.e. I want all the IDs with data - 12 123 1234 .. I am using this query select * from tablename where id like '123%'

Picturing numeric data...

2003-07-30 Thread Karam Chand
Greetings... I have a double column (id) that has data like - -123.123 1.1 0.001 200.001 -123.4 Is there any query wherein I can get formatted resultset like - -#123.123# +###1.1 +###0.001# +#200.001# -#123.4### Any MySQL function or a workaround Thanks in advance? Karam ___

Error 1005...

2003-07-31 Thread Karam Chand
Greetings I have MySQL 4.0.14 running on WinXP. Whenever I create a temporary table from an existing table that has multiple keys ( the temporary table has columns reordered from the original table ) with a query like - create temporary table if not exists `mn`.`sqlyog_23796` ( `entryid` int(6)

Re: SQL Server 2000 to mySQL Server

2003-08-14 Thread Karam Chand
Try SQLyog at http://www.webyog.com/sqlyog I have used to import lots of data from SQL Server to MySQL. Karam --- Martin Gainty <[EMAIL PROTECTED]> wrote: > The official mySQL response is that you are > overflowing the maxlength > attribute > Although there are many posts where SQLServer to > My

Can I change the date format...

2003-08-16 Thread Karam Chand
Hello Is there anyway to change the default date format (possibly in a .ini or .cfg file) from -MM-DD to another format ? (ie, mm/dd/ or any user-defined format). The useage that I'm looking at is to import a CSV file into a table (using Load data infile command) where dates are stor

User Permission and ODBC

2003-08-16 Thread Karam Chand
Hello I am using SQLyog. I want to manage user permissions down to a field level which SQLyog does. Any DDL or DML statements that I attempt to execute within SQLyog support the defined user permissions. However, when I use MySQLCC the persmissions are totally ignored. This is also true when I a

Formatted double value...

2003-08-16 Thread Karam Chand
Greetings I have a column with double values like - .01 .02 .03 Well...its sounds ridiculous but i do have data like that :) I am using C API to get the resultset, but the data is resturned as ( also with mysql client which uses C API ). |1e-006 | |2e-006 | |3e-006 | |

Re: Formatted double value...

2003-08-17 Thread Karam Chand
Hello It formats the output to ##,###,##.## . I dont want the commas and also I dont know what maximum decimal value is there in the table. It may be .001 or it maybe .001 . I just want them in simple expanded form. karam --- Roger Baklund <[EMAIL PROTECTED]> wrote: > * Karam Cha

create table....select * from table anomaly..

2004-10-15 Thread Karam Chand
Hello, I have three databases 3.23.54 (production) & 4.0.18 and 4.1.3 as test servers. I execute the following sqls: >>> create database testdb; use testdb; CREATE TABLE `test` ( `example_col` varchar(100) default NULL

Re: Transfering data from postgresql to MySQL

2004-10-18 Thread Karam Chand
Hello, You can use SQLyog's ODBC Import Tool to import data from PgSQL to MySQL using PgSQL's ODBC driver. More information about SQLyog can be found at http://www.webyog.com Karam --- Jochem van Dieten <[EMAIL PROTECTED]> wrote: > On Mon, 18 Oct 2004 18:08:24 +0800, 謝洪恩 > Patrick Hsieh wrote:

Result returned by LOAD LOCAL...

2004-10-25 Thread Karam Chand
Hello, When I execute a LOAD DATA INFILE statment.. mySQL returns a result with info like: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 How can I get more information about deletions, warnings etc? Karam __ Do You Yahoo!? Tired of spam? Yahoo!

Should I change the MySQL client library

2004-10-27 Thread Karam Chand
Hello, MySQL has released 4.1.7 http://lists.mysql.com/announce/226 As you can see there have been some bugfixes in libmysqlclient. I am using libmysql.dll provided with 4.1.1 in my app. Do I need to upgrade it to the one provided with 4.1.7? Regards, Karam _

Re: synchronizing mysql database in two diferrent places

2004-10-31 Thread Karam Chand
Hello, You might try MySQL's inbuilt replication feature. If you want a more simple approach, might take a look at SQLyog's Data Sync Wizard. More information can be found at http://www.webyog.com I think they have a article on the same subject in SitePoint. You might google it. Karam --- Eko

Works with MySQL Logo

2004-11-02 Thread Karam Chand
Hello, I searched MySQL.com but couldnt find the official "Works With MySQL" logo. Can somebody point me to the right direction. If they can send it to me as an attachment, will be helpful. Regards, Karam __ Do you Yahoo!? Check out the new Ya

Re: Works with MySQL Logo

2004-11-02 Thread Karam Chand
=en&lr=&q=%22Works+With+MySQL%22&btnG=Search > > Aman Raheja > > Karam Chand wrote: > > >Hello, > > > >I searched MySQL.com but couldnt find the official > >"Works With MySQL" logo. Can somebody point me to > the > >right d

Re: mysql admin clients

2004-11-05 Thread Karam Chand
Hello, Check out SQLyog at http://www.webyog.com/forums/index.php?s=94f4afb247fdfdfbd6435d793a56d60a&act=ST&f=2&t=977&st=0&#entry3909 Its FREE and very powerful. Regards, Karam --- leegold <[EMAIL PROTECTED]> wrote: > newbie question about mysql admin clients. What are > some good ones? And >

Static library for MySQL C API

2004-11-17 Thread Karam Chand
Hello, Is it possible to get static library for MySQL C API() instead of libmysql.dll? Regards, Karam __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http:

Re: Static library for MySQL C API

2004-11-18 Thread Karam Chand
TED]> wrote: > Hello. > See: > > http://dev.mysql.com/doc/mysql/en/Windows_client_compiling.html > > > Karam Chand <[EMAIL PROTECTED]> wrote: > > Hello, > > > > Is it possible to get static library for MySQL C > API() &g

Lost connection during query when using SSH tunneling

2004-12-10 Thread Karam Chand
Hello, I have a MySQL database hosted with my ISP. They provide direction as well as thru SSH tunneling. I can very well connect to it diredctly from any app but I prefer to use SSH tunneling. So I use Putty to create the SSH tunneler and then connecting to the local port. Now the problem, is th

RE: Lost connection during query when using SSH tunneling

2004-12-10 Thread Karam Chand
, Karam --- "Adams, Pat 006" <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Karam Chand [mailto:[EMAIL PROTECTED] > > > Sent: Friday, December 10, 2004 12:08 PM > > To: [EMAIL PROTECTED] > > Subject: Lost connection during q

Re: mysqlcc

2004-12-10 Thread Karam Chand
MySQL CC seems to be discontinued. Nowadays I prefer SQLyog (http://www.webyog.com) Karam --- Robin Lynn Frank <[EMAIL PROTECTED]> wrote: > I'm obviously missing something. I can use mysqlcc > to change data in a > row of a table and save it. But, if I try to insert > a row, add data and > save

Getting monthly download report

2004-12-13 Thread Karam Chand
I have a table like: CREATE TABLE `user_details` ( `id` bigint(6) unsigned NOT NULL auto_increment, `user_name` varchar(100) NOT NULL default '', `user_email` varchar(50) NOT NULL default '', `user_ref_from` varchar(100) default 'Not Given', `other_ref` varchar(255) default 'Not Given', `pro

Re: Mysql client that does export and import

2004-12-14 Thread Karam Chand
I use SQLyog everyday at my job. Check out http://www.webyog.com Karam --- [EMAIL PROTECTED] wrote: > When you install MySQL you get several tools (not > just the command-line > client and the various server versions). Two of them > are mysqldump and > mysqlimport. The docs for all of them c

Re: MySQL Query Browser

2004-12-15 Thread Karam Chand
YOu could try the free version of SQLyog. It works on my Win98. www.webyog.com Karam --- Chris <[EMAIL PROTECTED]> wrote: > Hassan Shaikh wrote: > > > The MySQL Query Browser online documentation > clearly mentions that it > > runs on 32-bit Windows operating systems, > including Windows 95, 9

FLUSH syntax query

2005-01-05 Thread Karam Chand
Hello, >From the MySQL docs: http://dev.mysql.com/doc/mysql/en/FLUSH.html What does FLUSH MASTER and FLUSH SLAVES does? Its not documented? Also, from which version of MySQL LOCAL and NO_WRITE_TO_BINLOG options supported? Regards, Karam __ Do Yo

Re: MySQL insert with PHPMyAdmin

2005-01-06 Thread Karam Chand
As far as I know there should not be any problem but I prefer SQLyog for all my MySQL work. It even has HTTP Tunneling to access dbs that dont allow remote access. Karam --- leegold <[EMAIL PROTECTED]> wrote: > Can using PHPMyAdmin cause problems. What I'm doing > is, I'm using > PHPMyAdmi as a

Re: FLUSH syntax query

2005-01-06 Thread Karam Chand
> > RESET MASTER and RESET SLAVE were named FLUSH MASTER > and FLUSH SLAVES > before MySQL 3.23.26. > > Karam Chand <[EMAIL PROTECTED]> wrote: > > Hello, > > > > From the MySQL docs: > > > > http://dev.mysql.com/doc/mysql/en/FLUSH.htm

FK Id in Innodb

2005-01-10 Thread Karam Chand
Hello, http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html According to it I can specify a name/id for a relation on and after 4.0.18. Before that InnoDB provides an internal id/number. I was just curious - what happened before 4.0.18 or 3.23.x. Was an ID still provided by Inn

ALTER TABLE....with CHANGE syntax

2005-01-10 Thread Karam Chand
Hello, I plan to reorder some columns of my table. So I am using ALTER TABLE STATEMENT .. with CHANGE syntax as suggested at: http://dev.mysql.com/doc/mysql/en/ALTER_TABLE_problems.html I believe its the only way to reorder columns? Is there something better? If CHANGE is the best option, is th

Re: mySQL C++ API (which libraries)

2005-01-11 Thread Karam Chand
The one supported by MySQL AB and the best till date is MySQL C API (well its best because I am C developer). It is the speediest too. I think you should find wrappers over the C API() over the net. If not then you can develop one for yourself and probably release it in GNU. Regards, Karam --- An

  1   2   >