T `table_foo`.* FROM `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
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 5
"username", "password")
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!!!
--
ost database,etc. can these be copied to my new Linux enviroment or
> > is it best 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 director
ost database,etc. can these be copied to my new Linux enviroment or
> > is it best 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 director
. can 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]
If I 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 Ma
o. Can 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]
ll 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 entr
w me to reduce the number of queries
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
anteed, I know that I
need to think 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]
ies.copyid=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 ha
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
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 create
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 you
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
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 f
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
ject:Re: 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,
t of it.
yonah
Yonah 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
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 availab
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 wa
/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/mysq
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
hat's 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
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
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).
D
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.
ly justify the licensing costs. 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: h
st 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]
:",$dbh->errstr);
$rv = $sth->execute();
while (($membername,$address,$city,$state,$zipcode,$phonenumber) =
$sth->fetchrow_array){
print "$membername - $address - $city - $state - $zipcode -
$phonenumber\n";
}
$sth->finish();
# Disconnect the Database
$dbh->disconnect();
#The dienice subroutine, for handling errors.
sub dienice {
my($errmsg) = @_;
print "Error\n";
print "$errmsg\n";
print "\n";
exit;
}
exit;
Russ Fineman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
execute? I'm finding
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
named mysql which contains files like my-huge, my-large, etc..
but nothing in "program files" to start or run..
so I'm pretty stuck, looking for the next move..
many thanks
Russ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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)
h
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;
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 Knowl
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
mysql
and test 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://
en returning a value from 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
-- O
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
hanks in advance for your 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: Bo
nyone is aware of a solution to this, please email me, I quite like
mySQL but I think I'd probably move to another DBMS rather than spend a long
time and get messy coding around this problem.
Russ Davies
- Original Message -----
From: "Oson, Chris M." <[EMAIL PROTECTED]>
T
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 -
x27;t answer this
question.
I have searched Google and the mySQL manual for 'boolean datatype' and other similar
searches.
Is there a datatype or an easier workaround for this?
Many thanks in advance,
Russ Davies
base.
Could anyone suggest 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 pos
46 matches
Mail list logo