Re: MySQL Connector/ODBC 5.2.6 has been released

no binaries for AIX? -- saqib http://hivemined.net On Wed, Oct 9, 2013 at 3:02 PM, Kent Boortz kent.boo...@oracle.com wrote: Dear MySQL users, MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the MySQL database management system, has been released. The available

Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX

Is it possible to MySQL Community Edition (as target) from Informatica Powercenter 9.5.1 running on AIX? If so, what is ODBC driver should we use?

Percent of match in condition

my_table where sex_id = 1 or country_id = 120 or education_id I mean if in my table there are some records with sex_id = 1 or country_id = 120  then I got 2 (2 match) then I can say 66% percent match. Thank you, ali -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

using a subquery/self-join to recursively retrieve a tree

Hello, I have following simplistic DB representing a hierarchy: ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | uid| int(10) | NO | PRI | 0 | | |

Re: case when then

I tried something like this but it doesnt work. Thank you.. SELECT table_1.id FROM table_1 CASE WHEN (table_1.pid 0) THEN LEFT JOIN table_2 ON table_1.pid = table_2.id WHEN (table_1.nid 0) THEN LEFT JOIN table_3 ON table_1.nid = table_3.id END 2009/2/24 Ali Deniz EREN ali.deniz.e

case when then

to table_1. As a result, it must be as below. id title body 6 title6 body_text6 5 ntitle5 nbody_text5 What would be the query? Thanks for your help. -- Ali Deniz EREN ali.deniz.e...@gmail.com

Re: How to create a unicode capable table??

Hello, Any thoughts on this? Thanks. On Tue, Nov 25, 2008 at 8:14 PM, Ali, Saqib [EMAIL PROTECTED] wrote: What Charset and Collation should I use while creating a mysql table such that it can take data from unicode SQL Server DB table? Thanks saqib http://doctrina.wordpress.com

How to create a unicode capable table??

What Charset and Collation should I use while creating a mysql table such that it can take data from unicode SQL Server DB table? Thanks saqib http://doctrina.wordpress.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Importing MS SQL exported CSV files adds spaces

I exported a large data set from from Microsoft SQL server in CSV format. However whenever I try to import that data to a a mySQL server running on Linux, it adds a space between each character in each field. Essentially: Saqib Ali becomes S a q i b A l i I have tried to use the dos2unix cmd

Re: Importing MS SQL exported CSV files adds spaces

try OPTIONALLY ENCLOSED BY ' ' already tried that. no help :( saqib http://doctrina.wordpress.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

WHERE .... IN

this. LIKE doesn't work because SELECT id, title, field1 FROM mesaj WHERE field1 LIKE 12 returns many result which is not my intention. Thank you. -- Ali Deniz EREN [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Please help to solve a serios problem

to solve this problem? We need to solve this problem urgently. Thanks in advanced! Regards, Ali Nebi! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Please help to solve a serios problem

Message- From: Ali Nebi [EMAIL PROTECTED] Sent: Nov 6, 2007 9:24 AM To: mysql@lists.mysql.com Subject: Please help to solve a serios problem Hi, i need of help for a serios problem. We have installed mysql 5 and we are using InnoDB engine. OS is CentOS 5, x86. Our problem is this. We

Re: Please help to solve a serios problem

- Original Message - From: Russell E Glaue [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November 06, 2007 8:55 PM Subject: Re: Please help to solve a serios problem The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used by your

Re: Mysql and filesystems question

Thanks for the answer :) Yes, you are right about fedora. I forgot to tell that we are moving the servers to CentOS 5 now :) i think also that other important thing that i forgot to tell is that our databases use INNODB engine. i'm waiting for other opinions. -- MySQL General Mailing List

Mysql and filesystems question

in advanced. Regards, Ali Nebi! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What to do if a table is supposed to get 3GB data per day?

wow 30GB is a lot of data. Do let us know what kind of hardware / OS you are using. In the past I have worked with larger tables then these, but I was using Objectivity DB running on UltraSPARC 64bit architecture. -- Saqib Ali, CISSP, ISSAP http://www.full-disk-encryption.net -- MySQL General

Re: What is your favorite GUI tool for creating and querying tables in MySQL?

sqlyog is pretty nice: http://www.webyog.com/ saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What is your favorite GUI tool for creating and querying tables in MySQL?

