Hello,
The size of libmysql.dll binary has increased from
188KB to 916KB from MySQL 4.0 to MySQL 4.1.1.
Researching around I came to know that the new
libmysql.dll was compiled linking the new character
stuff.
What do you mean by character stuff?
Just curious?
Karam
Try SQLyog - www.webyog.com
I use the ODBC Import Facility regularly.
regards
Karam
--- Arjun Subramanian [EMAIL PROTECTED] wrote:
Hello people ! I was hoping for some wisdom from the
good folks on this
list about moving databases from access to MySQL.
I am aware of the brute force method
Thanks for your help.
I am no seasoned C programmer so looking into the
source code is out of question.
I am having RichControl in my application that returs
text in Unicode data. So if a user has entered Hindi
text in the text control i have to add them in a
table. For that I will be using C
Try SQLyog - http://www.webyog.com/sqlyog
Karam
--- [EMAIL PROTECTED] wrote:
Hello colleagues,
I have to migrate a lot of ORACLE 8.1.7 databases to
MySQL 3.23
I'm looking for a tool or for an algorithm which
fully supports any
ORACLE structures ...
If needed I may use a commercial
Hello,
I have a project where I need to develop a database
product with working handling languages like hindi
etc.
The application will be written in Win32 API so I will
be using MySQL C API().
Can somebody give me pointers how to store and
retrieve data in Hindi using MySQL C API and MySQL in
Hello,
From MySQL 4.1, MySQL supports storing of data in
utf-8 and ucs2. But all the C API till supports only
char*.
This has brought up some issues in my mind:
1.) How do you I send Unicode data to MySQL server
using C API()? Should I convert the query to utf-8 or
double byte etc.?
2.) How
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
I use
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 Yahoo!?
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
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 localtable.key =
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 to
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
/04, 1:58:43 AM, Karam Chand
[EMAIL PROTECTED] wrote
regarding Result returned by show index from...:
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
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
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
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:
One of the my client is using the above version and he
is getting an error with my app so I would like to
test my app against this version..
Can I get a link to 4.0.15
Karam
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL
Try SQLyog Job Agent at http://www.webyog.com
Karam
--- Prashant Akerkar [EMAIL PROTECTED]
wrote:
Dear friends
We have our application with data tier as mysql
database in our office
running on windows platform which we need to
synchronize with the same
database on a remote system at
Try SQLyog at http://www.webyog.com. It has a very
good schedulable Data Sync Tool.
--- Roger Baklund [EMAIL PROTECTED] wrote:
* Andreas
[...]
On the other hand one could use intervals for key
assignment.
Every time a server runs out of keys it throws a
warning at the admin
and rejects
Hello
Can somebody tell me the exact version of MySQL from
which the functionality of adding COMMENTS to columsn
was added.
Karam
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General
How can I add comment to a column?
karam
--- Egor Egorov [EMAIL PROTECTED] wrote:
Karam Chand [EMAIL PROTECTED] wrote:
I have 4.1.0-alpha-max-nt. When i issue a command
-
show full fields from tblname;
I get information about the fields in the table.
There
are two columns i.e
Hello
I have 4.1.0-alpha-max-nt. When i issue a command -
show full fields from tblname;
I get information about the fields in the table. There
are two columns i.e. EXTRA and COMMENTS which is
always blank. I cant seem to figure out what
information they provide. The SHOW FULL FIELDS... in
my
Webyog has released SQLyog 3.61 - which includes
SQLyog Job Agent ( SJA ) that enables Zero Install
MySQL Data Synchronization.
SJA is a high-performance, multithreaded, multi
platform application to automate and schedule
Synchronization of Data between two MySQL hosts. On
Windows, it is
Hey
Just wanted to know...which are the most popular
English language ,agazines and journals read by MySQL
community?
Just curious...maybe i will subsribe to it.
Karam
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Hey
Just wanted to know...which are the most popular
English language magazines and journals read by MySQL
community?
Just curious...maybe i will subsribe to it.
Karam
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Hello
I have a C app that uses libmysql.dll provided with
MySQL 4.1.0-max-nt distribution. I am trying to
connect to a remote server running MySQL 3.23.47 and I
get the error -
Error No. 2007
Protocol mismatch, Server Version = 9 Client Version =
10
whenever I try to connect using
Hello
I have a C app that uses libmysql.dll provided with
MySQL 4.1.0-max-nt distribution. I am trying to
connect to a remote server running MySQL 3.23.47 and I
get the error -
Error No. 2007
Protocol mismatch, Server Version = 9 Client Version =
10
whenever I try to connect using
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 Chand
I have
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
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
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 |
|
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
MySQL
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`
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%'
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
Greetings
I have a table with the following table structure -
mysql desc email_table;
+-+---+---+--+-+-+---+
| Field | Type | Collation | Null |
Key | Default | Extra |
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
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
Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: Deleting duplicating records
Greetings
I manage a website wherein i keep track of the
people
email who have downloaded my software and the
version
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
Karam
--- Jeff McKeon [EMAIL PROTECTED] wrote:
How bout
Delete from tablename where email like
Greetings
Having a table with the following structure -
+-+---+---+--+-+-+--
--+
| Field | Type | Collation | Null |
Key | Default | Extra
|
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
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 table?
For eg, if I have data -
1,[EMAIL
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]
Greetings
I have a table with the following table structure -
FieldType Collation NullKey
Default Extra
--- - - --
-- --- --
emailchar(75) latin1_swedish_ci
is_sent
Greetings
I have a table with the following table structure -
FieldType Collation NullKey
Default Extra
--- - - --
-- --- --
emailchar(75) latin1_swedish_ci
is_sent
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.
--
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 asked about
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
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
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
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
Hello
Try SQLyog at http://www.webyog.com/sqlyog. You will
find a good tutorial out here
http://www.devshed.com/Server_Side/MySQL/SQLyog/page1.html
HTH...KARAM
--- Karma Dorji [EMAIL PROTECTED] wrote:
Is there is utility which is free to convert ms SQL
7.0 running on windows
NT into a
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 setting
Probably this is what you want
http://www.webyog.com/forums/index.php?act=STf=5t=351s=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?.
Im not
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 to
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
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
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
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
Hello
If you are on windows then you can try SQLyog at
http://www.webyog.com/sqlyog which has GUI interface
to do just for what you are looking.
Karam
--- Michael Satterwhite [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there a tool for displaying / printing
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
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
Hello
I would suggest SQLyog at
http://www.webyog.com/sqlyog.
Its FREE and find it more powerful and easy to use
then MyCC
Karam
--- Mike Hillyer [EMAIL PROTECTED] wrote:
I would suggest myCC --
http://www.mysql.com/downloads/mysqlcc.html
Regards,
Mike Hillyer
www.vbmysql.com
Hello
Export the data in CSV from Excel and then you can try
SQLyog at http://www.webyog.com/sqlyog
It has a very good interface to import data from CSV
file.
Karam
--- D Crompton [EMAIL PROTECTED] wrote:
I have an MS excel file with 8 columns and 500 rows
I have a table called 'names'
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
Hello
I prefer SQLyog at http://www.webyog.com/sqlyog
Its FREE, extremely fast and very easy to use. Runs
only on Windows though. Should give a try!!!
Karam
--- Thomas Hoelsken [EMAIL PROTECTED] wrote:
Thanks, FreeMascon is able to do it und it works
fine. If anyone knows
another solution,
MySQLFront 2.5 had so many bugs that I had to leave
it. I prefer SQLyog now. Its FREE !!! and has all the
features ( plus some realy cool extra features ).
You can try SQLyog at http://www.webyog.com/sqlyog
Karam
--- Peter Brawley [EMAIL PROTECTED]
wrote:
Not just MySQLFront. PhpMyAdmin chokes
SQLyog at http://www.webyog.com/sqlyog is the best
Windows GUI I have seen. Its FREE, small, compact and
extremely fast when working with remote server.
Best I have seen till data.
Karam
--- Neil Tompkins [EMAIL PROTECTED] wrote:
I have recently purchased the lease of a dedicated
mySQL
Hello
If you mean Administering your MySQL server, then
probably SQLyog ( http://www.webyog.com ) will be a
good choice. It is small, powerful and a FREE front
end to MySQL.
Karam
--- Javier Gonzalez [EMAIL PROTECTED] wrote:
Hi.
In novice in this, can you tell me how application
uses to
Hello
You can connect to your remote MySQL server using
SQLyog. Just give in your MySQL details and it will
connect to your remote MySQL server.
Then you can create the SQL script which will bring
your Local MySQL server and remote server in sync with
each other.
Karam
--- Florent Martineau
Hello
If you are on Win platform then there is a tool called
SQLyog at http://www.webyog.com/sqlyog which has a
very powerful Database Synchronization facility.
If I am not wrong then you can find a tutorial on
Synchronizatin with SQLyog at
http://www.phpbuilder.com
Karam
--- Florent
I have never tried MS DTS, but SQLyog works great for
me in transferring MS SQL Server data to MySQL.
--- phil [EMAIL PROTECTED] wrote:
How-To-Repeat:
I am tried to use MS DTS to transfer a table from
MSSQL 2000 to MYSQL
3.23.55,
however there has an error during the transformation
on
If you are using Windows, a GUI client like SQLyog
would be of great help. It is free, and has neat
interface to display / manage relationships.
--- Jeff Epstein [EMAIL PROTECTED] wrote:
Hello all.
I've only been using MySQL for a few days, but I'm
experienced with
Oracle. So consider
Tool called SQLyog at
http://www.webyog.com/sqlyog/download.html does that.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Hey
Try SQLyog at http://www.webyog.com/sqlyog
Similar interface like MS Query Analyzer and extremely
fast.
Karam
--- Scott Lewis [EMAIL PROTECTED] wrote:
I was wondering, is there a program simialar to MS
SQL server - Query
Analyser, where you can write sql queries to query
MySQl
Greetings
Try SQLyog at
http://www.webyog.com/sqlyog/download.html
Its the best i know and also it works like butter on
remote connections
karam
--- David Driscoll [EMAIL PROTECTED] wrote:
I have a fairly basic mysql database running on
unix. Now I need to make this
data available to other
Since you are on Windows I will suggest take a look at
SQLyog at http://www.webyog.com/sqlyog
I prefer it over MySQLCC
Karam
--- Michal Seidl [EMAIL PROTECTED] wrote:
Hi,
The MySQLCC's setup.exe program is calling MSIEXEC
windows installator.
I have no such program on my W98. Is it a
Hello
I have two tables of InnoDB type.
CREATE TABLE `ledger` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `id` (`name`)
) TYPE=InnoDB;
CREATE TABLE `voucher` (
`id` int(11) NOT NULL default '0',
`vdate` date NOT NULL default
Hello Ppl...
I have a fixed length CSV file and when I try to
import it using the LOAD LOCAL command
load data local infile 'F:/Documents and
Settings/Karam/Desktop/test.csv' into table
`karam`.`test_table` fields escaped by '\\' enclosed
by '' terminated by '' lines terminated by '\n' ignore
5
Hello
I have a fixed width csv file. To import it I use the
following statement -
load data local infile 'F:/Documents and
Settings/Insane/Desktop/test.csv'
into table `insane`.`user_details_copy` fields escaped
by '\\' enclosed by
'' terminated by '' lines terminated by \n' IGNORE 1
LINES ( id,
Try SQLYog
at http://www.webyog.com/sqlyog/download.html
Very fast, compact and intuitive.
Only for Win32 :-(
Regards,
Karam
--- Nilza Lafayette [EMAIL PROTECTED] wrote:
I'm running MySQL onto a Windows Advanced Server.
I´m
looking for a good and free admin/client GUI for
Win32
and Linux.
Hello,
I am behind a SOCKS proxy. How do I connect to MySQL
Server using MySQL C API?
Thanks in advance,
Karam
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Hello
I want to statically link libmysql.dll with my closed
source application, which I have not planned to
distribute freely or commercial ?
Can I do that or I am violating any rules.
Karam
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful.
hello..
i have a winxp and linux 7.2 on the same machine. I
have mysql on the linux server and MyCC in the win
partition.
i connect to the linux MySQL using the vmware lopback
adapter. everything is working fine.
now when i issue a backup table syntax. it is giving
syntax. Is back table only
Even I have tried, SQLyog and MyCC both.
MyCC has some interesting features like Blob Editing
and Editing Table
Properties etc. but SQLyog has some very good features
like Multiple Query
Execution and Multiple ResultSet in different tabs,
which I find usefule
manytimes.
If you are heavy
101 - 186 of 186 matches
Mail list logo