libmysql.dll size increased from 188Kb to 916KB
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 __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. 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]
Re: Migrating Access databases to MySQL
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 of exporting in > CSV format or tab > delimited formats and using mysqlimport to move the > tables. > > 1. I was wondering if there was a way to dump access > databases in SQL > queries like the mysqldump utility does ? > > 2. When exporting tab delimited values from access > and using mysqlimport > everything works fine except date columns. All the > data moves except the > date field which shows up zero's I mysql after I use > mysqlimport. Does > anyone have a clue on what might be happening? > > 3. Is there any way other than downloading some > shareware third party > programs to transfer my databases from access to > MySQL ? > > > I would appreciate any help at all. Thanks to > everyone in advance ! > > Arjun Subramanian > Georgia Tech Station 32003 > Atlanta GA 30332 > Cell: +404.429.5513 > "I'm MySQL certified. Are you?" > > > -Original Message- > From: Casey Sheridan [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 18, 2004 6:32 PM > To: [EMAIL PROTECTED] > Subject: writing queries to get distinct results > > I have a table that has employee names, pay rates, > and unique IDs. I > want > to select all of the distinct employee names, and if > there are two > employees > with the same name, I want to be able to choose only > one; the one with > the > highest pay rate. If there are two identical > employee names with the > same > pay rate, I want to select the one that has the > lowest unique ID number. > Can anyone help me on how to write this query? > Thanks! > -Casey Sheridan > [EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORACLE to MySQL migration
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 tool, otherwise a > free software / > shared software should > be very appreciated > > Can anyone give me some suggestions? > > thanks a lot > Enrico > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Using Indian languages and working with them using C API()
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 API mysql_real_query(). Should I send them after converting to utf-8 or it depends upon how the server was configured. I mean the server was configured to use ucs-2 then probably I can send the data as it is in Unicode and setting the correct length in mysql_real_query() API. WIndows has inbuilt functions that can convert from Unicode to utf-8 and vice versa. Since my application is a general purpose so I dont know how the server is configured...whether it is configured for ucs-2 or for utf-8. There how to figure out so that I can correctly convert the data returned from mysql_store_result() to Unicode value and display the result in my app. I am confused on how the data is returned back and forth between my client and the server? Regards Karam --- Jeremy March <[EMAIL PROTECTED]> wrote: > > Can somebody give me pointers how to store and > > retrieve data in Hindi using MySQL C API and MySQL > in > > general. Since alll the hindi text will be in > unicode > > format and C API uses char* parameter how do I > > interface between my Hindi text data and C API. DO > I > > convert them to some other format like utf-8 etc. > > I don't have very much experience writing clients in > C, but I have been > following the MySQL unicode development. If you > haven't already it > might help to look at the MySQL source that deals > with unicode. In the > strings directory there are two files ctype-utf8.c > and ctype-ucs2.c. > All the sorting and string comparisons for unicode > are defined there. I > think the conversion from char* to unicode is done > there. I suggest you > look at the latest source for 4.1.2 in the bitkeeper > tree because > changes are still being made to this code. I expect > there will be more > significant changes in the next couple of weeks. > > It might also help to read the SET CHARACTER SET and > SET NAMES commands > here: > http://www.mysql.com/doc/en/Charset.html > > Good luck, > Jeremy > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using Indian languages and working with them using C API()
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 general. Since alll the hindi text will be in unicode format and C API uses char* parameter how do I interface between my Hindi text data and C API. DO I convert them to some other format like utf-8 etc. If anybody has developed an application using MySQL with complex script like Hindiatheir ideas will be very helpful. Regards Karam Rega __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Unicode Data and C API
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 are Unicode data returned to the client? MYSQL_ROW is defined to be char? Are they sent in utf-8? Sorry for my ignorance but my app is written with Unicode support and all the string functions require Unicode data so should I convert them to utf-8 before sending them to C API and convert them to Unicode character after fetching them? Thanks for your help. regards karam __ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Import Access DB into MySQL
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 the .mdb file instead of a .txt file? > > If not does anyone have any suggestions? > > Thanks, > > Jacque > __ Do you Yahoo!? Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transfering from access to MySQL?
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!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Want to understand MySQL Code? Where to start...
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 only the mail you want. http://antispam.yahoo.com/tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query to another server
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 = > remoteserver.remotedatabase.remotetable.key > > > FBR > __ 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]
Re: oracle to mysql
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 migrate Oracle > databases and schema to MySQL 5.0? I know one such > tool, "Oracle-to-mysql" which is not free though. > > Thanks > Raza > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ 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]
How MySQL is handling unicode...some questions?
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 processing) it is decoding it? I am not sure about it...? Even the normal C API take char* for all their functions. Can somebody tell me how MySQL is handling multi-byte character data? Should I post the same in mysql-internals list? Regards Karam __ 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]
Re: Result returned by "show index from"...
Hello OK? Got it. So the structure of columns returned by SHOW INDEX has changed after 4.0.2 and it has remained same after that. Karam --- [EMAIL PROTECTED] wrote: > This is mentioned in the create table section: > http://www.mysql.com/doc/en/CREATE_TABLE.html > > >>>>>>>>>>>>>>>>>> Original Message > <<<<<<<<<<<<<<<<<< > > On 2/5/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 Cardinality Sub_part > Packed > > NullIndex_type Comment > > > In the docs at > > > http://www.mysql.com/doc/en/Show_database_info.html > > there is no mention for Packed column. > > > The same happens for 4.0.15, 4.1, 4.1.1? > > > Is this column added from 4.0.2 like Null and > > Index_type? > > > What does packed column mean...? > > > Do I assume that the columns returned by Show > index > > changed from 4.0.2 and have not changed after > that? > > > Regards > > Karam > > > > > __ > > 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] __ 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]
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 Cardinality Sub_part Packed NullIndex_type Comment In the docs at http://www.mysql.com/doc/en/Show_database_info.html there is no mention for Packed column. The same happens for 4.0.15, 4.1, 4.1.1? Is this column added from 4.0.2 like Null and Index_type? What does packed column mean...? Do I assume that the columns returned by Show index changed from 4.0.2 and have not changed after that? Regards Karam __ 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]
How MySQL is handling unicode() some doubts
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 processing) it is decoding it? I am not sure about it...? Even the normal C API take char* for all their functions. Can somebody tell me how MySQL is handling multi-byte character data? Should I post the same in mysql-internals list? Regards Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.1 Download
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:http://lists.mysql.com/[EMAIL PROTECTED]
Can I get Winows 4.0.15 binary..
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Synchronization and replication of two MYSQL databases
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 data centre on Linux. > > > Awaiting your reply at the earliest, > > Thanks & Regards, > Prashant A > > -- > 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 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]
In which version of MySQL was ADD COMMENT added
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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data sincronization
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 further inserts until it gets a new > key interval. > > It's a way to go at least with a low number of > servers. > > Maybe even give a warning some time _before_ you run > out of keys...? ;) > > You should never run out of keys. Every time you > sync, you also check if > there are many keys left to use... if you sync once > a day, as soon as you > have less than 10 times the expected daily usage of > keys left to use, you > request a new set of keys. > > You still would have to handle duplicates. > > -- > Roger > > > -- > 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 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]
Re: What information does "Extra" and "Comments" give in "show full fields"
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. EXTRA and COMMENTS which is > > always blank. I cant seem to figure out what > > information they provide. The SHOW FULL FIELDS... > in > > my MySQL Doc does not talk on this columns. > > Extra shows if column has attribute AUTO_INCREMENT. > Comments shows comment on the column level. For > example: > > mysql> show full fields from test; > +---+-+---+--+-+-++-+---+ > | Field | Type| Collation | Null | Key | Default > | Extra | Privileges | > Comment | > +---+-+---+--+-+-++-+---+ > | id| int(11) | NULL | | PRI | NULL > | auto_increment | select,insert,update,references | > this is a comment | > +---+-+---+--+-+-++-+---+ > 1 row in set (0.01 sec) > > > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > 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 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]
What information does "Extra" and "Comments" give in "show full fields"
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 MySQL Doc does not talk on this columns. __ 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]
[ANN] Tool for Zero Install MySQL Replication
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 included with SQLyog 3.61 - the latest version of the award winning MySQL Client. The Linux version of SJA is FREE and can be downloaded from http://www.webyog.com. SJA does not require any installation at hosts running the MySQL server. You can use any host to run SJA. For example you can use SJA to keep your production databases ( probably hosted with an ISP ) in complete sync with your test database located in your PC or LAN. SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore, only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts. Additionally, you can configure SJA to detect changes only for specific rows and columns. For example you can exclude blob columns or include only those rows that fulfill a WHERE clause. This makes it an ideal tool to sync data even if there is limited bandwidth. SJA is a command line tool that accepts a Job Definition file encoded in XML as one of the parameters. You can either create the Job Definition file manually or use one of the wizards included with SQLyog. If you use SQLyog to create your job files, you dont need to have any knowledge about XML or the Job Definition schema. On Windows platforms, SQLyog uses the Task Scheduler services to schedule your jobs. On other platforms you can use the respective OS scheduling services, e.g on Linux, you can use cron to schedule jobs. Apart from regular administration tools, SQLyog also contains the following features:- - ODBC Import - Migrate ORACLE, MS SQL, Sybase, DB2, Access, etc to MySQL with a powerful wizard based interface! - Schema Synchronization Tool - Automatically generate scripts to bring the table structures of two databases in sync. - Relationship Manager - Intuitive interface to create and manage relationships. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Journals and Magazines
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 http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Journals and Magazines
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 http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Protocol mismatch, Server Version = 9 Client Version =
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 mysql_real_connect(). What am I doing wrong? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10
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 mysql_real_connect(). What am I doing wrong? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Formatted double value...
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 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 | > > |4e-006 | > > |5e-006 | > > |6e-006 | > > | 8 | > > |8e-006 | > > > > Is there any way wherein I can get data like > .01, > > .02 etc. > > Maybe the FORMAT() function will do what you want: > > http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1391 > > > > -- > Roger > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Formatted double value...
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 | |4e-006 | |5e-006 | |6e-006 | | 8 | |8e-006 | Is there any way wherein I can get data like .01, .02 etc. Thanks in advance. karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
User Permission and ODBC
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 attempt to access the database through ODBC using a number of third-party tools. My intent is to offer my clients the ability to access their data through ODBC with the option to restrict a specific set of users to sensitive data (Financials or salary amount column for Payroll) using a tool such as SQLyog. Is this possible that one tool has the permission and another not? karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can I change the date format...
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 stored in mm/dd/ format and can change based on the source of the data. I can import the date fields into a char field and then convert it but would like to save the time to transform and copy contents into another table. Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Server 2000 to mySQL Server
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 have caused this
> error
> the solutions I have seen say go plain text and
> import using LOAD DATA
> INFILE
> Martin
> - Original Message -
> From: "David Alonzo" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 13, 2003 4:30 PM
> Subject: SQL Server 2000 to mySQL Server
>
>
> > I'm trying to do an export from an SQL Server 2000
> Database to and ODBC
> driver pointed to a mySQL Server Database. The
> export works if there is at
> least one record in the mySQL table. If the mySQL
> table is empty it gives
> an error that looks like this:
> >
> > Insert error, column 1 ('field1', DBTYPE_STR),
> status 6: Data overflow.
> >
> > The strange part is that the export works
> perfectly fine as long as there
> is one record in the mySQL table, if there are no
> records in the table, I
> get the error above.
> >
> > Thank you for your help.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 1005...
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) unsigned NOT NULL auto_increment , `caseid` int(6) unsigned NOT NULL DEFAULT '0' , `litigantid` int(6) unsigned NULL , `litiganttype` char(1) NULL , `counselid` int(6) unsigned NULL , primary key ( entryid ) ,KEY `caseid` ( `caseid` ), FULLTEXT KEY `counselid` ( `counselid` ), FULLTEXT KEY `litigantid` ( `litigantid` )); I get a error - Error No. 1005 Can't creat table 'C:\WINDOWS\TEMP\#sql794_37_2.frm' (errno: 140) Why the above query is not working? Is there anything wrong with the SQL? Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Picturing numeric data...
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 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why LIKE not using INDEX?
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%' It is returning me correct results...but the query does not seem to be using the INDEX? My question is ... does MySQL not uses INDEX when we execute a LIKE command on a NUMERIC data Is there any better solution to this query? __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can I make this query more optimised?
Greetings
I have a table with the following table structure -
mysql> desc email_table;
+-+---+---+--+-+-+---+
| Field | Type | Collation | Null |
Key | Default | Extra |
+-+---+---+--+-+-+---+
| email | varchar(50) | latin1_swedish_ci | |
PRI | | |
| is_sent | enum('Y','N') | latin1_swedish_ci | YES |
| NULL| |
| id | int(10) | binary| |
PRI | 0 | |
+-+---+---+--+-+-+---+
I have a index on (id,email)
I do a query like with Explain...
explain select
concat(sum(conv(substring(md5(concat(email,is_sent,id)),1,8),16,10)),
sum(conv(substring(md5(concat(email,is_sent,id)),9,8),16,10)))
as b,
substring(concat(id,email),1,3) as c,
count(*) as cnt from test.email_table
where substring(concat(id,email),1,2) = '33'
group by substring(concat(id,email),1,3)
order by 1;
++-+-+--+---+--+-+--
+---+--+
| id | select_type | table | type |
possible_keys | key | key_len | ref
| rows | Extra
|
++-+-+--+---+--+-+--
+---+--+
| 1 | SIMPLE | email_table | ALL | NULL
| NULL |NULL | NULL
| 33914 | Using where; Using temporary; Using filesort
|
++-+-+--+---+--+-+--
+---+--+
The Explain says that it is not using any query and
scanning 33914 rows ( that is the number of rows in my
table ).
When I execute the query, it takes around 80ms,
returns 10 rows. I am running MySQL 4.1.0-alpha-max-nt
on WinXP.
Is there any way to optimise this query more.or
the time taken by MySQL is GOOD?
Thanks in advance.
karam
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to know the maxmimum length of data in a perticular column?
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 PROTECTED],2000-12-12 > > 20,[EMAIL PROTECTED],NULL > > ... > > > > It will return me > > > > 2,15,10 > > SELECT MAX(LENGTH(field1)) AS f1len, > MAX(LENGTH(field2)) AS f2len, > MAX(LENGTH(field3)) AS f3len FROM mytable; > > -- > Dan Nelson > [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to know the maxmimum length of data in a perticular column?
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 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why the query is not using index?
Greetings
Having a table with the following structure -
+-+---+---+--+-+-+--
--+
| Field | Type | Collation | Null |
Key | Default | Extra
|
+-+---+---+--+-+-+--
--+
| email | char(50) | latin1_swedish_ci | YES |
MUL | NULL|
|
| is_sent | enum('Y','N') | latin1_swedish_ci | YES |
| NULL|
|
| id | int(10) | binary| |
PRI | NULL| auto_incr
ement |
+-+---+---+--+-+-+--
--+
If I issue a command like this -
explain select substring(id,1,4) from email_table
where substring(id,1,4) < 300 limit 500;
The result returned is -
++-+-+---+---+-+-+--
+---+--+
| id | select_type | table | type |
possible_keys | key | key_len | r
ef | rows | Extra|
++-+-+---+---+-+-+--
+---+--+
| 1 | SIMPLE | email_table | index | NULL
| PRIMARY | 4 | N
ULL | 33914 | Using where; Using index |
++-+-+---+---+-+-+--
+---+--+
This means it is using the index.
But, if issue a command like -
explain select email from email_table where
substring(id,1,4) < 300 limit 500;
++-+-+--+---+--+-+--
+---+-+
| id | select_type | table | type |
possible_keys | key | key_len | ref
| rows | Extra |
++-+-+--+---+--+-+--
+---+-+
| 1 | SIMPLE | email_table | ALL | NULL
| NULL |NULL | NULL
| 33914 | Using where |
++-+-+--+---+--+-+--
+---+-+
the KEY column is NULL i.e. it is not using Index?
Why the query is not using index?
Thanks in advance.
Karam
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Deleting duplicating records
Great. So in that case I need to create a new table with similar structure with a additional UNIQUE index on email. Karam --- Venelin Arnaoudov <[EMAIL PROTECTED]> wrote: > I would copy all the records (_email_, max(version)) > to a new table, > drop the old one and then rename 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 > > > >Karam > >--- Jeff McKeon <[EMAIL PROTECTED]> wrote: > > > > > >>How bout > >> > >>Delete from tablename where email like > >>[EMAIL PROTECTED] && 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 > >>> > >>>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 - > >>> > >>>1,[EMAIL PROTECTED],1.0 > >>>2,[EMAIL PROTECTED],2.0 > >>>3,[EMAIL PROTECTED],3.0 > >>> > >>>Now I want to delete all the records wherein all > >>> > >>> > >>rows > >> > >> > >>>with duplicate email addresses are deleted so > that > >>> > >>> > >>i > >> > >> > >>>have data like > >>> > >>>1,[EMAIL PROTECTED],1.0 > >>>... > >>> > >>>What should be the query? Thanks in advance. > >>> > >>>Karam > >>> > >>>__ > >>>Do you Yahoo!? > >>>Yahoo! SiteBuilder - Free, easy-to-use web site > >>> > >>> > >>design > >> > >> > >>>software http://sitebuilder.yahoo.com > >>> > >>>-- > >>>MySQL General Mailing List > >>>For list archives: http://lists.mysql.com/mysql > >>>To unsubscribe: > >>>http://lists.mysql.com/mysql?> > >>> > >>> > >>[EMAIL PROTECTED] > >> > >> > >>> > >>> > >>-- > >>MySQL General Mailing List > >>For list archives: http://lists.mysql.com/mysql > >>To unsubscribe: > >> > >> > >> > >http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > >__ > >Do you Yahoo!? > >Yahoo! SiteBuilder - Free, easy-to-use web site > design software > >http://sitebuilder.yahoo.com > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Deleting duplicating records
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 > [EMAIL PROTECTED] && 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 > > > > 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 - > > > > 1,[EMAIL PROTECTED],1.0 > > 2,[EMAIL PROTECTED],2.0 > > 3,[EMAIL PROTECTED],3.0 > > > > Now I want to delete all the records wherein all > rows > > with duplicate email addresses are deleted so that > i > > have data like > > > > 1,[EMAIL PROTECTED],1.0 > > ... > > > > What should be the query? Thanks in advance. > > > > Karam > > > > __ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site > design > > software http://sitebuilder.yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?> > [EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Deleting duplicating records
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 - 1,[EMAIL PROTECTED],1.0 2,[EMAIL PROTECTED],2.0 3,[EMAIL PROTECTED],3.0 Now I want to delete all the records wherein all rows with duplicate email addresses are deleted so that i have data like 1,[EMAIL PROTECTED],1.0 ... What should be the query? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant duplicate table???
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 `AdvertisementID` ( `AdvertisementID` ) )type=MyISAM select `AdInstanceID`, `AdvertisementID`, `KeyNumber`, `StationID`, `SpotDateTime`, `Duration`, `BreakNumber`, `AdsInBreak`, `PositionInBreak`, `PromoBefore`, `PromoAfter`, `TypeOfAd`, `CommentCode`, `ProgramID`, `MarketInd` from `aimdb`.`mtv20030105spots` where 1 = 0 MySQL giving me error - 'Cant create Tablename.frm(...)' I am running 4.0.13 on Win98? Can somebody tell me whats wrong? Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anomaly in ResultSet
Greetings
I have a table with the following table structure -
FieldType Collation NullKey
Default Extra
--- - - --
-- --- --
emailchar(75) latin1_swedish_ci
is_sent enum('Y','N') latin1_swedish_ci YES
N
id int(11)binary PRI
0
I store information about people email whom i need to
send mails and whether a mail has been sent to them or
not.
When I execute a query something like this -
select id/1024,
concat(sum(conv(substring(md5(email),1,8),16,10)),
sum(conv(substring(md5(email),9,16),16,10))) as b from
email_table_copy group by id/1024 order by 1 limit 5;
I get a rsultset -
id/1024 b
--- ---
0.00 90938840384071199637149243
0.01 220573218709550488768333706
0.02 1674463121499308443382963454000
0.03 1770590858478526561626311655000
0.04 3376981218189278277222690357000
When I execute a query like -
select id/1024, @a:=md5(email),
concat(sum(conv(substring(@a,1,8),16,10)),
sum(conv(substring(@a,9,16),16,10))) as b from
email_table_copy group by id/1024 order by 1 limit 5;
I get a resultset -
id/1024 @a:=md5(email)b
---
0.00 a0cb77a048bcafa0c122a97c48c4dc2f
1322364373425669539519654994000
0.01 3d3de1a6987b54fa31c9290a0eaa987d
1194487973410412847951641086
0.02 0b84e00a70f4d0b2cfc38449e5ab8b4b
276678297684241708186218316000
0.03 025ab61135c8ed4a329dd5670801e866
54875101143019835333537694000
0.04 f53e627643b62f9bda102b0612f28ec3
411845628615266700430955928
Shouldnt be the value of `b` be same both the times.
By executing the second query i belive i do md5
conversion only once which should significantly boost
the result on a big table.
Am I doing something wrong?
Also, what is the best way to remove the md5 key
column from the resultset as I dont need that.
Thanks in advance
Karam
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to convert SQL Server 2000 database to MySQL?
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]> wrote: > Hi. > First, you will be happy to know that I am migrating > a client to > PHP/MySQL from ASP/MSSQL. This is for reasons of > future preservation, > cost, security, efficiency, et cetera. The problem > is, I don't > currently have a PC and $$ to run Windows 2000 > server on. I have been > sent the MDF and LDF database files by the client... > Does someone know > of a way to convert those files to SQL without > running Windows to do > it? If not, is there an SQL-like format that SQL > Server will save as > that I can request from the client? Or is there > an application > (Windows or anything) that someone can recommend to > make this > conversion? I should point out that this is a > simple database with no > stored procedures or anything fancy. > > thanks for taking the time to read this, > Kumar > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anomaly in resultset
Greetings
I have a table with the following table structure -
FieldType Collation NullKey
Default Extra
--- - - --
-- --- --
emailchar(75) latin1_swedish_ci
is_sent enum('Y','N') latin1_swedish_ci YES
N
id int(11)binary PRI
0
I store information about people email whom i need to
send mails and whether a mail has been sent to them or
not.
When I execute a query something like this -
select id/1024,
concat(sum(conv(substring(md5(email),1,8),16,10)),
sum(conv(substring(md5(email),9,16),16,10))) as b from
email_table_copy group by id/1024 order by 1 limit 5;
I get a rsultset -
id/1024 b
--- ---
0.00 90938840384071199637149243
0.01 220573218709550488768333706
0.02 1674463121499308443382963454000
0.03 1770590858478526561626311655000
0.04 3376981218189278277222690357000
When I execute a query like -
select id/1024, @a:=md5(email),
concat(sum(conv(substring(@a,1,8),16,10)),
sum(conv(substring(@a,9,16),16,10))) as b from
email_table_copy group by id/1024 order by 1 limit 5;
I get a resultset -
id/1024 @a:=md5(email)b
---
0.00 a0cb77a048bcafa0c122a97c48c4dc2f
1322364373425669539519654994000
0.01 3d3de1a6987b54fa31c9290a0eaa987d
1194487973410412847951641086
0.02 0b84e00a70f4d0b2cfc38449e5ab8b4b
276678297684241708186218316000
0.03 025ab61135c8ed4a329dd5670801e866
54875101143019835333537694000
0.04 f53e627643b62f9bda102b0612f28ec3
411845628615266700430955928
Shouldnt be the value of `b` be same both the times.
By executing the second query i belive i do md5
conversion only once which should significantly boost
the result on a big table.
Am I doing something wrong?
Also, what is the best way to remove the md5 key
column from the resultset as I dont need that.
Thanks in advance
Karam
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQLyog 3.51 has been released
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 data does not require double click for viewing if the data is < 255 bytes. -- More compact and optimized executable ( 480 KB ). -- Lot of bugfixes and enhancements. SQLyog 3.51 is available at an Introductory price of $49. You can download a full featured Trial version of SQLyog at http://www.webyog.com/sqlyog/download.html Hope you like it as much I like using it. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL GUIs
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 the best GUI for accesing > MySQL - and as you asked > the question you know there is only one best GUI > ;-). Anything mentioned > below is my personal opinion and I am ot related to > tany of the parties > mentioned. Any welcome to fire back on me ;-) > > EMS's MySQL Mangaer is to heavy loaded and the > interface is anything else then > intuitive - so kick it into the bucket ;-) > > There are many such tools around to be honest, but > my absolute favourite one > has to be DbVisualizer (www.minq.se) with a > loong distance second . > > That has very good reasons which I am willing to > explain. > > a) First the Menu is intuitive AND context > sensitive. > b) its fast > c) it works > d) its java > e) its professionally done > f) contains a chart software (yfiles from > www.yworks.com) > g) support replies under 10 minutes !! REGULARLY > h) its not a windows copy GUI ;-) > i) two license model > j) any major OS supported > > > About a) I want to explain a bit more. When you > choose data and go to the > export menu it will offer you to export as html or > csv. If you choose to > export the diagramme it will offer as choice jpeg or > gif. So the menu changes > (in the background) and you dont have to think about > it. It also takes the > millions off not needed options out of the menu >> > simpler. > > Of course there is more but I believe that I gave > enough good reasons ;-) > > I have no clue why MySQL is partnering with EMS ;-), > but I strongly believe > that DbVisualizer is the best around. > > If anybody believes that another tool is better than > I would be VERY > interested to hear about it. > > Best regards > > Nils Valentin > Tokyo/Japan > > > > > 2003年 6月 12日 木曜日 23:21、Adam Nelson > さんは書きました: > > I like MySQL Manager - it costs a bit of money, > but I find it > > indispensible. > > > > www.ems-hitech.com > > > > It runs on Windows AND Linux. I'll be switching > to the linux version in > > about two weeks, so I'll tell you how well it > works. > > > > > -Original Message- > > > From: Knepley, Jim > [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, June 11, 2003 3:00 PM > > > To: Rodolphe Toots; [EMAIL PROTECTED] > > > Subject: RE: mySQL GUIs > > > > > > > > > I'm a big fan of Scibit's "Mascon" > > > > > > > > > > > > -Original Message- > > > From: Rodolphe Toots > [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, June 11, 2003 5:17 AM > > > To: [EMAIL PROTECTED] > > > Subject: mySQL GUIs > > > > > > > > > hi! > > > > > > i am looking for a good mySQL gui for windows > > > i have used mySQL front, which was an excellent > free program, > > > but i did > > > not handle relations and diagrams. also the > program is no longer being > > > developed > > > > > > i have now found the prog mySQL tools > (http://www.mysqltools.com/) and > > > mySQL explorer that works almost as enterprise > manager for MS SQL > > > server. it even creates database diagrams with > relations as in > > > enterprise manager! only backdraw is that this > program is not > > > free, but > > > it is the best i have ever seen so far > > > > > > is there anyone out there that knows of a > program that is > > > freeware/shareware and is good (like mySQL > tools)? > > > > > > > > > > > > /rewdboy > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL GUIs
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 has lot of less features as compared to SQLyog. Karam --- Rodolphe Toots <[EMAIL PROTECTED]> wrote: > hi! > > i am looking for a good mySQL gui for windows > i have used mySQL front, which was an excellent free > program, but i did not handle relations and > diagrams. also the program is no longer being > developed > > i have now found the prog mySQL tools > (http://www.mysqltools.com/) and mySQL explorer that > works almost as enterprise manager for MS SQL > server. it even creates database diagrams with > relations as in enterprise manager! > only backdraw is that this program is not free, but > it is the best i have ever seen so far > > is there anyone out there that knows of a program > that is freeware/shareware and is good (like mySQL > tools)? > > > > /rewdboy > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Starting MySQL with SSL
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 compile MySQL from the source, or what with option do I need to start mysqld-nt-max? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Loading database information from a text file.
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 > create databases to setting up tables. I have > looked > throught the mysql docs onto how to load these on > from > the mysql prompt. But all I can find is: > > load data infile "filename.txt" into table whatever > > But this is not what I am looking for. :( As the > tables are already defined in the text file and the > appropiate database name to enter them into. > > Is there a way to load these into the database > directly instead of doing each table seperately from > the mysql prompt? (not web admin) > > Thanks in advance. > > Kind Regards, > Jerry > > > > http://mobile.yahoo.com.au - Yahoo! Mobile > - Check & compose your email via SMS on your Telstra > or Vodafone mobile. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: msSQL-MySQL
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 mySQL format, i would be very grateful if
> someone in here could
> help me out.
>
> Thanks.
> Karma
>
>
>
> - Original Message -
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 06, 2003 2:53 PM
> Subject: Re: start innodb without transactions
>
>
> > Carlos,
> >
> > please send me your my.cnf. How big is the
> combined size of your log
> files?
> >
> > "
> > MySQL/InnoDB-4.0.9, January 14, 2003
> >
> > Fixed a bug: if the combined size of InnoDB log
> files was >= 2 GB in a
> > 32-bit computer, InnoDB would write log in a wrong
> position. That could
> make
> > crash recovery and InnoDB Hot Backup to fail.
> > "
> >
> > In the first printout:
> >
> > > InnoDB: Starting log scan based on checkpoint at
> > > InnoDB: log sequence number 13 1000286684
> > > InnoDB: Doing recovery: scanned up to log
> sequence number 13 1000286208
> >
> > looks like InnoDB is not able to scan the log file
> at all, not even up to
> > the checkpoint!
> >
> > > InnoDB: log sequence number 13 1002344016
> > > InnoDB: Doing recovery: scanned up to log
> sequence number 13 1002343936
> >
> > The same in the next printout. It has written some
> 2 MB more log but
> cannot
> > after a crash scan the log at all!
> >
> > The failing assertion checks when freeing a BLOB
> or TEXT field that its
> > length is right:
> >
> > if (extern_len - part_len == 0) {
> > ut_a(next_page_no ==
> FIL_NULL);
> > }
> >
> > This could be:
> >
> > 1) a bug in InnoDB's log writing;
> > 2) hardware fault, broken disk;
> > 3) serious corruption of the OS file system.
> >
> > If InnoDB fails to scan lots of log in crash
> recovery, it means that the
> > resulting database may have very extensive
> corruption. That can explain
> why
> > some of your tables are not visible at all.
> >
> > There is little hope of recovering your tables.
> You should resort to a
> > backup and upgrade to 4.0.13. Then do some heavy
> processing, for example,
> a
> > table import, and crash mysqld artificially by
> >
> > killall -9 mysqld
> >
> > Look then if InnoDB is able to scan the log in
> crash recovery.
> >
> > Best regards,
> >
> > Heikki Tuuri
> > Innobase Oy
> > http://www.innodb.com
> > Transactions, foreign keys, and a hot backup tool
> for MySQL
> > Order MySQL technical support from
> https://order.mysql.com/
> >
> >
> >
> > - Original Message -
> > From: ""Carlos Proal"" <[EMAIL PROTECTED]>
> > Newsgroups: mailing.database.mysql
> > Sent: Friday, June 06, 2003 7:41 AM
> > Subject: Re: start innodb without transactions
> >
> >
> > >
> > > Probably i need to describe the whole story:
> > > I did a huge insert, a file about 100Mb, and
> mysql crashed/restarted,
> the
> > > err file showed:
> > >
>
--
> > > 030605 12:11:59 mysqld restarted
> > > 030605 12:12:00 InnoDB: Database was not shut
> down normally.
> > > InnoDB: Starting recovery from log files...
> > > InnoDB: Starting log scan based on checkpoint at
> > > InnoDB: log sequence number 13 1000286684
> > > InnoDB: Doing recovery: scanned up to log
> sequence number 13 1000286208
> > > InnoDB: Last MySQL binlog file position 0
> 756499, file name
> > > ./catarina-bin.057
> > > 030605 12:12:01 InnoDB: Flushing modified pages
> from the buffer pool...
> > > 030605 12:12:01 InnoDB: Started
> > > /centia01/final/database/mysql/libexec/mysqld:
> ready for connections
> > > 030605 12:14:01 InnoDB: Out of memory in
> additional memory pool.
> > > InnoDB: InnoDB will start allocating memory from
> the OS.
> > > InnoDB: You may get better performance if you
> configure a bigger
> > > InnoDB: value in the MySQL my.cnf file for
> > > InnoDB: innodb_additional_mem_pool_size.
> > > mysqld got signal 10;
> > > This could be because you hit a bug. It is also
> possible that this
> binary
> > > or one of the libraries it was linked against is
> corrupt, improperly
> > built,
> > > or misconfigured. This error can also be caused
> by malfunctioning
> > hardware.
> > > We will try our best to scrape up some info that
> will hopefully help
> > > diagnose
> > > the problem, but since we have already crashed,
> something is definitely
> > > wrong
> > > and this may fail.
> > >
> > > key_buffer_size=67104768
> > > read_buffer_size=131072
> > > sort_buffer_size=524280
> > > max_used_connections=4
> > > max_connections=500
> > > threads_connected=4
> > > It is possible that mysqld could use up to
> > > key_buffer_size + (read_buffer_size +
> sort_buffer_size)*max_connections
> =
> > > 385528
> > > K
> > > bytes of memory
> > > Hope that's ok; if not, decrease so
mysql_real_connect() hangs with SSL support
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 code i use is - UINT client = 0; client = client | CLIENT_SSL; ret = mysql_real_connect ( mysql, "localhost", "user", "pwd", NULL, 3306, NULL, client ); The app seems to hang? but when i comment out the line client = client | CLIENT_SSL; everything seems to be working find. I want to use the SSL protocol? Am I doint anything wrong. Yeah...I am using the libmysql.dll which was provided with 3.23.54? Do I need to upgrade the .dll and .lib which is provided with MySQL 4.x??? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database copy
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 do this quite a few times myself. > If you have use of a server with MySQL on it then it > can be done using a GUI > (I use MySQL-Front, but most people seem to MySQL > Control Center. > All you do is use the built-in tools to transfer > table structures + data to > a database (any) on the external server and then > transfer it from there to > the other PC. > > If this doesn't make much sense to you, let me know! > Best wishes, > Paul Najman > > - Original Message - > From: "Fabio Bernardo" > <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, June 03, 2003 4:12 PM > Subject: database copy > > > Hi there, I ´m using the Mysql control center with > a database called dbONE > in a PC, and I would like to copy it to another PC, > Do you have any idea to > how can I do it? I dont wanna create all the tables > again... > Thanks a lot > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQLyog can not insert/update Table w/o Primary Key
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?. > Im not quite sure what a primary does. I only used > a primary key on one > table which had auto_increment column only because > it forced me to add it. > ?? > > > > > 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 > >to Outlook(TM). > > http://calendar.yahoo.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQLyog can not insert/update Table w/o Primary Key
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 to enable this? > > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Field Information from 'show fields from...'
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. Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlclient.exe
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 > > aghajani wrote: > > > Hello, > > I have downloaded all the following files, but I > cannot find the file > > mysqlgui.exe I am interested in using the > graphical MySQL client. > Could you > > please help me where I can find this file? > > Thank you very much > > Jaafar Aghajanian > > > > MySQLGUI 1.7.5 Source Code > > Statically Compiled MySQLGUI 1.7.5-1 > > Linux semi static binary of MySQLGUI 1.7.5 > > Win32 static binary of MySQLGUI 1.7.5-2 > > FreeBSD 4.2 static binary of MySQLGUI 1.7.2 > > OpenBSD 2.6 static binary of MySQLGUI 1.4 > > OpenBSD 2.6 semi static binary of MySQLGUI 1.4 > > Sun Solaris 2.7 Sparc static binary of MySQLGUI > 1.6 > > Sun Solaris 2.8 Sparc static binary of MySQLGUI > 1.7.5 > > > > > > > > Hi! > > MySQLGUI is deprecated, instead you should use MySQL > Control Centre > (MySQLCC): > > http://www.mysql.com/downloads/mysqlcc.html > > -Mark > > - -- > For technical support contracts, visit > https://order.mysql.com/?ref=mmma > > __ ___ ___ __ >/ |/ /_ __/ __/ __ \/ / Mark Matthews > <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. > Manager - J2EE/Windows > /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), > IL USA > <___/ www.mysql.com > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.1 (MingW32) > Comment: Using GnuPG with Mozilla - > http://enigmail.mozdev.org > > iD8DBQE+3AUatvXNTca6JD8RAqRaAKCG5Ty8Pm+Z1zMFXmzdAc4xp/FDJQCfZ5XZ > EvYve2amxovxHiC13s7epQw= > =qsLa > -END PGP SIGNATURE- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant connect with SSL support
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 code i use is - UINT client = 0; client = client | CLIENT_SSL; ret = mysql_real_connect ( mysql, "localhost", "user", "pwd", NULL, 3306, NULL, client ); The app seems to hang? but when i comment out the line client = client | CLIENT_SSL; everything seems to be working find. I want to use the SSL protocol? Am I doint anything wrong. Yeah...I am using the libmysql.dll which was provided with 3.23.54? Do I need to upgrade the .dll and .lib which is provided with MySQL 4.x??? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
result returned from query 'show fields from .....'
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. Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant connect with SSL support
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 code i use is - UINT client = 0; client = client | CLIENT_SSL; ret = mysql_real_connect ( mysql, "localhost", "user", "pwd", NULL, 3306, NULL, client ); The app seems to hang? but when i comment out the line client = client | CLIENT_SSL; everything seems to be working find. I want to use the SSL protocol? Am I doint anything wrong. Yeah...I am using the libmysql.dll which was provided with 3.23.54? Do I need to upgrade the .dll and .lib which is provided with MySQL 4.x??? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
charset=latin1 problem
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 SQL syntax near
'CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata'' at line 38
(113 ms taken)
The create table query is as follows
CREATE TABLE `abonnenter` (
`id` int(11) NOT NULL auto_increment,
`navn` varchar(100) NOT NULL default '',
`abonr` varchar(20) NOT NULL default '',
`adresse` varchar(50) NOT NULL default '0',
`post` varchar(50) NOT NULL default '0',
`telefon` varchar(20) default NULL,
`telefax` varchar(20) default NULL,
`epost` varchar(100) default NULL,
`web` varchar(50) default NULL,
`kp_navn` varchar(50) NOT NULL default '',
`kp_telefon` varchar(20) NOT NULL default '',
`kp_epost` varchar(50) default '',
`abbtype` varchar(10) NOT NULL default '0',
`tdato` date NOT NULL default '-00-00',
`kresp` enum('J','N') NOT NULL default 'N',
`passord` varchar(20) binary NOT NULL default '',
`sdato` datetime NOT NULL default '-00-00
00:00:00',
`sist_innlogget` datetime NOT NULL default
'-00-00 00:00:00',
`kandidat_brukernavn` varchar(30) default NULL,
`skifte_passord` enum('TRUE','FALSE') NOT NULL
default 'FALSE',
`po_spm` varchar(100) NOT NULL default '',
`po_svar` varchar(100) NOT NULL default '',
`visinfo` enum('TRUE','FALSE') NOT NULL default
'TRUE',
`regdato` datetime NOT NULL default '-00-00
00:00:00',
`selgernr` varchar(30) NOT NULL default '',
`status` varchar(30) NOT NULL default 'Aktiv',
PRIMARY KEY (`id`,`abonr`),
UNIQUE KEY `abonr` (`abonr`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `abonr_index` (`abonr`),
UNIQUE KEY `kandidat_brukernavn_index`
(`kandidat_brukernavn`(10)),
KEY `id_2` (`id`),
FULLTEXT KEY `navn` (`navn`),
FULLTEXT KEY `navn_2` (`navn`),
FULLTEXT KEY `navn_3` (`navn`)
) TYPE=MyISAM CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata';
When I try to exeucte it at my work office, everything
works fine?
Why the anomaly? Is my home MySQL configuration
missing something?
Even this query is returning me error -
CREATE TABLE `aboutvidelser` (
`id` int(11) unsigned NOT NULL auto_increment,
`abonr` varchar(20) character set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '-00-00
00:00:00',
`abotype` char(1) character set latin1 NOT NULL
default 'O',
`antall` smallint(5) unsigned NOT NULL default '0',
`selgerid` int(11) unsigned NOT NULL default '0',
`stat` enum('aktiv','slettet') character set latin1
NOT NULL default 'aktiv',
`slettetdato` datetime NOT NULL default '-00-00
00:00:00',
PRIMARY KEY (`id`),
KEY `abonr_index` (`abonr`),
KEY `selgerid_index` (`selgerid`)
) TYPE=MyISAM;
The error returned for the above case is -
You have an error in your SQL syntax near 'character
set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '' at line 4
Thanks in advance.
Karam
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Structure report
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 the tables > and table definitions for > a given database? I know about info / show, I'm > looking for something that > can take a database name and produce the entire > definition report. > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) > > iD8DBQE+1zbEjeziQOokQnARAkgEAJ4s83PuSpdIBMbloSHkyTzvzrWBMQCbBGiN > cwTOo+L/Kkdex0h7+ZJgvJU= > =/GF8 > -END PGP SIGNATURE- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting data in excel into a mysql table?
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' setup in mysql which > i have created with 8 > columns. > > I now need to get my data from excel into that > table. > > How would u do this?. > > I had a look in mysqlcc to see if there was an > import option but couldn't see one > > Advice v much appreciated > > thanks > Dan __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Creating a Table (wot no GUI?)
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 > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 28, 2003 6:45 AM > To: [EMAIL PROTECTED] > Subject: Creating a Table (wot no GUI?) > > > Excuse my naivety but how do I create a Table in > MySQL? > > I can't find any Text/Windows based programme that > allows be to create > and > edit the table, fields, data types, size etc? > I'm not looking for anything complex. > > Many thanks, > > Ed > > Edward Hasted > > Contact Information: > E-mail : [EMAIL PROTECTED] > Tel : +44 (0) 20 8780 0801 > Fax : +44 (0) 20 8780 0802 > Mobile : +44 (0) 7711 421180 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset=latin1 problem
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 SQL syntax near
'CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata'' at line 38
(113 ms taken)
The create table query is as follows
CREATE TABLE `abonnenter` (
`id` int(11) NOT NULL auto_increment,
`navn` varchar(100) NOT NULL default '',
`abonr` varchar(20) NOT NULL default '',
`adresse` varchar(50) NOT NULL default '0',
`post` varchar(50) NOT NULL default '0',
`telefon` varchar(20) default NULL,
`telefax` varchar(20) default NULL,
`epost` varchar(100) default NULL,
`web` varchar(50) default NULL,
`kp_navn` varchar(50) NOT NULL default '',
`kp_telefon` varchar(20) NOT NULL default '',
`kp_epost` varchar(50) default '',
`abbtype` varchar(10) NOT NULL default '0',
`tdato` date NOT NULL default '-00-00',
`kresp` enum('J','N') NOT NULL default 'N',
`passord` varchar(20) binary NOT NULL default '',
`sdato` datetime NOT NULL default '-00-00
00:00:00',
`sist_innlogget` datetime NOT NULL default
'-00-00 00:00:00',
`kandidat_brukernavn` varchar(30) default NULL,
`skifte_passord` enum('TRUE','FALSE') NOT NULL
default 'FALSE',
`po_spm` varchar(100) NOT NULL default '',
`po_svar` varchar(100) NOT NULL default '',
`visinfo` enum('TRUE','FALSE') NOT NULL default
'TRUE',
`regdato` datetime NOT NULL default '-00-00
00:00:00',
`selgernr` varchar(30) NOT NULL default '',
`status` varchar(30) NOT NULL default 'Aktiv',
PRIMARY KEY (`id`,`abonr`),
UNIQUE KEY `abonr` (`abonr`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `abonr_index` (`abonr`),
UNIQUE KEY `kandidat_brukernavn_index`
(`kandidat_brukernavn`(10)),
KEY `id_2` (`id`),
FULLTEXT KEY `navn` (`navn`),
FULLTEXT KEY `navn_2` (`navn`),
FULLTEXT KEY `navn_3` (`navn`)
) TYPE=MyISAM CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata';
When I try to exeucte it at my work office, everything
works fine?
Why the anomaly? Is my home MySQL configuration
missing something?
Even this query is returning me error -
CREATE TABLE `aboutvidelser` (
`id` int(11) unsigned NOT NULL auto_increment,
`abonr` varchar(20) character set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '-00-00
00:00:00',
`abotype` char(1) character set latin1 NOT NULL
default 'O',
`antall` smallint(5) unsigned NOT NULL default '0',
`selgerid` int(11) unsigned NOT NULL default '0',
`stat` enum('aktiv','slettet') character set latin1
NOT NULL default 'aktiv',
`slettetdato` datetime NOT NULL default '-00-00
00:00:00',
PRIMARY KEY (`id`),
KEY `abonr_index` (`abonr`),
KEY `selgerid_index` (`selgerid`)
) TYPE=MyISAM;
The error returned for the above case is -
You have an error in your SQL syntax near 'character
set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '' at line 4
Thanks in advance.
Karam
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Variables doesn't work?
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 on it, too. > > - > - Original Message - > From: ML > To: [EMAIL PROTECTED] > Sent: Tuesday, May 27, 2003 9:08 AM > Subject: Re: User Variables doesn't work? > > > You are right, I tried from command line and it > works, the problem occurs > with MySQL Front v2.5. This is strange because I > love this software and > this > is a strange bug... > > Regards. > > > > > I'm using User Variables, I tried it with the > query found in the mysql > > > manul: > > > SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; > > > But I receive this error: > > > You have an error in your SQL syntax. Check > the manual that > corresponds > to > > > your MySQL server version for the right syntax > to use near > > > '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 > > > I have MySQL v4.0.12 > > > > Worked perfect for me. Did you execute the above > query from command-line > client or what client did you use? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
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, I'm interested in! > > Thomas > > --- > _ > / __// __// ___/Thomas Hoelsken > <[EMAIL PROTECTED]> > / /_ / __// /_ / IT-Coordinator >/___//_/ // Operations Control FRA HE/I > > Condor Flugdienst GmbH Tel: +49-6107-939-8304 > Am Gruenen Weg 3 Fax: +49-6107-939-145 > 65451 KelsterbachSITA: FRAH2DE > GERMANY > > > -Original Message- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, May 27, 2003 7:14 PM > > To: Thomas Hoelsken > > Cc: [EMAIL PROTECTED] > > Subject: RE: How to fill an Blob with binary data > > > > > > Mascon can do it .. it's a win32 app.. > > > > On Tue, 27 May 2003, Thomas Hoelsken wrote: > > > > > Hi, > > > > > > isn't there any other solution instead of using > PHP just > > for filling > > > an Blob!? > > > > > > I don't need php and would prefer any other way! > > > > > > Thanks, > > > Thomas > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > > > Sent: Tuesday, May 27, 2003 6:56 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: Re: How to fill an Blob with binary > data > > > > > > > > > > > > > > > > Search the mailing list archives for this... > There is a > > link to this > > > > article: > > > > > > > http://www.php4.com/forums/viewtopic.php?t=6 > > > > > > > > > I wonder if the mailinglist search was powered > by google > > more people > > > would use it? > > > > > > On Tue, 27 May 2003, Thomas Hoelsken wrote: > > > > > > > Hi, > > > > > > > > I would like to fill an Blob with binary data > thru > > SQL-statements or > > > > any other MySQL tools and don't know how!? > > > > > > > > Are there suggestions? > > > > > > > > Thanks, > > > > Thomas Hoelsken > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: > http://lists.mysql.com/mysql > > > > To unsubscribe: > > http://lists.mysql.com/mysql?> > [EMAIL PROTECTED] > > > > > > > > > > > > -- > > > MySQL General > > Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL GUI
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 server running on > linux. > > I normally use a GUI tool to modify databases etc. > But now I need to create > them aswell. Can anyone recommend a free tool to do > this to run on Windows > and connection to a mySQL server running on linux. > > Thanks > Neil > > _ > Overloaded with spam? With MSN 8, you can filter it > out > http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Edit my database in Server
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 edit your > databases in your server (not in local). > Did someone uses MySQL Control Center I cant > configure it to works > in remote. > > PS My english sucks > > > __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: sql diff for mysql
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 <[EMAIL PROTECTED]> wrote: > Thanks for sqlfs, very interessant! > > know i use SQLyog > but this soft do not have a php client do deal with > sql server hosted > behind a web server. > and it do diff only on the structure, not on the > data. > > Tonu Samuel wrote: > > On Fri, 2003-03-14 at 17:19, Florent Martineau > wrote: > > > >>Hi, > >> > >>I'm searching for a mysql diff tool to update my > database when changing > >>structure and so. > >>Does anybody outthere knowing such a tool ? > > > > > > As much I know, there is no such tool exists. I am > doing myself some > > version control of SQL tables after their dumpout > with mysqldump. > > > > You might be also interested in my SQLFS project > on > > http://www.sqlfs.org. This must enable full > control of any database in > > future with common tools like cvs, grep, diff, sed > and so on. > > Currently it can do read-only access for demo > usage only. > > > >Tõnu > > > > > > > > -- > Florent MARTINEAU > SoftKeys sarl > +33 (0)6 89 49 20 01 > http://www.softkeys.fr > > > - > 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 > __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - 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: sql diff for mysql
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 Martineau <[EMAIL PROTECTED]> wrote: > Hi, > > I'm searching for a mysql diff tool to update my > database when changing > structure and so. > Does anybody outthere knowing such a tool ? > > Thanks > > - Florent > > > > - > 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 > __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com - 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: BUGs on MyODBC when trying MS DTS MSSQL 2000 to MYSQL 3.23.55
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 one data type. The > error happens when I have a "text" datatype on MSSQL > 2000 table, and > "text/blob" on MySQL table. > > > The error is "fail to insert or update the blob data > type". > > > > The table only has one attribute > MS SQL 2000-> MySQL > > > MS Table a1 MySQL Table a1 > text -> blob > (doesn't work) > > > MS Table b2 MySQL Table b2 > text -> text > (dosen't work) > > > MS Table c3 MySQL Table c3 > varchar (255) -> varchar (255) > (works) > > - > 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 > __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - 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: How to determine foreign keys? Meta data?
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 this a sort-of-newbie question. > > Is there any way to determine what foreign keys > exist on a table? I > have tried "myisamchk", "describe", "show index", > "show create table", > all to no avail. > > Is there complete access to the meta-data? > > (I'm using version 3.23.55, by the way.) > > > Thanks! :' ) > > = > :' ) > Jeff Epstein > [EMAIL PROTECTED] > http://www.jeffyjeffy.com > > > .. > > __ > Do you Yahoo!? > Yahoo! Shopping - Send Flowers for Valentine's Day > http://shopping.yahoo.com > > - > 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 > __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - 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: Is there a SQL/diff program out there?
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 - 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: Is there anything like Query Analyser for MySQl
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 databases? > > > Scott > > > > - > 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 > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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: simple windows client for 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 people. These would be > various engineers and > administrators using every version of windows from > 95 (japanese version) to > XP all using laptops connected to our internal > network. I am looking for an > easy to use, easy to install mysql client which > would enable users to query > my database. It seems that installing mysql server > for windows on each > machine would do this but it seems like using a > shovel to swat a fly. > Suggestions? Cheap is good too. > Thanks > Dave Driscoll > > - > 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 > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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: How to install MySQLCC on W98
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 problem > only of my windows 98 > or it is possible to use MySQLCC only on w2000 and > newer? > Is there any way how to install MySQL Control Center > without MSIEXEC? > Thanks Michal > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > > - > 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 > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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
InnoDB Foreign Key Questions
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 '-00-00', `amount` decimal(10,0) default '100', `name` varchar(50) default 'Karam', PRIMARY KEY (`id`,`vdate`) ) TYPE=InnoDB; Now I add a Foreign Key reference to ledger.id for voucher id by using the following command - alter table voucher add constraint fk_key_1 foreign key (id) references ledger (id) now when i do a query - show table status like 'voucher' I am getting the following value in the comment field. InnoDB free: 23552 kB; (id) REFER rohit/ledger(id) It shows that foreign key has been made but i had specified it to be fk_key_1. Even if I make the Foreign Key without the keyword constraint the same thing happens ? So, what is the purpose of CONSTRAINT keyword. How can I give a name to a relationship. Also after reading the MySQL and InnoDB docs I am not able to guess how to drop a FOREIGN KEY ? How can I do that ? I am using mysql-mx-nt 3.23.54 running as a service in WinXP. Any help will be appreciated. Thanks in advance. Karam sql, query ( filteraide ) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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
IGNORE LINES in LOAD LOCAL not working in FIXED LENGTH CSV FILE
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 lines ( ID, VARCH_VAL, RAW_VAL, LONG_VAL ) MySQL always seem to import from the first line itself and never ignores those 5 lines which is expected ? But when I import it from a tab separated file, LOAD LOCAL works fine and it ignores the 'n' lines which is specified in the query ? Am I missing something or MySQL does not ignores lines for a FIXED LENGTH CSV ? Thanks in advance. Karam SQL, QUERY __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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
IGNORE Line LOAD DATA LOCAL
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, user_name, user_email, user_ref_from, other_ref, want_notify, dateofdown ) Now the problem is what even value I give for IGNORE LINES, MySQL seems to import from the first line always ? Whereas if the CSV file is , delimited, the IGNORE LINES syntax seems to be working fine ? Is IGNORE LINES not valid for FIXED LENGTH format or I am missing something ? Thanks in advance karam __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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: Admin/Client GUI - Win32 and Linux
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. Can anyone guide me or share with me > about > good and free admin/client GUI? > > Thanks. > Janine. > > = > Janine > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > > - > 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 > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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
Am I Violating Any Rules ?
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. Affordable. Sign up now. http://mailplus.yahoo.com - 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
Connecting to MySQL thru SOCKS proxy
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 - 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
Back Table syntax
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 works in backing up table in the server or I can make a copy thru a client software like MyCC karam __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com - 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 : Help On SQLyog
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 queries, then I suppose SQLyog is a better option. Karam - Original Message - From: "Robert Tam" <[EMAIL PROTECTED]> To: "Kevin Tsay" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 11:57 PM Subject: Re: Help on SQLyog > Kevin, > > It sounds like you don't have your MySQL access setup correctly. I am also > a newbie to MySQL. I recently experienced the same problem with MyCC, which > is similar software to SQLyog. I have both, MyCC and SQLyog, installed and > currently comparing and contrasting to see which one I like to use. I used > Webmin (a graphical user tool which allows me to configured just about > anything in Linux) to configured my MySQL access. You basicall need to set > the user's permission to access MySQL from another host or all hosts (the > MySQL is set to localhost only). You may need to specify the port 3306 in > the /etc/my.cnf file as well. This did it for me. > > Good Luck! > > > - Original Message - > From: "Kevin Tsay" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, October 01, 2002 10:45 AM > Subject: Help on SQLyog > > > > Dear Listers: > > > > I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. > > When I start SQLyog and type in the > > > > mySQLHostAddress: 10.0.5.210 > > User Name: root > > Password: > > Port: 3306 > > > > Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to > > connect to > > this MySQL server. > > > > Do I need to setup or change anything on MySQL DB in order for this > > connection to > > go through ? > > > > Thanks > > > > --Kevin > > > > > > - > > 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 > __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com - 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