and also http://fabforce.net/dbdesigner4/ sorry for 2 seperate emails. saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Retaining last primary key value

://lists.mysql.com/[EMAIL PROTECTED] -- Saqib Ali, CISSP, ISSAP http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OT: LAMP appliance for non-profit use

Hello All, I know this is little bit off-topic but I think users of this group can give good advice on this topic. We have a in-house built application using MySQL + PHP + Apache. It is essentially a elaborate collection of online forms that will be used for managing school scholarship in the

mysql++ problem(undefined symbol to)

hello. i want to connect to mysql from c++ . i examine any version or platform. i use mysql5 and 4 in suse10 with gcc.then examine mingw and mysql5 and 4 and 3 for severeal times but i can't solve this problem.when i want to compile examples of mysql++ following error appeared:

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

- Adelaide) [EMAIL PROTECTED] wrote: Hi Ali, I'll repeat what I've already said, it is the ld command that is having the problem. If you don't know what the ld command is or does, you need to look elsewhere for the answer as this is beyond the scope of this list. As I have previously mentioned, try

undefined reference to `mysqlpp::Connection::Connection(bool)'

Hi, I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i want to connect to MySQL through C. When I am compiling the program, I am getting the following error. #gcc -o custom1 -lmysqlclient -lz custom1.cpp

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

Hi.thanks logan. I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i trying too many pathes in gcc cammand but that error continued. I am getting the following error. # gcc -o custom1 -lmysqlclient -L

undefined reference to 'mysql_init'

Hi, I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i want to connect to MySQL through C. When I am compiling the program, I am getting the following error. *** gcc -o test test.c

gcc -o test -L/usr/lib/mysql -lmysqlclient test.c

hi to all. thanks luiz and mike for response. my code is compiled when i use -lmysqlclient option and executable file is now exist but when i try to execute this file it prompts segmentation error .what's the meaning of it and what i have to do? The code is as fillows:

Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c

hi to all. thanks luiz and mike for response. my code is compiled when i use -lmysqlclient option and executable file is now exist but when i try to execute this file it prompts Segmentation fault .what's the meaning of it and what i have to do? ## gcc -o test -L/usr/lib/mysql

text datatype

hi i am creating web newsprogram by php and mysql. how to i can use text data type for saving contents of articles in database? when i use text format,contents save in the tables unless eny new line. howto i can insert \n element in text format? -

STOPPING server from pid file

hi to all i have mysql5.1 installed on fedoracore3 it was worked sucsessfully since yesterday. but when i run mysql_safe script today, it prompt following error: STOPPING server from pid file /usr/local/mysql/var/localhost.localdomain.pid

Re: trouble with deleting a user

Note: forwarded message attached. Yahoo! FareChase - Search multiple travel sites in one click. ---BeginMessage--- Michael Stassen [EMAIL PROTECTED] wrote: ali asghar torabi parizy wrote: hi to all i have a problem when i trying to delet a user by drop user directive

trouble with deleting a user

hi to all i have a problem when i trying to delet a user by drop user directive *** drop user atp; Can't drop one or more of the requested users *** i add this user by crant: *** GRANT ALL PRIVILEGES ON *.* TO

how to installing mysql5 on fc3?

hi all i want to install mysql5 on fc3 but i cant when i trying to implement it by rpm. i remove mysql3 with rpm -e directive. who cabn help me?:( thanks rpm -ivh MySQL-server-5.0.15-0.i386.rpm error: MySQL-server-5.0.15-0.i386.rpm: V3 DSA signature:

which release of Mysql is compatible with fedora core3 ?

i have fedora core3 installed on my system. which release of Mysql is compatible with fedora core3 ? - Yahoo! FareChase - Search multiple travel sites in one click.

Fwd: which release of Mysql is compatible with fedora core3 ?

Note: forwarded message attached. Yahoo! FareChase - Search multiple travel sites in one click. ---BeginMessage--- i have fedora core3 installed on my system. which release of Mysql is compatible with fedora core3 ? Yahoo! FareChase - Search multiple travel sites in one click.

Best practices for deleting and restoring records - moving vs flagging

. However if we just flag the record as deleted the restoring is quite easy. Any thoughts/ideas ? -- In Peace, Saqib Ali http://www.xml-dev.com/blog/ Consensus is good, but informed dictatorship is better. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

User connection history?

Hi, Is there a way to determine when was the last time a MySQL user attempted to connect to the MySQL Database? -- Thanks Regards, Dilshad Ali -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How-to copy a column

Does anyone know the easiest way to copy a column in mysql? I have a table (table1) which has 4 columns, I want to copy all the contents of col1 into col2. Col3 is the primary unique key, so the copy has to keep the data matched with col3. I guess one possible way is to do a select and output

Fwd: Undelivered Mail Returned to Sender

- Weitergeleitete Nachricht von Mail Delivery System [EMAIL PROTECTED] - Datum: Tue, 18 Jan 2005 08:09:14 +0100 (CET) Von: Mail Delivery System [EMAIL PROTECTED] Antwort an: Mail Delivery System [EMAIL PROTECTED] Betreff: Undelivered Mail Returned to Sender An: [EMAIL

Re: Query Speed in Terminal vs. PHP

Is index defined on all of your tables? Saqib Ali - http://validate.sf.net (X)HTML / DocBook Validator and Transformer On Tue, 2 Mar 2004, Chris Fowler wrote: I have a query that is admittedly inefficient in that it is doing multiple OR clauses and joining multiple tables

MySQL and Perl DBI Persistent Connection

Hello, I have a Perl CGI script which uses DBI to access MySQL. I noticed that each query through the Perl CGI script using DBI has a connect, query and then quit. I was wondering if there is a way of keeping the connection persistent to Mysql through the Perl CGI script. In my Apache httpd.conf

How to move data between tables in a database?

Hello, I would like to move data between tables in mysql within the same database, I am not sure what the best way to go about it is. I do not need to move all the data in the tables, just the output of some select statements. I am using Perl DBI and MySql 4.0.15-standard on RedHat 8.0. I guess

Re: Database-design

you need to normalize your database structure, and create an ER diagram based on that. On Tue, 11 Nov 2003, Meli Meli wrote: I have a table with following structure: Id first quarter second quarter third quarter last quarter year month week day On an entry not all fields of the

Re: Lost Password

you can always reset the mysql root passwd http://www.mysql.com/doc/en/Resetting_permissions.html Saqib Ali - http://validate.sf.net --- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, Carol Andrejak wrote: Hello Listers, I have a problem in that I cannot find my user id

Re: phpmyadmin screw up

seems like you set the mysql root passwd which is the right thing to do. now should connect as follows: # /usr/local/mysql/bin/mysql -u root -p Saqib Ali - http://validate.sf.net --- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, joffrey leevy wrote: Hi all: I was trying to use

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

a question... is any DB that complies to the Relational Algebra a Relational DB??? Saqib Ali - http://validate.sourceforge.net --- XHTML/HTML/DocBook Validator On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote: I tend to agree with the past two posts that mysql is in fact relational

RE: Is MySQL Relational? (was: Foreigner keys in MySQL?)

so funtions that can be performed by relation algebra are a subset of the functions performed by a relational database? however isn't it required for a relational database to perform all the functions of relation algebra? Saqib Ali - http://validate.sourceforge.net --- XHTML/HTML

Representing time sheet data in Mysql

Hello, I am trying to store our timesheet data in the Mysql database. I would appreciate suggestions on the database scheme to use. One of the possible ways to do it is to have a table indexed with the employee ID and then having as many columns as there are days in the year. This approach

corrupted passwd

-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! Any ideas? Saqib Ali - http://www.xml-dev.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Representing time sheet data in Mysql

So if you needed to know status of a work day for an employee day (say 9/1/2003), how did you go about looking it up in your table? Assuming that a employee can be present (p), on vacation (v), sick day (s)? Your table seems to store only the number of hours worked Thank you, Syed Ali (609

optimizing left join query

to make this query go faster. In Peace, Saqib Ali I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection) Al-Quran 6:15 http://docbook.sc-icc.org - Before posting, please check: http

Re: optimizing left join query

Diana, Thanks for the suggestion. I completely forgot to add the index/primary key. Now it works just fine :) Thanks again. In Peace, Saqib Ali I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection) Al-Quran 6:15 http://docbook.sc-icc.org

mysql 4.0.8 on solaris 8 problem

i have installed mysql4(binary version) on solaris but i get this error when i try to run it: ld.so.1:bin/mysqld : fatal : libCstd.so.1 : open failed : No such file or Directory what could be wrong? - Before posting, please

unicode encoding

hi all i want to know does mysql support unicode encoding ? if yes ( i wish ) how can i set this ? are this support automatic or i must do something ? thax in advance ali http://www.freewebz.com/alphautils - Before posting

MySQL for the Enterprise

Hello Everyone I have been using MySQL on Linux for over two years and am a devoted fan. I have been using MySQL for very ordinary applications till now. Now there may be a requirement that we need to build an enterprise application running on MySQL. The application must be very reliable, very

Re: problem on Load Data!

Hi Jack, For question1, I think you need to use insert with set: insert into table ABC set column3 = , column4 = , column5 = ; I think that should do it. Have you managed to find an answer to question2? Please let me know. Ali From: Jack [EMAIL PROTECTED] To: [EMAIL

Pubs2/Pubs3 database

please. Thanks. Ali _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com

Not able to compile mysql-test

-recursive] Error 1 make[1]: Leaving directory `/download/mysql-3.23.43' make: *** [all-recursive-am] Error 2 Any help would be highly appreciated. Thanks Saqib Ali - Before posting, please check: http://www.mysql.com/manual.php

