People (friday_id, parent_id) values (1,1), (2,1);
DELETE FROM People;
Output: Query OK, 1 row affected
Shouldn't this be 2 rows affected?
MySQL version 5.1
--
Fayaz Yusuf Khan
Cloud developer and architect
Dexetra SS, Bangalore, India
fayaz.yusuf.khan_AT_gmail_DOT_com
fayaz_AT_dexetra_DO
miss OR which values do not return any tuple.
Perhaps this would be what you're looking for?
"SELECT fieldname,COUNT(*) FROM tablename WHERE fieldname IN
('aaa','bbb','ccc','ddd') GROUP BY fieldname;"
--
Fayaz Yusuf Khan
Cloud developer a
queries on our
DEV system running faster than LIVE simply because the LIVE
environment is getting hammered!
Can you post your my.cnf file?
On Mon, Mar 22, 2010 at 4:38 AM, Abdul Mohid Khan
<mailto:abdulmohid.k...@magnaquest.com>> wrote:
Hi Gavin,
Same setup i am usin
) and one update (InnoDB).
Thanks in Advance
On 3/19/2010 11:14 PM, Gavin Towey wrote:
What changed between your test that took 5ms and the current production system?
-Original Message-
From: Abdul Mohid Khan [mailto:abdulmohid.k...@magnaquest.com]
Sent: Friday, March 19, 2010 12:27
ne |
x86_64 |
| version_compile_os |
redhat-linux-gnu |
| wait_timeout| 28800
Thanks in Advance
Abdul Mohid Khan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
I am stuck in a very stupid problem and I have tried quite a few things but
it just doesnt work. The problem in short is that one of my queries is
taking TOO LONG in the 'sending state' and for no reason since there are
much more complex queries which don't take more than couple of secs.
Basic
Hello all
Does MySQL 5 conform to Codd's rule 8, i.e. physical data independence,
which says that:
*Applications should not be logicaly impaired when the physical storage or
access ethods change.*
Any help would be greatly appreciated.
Thanks
Yes, I did and what happens is that the 'xxx' becomes appended to the
next line and the line after that asks the user for the password
(which also fails).
The way I got it working was this:
mysql -u root -p
Kindest regards,
Unnsse
On Feb 25, 2008, at 8:34 AM, fire9 wrote:
Unn
Hello there,
I am running OS X Leopard on an Intel based iMac machine...
Followed the instructions to a T and everything works as described in:
http://hivelogic.com/articles/installing-mysql-on-mac-os-x/
Now, after running MySQL using launchd, when I try to login using:
mysql -u root
I get t
Hello there,
I am running OS X Leopard on an Intel based iMac machine...
Followed the instructions to a T and everything works as described in:
http://hivelogic.com/articles/installing-mysql-on-mac-os-x/
Now, after running MySQL using launchd, when I try to login using:
mysql -u root
I get t
back and it seems to work just fine. It uses
launchd rather than the old /Library/StartupItems folder
http://blog.tomatocheese.com/archives/2007/11/1/migrating_mysql_to_mac_os_x_leopard/
Regards,
Grant Limberg
[EMAIL PROTECTED]
On Feb 11, 2008, at 6:34 PM, Unnsse Khan wrote:
Hello there
Hello there,
I am having problems running MySQL 5 on OS X Leopard...
Nothing happens when I try to start MySQL in System Preferences.
From the command line, this is the error I receive (when trying to
start MySQL):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/t
ECTED]> wrote:
perhaps you might share with us what error you are getting and what
version of MyQSL you are using? The more context you can suply, the
better.
On 5/7/07, Shahbaz Khan <[EMAIL PROTECTED]> wrote:
> This portion of the script gives error.
>
> reate table lxr_release
This portion of the script gives error.
reate table lxr_releases
(fileid int not null references lxr_files,
release char(255) binary not null,
primary key (fileid,release)
The script is present as attachment if needed. I suspect this script
is for mysql 4
rt_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
<----- End of excerpt ->
From: "Ubaidul K
Hello,
We are running MySQL 4.0.13 on Solaris 8 UltrSPARC with 2048 MB of RAM.
This machine has plenty of swap space and has worked fine for over a year
now. Out of the blue, it stopped working yesterday and after looking
through the error logs, following is what I found:
<
Can some one please tell me what I am doing wrong here I have installed
and configured users in the database. I am using ODBC driver to logon.
When I use the password, it does not work but surprisingly the logon is
allowed without a password. I have tried to use MySQL Administrator to
logon r
I have installed mySQL with admin ID and password. However when I login
using the mysql Administrator, it allows logons without a password. How do
I force it to get the password and authentic rather allowing only user id?
Thaks
all failed with the same message and in every
case there was no log file in mysql/data directory.
Please check. If you need further information
please let me know.
Thanks.
Helal Khan
Sr. Manager, SDC
Two Metrotech, 8th Floor
Brooklyn, NY 11201
Tel: 212.383.4000
Fax:212.383.4325
E-mail: [EMAIL
see handheld Windows CE on the list of supported
platform by mySQL, and I am almost confused.
Khan Ming
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I have two date fields (1095689105) in mysql. One is Creation date and
other is Modify date. If news is not modified its value is 0. How can I
sort my news so modify date is more important (if exists) than creation
date?
TNX
--
MySQL General Mailing List
For list archives: http://lists.
Is there any way to restrict UPDATE without a WHERE clause?
Mohammad Khan
Software Engineer
Legal Computer Solutions, Inc.
107 Union Wharf
Boston, MA 02109
http://www.lextranet.com
(617) 227-4469 x 212
Hi,
I'm using solaris 8 with mysql v 3.23.54.
I want to enable a solaris user - 'user1', to use the mysqlimport command
without using a password.
I've run, as root, the following sql command:
mysql>grant all on db1.* to user1@localhost
-this appears to work fine.
However as user1 in the solari
Hi,
I'm working on SOlaris 8 with MySQL v3.23.54.
I'm trying to give a user 'user1' access to one of my databases 'db1', and
specifically one table 'table1'.
As root I've run:
msql> grant all on db1 to user1@localhost
-and it appears to work fine.
However when as the solaris user 'user1', I ru
3307:
> $host="192.168.10.1:3307";
> $username="abcdefg";
> $database="database";
> $password="123456789";
Best regards
Daniel Khan
-
Before posting, please check:
http://www.m
to tune my setup?
Please CC to me as I don't know if ezmlm allready added me to this list.
Thanks in advance
Daniel Khan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Hi,
As I understand it an ANSI92 join is written as;
SELECT b.columnA
FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id
Whereas the 'old' style would be;
SELECT b.columnA
FROM tableB AS b, tableC AS c
WHERE b.id = c.id
Personally I find the former much easier to read though not sure about
t
the .cnf file and then restart the server. But I
> > dont' want to do this because this requires a slave shutdown...so is there
> > a way I can solve this problem?
> >
> >
> > Regards.
> >
> > --Azhar Khan
> >
> >
>
>
Mysql problem
Regards.
--Azhar Khan
On Fri, 10 May 2002 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> s
ld be specified
I can't open the mysqld file to add the pathtodatafile
Where am I suppose to set the variables at the startup(of mysql)
Does someone have step by step process in mind that I can follow. Help
would be extremely helpful.
Regards.
--
Thank you all for your suggestions. I used the /tmp directory on my ISP
which has permissions to all and it work.
Thanks,
Sharaaz
- Original Message -
From: "Sharaaz Khan" <[EMAIL PROTECTED]>
To: "Carsten H. Pedersen" <[EMAIL PROTECTED]>;
<[EMAIL PR
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: "Sharaaz Khan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 1:52 PM
Subject: RE: LOAD_FILE does not work
> > I have been trying to
updated at
all:
UPDATE Software SET Description =
LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file)
WHERE ID = 9
I have used single and double quotes around the file name without success.
In the mySQL documentation, it says that I need FILE privileges. I asked my
ISP to give me
advice.
Thanks for all the help.
Khan
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
-
Before posting, please check:
http
Hi there,
I am having problem finding "MySQL Client software" to connect to Web Hosts
server so i can create tables and run queries at their server remotely. I am
running windows so any related softwares would be great help.
Please reply soon as i need to proceed on project and really need
afore
Dear Sir,
I'm new to mysql. So please forgive me if I may sound so stupid.
I did install mysql database. I also downloded you
Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6
After I unziped what should I do? How can this to work?
My database is running on Sun Solaris 2.8. Your help is al
DuBois.
Read it, learn it, live it.
-Original Message-
From: Mohammad H. Khan [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 1:42 PM
To: [EMAIL PROTECTED]
Subject: Create Table with password
Hi All..
I created a table ..
create table A (
A1 int(4) auto_increment,
A2 varchar(16),
prim
password option work on a table...
Anybody .. Drop few lines... Please
--
Mohammad H. Khan
Web Architect
Legal Computer Solutions, Inc
Boston, MA 02109
-
Before posting, please check:
http://www.mysql.com/manual.php
server version 3.23.35
> -Original Message-
> From: Khan, Jawad [COLE:6S34:EXCH]
> Sent: Thursday, June 28, 2001 1:13 PM
> To: '[EMAIL PROTECTED]'
> Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete
> as shown
>
> Ho
Hope you can find the problem in the following SQL command:
delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;
raiseTime is of type BIGINT.
ailed: No such file or directory
010511 11:27:05 mysqld ended
> Regards
> Khuram Khan
>
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
on linux what user do u instal mysql with ? root or a normal user ?
> Regards
> Khuram Khan
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
i typed this when installing binary version of mysql .. chown -R
mysql /usr/local/mysql/var
i get error message ---> no such file or directory ! whats wrong ?
> Regards
> Khuram Khan
>
>
>
-
Befo
hello
RE: Linux (Intel libc6 systems) [pc-linux-gnu-i686]
downloaded the above file. nad am trying to get it going ! i have read the
readme files but not much help there !
uncompressed it and untarred the sql ! what is it i do next ! please if it
is not
too much help how do i get it goin
it seems to be working after i type safe_mysqld --log
but i get this message when i try to run mysql , i try creating a database
using mysqladmin but the same socket thing comes into it !
my error message
mysql admin connection to localhost failed
error can't connect to local mysql server th
you can help !
> Regards
> Khuram Khan
>
-
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 <[EMA
sorry for this message i find out the location :)) (its in the signature of
every message )
thanks anyway,
-Original Message-
From: Khan, Moin [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 10:54 AM
To: 'MySQL-list'
Subject: Mysql List Web Archive ?
Please tell
Please tell me the web archive of this mailing list , so i not bother you
for some already answered questions.
Thanks,
Moin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
try to use gtar from www.mysql.com
there is some known problem in solaris tar file...
-Original Message-
From: Shahid Iqbal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 3:04 PM
To: [EMAIL PROTECTED]
Subject: error in unzip
I have Solaris 2.6 on a SUN E450
I downloaded the
information on net.
Thanks,
Moin
-Original Message-
From: Jonothan Farr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 3:09 PM
To: Khan, Moin; [EMAIL PROTECTED]
Subject: Re: SQL Documentation
Here's an online SQL tutorial you may find helpful.
http://www.sqlcourse.com/
--
Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 1:50 PM
To: Khan, Moin; [EMAIL PROTECTED]
Subject: RE: SQL Documentation
http://www.mysql.com/documentation/index.html
Cal
http://www.calevans.com
-Original Message-
From: Khan, Moin [mailto:[EMAIL PROTECTED]]
Sent
Hi,
I am new on this list, and also new on mysql, i know little much abt
database and SQL as i learn in my graduate course, is there any online
documentation available for SQL or Database, so i referesh my knowledge and
create database on mysql. I already installed mysql server on Solaris 8(x86)
Is there way to change the installation layout (of directories) of
mysql3.23.33. I am compiling mysql3.23.33 on Solaris on a ultr10.
Which file is it that controls the layout? Thanks
Ubaidul Khan
Senior System Administrator
Library System and
Say I have a bunch of records in a table with a bunch of fields. One of
those fields is cluster_id. It is not unique. However, I want to make a
unique set. I want one record for each cluster_id value. I don't care
which record that is.
Right now, I do:
SELECT DISTINCT cluster_id FROM my_table
Th
54 matches
Mail list logo
