Am 18.05.2013 17:56, schrieb Last Hacker Always onpoint:
Hey sir thanks for adding me to the list but if I want to send a
question where do i send it to? mysql-subscr...@lists.mysql.com or
mysql@lists.mysql.com
what about read the welcome message or the text on the subcribe site?
http
Dear Sir,
Thank you for advising me generally, how to approach/in what cause we need to
approach!
I will follow your advise very strictly here after. I will try to find out
solutions my self first and if not, i ll write to the experts.
Thank you so much for making me to understand the
Thanks to everyone that offered all the valuable suggestions. SImply
replaced the shared-community with shared-compat and all seesm fine.
Will live with, or deal with, the missmatch in php libraries later, but
for now everything seems to work.
Thanks again to everyone that offered
, any
recommendations are much appericated!
PS: I posted this question on Java section but no replys :(
Ray
--
View this message in context:
http://www.nabble.com/jdbc-connection-pool-problem%2C-help%2C-thanks%21-tp15673813p15673813.html
Sent from the MySQL - General mailing list archive
Thank you so much, that worked!
--
Steve M.
on 1/15/08 3:17 PM Rolando Edwards ([EMAIL PROTECTED]) wrote:
ORDER is a reserved word in standard SQL
Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName;
If the column name in the table is ORDER, then put backquotes
geodesic_user_data
FROM geodesic_user_data
LEFT JOIN subscriber ON
geodesic_classifieds_userdata.id=subscriber.GeoClassID
WHERE subscriber.GeoClassID IS NULL;
Our hosting company uses MySQL 4.0.17 so the subquery approach is not
possible.
Thanks in advance - Miles
Miles,
It looks fine but you
of eyes would be appreciated.
DELETE geodesic_user_data
FROM geodesic_user_data
LEFT JOIN subscriber ON
geodesic_classifieds_userdata.id=subscriber.GeoClassID
WHERE subscriber.GeoClassID IS NULL;
Our hosting company uses MySQL 4.0.17 so the subquery approach is not
possible.
Thanks in advance
On 8/22/06, Karl Larsen [EMAIL PROTECTED] wrote:
$ mysqladmin -U make new password for root doesn't work.
can you copy the error?
if you want to set the root password you can use
mysqladmin -u root password newpwd
--
http://www.obed.org.mx --- blog
--
MySQL General Mailing List
For list
I got a lot of good help from people on this list. Some of them got
pissed at me because I was slow to use their suggestions. My reason was
I could not believe someone would release a rpm(s) that required the
user to make a directory not mentioned in the referance manual and
change it's
Hi Sheeri, you are correct in both the MySQL tips and in your suggestion that I
should include my test when I think something doesn't work ;) Thanks a lot!
I realize now that when I've sent a thank you note, I have only sent it to the
responder instead of all the list; my problem was sorted
Thanks for the help, I'll give some of these examples a try~!!!
Thanks,
Matt Babineau
Criticalcode
858.733.0160
[EMAIL PROTECTED]
http://www.criticalcode.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Thanks everyone!! It was just a typo and everything was updated :(
That's okay, I got my Admin guy to restore backup files. I'll just
Have to get in the habit of using commit and rollback.
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 17, 2005 10
Ahh okay the column was cut off or something \G shows it!
Thanks!!
-Original Message-
From: Rich Lafferty [mailto:[EMAIL PROTECTED]
Sent: Friday, April 29, 2005 10:28 AM
To: mysql@lists.mysql.com
Subject: Re: Can someone explain strange query!!
On Fri, Apr 29, 2005 at 10:46:16AM
is successfully
made, and I attempt to match my little search (for the word short) contained in the
variable $searchterms. However, I get back the message that $peeky (below) is not a valid MySql
resource. Can someone tell me what I am doing wrong? Thanks so much!
Cheers!
-Warren
=== Errant
, and I attempt to
match my little search (for the word short) contained in the variable
$searchterms. However, I get back the message that $peeky (below) is not a
valid MySql resource. Can someone tell me what I am doing wrong? Thanks so
much!
Cheers!
-Warren
=== Errant Code follows
Thanks to all of, I could get it
Thanks
Manisha
- Original Message -
From: Karl Pielorz [EMAIL PROTECTED]
To: Manisha Sathe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, August 23, 2004 9:52 PM
Subject: Re: How to get the last record from the slected record set
--On 22
Rhino
This is great it works a treat
Thanks
Regards
John Berman
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 13:40
To: [EMAIL PROTECTED]; 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: Re: Query Help
I hope you don't mind me butting in but your note
enough). In any case, I kept the underscore at the
end of your table names but left it out from your column names. You'll
have to modify my example queries to fit your real table and column names.
John Berman wrote:
Rhino
This is great it works a treat
Thanks
Regards
John Berman
-Original
Yours ID afccvi
--
Thank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a windows box to connect.
any ideas on how to set this beginner (me) straight
Thanks,
eric
--
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
Thanks to you all,
In regards to my question about the retreiving the last few rows in a
database
your help was really appreciated. Chris thanks for that tip and YEP work
for me
we will read it into a array then read it back in reverse.
Thaks again GUYS and I can't wait to be of help to some
the solution can be the list.
Thanks,
Hector
--
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
Thanks for your help, just what I needed.
I will play around but if you have a chance and know how, how would I order
the results by count? (ie. highest counts first..)
-Original Message-
From: Mike Knox [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 5:09 AM
To: '[EMAIL
Paul
How about
select FIRST_NAME, count(*)
from a table
group by FIRSTNAME
having count(FIRST_NAME) 1
Mike
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person
my nap I
dreamed up something like selecting all FIRST_NAME ordered by same, and them
some kind of script to do counts.
Any other/further suggestions appreciated. Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Thanks for the advice - and your patience in giving it to me.
The recommended changes in the ini file worked (but only along
with removing the word local from the load data local infile
instruction) [since I have a localhost Apache server as testing
environment]
thanks again to those more
Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30,
httpd_2.0.44
Thanks to Paul DuBois, Roger Davis, Helen Sallee, Ronan Chilvers, and Edward
Dudlik
for thier response to my question. I've included the a (one of many?)
snippit of code that
I've decided to use as a pattern
timestamp solved - thanks...
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
addisonellis.com
THIS E-MAIL AND ANY
What does mysqld.log say?
Manuel Velasco wrote:
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done./safe_mysqld
leo:/usr/bin # cd /var/lib/mysql
|
+-+++-+
2 rows in set (0.00 sec)
Hope this helps...
On Sat, 2003-01-11 at 16:25, Steve Lefevre wrote:
First of, thanks to all who replied to my questions earlier!
Now I have another problem. I have a table of Classes and Workshops. Each
Class has a number of workshops. Each workshop has
First of, thanks to all who replied to my questions earlier!
Now I have another problem. I have a table of Classes and Workshops. Each
Class has a number of workshops. Each workshop has a date.
I have a query that gives me the date range of a class - the min and max
dates of its workshops
Well, thanks to all of your great help! I am able to
speed up the query {select count(*) from NEW_Sequence
s left join NEW_Sequence_Homolog h on s.Seq_ID =
h.Seq_ID;} from 1 min 52.61 sec down to 20.62 sec now.
The only thing I changed so far was the Seq_ID from
type varchar to bigint. The Seq_ID
Thanks to all who recently answered some of my MySQL questions, although I
am still having some problems with the concept of joins, but what I have
figured out certainly does make it more efficient and versatile. I have
managed to eliminate two tables (actually combine them into one) which made
my
Thanks to all for the responses. Especially to those who pointed
my to documentation.
Regards
-tim-
* Cliff [EMAIL PROTECTED] [021108 08:32]:
You can use the function : mysql_insert_id() to get the value you've just added.
Please see http://www.mysql.com/doc/en/mysql_insert_id.html for more
First of all, thanks to everyone for no reply and no help!
If someone is interested, I've found that i Win9x systems,
if there are persistent connections open, the system instead of
used the same opened connection for the same session,
it opens a new connection for each script call, and,
because
of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have written the following:
First of all, thanks to everyone for no reply
-
From: Terence [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 15, 2002 9:38 PM
Subject: Thanks to MySql and it's Developers
To MySql AB and it's developers,
I am from Sunway College in Malaysia, and we implemented MySql about a
year
and a half ago. It was a shift from
Thank you very much for help.
Nick.
sql,query
-
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
Thanks to Dan Nelson and Mike Hillyer,
Indexing brought the search downto 2.03 sec compared to 3 min and 16 sec !
Thanks again.
Rgs
Steinar Kolnes
-Opprinnelig melding-
Fra: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sendt: August 14, 2002 1:14 AM
Til: Steinar Kolnes
Kopi: Mysql List
Emne
Thanks to all who responded to this posting.
The problem was due to ODBC logging turned on. When this was rectified the
system flew along like a greyhound!
I appreciate the other helpful suggestions given. The reason for moving from
Access to MYSQL is that I am moving a GIS application
Dear Monty,
At the beginning, I missed doing the step of setting default
character-set.
After I have done what you said about setting default character set,
the correct chinese characters are stored in mysql database.
Thank you very much!
Best regards,
Henry.
From: Michael
Thanks Charles for your patience and help. I removed winmysqladmin from
startup and ALL problems went away! When winmysqladmin started up on the other
user accounts it would somehow block connections to MySQL (since before I
uninstalled, on normal [non-admin] user accounts, I could
10:59 PM
Subject: Thanks
Thanks Charles for your patience and help. I removed winmysqladmin from
startup and ALL problems went away! When winmysqladmin started up on the
other
user accounts it would somehow block connections to MySQL (since before I
uninstalled, on normal [non-admin] user
You are very welcome. I am glad I was able to help.
Charles Q.
At 03:58 PM 6/6/2002 -0500, k wrote:
Thanks Charles for your patience and help. I removed winmysqladmin from
startup and ALL problems went away! When winmysqladmin started up on the
other user accounts it would somehow block
the fulltext queries on the slave server?
Thanks,
Brian Bray
[for the filter: sql,query]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Manager
Mountain Top Herbs
-Original Message-
From: Andrew Lietzow [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: Thanks to whomever... for the tip on mySQLMan...
Helo list,
I don't recall if it was here that I heard of this mySQLMan
-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:52 PM
To: Andrew Lietzow; [EMAIL PROTECTED]
Subject: RE: Thanks to whomever... for the tip on mySQLMan...
I just went in looked at mySQLMan, and I must say, I'm not very
impressed with it. If you like that package
Hi,
How to take part in a mail list for Redhat and FreeBSD such as this one.
Thanks, Dominic
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Thanks to all who responded to my message from yesterday re: the text field
(or column) sizes available in MySQL. I've now gotten the download of the
manual and will be pouring over that today in order to pursure further
answers to questions specific to our project.
Your quick replies
of
whats going on. I thank everyone for their time on this problem.
one thing though, I am surprised that grant did not alter the db table ?
does this surprise anyone else.
Thanks,
Matt.
-Original Message-
From: Ho, Kam [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 14:00
To: '[EMAIL
Through the responses, links, and a little concern (and a really smart and
helpful web
Host, he did most of the hard stuff), I got MyODBC working like a charm.
Made up a file DSN and can use it in Visual C++, Visual Basic, and Access.
Also thanks to whomever put MyODBC out there...
database
Thanks to all who helped with this problem.
As it turns out, it was much stupider than one could suppose, just yet another
demonstration that nobody should code more than a very few hours in a row...
The odbc_connect statement is nested in the whole PHP code in
such a way (thanks to include
Hi all,
On the subject of licensing: I've seen the discussions around this topic
and would like to approach it from another angle.
Until recently I were a student and if it weren't for the free
distribution of mySQL I would have had problems.
On the other hand I will be the
Joyce Vermeulen writes:
Hi all,
On the subject of licensing: I've seen the discussions around this topic
and would like to approach it from another angle.
Until recently I were a student and if it weren't for the free
distribution of mySQL I would have had problems.
On the
to thank all at Snitz Forum 2000 forum and the mysql maillist for
all there help!
Thanks,
eeehaah
BTW, the info returned by mysql_install_db about setting root password
is wrong, there must be no space between u and root;
/mysqladmin -uroot -p password 'yourdesiredpassword'
and
/mysqladmin
... you are really very kind and helpful!
Now I can avoid managing temp tables.
Thanks very much,
Nico Sabbi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
nsabbi writes:
... you are really very kind and helpful!
Now I can avoid managing temp tables.
Thanks very much,
Nico Sabbi
You are welcome.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL
and a workaround
is
chown mysql.mysql path-where-mysql sock file located
apparently my info was outdated, to install the initial database files
the command line is:
service mysqld start
Again, thanks to everyone.
--
Andy De Paoli
emails: [EMAIL PROTECTED]
[EMAIL PROTECTED
Thanks for the great tutorialg I added it to my MySQL notes database. I
like the way you explained it start to finish..
TIA
M;-)
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 6:13 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
Thanks to all of those who lent their advice. Seems that when you initialize
MySQL using the --skip-grant-tables option enabled, it disallows the ability
to use the GRANT command. I guess that makes perfect sense. I also forgot
the use the PASSWORD() function when I used SQL to update my root
Thanks for advices. As I got the error message, I thought the server has not
been started. It runs really!
Frank Tu
From: Miguel Angel Solórzano [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED],tu tuande [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: Mysql and Windows ME?
Date: Sat, 26
Thanks everyone for the help, you are an awesome crowd. We got it :)
Alan
-Original Message-
From: Peter Pentchev [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 10:19 AM
To: Alan Halls
Cc: [EMAIL PROTECTED]
Subject: Re: Can anyone help with a search?
On Tue, Apr 24, 2001
Hello,
I just wanted to thank everybody who helped me to understand
the topic below. I am going to unsubscribe from this list now,
so please address any further message, if any, to:
[EMAIL PROTECTED]
Thank you for your time
Marco
On 2001/04/14 20:37:15 +0100,
Thanks to those who replied. The solution was to drop the table and
then rebuild it. It was originally populated with a negative number
(yes, we know about the negative problem with auto incrementation),
which caused the max value to show up. I did not know that you
cannot simply delete
65 matches
Mail list logo