Re: how include library correctly in a visual c++ 6 project

file text box (don't sperate files by ;). Also put the path for additional lib i.e c:\mysql\lib\debug. I've tried this it works... But I want to use Borland C++.do you or any one else can reply to my previous mail Regards, Ali --- thomas WOLFF [EMAIL PROTECTED] wrote: one question

BCC32 problem.................

to avoid unreferrenced symbol error at link time. Could any one pass me through this stage..My mind is now almost dead on this issue..Please help me out! Ali - Before posting, please

lcc-win32 couldn't compile..........

the same code is compiled linked using MS-VC++, it runs...Could anybody guide me how to tune lcc-win32 or any other C IDE..I don't want to use MS-VC++... Ali __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com

C IDE for Windows...........?

MySQL headers, it throws errors...which I guess is the problem of long header file names (not complaint with DOS 8.3 file name convention). I'm in search of an IDE that can support MySQL and that should not be much different from the one I'm used to. Could anybody help me out Cheers.. Ali

rearranging id's

Hello, is there an easy way of rearranging id's in a table after deleting one or more entry/entries (other than creating a new tbl and dropping the old one). I appreciate any hint. Thank you. --- Ali Reza Sajedi http://www.bupnet.de/info/mitarbeiter.php3?id

Re: Database size limit

Ravikumar Sarma Chengalvala wrote: No need to worry.On NT each table can have upto4GB.Database there is predefined limit.It can go even upro 20GB or more also. --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Hi, I'm new in this list and new to MySQL also. What I want to know

Database size limit

Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - Before posting, please

Mysql SELECT command

Can somebody please point me to the good resourse of learning mysql's SELECT command on the Internet? Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Connection problem...

I cannot seem to connect to a remote mySQL server located at my ISP. I basically downloaded mysqlgui-win32-static-1.7.4-2.zip and installed. filled in the server information. database name and username then tried to connect. WHen I try to connect it tells me Access denied for user:

Auto Increment

Dear All I am inputting data into a MySQL database where i have set the primary key as the ID and it is auto-incrementing. I make sure that my input file contains a null or 0 value where it should be auto- incrementing. While entering data using LOAD command, my input file had an error with

master and slave source code

help will be really appreciated. Thanks Ali, Mohammed Systems Administrator iWon.com One Bridge Street, Suite #42 Irvington, NY 10533 (914) 591-2000 - Before posting, please check: http://www.mysql.com/manual.php (the manual

MySQL data structure

Hello. I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by O'Reilly states that for a table named book under a database Test following is the structure: book.ISM book.ISD and book. frm On my system MySQL 3.23.27 beta the structure is different. book.MYI

for configure

00%-- col 1 please help me !! Ali. Mar 19,2001 __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please

Locked Out

I have been using MySQL for sometime now. However, i had been experimenting with MySQL priviliges and have locked myself out. I cannot access the database to perform any function. I cannot issue any command like mysqladmin ping or mysqlshow. Somehow the command mysqlaccess doesnt execute

CREATE TABLE

Hello, does anybody know why the following statement does not work when it contains "IF NOT EXISTS" CREATE TABLE IF NOT EXISTS tab_name. This is given in the manual but it does not work in this case. Any hint is appreci