hi
can anybody help me to check this query is written in good way
select ATX_Status.Server as `Server`, ATX_Status.Load as
`Load`,ATX_Status.System as `System`,
atx.ATX_Status.Timestamp as `TimeStamp`, `Coverage`,
atx.ATX_Summary.Testware as `View`, `Traffic`,
ATX_Status.Status as `Status`,
Sac,
this is like saying I have a pain, what can it be?
Attach more info if you hope in some help, at least the explain plan.
Cheers
Claudio
2010/1/13 F.A.I.Z.A.L sac.fai...@gmail.com
hi
can anybody help me to check this query is written in good way
select ATX_Status.Server as `Server`,
Manao ahoana, Hello, Bonjour,
I have LDAP entries, and SQL tables are the relation between them.
There are only relations between 2 entries.
There are modem and customers entries in the LDAP directory
I need advice on optimizing the way I store relations.
For example
SELECT * FROM
Hey
Nobody any ideas?
-Ursprüngliche Nachricht-
Von: Intell! Soft [mailto:intellis...@fachoptiker.net]
Bereitgestellt: Freitag, 08. Jänner 2010 11:06
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show Tables not working
Betreff: Show Tables not working
Hey
I try to
Mihamina Rakotomandimby miham...@gulfsat.mg :
Have you another way to do it?
- splitting the comma separated fields?
I mean:
customer_cn|customer_sn| customer_uid|modem_cn|modem_sn|modem_uid|
staff | (null) |(null) |staff | (null)| (null) |
Joe M |Mudd |
Try backticks.
On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft h.ba...@intelli-soft.atwrote:
Hey
Nobody any ideas?
-Ursprüngliche Nachricht-
Von: Intell! Soft [mailto:intellis...@fachoptiker.net]
Bereitgestellt: Freitag, 08. Jänner 2010 11:06
Bereitgestellt in:
i dont think my design is valid.
There should not be any SPACE for a db name.
On Wed, Jan 13, 2010 at 7:26 PM, Johan De Meersman vegiv...@tuxera.bewrote:
Try backticks.
On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft h.ba...@intelli-soft.at
wrote:
Hey
Nobody any ideas?
As I told, Backticks don't work.
But it is valid to use spaces in DB's because, mySQL Administrator can
handle it and my third party tool MySQL Maestro can also handle it. So,
when those two programs get the tables, then there has to be a solution
for it!?
THX
-Ursprüngliche
It is valid, it's just not a very smart thing to do, as various tools may
not be very happy about it.
On Wed, Jan 13, 2010 at 3:07 PM, Ananda Kumar anan...@gmail.com wrote:
i dont think my design is valid.
There should not be any SPACE for a db name.
On Wed, Jan 13, 2010 at 7:26 PM, Johan
Hi All,I want to implement MySQL Master Master
Replication. But I have read in the various documentation that in mysql
replication it is possible that I loose data.Is it also applicable to
MySQL Master Master Replication.
Thanks in advance.--Regards,
Manasi Save
Hi all,
I have a Linux server with MySQL 5.0 (5.0.67) installed.
In that server, I have a database that has a table with many fields (around 60).
It would be convenient for me to get a list of those fields ordered by
field / column name. Unfortunately, a DESC tablename (DESCRIBE
tablename)
Then you possibly aren't using backticks, because I just tested them :-)
On Wed, Jan 13, 2010 at 3:36 PM, Intell! Soft h.ba...@intelli-soft.atwrote:
As I told, Backticks don't work.
But it is valid to use spaces in DB's because, mySQL Administrator can
handle it and my third party tool MySQL
Hi Manasi,
As both are implemented by replication, there is a possibility for loosing
data.
Thanks
Suresh Kuna
MySQL DBA
On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I want to implement MySQL Master Master Replication. But I have read in
Yes, I am sorry, I didn't use Backticks.. - I used ' not `
THX - now it works!
-Ursprüngliche Nachricht-
Von: Johan De Meersman [mailto:vegiv...@tuxera.be]
Bereitgestellt: Mittwoch, 13. Jänner 2010 17:11
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show Tables not
It would be convenient for me to get a list of those fields ordered by
field / column name.
SELECT *
FROM information_schema.columns
WHERE table_schema='db' AND table_name='tbl';
PB
-
Ricardo Dias Marques wrote:
Hi all,
I have a Linux server with MySQL 5.0 (5.0.67) installed.
In that
At 07:00 AM 1/13/2010, F.A.I.Z.A.L wrote:
where (
ATX_Status.Status like '%running%' or ATX_Status.Status like '%queued%' or
ATX_Status.Status like '%migrating%' or ATX_Status.Status like '%loading%'
or
ATX_Status.Status like '%configuring%' or ATX_Status.Status like
'%activating%' )
It looks
At 08:36 AM 1/13/2010, Intell! Soft wrote:
As I told, Backticks don't work.
But it is valid to use spaces in DB's because, mySQL Administrator can
handle it and my third party tool MySQL Maestro can also handle it. So,
when those two programs get the tables, then there has to be a solution
for
Hello,
This is going to be a very odd question. I'm looking for a way to
purposefully corrupt a table. The reason behind this, is that I would like
to write a php script that will go through all databases/tables in the
environment, and find any tables that are marked as crashed/corrupt, so that
I have a script that does this. It goes through every table in every
database (excluding specific database like information_schema, etc) and
issues the command:
select 1 from db.tab limit 1;
At first, I only checked for the error code for a crashed table, but found I
had some other tables that
On Wed, Jan 13, 2010 at 1:14 PM, Jim Lyons jlyons4...@gmail.com wrote:
I have a script that does this. It goes through every table in every
database (excluding specific database like information_schema, etc) and
issues the command:
select 1 from db.tab limit 1;
Interesting. Would you mind
On Mon, Jan 11, 2010 at 3:21 PM, mos mo...@fastmail.fm wrote:
At 09:56 AM 1/11/2010, Johnny Withers wrote:
Victor,
The temporary table solution is not a good one. Use a single table and
store
each item put into a cart identified by the session ID of the user. A
process should clean out
January 13, 2010
PostgreSQL Conference East, The PostgreSQL Conference for Decision
Makers, End Users and Developers, is being held at the Radisson Plaza,
Warwick Hotel in Philadelphia on March 25th through 28th.
This is the second call for papers for this conference. You can review
the skeletal
The issue is that in theory this should work given the facts announced
by MySQL regarding binary logging and replication.
I can certainly do it the way you propose, but to my mind I should also
be able to do it using the fact that both machines are fully synced and
hence at
that point I should
No one designs a shopping cart system this way.
http://www.google.com/search?q=shopping+cart+database+table+design
If you are dead set on this crazy design it doesn't matter if you put the
temp tables in the main database or another database. It'll be just as silly
either way.
JW
On Wed, Jan
On Wed, Jan 13, 2010 at 2:33 PM, Johnny Withers joh...@pixelated.netwrote:
No one designs a shopping cart system this way.
http://www.google.com/search?q=shopping+cart+database+table+design
If you are dead set on this crazy design it doesn't matter if you put the
temp tables in the main
On 1/13/10 2:28 PM, Lawrence Sorrillo sorri...@jlab.org wrote:
The issue is that in theory this should work given the facts announced
by MySQL regarding binary logging and replication.
I can certainly do it the way you propose, but to my mind I should also
be able to do it using the fact that
On Jan 13, 2010, at 1:28 PM, Lawrence Sorrillo wrote:
The issue is that in theory this should work given the facts announced by
MySQL regarding binary logging and replication.
I can certainly do it the way you propose, but to my mind I should also be
able to do it using the fact that both
mySQL-5.1.34-osx10.4-powerpc-64bit
Not sure how this happened, but mySql will not start anymore, either
from the command line or the system pref control panel.
here's a startup sample: [I have blocked out the password]
Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/bin/
can you give us the error , it can be found on the file
/usr/local/mysql/data/Power-Mac-G5.local.err
Thanks
Anand
On Thu, Jan 14, 2010 at 9:49 AM, Chris Elhardt celha...@mac.com wrote:
mySQL-5.1.34-osx10.4-powerpc-64bit
Not sure how this happened, but mySql will not start anymore, either
Victor Subervi wrote:
You're so complimentary! Wouldn't it have been better to simply suggest FKs?
I think the reason the other poster was so harsh is because others have
suggested the right way to do it, if not in a lot of detail, and you
have just argued with them.
Since I'm not in
hi
anyone can help. its urgent. iam trying to start mysql server but it is not
starting.
bash-2.03# ./mysqld_safe
[2] 3422
bash-2.03# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/andd141.pid
100114 11:31:22 mysqld ended
log
31 matches
Mail list logo