On Thu, 31 Oct 2002 [EMAIL PROTECTED] wrote:
> I want to create a table in PHP with data from a MySQL database table. Can someone
>please help with a sample script. I know this is probably easy but I need quick
>help. I searched the archives and couldn't find something this simple. Please he
At 20:15 -0800 10/31/02, Andre Kirchner wrote:
Hi,
is it possible in the mySQL to have an index that none
of the values could be repeated except for a single
value that could be repeated?
Yes, but the only value that can be repeated is NULL.
That's how UNIQUE indexes work for MyISAM and InnoDB
No, I hadn't. So I did. IT WORKED!
Thank you very much!
Roger Baklund wrote:
* [EMAIL PROTECTED]
[...]
In other words, any pix that has a bigpix defined is ok. But on any
pix that does not have a bigpix defined, I "loose" the filename info
from pix.
And I don't understand why!
Here is the
Hello all,
Having a column
item set('a','b','c','d')
it is possible to select
bit_count(bit_or(item))
to get the total number of used positions; and also to do a
sum(bit_count(item))
to get the total number of set positions. However, I would also like to
add a
make_set(bit_or(item),
I think the best solution would be
TABLE ITEMS
[ item_id | parent_id | item_name ]
data
1, 0, foo
2, 0, bar
3, 2, baz
4, 2, quux
5, 1, fee
6, 1, fi
So above baz and quux are subcats of bar and fee/fi
are subcats of foo
This structure allows for unlimited levels of
sub-categories to be added. G
Hello Matt
You probably already thought of this - but why not just set up a database
or table for each department and set up separate users with privileges to
their corresponding database or table?
It would virtually accomplish the same thing. They would have their own
database that could on
Matt Neimeyer wrote:
Hey All,
On Redhat Linux is there an easy way to have an ISP style setup where
each "user" has their own database directory?
Long story short, we have to implement a small in house server that
will allow multiple departments to create their own little web pages.
Perhaps
Hey All,
On Redhat Linux is there an easy way to have an ISP style setup where each
"user" has their own database directory?
Long story short, we have to implement a small in house server that will
allow multiple departments to create their own little web pages. Perhaps
I've missed something o
Hi,
is it possible in the mySQL to have an index that none
of the values could be repeated except for a single
value that could be repeated?
The values of the column would be something like this
'123'
'245'
'233'
'XXX'
'XXX'
'027'
where just the value XXX could be repeated.
Thanks,
Andre
___
Hi there,
I found a way to do it with the following query
select * from theTable
where 'test' like concat( theColumn, '%' );
Thanks for the help,
Andre
--- Andre Kirchner <[EMAIL PROTECTED]> wrote:
> thanks for the help, but what I really want is to
> select all the values that are a substrin
I noticed that the resources used by MySQL grow continually. I recently
restarted our MySQL server because the process had grown to 259MB.
MySQL is used by our Webserver running CGI scripts with roughly
57,000 connections in the last couple of days. Currently the process is
using 18MB of memo
thanks for the help, but what I really want is to
select all the values that are a substring of 'test'
as 't', 'te', 'tes' and 'test', and so I was trying
the query
select * from theTable
where ( theColumn || '%' ) like 'test';
I think my previous email as a litle bit confusing.
Sorry for that :
Um, kindof an obvious question, but did you install the mySQL CLIENT as
well as the server? They are separate .rpm files or binaries or whatever
you use.
DÆVID.
"A good friend will come and bail you out of jail...but a true friend
will be sitting next to you in the holding cell, laughing and sayi
On Thu, 2002-10-31 at 21:27, Elaine Kwek wrote:
> i hope someone can help me in my problem. I have use the password function
> in mysql to encrypt a string. Then when i try to get the encrypted password
> using php and compare with the password that user enter. although the user
> provide the corre
You can't decrypt the password from MySQL, instead, you should encrypt the
input from PHP and then do the string comparison.
Good Luck,
Dennis
- Original Message -
From: "Elaine Kwek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 9:27 PM
Subject: password f
select * from theTable where theColumn like 'test%';
or
select * from theTable where LEFT(theColumn,4) = 'test';
depending on the table structure and data and indexing, etc. I have seen a
performance difference between the two, test and see which works best for
your application.
Hi there,
how c
- Original Message -
From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]>
To: "'CM Miller'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 3:16 AM
Subject: RE: Still not getting a mysql prompt
> In order to perform these tasks you may need to stop the
> mysqld daemon
i hope someone can help me in my problem. I have use the password function
in mysql to encrypt a string. Then when i try to get the encrypted password
using php and compare with the password that user enter. although the user
provide the correct password, but then the comparetion still fail. So, wa
'command not found' means that the server cannot find the application.
Either alias it or add
/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/ to your path or try
cding to /usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/ and then
running it or just type the entire path at your prompt.
th
Hi there,
how can I query all the values starting with 'test'?
I tried the following query, but it didn't work
select * from theTable where ( ( theColumn || '%' )
like 'test' );
Thanks,
Andre
mySQL
__
Do you Yahoo!?
HotJobs - Search new jobs dail
Make sure you are logging in as indicated in the docs.
Something along these lines (from local host)
shell> mysql -u username -p hostname databasename
if hostname (being your hosts domain name) doesn't work
try "localhost"
It may be possible that mysql needs to be owned over to
a user id on th
I want to create a table in PHP with data from a MySQL database table. Can someone
please help with a sample script. I know this is probably easy but I need quick help.
I searched the archives and couldn't find something this simple. Please help.
Ben
---
I'm still not getting a mysql prompt to login to.
I've tried what was suggested below, but I'm not sure
what it does and I searched for that directory and
could not find a TMPDIR.
If I try loging in under Root or as a user by typing
mysql I get an error message: command not found, but
the mysql
Well, I should correct what I just said. The OSDN number is likely not
up to date. Bad comparison. Nevertheless, MySQL seems to handle data as
fast as you can supply it with.
> > But this has nothing to do with SQL or QUERYs. :)
>
> True, so I'll shut up now.
Really this time.
Sincerely,
Steven
> Alexa's a horrible measure...
Things I don't want to listen to. ;)
At any rate, my point is that we have a very dynamic site (all forums
and chat) powered by MySQL that continuously both updates and reads from
the same server and does 100,000,000+ pageviews a month. (Slashdot +
freshmeat + geoc
On Thu, Oct 31, 2002 at 05:02:49PM -0300, Alexander Burbello wrote:
> I am try to make replication between two servers.
>
> I configurated the master and slave servers with the follow parameter in
> my.ini
>
> MASTER
> server-id=1
>
> SLAVE
> master-host=
> master-user=
> master-password=
> mast
Hi! mysql experts,
I'm migrating my access db's to mysql but some querys in Access need sub
querys.
I know that is n't possible with mysql but maybe with the beta
distribution I could do it.
can some body helpme, maybe there are other way to do it.
thanks,
Victoria
-
On Thu, Oct 31, 2002 at 03:02:09PM -0500, Michael T. Babcock wrote:
> Jeremy Zawodny wrote:
>
> >>A very good suggestion indeed (IMHO); replication for performance in
> >>this way is probably very under-utilized. I wonder if Slashdot is
> >>doing it yet?
> >>
> >>
> >
> >They've been using Re
Hello all,
I have an 'items' table with 2 'types' of items -- 'foo' & 'bar'
Say that items of type 'bar' may be further classified as 'subtypes' 'baz',
'quux', etc.
Now I build an online store so that visitors may buy items.
Contstraints
1.) I would like to, as much as possible, use the same c
In my perl script I do the following:
my $sth = $dbh->prepare("SELECT MAX(Id) FROM sometable");
my $id = $sth->execute();
print "id: $id\n";
It prints 1 which I guess is the number of rows selected. I was expecting that
it would give me the highest id in that table. How can I get that? Thanks for
Hi,
I need a 20 GB + DB that I'd like to access by row number or physical order.
Of course I could use a special rownum column but that would be a waste of
space plus require an additional key whereas mySQL already maintains such
table internaly.
Hope this makes sens,
Best,
Thierry
www.arbitr
Incase anyone cares the fix was to give ownership to everything in the mysql
directory to user mysql.
Thanks all who helped!!
Jason
-
Bond: "That gun, looks more fitting for a woman."
Largo: "Do you know much about guns Mr. Bond?"
Bond: "No, I know a little abou
It's all right here => http://www.mysql.com/manual.php
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Thursday, October 31, 2002 1:49 PM
To: [EMAIL PROTECTED]
Subject: Creating users through SQL
How do I create users for a specific database using SQL?
-
Michael
Heheheh lmao!
I can see what you mean
oh yea sql query!
~K Black
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Thursday, October 31, 2002 12:11 PM
To: '[EMAIL PROTECTED]'
Subject: Re: sql query
Black, Kelly W [PCS] wrote:
>Pretty lam
Apparently I am unpopular.
This person => Abdel-Hameed Abdel-Salam Badawy <[EMAIL PROTECTED]>
tried to unsubscribe me from the list server
:(
Hmm wonder why?
Sorry if I hurt someone's feelings or something? *looks confused*
~K Black
sql,query
-Original Message-
From: [EMAIL PROTE
How do I create users for a specific database using SQL?
-
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 <[E
You must issue
flush privileges;
to the sql query line.
~K Black
-Original Message-
From: alex [mailto:alex@;dynaweb.ru]
Sent: Thursday, October 31, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: access denied for user with granted privileges
Hi ppl!
I've got a strange problem.
I've c
Try compiling form source instead of running binary.
~K Black
-Original Message-
From: Mark [mailto:admin@;asarian-host.net]
Sent: Thursday, October 31, 2002 12:33 PM
To: heath boutwell; [EMAIL PROTECTED]
Subject: Re: Thread Thrashing and 3.23.53a
- Original Message -
From: "hea
compile mysql with
./configure --with-memory-limit=
I forget the exact syntax.
It's also possible to pass the limit on via the env.
try using "show variables;"
as your sql query, and read how my.cnf is affecting the
settings.
Then you can export memory limits with ulimit to env from the
shel
Hi:
Consider (default table type set to InnoDb, mysql
3.23.52):
CREATE TABLE A (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(20), PRIMARY KEY (id)
);
CREATE TABLE B (
id INTEGER NOT NULL AUTO_INCREMENT,
AID INTEGER NOT
Joe
You might want to try owning all the mysql files over to
a userid like "mysql" and then use
cd /usr/local/mysql-ver.
./bin/mysqld_safe --user=mysql &
sql query
Regards
~K Black
-Original Message-
From: Joe M [mailto:joe_m@;circlepressroom.com]
Sent: Thursday, October 31, 2002 11:1
Mysql is installed properly with user mysql and group mysql.
What happens if I limit the maximum filesize for the mysql user? When it
reches that size it will send what kind of errors to the user doing the
query?
Another problem is that I have quite big innodb data-files, owned by
mysql, the limi
I've got, in my slave my.cnf:
replicate-wild-do-table = RemoteTableName
replicate-rewrite-db = RemoteTableName->LocalTableName
... and the slave thread seems to be happily following along with the
sequence numbers on the master, but when I insert data into the master's
"RemoteTableName", nothin
Steven Roussey wrote:
Really? If I were to go by their Alexa traffic rating of 1390, I'd think
it would not even be necessary. Our traffic ranking is 859 and we don't
need to do anything like that. Maybe Alexa is not a good measure. :( I
like our ranking there...
Alexa's a horrible measure, e
Benjamin Pflugmann wrote:
So what's left is that you save the real md5 string instead of it's
hex representation, e.g. in a CHAR BINARY. That's easiest if you have
the binary representation on the client side. I see no easy way of
doing it in MySQL if you only have the hex rep (you could split it
>From: Lars Andersson <[EMAIL PROTECTED]>
>
>Thanks for your advices, but I don't want to solve this problem on the
>OS/shell level.
Assuming MySQL is installed properly, with its own user and group, I don't see why you
should not want to solve the problem this way.
--
SQL SQL SQL SQL SQL
Heikki Tuuri wrote:
Ryan,
- Original Message -
From: "rcandersonmn"
Newsgroups: mailing.database.mysql
Sent: Thursday, October 31, 2002 4:23 PM
Subject: Prepared Statement Problem
>I'm new to MySQL and am having problems with Prepared Statements in
>MySQL. I'm using the latest MySQL b
> They've been using Replication for a long time at Slashdot.
Really? If I were to go by their Alexa traffic rating of 1390, I'd think
it would not even be necessary. Our traffic ranking is 859 and we don't
need to do anything like that. Maybe Alexa is not a good measure. :( I
like our ranking the
Hello.
On Thu 2002-10-31 at 13:54:18 -0500, [EMAIL PROTECTED] wrote:
> Am I right in assuming that comparing two md5 strings would be faster
> if they were compared as two hexadecimal numbers than if they were
> compared as two strings?
>
> If so, is there any way to insist on this in a SQL que
- Original Message -
From: "heath boutwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 5:22 PM
Subject: Re: Thread Thrashing and 3.23.53a
> Aren't these just aborted clients? When you upgraded before did mysql
> bring the server t
Ryan,
- Original Message -
From: "rcandersonmn" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, October 31, 2002 4:23 PM
Subject: Prepared Statement Problem
> I'm new to MySQL and am having problems with Prepared Statements in
> MySQL. I'm using the latest MySQL be
Can anyone that was experiencing the thread thrashing
problems with the other binaries confirm that this has
been with resolved with 53a?
Yes. At least for us. We can again do 3,000+ qps. The 'out of sync'
errors were completely separate issue related to PHP.
Pre
Black, Kelly W [PCS] wrote:
Pretty lame.
Agreed (again)
Oh yeah, SQL QUERY.
PS,I'm typically against "me too" type comments, but this p@!ses me off
so much, its worth it ...
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
Jeremy Zawodny wrote:
A very good suggestion indeed (IMHO); replication for performance in
this way is probably very under-utilized. I wonder if Slashdot is
doing it yet?
They've been using Replication for a long time at Slashdot.
That's not actually what I asked; I asked if they were
I am try to make replication between two servers.
I configurated the master and slave servers with the follow parameter in
my.ini
MASTER
server-id=1
SLAVE
master-host=
master-user=
master-password=
master-port=
server-id=
What I have to do for the servers starts to replicate data?
Alexander
Is there any way to put a limit on the size of temporary tables? Or is
it possible for my users to put the server down just by creating some
kind of big cartesian product as a result of a big join?
The server is used in an production environment and it would be a great
releaf if there is some way
Almost all modern unix type systems come with the powerd daemon.
-Original Message-
From: Jan Steinman [mailto:Jan@;Bytesmiths.com]
Sent: Thursday, October 31, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: UPS (Was: Mysql in Innodb)
>From: gerald_clark <[EMAIL PROTECTED]>
>
>A UPS is of
Hello,
starting mysql-3.23.32 on ydlinux from the command
prompt. freezes the current terminal, BUT the mysql server
is running, i can access it from outside or a new term.
#safe_mysqld & or just #safe_mysqld, tried both. can't
find anything in the man. thanks--Joe M
-
On Thu, Oct 31, 2002 at 12:38:37PM -0500, Michael T. Babcock wrote:
> Joseph Bueno wrote:
>
> >You install a slave server on your web frontend and use it for all
> >your selects: no need to upgrade your network anymore !
> >
>
> A very good suggestion indeed (IMHO); replication for performance in
pico /etc/services
ulimit 2 # size in k
BTW
It cannot remove files in use.
It would simply generate cron errors
-Original Message-
From: Lars Andersson [mailto:lars@;rockar.nu]
Sent: Thursday, October 31, 2002 11:05 AM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: my
Varun VallaBhaneni wrote:
MYSQL,same as we do in th Access Reports,I am not
getting much information on how to start this.So, it
will be of great help to me if we give Some
MySQL only does the back-end work, not the reports, etc. You can easily
generate reports with PHP + MySQL in my experie
Thanks,
Unfortunatley I think things will break if I remove the temporary files
while they still are in use =)
I want a solution that keeps the files limited in size. There must be
some settings that controll this kind of stuff.
/Lars
On Thu, 31 Oct 2002, Black, Kelly W [PCS] wrote:
> #!/usr/l
Am I right in assuming that comparing two md5 strings would be faster
if they were compared as two hexadecimal numbers than if they were
compared as two strings?
If so, is there any way to insist on this in a SQL query? I am using
PHP, and would like to know from that perspective if it makes an
Hi ppl!
I've got a strange problem.
I've created a user account with access to some concrete database using
GRANT query (see below) but I cannot connect to the server using this
usename only when connecting via mysql_real_connect() from C API. When
using "mysql -u MY_USER" it works fine.
What's w
#!/usr/local/bin/perl
use strict;
my @files=(`/bin/ls /tmp/sql*.M*`);
for (@files) {
unlink;
}
exit 0;
shell> crontab -e
0 2 * * * /usr/local/bin/perl /path/to/delete/program
:wq
:)
-Original Message-
From: Lars Andersson [mailto:lars@;rockar.nu]
Sent: Thursday, October 31, 2002 9:56 A
Hi,
I could use some advice on this query.
SELECT cell, sum(att) as att , sum(lc) as lc , sum(csh) as csh,
ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc + suf)),2)
AS drops, sum(tccf) as tccf, sum(bpp) as bpp, sum(bpc) as bpc, sum(suf) as
suf,
ROUND((SUM( tccf + bpp + bpc
>From: gerald_clark <[EMAIL PROTECTED]>
>
>A UPS is of little use if you dont have software installed to shut the computer
>down when AC power is lost.
That may be true of un-attended operation, but if someone is around to shut down when
the UPS starts making noise, Bob's your uncle!
But such so
use this
Shell>TMPDIR=/tmp
Shell>export TMPDIR
restart mysql.
-Original Message-
From: CM Miller [mailto:cmmiller1973@;yahoo.com]
Sent: Thursday, October 31, 2002 9:42 AM
To: [EMAIL PROTECTED]
Subject: How do I log into MySQL?
I can start/stop the daemon for MySQL with no problem.
>From: tosca ballerini <[EMAIL PROTECTED]>
>
>I want to import a
>database from filemaker to mysql: is that possible? and how?
It's a pain in the butt. FileMaker does not allow access to all the schema info you
need to do a fully automated CREATE TABLE, and its typing and relational mechanisms
a
Pretty lame.
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com]
Sent: Thursday, October 31, 2002 11:58 AM
To: Black, Kelly W [PCS]
Subject: Re: SELECT
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
The government has a white paper on this.
Just !google "benchmark MySQL"
-Original Message-
From: Benji Spencer [mailto:ben.spencer@;moody.edu]
Sent: Thursday, October 31, 2002 9:36 AM
To: Benjamin Pflugmann
Cc: [EMAIL PROTECTED]
Subject: Re: How much data can MySQL push out?
>Sorry,
Hi.
On Thu 2002-10-31 at 11:35:56 -0600, [EMAIL PROTECTED] wrote:
>
> >Sorry, I do not have much experience with MySQL on Suns (at least not
> >in pushing it to the limits). On an Athlon 700Mhz selecting 1
> >random rows out of 6, I get over 330MB/sec (1000 queries/sec) on
> >localhost an
Benji Spencer wrote:
3) We would be adding a database to a machine which is already
somewhat busy (we split the web and database off of the same box
because the CPUs where not able to keep up with both web and db activity)
Understandable, but it might actually improve performance to not be
w
,5) AS Item_Sku,count(*) as Quantity_Sold,
SUM(price) AS Total_Sales FROM `orderline` WHERE (order_date>='20021030'
AND order_date<='20021031') GROUP BY sku ORDER BY Item_Sku ASC
Produces results like:
Item_Sku Quantity_Sold Total_Sales
LE104 1 18
MD008 1 25
MD012 1
Have you tried installing a Windows copy of MySQL on the web server for
the replication suggestion given before? I know it may be difficult to do
politically.
This is a little hard to do politically for a number of reasons.
1) In order for this to work, the backend database (which allows upda
Quantity_Sold,
SUM(price) AS Total_Sales FROM `orderline` WHERE (order_date>='20021030'
AND order_date<='20021031') GROUP BY sku ORDER BY Item_Sku ASC
Produces results like:
Item_Sku Quantity_Sold Total_Sales
LE104 1 18
MD008 1 25
MD012 1 5
MD103 1 18
MD104 10 400
MD104
Benji Spencer wrote:
this helps A LOT. MySQL doesn't have to be on the Sun Box. What OS
where you using? We could put MySQL on a Windows box. I don't know
that I could convince them to put it on a Linux box though.
Have you tried installing a Windows copy of MySQL on the web server for
the r
Hi,
I manage a mysql server with a few hundred users. All of a sudden mysql
has started to put large files in /tmp
I've never noticed this behavior before. The files looks like this
-rw-rw1 mysqlmysql3788431360 Oct 31 17:49 #sql420e_36b82b_1.MYD
-rw-rw1 mysqlmysql
> I have a database which has identical entries. Is there
> a way to tell mySQL to throw out duplicate entires
> when un insert/update is done via ColdFusion?
Tell mySQL that the columns are UNIQUE.
Alec
-
Before po
Why not only do:
conn.beginTrans();
//Statments
conn.commit(); or conn.rollback();
-Original Message-
From: David Shanes [mailto:dshanes@;san.rr.com]
Sent: October 31, 2002 12:12
To: [EMAIL PROTECTED]
Subject: SQL UPDATE question
Filter: SQL, UPDATE
Is there a way to do the following
Peter Lovatt wrote:
Somebody out there is probably infected. Do us all a favour and make sure
you are virus free :)
And get your network admins (if that's not you) to install a virus
scanner on your E-mail system (like the McAfee + qmail + smtpd-queue
patch combo I use). It doesn't use SQL
I can start/stop the daemon for MySQL with no problem.
And, if i ps -aux | grep mysql I show that it is
running, but if I check the log I get the following
output:
021025 20:11:44 mysqld started
021025 20:11:44
/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
Can't create/write to
Joseph Bueno wrote:
You install a slave server on your web frontend and use it for all
your selects: no need to upgrade your network anymore !
A very good suggestion indeed (IMHO); replication for performance in
this way is probably very under-utilized. I wonder if Slashdot is doing
it yet?
Hi,
How can we Prepare Reports From
MYSQL,same as we do in th Access Reports,I am not
getting much information on how to start this.So, it
will be of great help to me if we give Some
information on How to get started.
I am working on a project in Linux, PHP, Apache,
MYSQL,
one o
Sorry, I do not have much experience with MySQL on Suns (at least not
in pushing it to the limits). On an Athlon 700Mhz selecting 1
random rows out of 6, I get over 330MB/sec (1000 queries/sec) on
localhost and about 5.5MB/sec via a 100MBit TCP connection using the
mysql command line clie
Use the concat function. It takes any number of arguments.
mysql> create table test (a char(5));
Query OK, 0 rows affected (0.04 sec)
mysql> insert into test values ('A');
Query OK, 1 row affected (0.02 sec)
mysql> select * from test;
+--+
| a|
+--+
| A|
+--+
1 row in set (0.
Hello.
On Thu 2002-10-31 at 08:10:17 -0600, [EMAIL PROTECTED] wrote:
> We are experiencing some issues with performance on a non-MySQL box and are
> looking for alternatives (and alternative methods). Once of the issues that
> we seem to be facing, is that the pure volume of data which needs to
Filter: SQL, UPDATE
Is there a way to do the following in one single statement? I know I can
get all of the info from the three tables in a single query using
joins...
// Start a transaction
conn.setAutoCommit(false);
// Do the work.
stmt = conn.createStatement();
// Update general acct info
sS
I'm sure you've already specified this, but here's a few questions:
Probably not a bad idea to recap
What size of machine (CPU, RAM, # and type of drives) are you using for
each server? (MySQL vs. MS SQL)
MSSQL (Current setup) - 2-1.2 GHZ CPUs, 4 gig of mem, and a RAID5 SCSI
array, Server
Brian,
Thursday, October 31, 2002, 6:07:43 PM, you wrote:
BH> Is there anyway to get a mysql server to tell me
BH> a) What user I am connected as?
BH> b) What host I am connected from (i.e., localhost vs. fqdn)?
SELECT USER();
BH> c) What database I am using?
SELECT DATABASE();
SHOW PROCESSLI
* scott
[...]
> Lets say I had another table called others
> And I wanted the query you supplied to INCLUDE items from others that
> are not in test
>
> Eg, (old example)
> Others
>
> Name item
> --
> Abc 10
> Def 11
> Geh 12
> Ijk 13
> Lmn 99
This table has a different strucure
--- gerald_clark <[EMAIL PROTECTED]>
wrote:
> A UPS is of little use if you dont have software
> installed to shut the
> computer
> down when AC power is lost.
Indeed :-). The problem was the eletrical board. This
kind of problems shouldn't happen but sh*t happens
:-))). Anyway, I read more caref
Filter: SQL, UPDATE
Is there a way to do the following in one single statement? I know I can
get all of the info from the three tables in a single query using
joins...
// Start a transaction
conn.setAutoCommit(false);
// Do the work.
stmt = conn.createStatement();
// Update general acct info
sS
Create an unique index.
See: http://www.mysql.com/doc/en/CREATE_INDEX.html
Regards,
Joseph Bueno
FlashGuy wrote:
> Hi,
>
> I have a database which has identical entries. Is there a way to tell
> mySQL to throw out duplicate entires when un insert/update is done via
> ColdFusion?
>
>
> --
This really isn't a bug, just an a bit of information
I copmiled MySQL for Solaris 9 on an UltraSPARC using gcc-2.95.3.
If you compile MySQL with the option --with-libwrap for tcp wrappers
support, and then try to run the test cases, they will not fail, but
they will hang. If you compile MyS
Since your requests are mainly selects and each select is returning
a lot of data (more than 500K) you could eliminate most of your
network problem with MySQL replication :
You install a slave server on your web frontend and use it for all
your selects: no need to upgrade your network anymore !
Re
Benji Spencer wrote:
is why that might be an option. However, it might be easier to switch
from MSSQL to MySQL if MySQL would handle the traffic better. We do
need a little logic to determine if the user is logged in (if they
aren't logged in, they don't see the page) but it shouldn't be all
The query below:
SELECT DISTINCT LEFT(sku,5) AS Item_Sku,count(*) as Quantity_Sold,
SUM(price) AS Total_Sales FROM `orderline` WHERE (order_date>='20021030'
AND order_date<='20021031') GROUP BY sku ORDER BY Item_Sku ASC
Produces results like:
Item_Sku Quantity_Sol
Many thanks
I have checked out the mysql site and am starting to get my head around
it. How would I modify your query so that I had a clause that selected
in another value from another table?
Your suggestions have been most helpful
Lets say I had another table called others
And I wanted the query
Okay, I figured out the problem. Test cases will not pass if you
compile MySQL with the flag --with-libwrap, if you don't include
127.0.0.1 in the /etc/hosts.allow file. Even if you have your machine's
IP in there, you must also include the localhost IP as well. Oh, the
frustrations this cause
1 - 100 of 159 matches
Mail list logo
