On 19.04.2013 06:49, Kapil Karekar wrote:
Though I would recommend not using such names. Some poor guy working
on your application six months down the line is going to wonder why
his queries are failing, spend a day trying to figure out and will
post the same question again to this list :-)
.
Hello,
why these db names created fail but the last one gets success?
mysql> create database 3208e1c6aa32;
ERROR 1064 (42000): 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 '3208e1c6aa32' at line 1
mysql> cre
On 2013-04-19, Doug wrote:
>
> why these db names created fail but the last one gets success?
[snips]
> mysql> create database 3208e1c6aa32;
> mysql> create database 208e1c6aa32;
> mysql> create database 08e1c6aa32;
> mysql> create database 8e1c6aa32;
> mysql> create database e1c6aa32;
https://
On 19-Apr-2013, at 9:14 AM, Doug wrote:
> why these db names created fail but the last one gets success?
>
> mysql> create database 3208e1c6aa32;
> mysql> create database 208e1c6aa32;
> mysql> create database 08e1c6aa32;
> mysql> create database 8e1c6aa32;
These are not working because MySQL is
But connect-timeout has nothing to do with termination of query. It is no.
of secs that mysqld server waits for a connect packet before responding
with Bad handshake, default value is 10 seconds.
Probably you should adjust net_read /write_ timeout.
But connect-timeout has nothing to do with termination of query. It is no.
of secs that mysqld server waits for a connect packet before responding
with Bad handshake, default value is 10 seconds.
Probably you should adjust net_read /write_ timeout.
Also check for any firewall or NAT
On Sep 5, 2012 5:17 PM, "indrani gorti" wrote:
> Hi all,
> I am a newbie to work with the settings in mysql although I have used in
> very small applications before
> I am currently experimenting with very large tables and a few complicated
> queries. I am usin
- Original Message -
> From: "indrani gorti"
>
> Later I changed it to SET GLOBAL connect_timeout=60;
> However, I still find that the query loses the connection to mysql
> server after about 10 mins( 600.495 secs)
> I see that the connect_time is 60 though.
If I recall correctly, all t
Hi all,
I am a newbie to work with the settings in mysql although I have used in
very small applications before
I am currently experimenting with very large tables and a few complicated
queries. I am using mysql 5.5. My tables are of size of abt 1 million
tuples. The queries upon these tables ta
What about sub selects. As I see it you only care about the highest
and lowest order of results in each list.
Sorry, in am on a mobile so I can nit make a test case, and this will
be pseudo SQL.
Select * from table where start <= (select foo) and ( select foo) ...
Also look at the "between
abhishek@gmail.com (Abhishek Pratap) writes:
> I am kind of stuck with this query , cant expand my thinking. May this is a
> limitation. Here it is
>
> I have a database with many cols two of which are start and end position for
> an event.
>
> Now I have a list of event time stamps, I wan
then either build the statement by way of a program like a perl script or
select all records with a start time after the min start time of all in your
list and an end time less than the max end time in your list then filter
them further either in a program or a store procedure.
On Fri, May 8, 2009
Abhi,
I might not be understanding the problem but could you use the max
and min timestamp values and use something like
SELECT * FROM TABLE WHERE start BETWEEN max AND min AND end BETWEEN max AND min
or
SELECT * FROM TABLE WHERE START IN (1,2,3,4,5) AND END IN(1,2,3,4,5)
I might be complet
Hi Jim
Unfortunately I have thousands of such points. So explicit statement calling
will be very expensive both computationally and in terms of writing..
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:37 PM, Jim Lyons wrote:
> why not something like below. Assume you have 3 pairs of start/end
> time
why not something like below. Assume you have 3 pairs of start/end
timestamps and you want to find everything within those 3 time periods:
select * from table_name where start >= start1 and end <= end1
union
select * from table_name where start >= start2 and end <= end2
union
select * from table_
aah okie I think I was trying to get too clever. Guess that won't work ...
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:34 PM, Barney Boisvert wrote:
> You'll have to iterate over your two lists of timestamps and build a
> set of ORed conditional pairs:
>
> sql = "select ... from ... where 1 = 0"
> f
Hi All
I am kind of stuck with this query , cant expand my thinking. May this is a
limitation. Here it is
I have a database with many cols two of which are start and end position for
an event.
Now I have a list of event time stamps, I want to find all the info once the
current event time stamp
> Date: Mon, 20 Apr 2009 13:03:14 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi Alugo,
>
> abdulazeez alugo wrote:
> >
> > Hi Andy,
> > Thank you ver
Hi Alugo,
abdulazeez alugo wrote:
Hi Andy,
Thank you very much you have been really very helpful. All those
mistakes you pointed at in the script about the apostrophe and others,
are simple mistakes I just made in the rush of typing the message; and
yes $conn is the result from mysql_connect
> Date: Mon, 20 Apr 2009 08:06:05 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi,
>
> abdulazeez alugo wrote:
> >
> >> Date: Sun, 19 Apr 2009 23:19:56
Hi,
abdulazeez alugo wrote:
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an
> Date: Sun, 19 Apr 2009 23:19:56 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi Alugo,
> > Hi Andy,
> >
> > Thanks for your prompt response. However, s
Hi Abdul-
you may want to check this thread out regarding the same issue...
http://www.webmasterworld.com/php/3565843.htm
On Apr 19, 2009, at 3:23 PM, abdulazeez alugo wrote:
Hi guys,
I'm having a really terrible problem with my mysql coding and I'ld
appreciate any help I can get on this
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically.
Ah, I see your point. I'm guessing by your code you're using PHP? If
so call mysql_insert_id() after you've inser
> Date: Sun, 19 Apr 2009 22:50:20 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi,
> > Now I have successfully created a relationship between the two tables but
>
Hi,
Now I have successfully created a relationship between the two tables but how
do I make sure the value of tbl1_id in tbl1 is equal to the value of tbl1_id in
tbl2???
MySQL handles this for you. Simply INSERT the value into tbl1, then
INSERT the value of tbl1_id in tbl2. Then try INS
Hi guys,
I'm having a really terrible problem with my mysql coding and I'ld appreciate
any help I can get on this cause it's really driving me crazy.
I have two tables and I've succeeded in creating a one to many relationship
between both table but the problem I'm having is that I dont know ho
Hi,
I need some urgent for sql query.. It will be great if someone could help
me..
I have ARTICLE, FAVORITE_ARTICLES, RATING Tables apart from other table
USER, CHANNEL, CATEGORY etc
ARTICLE table stores a user's article, FAVORITE_ARTICLES will store a user's
favorite articles, and rating table
Login to mysql
Perform this on the table
ALTER TABLE tbl-name MODIFY COLUMN Rating varchar(10);
Then recreate the ODBC link in OpenOffice
Give it a try.
Colleen Beamer <[EMAIL PROTECTED]> wrote:
Hi,
I apologize for posting here, because I only use MySQL at a very basic
level
Hi,
I apologize for posting here, because I only use MySQL at a very basic
level - I wanted to create an Access-like database and found that I
could use Open Office with an ODBC connection to a MySQL database to do
what I wanted.
Up to this point all has been fine. However, I just upgraded to My
Question.
I have two tables donation_test, and max_donation. The
max donation table is a summary table, used to keep
the max donation for each contact_id, by listing its
donation_id. We have decided to use database level
triggers to keep the summary table (max_donation)
table up to date. I have bee
lists.mysql.com
Subject: Newbie help with MySQL
Hello there,
I am running MySQL 5 Community Edition on Mac OS X Tiger
Here's what I did:
1. Ran the MySQL server from System Preferences
2. Launched Terminal and typed in the following:
untz$ mysql -u root -p
3. Was prompted for my
Hello there,
I am running MySQL 5 Community Edition on Mac OS X Tiger
Here's what I did:
1. Ran the MySQL server from System Preferences
2. Launched Terminal and typed in the following:
untz$ mysql -u root -p
3. Was prompted for my password, and after entering that in, I
received this
> When I su mysql and run mysqld I get this:
> 050107 14:09:12 [Warning] Asked for 196608 thread stack, but got 126976
> mysqld: Can't create/write to file '/tmp/ib5ArcLz' (Errcode: 13)
> 050107 14:09:12 InnoDB: Error: unable to create temporary file; errno: 13
> 050107 14:09:12 [ERROR] Can't init
Permission problem:
[EMAIL PROTECTED] santino]$ perror 13
Error code 13: Permission denied
Check /tmp permission
and check /usr/local/mysql/data/
user and group of this directory must be mysql:mysql
if not:
chown -R mysql:mysql /usr/local/mysql/data/
Santino
PS: /usr/local/mysql is a symbolic lin
OK I am running Fedora Core3, Kernel kernel-2.6.9-1.724_FC3 along with
MySQL-server 4.1.8-0.i386.
No matter what I do MySQL the process will not start. This happens to me on
a couple of boxes.
One of the boxes which was upgraded from Fedora Core2 to Core3 does work
with the exact same versions of
Hi,
I currently have a table with 2 text fields, both of
which are marked as fulltext. I'm using the full-text
boolean search method with fairly good results.
My problems however are:
1. I am on a shared host provider so I can't tweak
the full-text search options such as stop words or
minimu
I have a problem with mysql/innodb, hopefully someone
here can offer a nice pointer.
our innodb databases got wiped out (oops), and the problem
is the .frm files dont seem to match the structure needed,
we tried working around that in the docs online, but now
we get this message:
InnoDB: Error: t
I have a problem with mysql/innodb, hopefully someone
here can offer a nice pointer.
our innodb databases got wiped out (oops), and the problem
is the .frm files dont seem to match the structure needed,
we tried working around that in the docs online, but now
we get this message:
InnoDB: Error: t
Hi Michael,
I a not 100% sure if I understood you correctly, but what you want to do seems
to be better made in the application itself, rather then the SQL code.
However you can use ALIASES together with the GROUP BY function and specify 2
columns (Cars and COUNT(Monthofyear) which should list
UGHH HELP!!
I need to write a sql statement that will take the data from my table and
use it as column headers. For example,
If I have a field named GoLiveDate and a field called Qty and a field called
Cars:
Cars | Qty | GoLiveDate
==
CarA | 5 | 7/21/2003
CarA | 10
Veysel Harun Sahin wrote:
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
The above is the correct query, to save yourself some time. As for your
problem:
But when I execute I get this:
Resource id#3
Resource id#4
This means you're using a resource resp
Geek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 15, 2003 10:09 AM
Subject: Need Help With MySQL Query
> hello,
>
> I've performed searches on this site and php.net to try and figure out
> why this is occuring. I can't find any i
Hi
Interesting problem, normally to get a total by type, you would have a query
like,
select van, sum(pay) from ($usertableDaily) group by van;
However you are individually quering each total, your approach is correct, but
slower.
The problem you have though is the return of
Resource i
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
[EMAIL PROTECTED] wrote:
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question to this list
Here's my table ($usertableDaily):
vanNumber|grossPay
-
Hi, I need some help with Mysql on OSX 10.2.1
I get this error
phpBB : Critical Error
Could not connect to the database
I created a database with nothing inside " phpbb "
I set all the users with passwords and used
default user: root and local host and I get that error
I have n
Kent,
Thursday, July 11, 2002, 9:22:52 PM, you wrote:
KH> I would use this query:
KH> SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
So?
Syntax of your SQL statement is correct.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This ema
I would use this query:
SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
Cheers,
Kent
sql, query, y'hear
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
: Re: help with MySQL SELECT statement
wait, how will the MySQL SELECT DISTINCT pick only one between these two
addresses (as an example):
[EMAIL PROTECTED]
[EMAIL PROTECTED]
I only need one email address each for alltel.com, one for ualr.edu, one for
target.com, etc. when there might be 50 email
wait, how will the MySQL SELECT DISTINCT pick only one between these two
addresses (as an example):
[EMAIL PROTECTED]
[EMAIL PROTECTED]
I only need one email address each for alltel.com, one for ualr.edu, one for
target.com, etc. when there might be 50 email addresses from each of those
domains.
Use SELECT DISTINCT.
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-Original Message-
From: Kirk Babb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 9:59 PM
To: [EMAIL PROTECTED]
Subject: help with MySQL SELECT statement
Easy
Easy question I hope, relatively new user (< 6 months) here wanting to know
how to fashion a MySQL
select statement based on the following:
there is a list of managers and their email addresses. This list changes
all the time as we add and subtract different companies from the db. I
would like
Should be able to find the right rpm's from your Linux distribution's
website. Just a guess here but www.redhat.com.
Mike
sqp,mysql
Balteo wrote:
> Hello,
>
> I am trying to install mysql from RPMs. My installation guide requires:
>
> -Mysql server
> -Mysql shared
> -Mysql client
>
> Howev
> Hello,
>
> I am trying to install mysql from RPMs. My installation guide requires:
>
> -Mysql server
> -Mysql shared
> -Mysql client
>
> However those files are not present on mysql's website. Where do I find
> them??
Where do you want to install .. on 1) Unix like OS or 2) windows or 3) any
o
Hello,
I am trying to install mysql from RPMs. My installation guide requires:
-Mysql server
-Mysql shared
-Mysql client
However those files are not present on mysql's website. Where do I find
them??
Is the file available at Mysql.com sufficient for a server + client
installation?
Thanks
Hi all,
I hope I am not too far off the topic here. I actually need help with cgi,
and mysql.
Please refer to the this file to see the program itself:
http://www.jhanna.com/ExtraPage4.txt
What I need to do is to break apart the subroutine, and do some
manupulations on it before displaying the out
On Tue, 2002-02-05 at 02:42, Joe Villari wrote:
> I'm hoping I can get some help here, I'm trying to get MySQL running
> on YellowDog Linux 2.4.17 kernel. I've installed the mysql,
> mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD.
> Ran mysql_install_db then changed the group
On Tue, 2002-02-05 at 02:42, Joe Villari wrote:
> I'm hoping I can get some help here, I'm trying to get MySQL running
> on YellowDog Linux 2.4.17 kernel. I've installed the mysql,
> mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD.
> Ran mysql_install_db then changed the group
I'm hoping I can get some help here, I'm trying to get MySQL running
on YellowDog Linux 2.4.17 kernel. I've installed the mysql,
mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD.
Ran mysql_install_db then changed the group and owner on
/var/lib/mysql to root.
This is what sho
Hey folks -
Here is hoping someone can help & once I get it down I promise I'll post all
my work on this list so some other newbie can benefit.
I'm simply trying to run a very very straightforward JDBC test with mySQL &
I keep getting the "Server configuration denies access to data source"
error
Raymond Norton wrote:
> error: failed dependencies:
>
> MySQL conflicts with mysql-3.23.36-1
>
> MySQL-server conflicts with mysql-server-3.23.36-1
Yeah, the MySQL rpms are incompatible with the mysql rpms (which are done
by RedHat). Apparently the two camps each think the other's file sys
>
>error: failed dependencies:
>
> MySQL conflicts with mysql-3.23.36-1
>
> MySQL-server conflicts with mysql-server-3.23.36-1
>
>
>- Original Message -
>From: "Kelly Firkins" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, December
day, December 10, 2001 4:20 PM
Subject: Re: need help with mysql rpms
> try just upgrading the RPMs using rpm -ivh
>
> --
> Kelly Firkins
> [EMAIL PROTECTED]
>
>
> >I need to remove a previous version of mysql and install the newest. When
> >t
try just upgrading the RPMs using rpm -ivh
--
Kelly Firkins
[EMAIL PROTECTED]
>I need to remove a previous version of mysql and install the newest. When
>trying to remove the previous version it complains about dependencies . I
>don't know what to do about it, so I end up with a
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a successful install of the
new version. Any help would be appreciated
rpm -e mysql-3.23.36-1
error:
At 6:23 PM -0400 6/16/01, Malkhaz Mangoshvili wrote:
>Hello. I installed on my computer Red Hat Linux 7.0. After that I
>started configuring
>mysql. I upgraded mysql, added all necessary packages and I wanted
>to run mysql server.
Are you using RedHat's MySQL RPMs? If so, you should uninstal
"Malkhaz Mangoshvili" <[EMAIL PROTECTED]> writes:
> Hello. I installed on my computer Red Hat Linux 7.0. After that I started
>configuring
> mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
>server.
> Whenever I type mysql it gives me such an error message: "
Hello. I installed on my computer Red Hat Linux 7.0. After that I started configuring
mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
server.
Whenever I type mysql it gives me such an error message: "ERROR 2002: Can't connect to
MYSQL server through socket /v
Luis ([EMAIL PROTECTED]) writes:
> 1. I would love to move my database in access (ms) to mysql running on my
> linux box (rh7.0)
> How would I do this?
We use the ExportSQL script - you can get it from the MySQL.com web site.
> 2. Then I would like to connect threw my windows machine into t
Hello all, Just have a simple question I hope.
1. I would love to move my database in access (ms) to mysql running on my
linux box (rh7.0)
How would I do this?
2. Then I would like to connect threw my windows machine into the database
running on the linux box.
I download the MyODBS file fr
This is a permissions issue. Check the directories mysql is located in
and grant executable permissions. Also verify ownership requirements for
each of these directories.
Charles Hagen
On Mon, 12 Mar 2001, Russ Heaton wrote:
>
> I just installed RH 7.0 selecting the 'install everything' optio
I just installed RH 7.0 selecting the 'install everything' option. Now
when I use safe_mysqld, it starts then ends immediately with the
following message in the log.
010310 12:43:30 mysqld started
010310 12:43:30 Can't start server : Bind on unix socket: Permission
denied
010310 12:43:30 Do y
Mike W. Baranski writes:
> All of the examples from teh mysql++ docs show hte connection as:
> Connection con("mysql_cpp_data");
> whenever I run this statement, I get a seg fault. What is the problem?
> My permissions are okay, I don't need any for mysql. Someone please
> help, I'm stuck
All of the examples from teh mysql++ docs show hte connection as:
Connection con("mysql_cpp_data");
whenever I run this statement, I get a seg fault. What is the problem?
My permissions are okay, I don't need any for mysql. Someone please
help, I'm stuck here and this is not good. I'm using Re
Marten Svensson writes:
> I'm currently creating a program where I'm accessing a database using
> mysql++. I can't get the "DateTime" type to work, though.
> My program works if I use the "Date" type instead, but it's not good
> enough!
> I can write to the database, but when I try to read
I'm currently creating a program where I'm accessing a database using
mysql++. I can't get the "DateTime" type to work, though.
My program works if I use the "Date" type instead, but it's not good
enough!
I can write to the database, but when I try to read out a
"DateTime" my program hangs.
Does
77 matches
Mail list logo