Hello,
I am currently upgrading from mysql 5.1.72 - mysql 5.6 and the migration and
upgrade is sound (In a QA ENV). Queries work etc. However, when I run a query
similar to SELECT `table`.* FROM `table` WHERE (some_id IN (13528, 14906,
38845)) ORDER BY `date` DESC LIMIT 1; on 5.1.72 and on
`table_foo` WHERE (credential_id IN (13528, 14906,
38845)) ORDER BY `date` DESC LIMIT 1;
Thanks!
From: myfriendvi...@gmail.com
Date: Fri, 27 Dec 2013 10:27:28 -0800
Subject: RE: MySQL Descending ORDER issue
To: russ_lav...@hotmail.com; mysql@lists.mysql.com
Hi Russ,
Please share with us
)
or die(mysql_error());
mysql_select_db(Lions,$conn) or die(mysql_error());
This works. But I don't want someone to beable to read the other databases or
tables in the Lions database.
Any help would be appreciated!!!
--
Russ
--
MySQL General Mailing List
For list archives
to rebuild everything?
I think you should, dump your data from the live windows server with the
mysqldump program (if you don't have such, setup it and copy tables to its
data directory). And then, import your data from the dump file into the new
Linux server.
Russ [EMAIL PROTECTED] wrote:
I
to rebuild everything?
I think you should, dump your data from the live windows server with the
mysqldump program (if you don't have such, setup it and copy tables to its
data directory). And then, import your data from the dump file into the new
Linux server.
Russ [EMAIL PROTECTED] wrote:
I
these be copied to my new Linux enviroment or is
it best to rebuild everything?
Thanks in advance for any help!!
--
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
manually start mysqld directly it runs as the changed user. so its
something in mysqld thats changing it but I cannot find out what. I have a
little programming knowledge but I'm no master.
Can anyone point me in the right direction?
Thanks in advance!!!
--
Russ
--
MySQL General Mailing List
anybody help with this?
Thanks in advance,
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
these files or which ones need changing?
Thank you for any help provided!!!
--
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, 9 Jun 2004 21:58:39 -0500, Donny Simonton [EMAIL PROTECTED]
wrote:
Russ,
We use #2 currently, and we are actually about to switch back to the
inserting them one at a time. The reason is very simple. In our case we
have a insert statement that will insert a maximum of 600 entries
of something else. :-)
Thanks,
--
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to 1, (plus a call to LAST_INSERT_ID), and wouldn't involve having to
match up the rows from the second query in 2).
If nobody knows the answer I'll just go with 2, but I thought it was an
interesting bit of trivia in addition to being useful to my specific
circumstance.
Thanks.
--
Russ
Hi,
I have two tables- books and copies
every book has an id in the books table
every copy of a book has the books id and a copy id in the copies table
(1 row per copy)
I want a list of all the books that don't have any copies meaning all
the book id's in books that don't match any book id's in
=NULL;
this didn't work even though without the where clause I got exactly what
I wanted- the left join filled in the entries that didn't have copies
with a null copyid.
what did I do wrong?
thanks
yonah
Yonah Russ wrote:
Hi,
I have two tables- books and copies
every book has an id in the books
There does seem to be a bug in icc- I've posted on intel's message
boards and they've confirmed a problem. There is a work around - here is
the post:
Hi Yonah,
I can see the same problem on my system.
I will create a support issue for you and will let you when
this get fixed.
I found that if
I've been trying to compile a mysql server optimized for a zeon
processor and a specific application- I'm compiling with icc.
the problem is with the sql benchmarks- the perl regexp for making the
detailed report of the benchmark doesn't match the output from the
benchmarks so it doesn't
are you sure that the icc binary is in your path?
have you sourced the script in the icc directory which sets the
environment variables for you?
yonah
Walter Andreas wrote:
Hi there,
I am trying to compile mysql 4.x with intel compiler for maximum performance. On my research I have found that
Can anyone explain what the raid configure option does? Is this for use
when storing mysql on hardware raid? if so, what type(s)- ie. striping,
mirroring?
Thanks
yonah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
: compiling with icc
Date: Thu, 1 Apr 2004 22:23:02 +0200 (CEST)
From: Lenz Grimmer [EMAIL PROTECTED]
To: Yonah Russ [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
References: [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Yonah,
sorry for the late reply. I have now
sorry- typo- the gcc binary was 4.0.18
yonah
Yonah Russ wrote:
Hi all- Here is more info on compiling mysql with icc 8 from the mysql
packagers list-
As for my attempts, I compiled successfully a couple times and the
first benchmark I did was faster than the gcc compiled server by about
10
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
including my last configuration for compiling and how it died- I've
tried about a million other ways- this seems to come the closest to
compiling normally but dies with an internal error(looks like intel's
fault not yours).
Victor Medina wrote:
8
must probably no one here uses the Intel compiler since it is paid =(
actually there is a free non-commercial license version here:
http://www.intel.com/software/products/compilers/clin/noncom.htm
which is how I happen to have it
yonah
it dies with this error:
IPO
what they used) but not with 4.0.18
yonah
Chris Nolan wrote:
Victor Medina wrote:
Hi!
On Wed, 2004-03-24 at 09:51, Yonah Russ wrote:
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
8
GUAO! nice!, let us know how faster it is with the Intel compiler, just
curious
Victor Medina wrote:
it dies with this error:
IPO Warning: unresolved : rl_attempted_completion_function
Referenced in ipo_icc5X7oE4.o
IPO Warning: unresolved : rl_completion_entry_function
8
Ncurses devel and the readline libriries must be installed for the
client to compile
/local/mysql/lib/mysql
/usr/local/lib
/usr/local/intel/lib
.
thanks
yonah
Victor Medina wrote:
On Wed, 2004-03-24 at 10:57, Yonah Russ wrote:
8
make[2]: Leaving directory `/moat-files/mysql-4.0.18/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/moat-files/mysql-4.0.18
Great! Thanks for the help.
Here is some more info, in case it's helpful- these are all the compile
warnings from the make:
my_thr_init.c(67): warning #266: function declared implicitly
pthread_mutexattr_setkind_np(my_fast_mutexattr,PTHREAD_MUTEX_ADAPTIVE_NP);
^
...
icc: Command line
I'm not a big mysql expert but I think mysql has some buffers which it
keeps per connection
here are some examples (from mysql website):
/
/If you have complex queries |sort_buffer_size| and |tmp_table_size| are
likely to be very important. Values will depend on the query complexity
and
Russ wrote:
Great! Thanks for the help.
Here is some more info, in case it's helpful- these are all the
compile warnings from the make:
my_thr_init.c(67): warning #266: function declared implicitly
pthread_mutexattr_setkind_np(my_fast_mutexattr,PTHREAD_MUTEX_ADAPTIVE_NP);
^
...
icc
I have MySQL ver. 4.0.18 binarys for windows installation. I just finished installing mysqld-max-nt as a service on a WinXP box yesterday afternoon. Using the MySQL Administrator client/utility GUI, I configured the anonymous and root Users, then added a superuser level account for myself. I
. Are there
any other options for a live backup? The only others means of backup
would be to shutdown the server and copy the data manually I assume?
Any pointers to the above two queries greatly appreciated!
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
by checking the ID rather than tracing back the
various relations that will link said row/table back to a user.
Any advice would be appreciated,
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it difficuly to optimise my query as I'm not sure exactly which times
are correct.
Hope I've explained this OK - sure I'm missing fundamental, so
apologies in advance.
Regards,
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
$membername - $address - $city - $state - $zipcode -
$phonenumberp\n;
}
$sth-finish();
# Disconnect the Database
$dbh-disconnect();
#The dienice subroutine, for handling errors.
sub dienice {
my($errmsg) = @_;
print h2Error/h2\n;
print $errmsgp\n;
print /body/html\n;
exit;
}
exit;
Russ Fineman
Hiya.
I have inherited an Access database whose originator has used the # character in
field names as you can see below. I would like to replace this with a MySQL served
version. This is part of the script created by ACCESSDump.
DROP DATABASE cd2;
CREATE DATABASE if not exists cd2;
USE cd2;
Hello.
Thanks for the reply.
I am issuing it as a command line option to the script. i.e.
mysql -u crn -p cd2.sql.
Any help?
Russ.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
When I try to add a string to the end of an enum list I get the following
error message:
You have an error in your SQL syntax near '\','Historical
Knowledge','Chronological Thinking, Comprehension, Analysis and I' at line 1
The schema for the field is:
standards_topic enum('','Historical
how do i sort my results by reverse order ?? say the collume containts 1 2 3
4 , if i use ORDER BY VOTES it returnes 1234 but i wont it in revers 4321
etc is there any way i can do this with a sql function?
Russ
-
Before
databases in it, there is no file named mysql.sock in it.
Any help would be appreciated. Thanks in advance.
Russ Heaton
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
mySQL, ASP detects the string is "True" and it
evaluates succesfully ("true" = True)
Many thanks for everyones help on a relatively simple question, you've been really
good. I've taken enough of your time now...
Russ Davies
-- Original Message ---
st a better way of implementing this, or am I missing something?
I have done a Google search and searched the mySQL manual, but got nothing.
Many thanks in advance of your efforts.
Russ Davies
-
Before posting, please check:
http:
manual for 'boolean datatype' and other similar
searches.
Is there a datatype or an easier workaround for this?
Many thanks in advance,
Russ Davies
Thanks for the suggestion, but this would still mean converting the data
type from within ASP (the 'True' type) down to a char ('T') would it not?
It is more sensical than using 1/0 but still involves the same number of
processes?
Russ Davies
- Original Message -
From: "Oson, Ch
efforts,
Russ Davies
- Original Message -
From: "Matt Friedman" [EMAIL PROTECTED]
To: "Russ Davies" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 9:11 PM
Subject: Re: Boolean Datatype
Try using enum in mysql. That mi
to be for an ENUM data type?
Russ Davies
- Original Message -
From: "Vivek Khera" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 9:09 PM
Subject: Re: Boolean Datatype
"RD" == Russ Davies [EMAIL PROTECTED] writes:
RD Thanks for the suggestion, but t
44 matches
Mail list logo
