If you are brand new to mysql, you do not want to start with the
cluster. Try the community server distro instead:
here is a link to the 64-bit generic linux version:
http://dev.mysql.com/downloads/mirror.php?id=401067#mirrors
On Thu, Feb 10, 2011 at 10:33 AM, rohit bishnoi wrote:
> *hello ev
*hello everyone on list*
*i am a student of MCA and want to learn mysql. i have installed
"mysql-cluster-gpl-7.1.4b-linux-i686-glibc23" binary distribution on my
fedora 14 system. the installation process have gone OK according to steps
listed in distribution's installation file.*
*
*
*But when i
i asked about this once upon a time, and might need a little more
help here. a friend's mysql hosting provider lost an entire DB, but
has managed to recover and hand over the "ibdata1" file (or at least
some portion of it).
when my friend popped into mysql, what he's seeing is that some of
t
hink is the best and I would like some
help so I can improve my skills.
P.S.:A related problem is that for a user_id that has none events
closed with ev_status=1 it's not listed in the query.
Try something like
SELECT user_id,
sum(CASE ev_status WHEN 0 THEN 1 ELSE 0 END),
of
using a DATE column?
> I need to get a report out of the DB that will show me for each
> user_id how many events(count) are closed with the ev_status=0,
> ev_status=1 ..., ev_status=6. Like I've said before the way I am
> getting the date now I dont think is the best and I
nd I would like some help so I can improve my
skills.
P.S.:A related problem is that for a user_id that has none events closed
with ev_status=1 it's not listed in the query.
SELECT user_id,ev_status,COUNT(*) from events WHERE user_id='abc' and
ev_st
- Original Message -
From: "Michael J. Pawlowsky" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
> Rhino wrote:
>
> >- Original Message -
> >From: &qu
Rhino wrote:
- Original Message -
From: "iNFERNo" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a databa
- Original Message -
From: "iNFERNo" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
> Hi,
>
> I have a problem: I am using mysql 4.0.24 and I need to make
> some reports from
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql> describe events;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--
> Create composite index on (cat, date). Use EXPLAIN to see if MySQL uses
index:
> http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
This partially solved my problem. Thanks a lot. However I am facing a new
problem here.
The query where I am ordering by a column is much more slowly than the same
que
On 13 Jan 2004, at 19:11, Jochem van Dieten wrote:
I most certainly hope this Oracle idiosyncracy will never make it into
MySQL.
The SQL standard defines a different syntax for doing recursive
queries, using WITH RECURSIVE. I see no reason for MySQL to implement
a non-standard way for doing recurs
more on nested set models.
Cheers,
Matt
-Original Message-
From: Steve Folly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 1:59 PM
To: MySQL MySQL
Subject: Re: hierarchical records, I need some help!! ;(
On 13 Jan 2004, at 09:19, Victor Reus wrote:
> Hi again,
>
>
>I want to have all the items into a recorset with only one query like
>Select id, reference, component from NOMS where reference = '4'
>but i want not only the primary relations, i want all relations.
>Could somebody help a newbie like me?
It can also help to change the way you look at the r
Steve Folly said:
>
> However, I suspect this isn't the full story. Do you also want to
> see what components make up C003 and D003 in the same query? I
> think you're after a feature not yet implemented in MySQL - the
> 'CONNECT BY PRIOR' SELECT statement, just the ticket for
> hierarchical que
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify what you mean with "all relations". Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | a
Hi again,
> Second: specify what you mean with "all relations". Can you
> share some sample data and sample output (that is: what
> do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | auto_increment
| reference| varchar(255) |
Victor,
First: don't ask the same thing twice.
> I have one table called noms like this:
>
>
> | id | int(11) | | PRI | [NULL] | auto_increment |
> | reference| varchar(255) |
> | component| varchar(255) |
>
> the relation between reference and component is hierarch
Hi
I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment |
| reference| varchar(255) |
| component| varchar(255) |
the relation between reference and component is hierarchical like
reference - > component
reference
Hi
I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment |
| reference| varchar(255) |
| component| varchar(255) |
the relation between reference and component is hierarchical like
reference - > component
reference
* Elisenda
[...]
> So, the good way to write joins will be as follows, doesn't it?
>
> FASE.SQL_ID_CE=CA.CA_ID_CE AND
> FASE.PR_PP_ID_COORD=PP.PP_ID_PP AND
> CA.CA_ID_CE=CE.CE_ID_CE AND
> FASE.AU_PR_AULA=AU.AU_AULA
Those are the exact same criteria as you had, only in a different order,
isn't it?
Roger,
> * Elisenda
> [...]
>> The explain select says as follows:
> [...]
>
> I re-formatted the query and the EXPLAIN output for readability:
Sorry for not re-formatted the query, I've learn it for next time.
Well, I've learn a lot with your lessons.
>
> Select FASE.PR_Date_Visita_2, CE.CE_
* Elisenda
[...]
> The explain select says as follows:
[...]
I re-formatted the query and the EXPLAIN output for readability:
Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio, CE.CE_CP,
CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV, CE.CE_CCAA,
CA.CA_Horario,
PP.PP_Contacto, PP.PP_C
Roger,
Your help was fantastic. It seems that it goes better. At the end I achieve
some result but not all I need.
The explain select says as follows:
EXPLAIN Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio,
CE.CE_CP, CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV,
CE.CE_CCAA,CA.CA_Hora
* Elisenda
> The problem is that it 's too slow and the result doesn't appear.
> I am going to try to explain the query.
Please do that using the EXPLAIN SELECT statement:
http://www.mysql.com/doc/en/EXPLAIN.html >
This will show what index is beeing used on the different joins, and
approximatel
I'm sorry I didn't explain anything.
The problem is that it 's too slow and the result doesn't appear. I am going
to try to explain the query.
Fields from Table FASE: (300.000 records)
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
SQL_ID_PY char(6),
SQL_ID_CE char(6),
PR_flag INT,
PR_Date_Visita
it would help alot if you dump the table structure for us
- Original Message -
From: Elisenda
To: [EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 7:10 PM
Subject: Some help with a complex query
I have a query which tries to select different fields from 5 different
* Elisenda
> I have a query which tries to select different fields from 5 different
> tables.
>
> In WHERE part I have write all the conditions and relationships.
> Perhaps two many.
Joining 5 tables should not be a problem, but having indexes on the relevant
columns may be essential, especial
I have a query which tries to select different fields from 5 different
tables.
In WHERE part I have write all the conditions and relationships. Perhaps two
many.
The main table for me is FASE. From this table I try to find all the other
information.
I guess I'm doing something wrong but I d
I'm trying to write a Delphi program that accesses a MySQL database via
MyODBC. It's going pretty well except for a sticky problem I'm having with
an unsigned integer column.
I have a column named 'IP', type unsigned integer, that will hold IP
addresses. However, Delphi seems to assume this colu
L Mailinglist
Subject: RE: little problem, I need some help...
Every SQL database requires the ability to locate a record which is
unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to r
hello everyone:
1) in my school groups are called forms, so I used it not to confuse you
2) I hadn't learnt how to define indexes on MySQL so I hadn't defined any
3) now I have, and...
4) the query worked.
thanks for your help,
Emilio Pisanty
e-
> From: 3mip1s4la-Emilio Pisanty [mailto:emipisala@;lancaster.edu.mx]
> Sent: Sunday, 10 November 2002 11:34
> To: R. Hannes Niedner
> Cc: MySQL Mailinglist
> Subject: Re: little problem, I need some help...
>
>
>
> > > tables have met with a 1175 error ("You
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote:
>
> > > tables have met with a 1175 error ("You are using safe update mode and you
> > > tried to update a table without a WHERE that uses a KEY column").
> > Nothing is obvious and is hard to advise you if you don't give us some more
>
lt;[EMAIL PROTECTED]>
To: "R. Hannes Niedner" <[EMAIL PROTECTED]>
Cc: "MySQL Mailinglist" <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 12:34 AM
Subject: Re: little problem, I need some help...
>
> > > tables have met with a 1175 error (&quo
> > tables have met with a 1175 error ("You are using safe update mode and you
> > tried to update a table without a WHERE that uses a KEY column").
> Nothing is obvious and is hard to advise you if you don't give us some more
> info on the table structure and the update query you have trouble wi
On 11/9/02 3:14 PM, "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]>
wrote:
> hello everyone:
>
> to begin with, I apologise for asking a question which is probably
> obvious. My name is Emilio Pisanty and I and one of the two makers of my
> school's website. recently we updated the database system
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on mysql) from
version 3.23 to version 4. since then, any attmepts we've made t
sachin,
Friday, August 30, 2002, 10:30:47 AM, you wrote:
ss> Description:
[skip]
ss> I got this
ss> MySQL-3.23.52-1
ss> That means mysql is installed successfully.
ss> What is the step by step procedure for post
ss> Installation configuration of MySql server?
Check chapter "2.4 Post-install
From: root
To: [EMAIL PROTECTED]
Subject: I need some help in MySql installation
Description:
I tried to install MySQL,version :- MySQL-3.23.52-1
using RPM which I downloaded from mysql website. I
copied it in my root directory i.e. [root@FireWall2
/root]
My machine name is
le or type mysqlhotcopy without any parameters and see if it
gives you some help. Shouldn't be too hard to figure out.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
dnesday, June 05, 2002 12:25 PM
>To: [EMAIL PROTECTED]
>Subject: Looking for some help
>
>I am running MySQL 3.23 on WIN 2k server and would like to create
a daily
>scheduled task that will utilize mysqlhotcopy (or other back up
method) to
>back up my db. I understand that I need
-Mage
* http://www.calevans.com
*
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 12:25 PM
To: [EMAIL PROTECTED]
Subject: Looking for some help
I am running MySQL 3.23 on WIN 2k server and would like to create a daily
scheduled task that
I am running MySQL 3.23 on WIN 2k server and would like to create a daily
scheduled task that will utilize mysqlhotcopy (or other back up method) to
back up my db. I understand that I need to create a .BAT file that contains
the command to run hotcopy but I'm a bit confused as to the syntax. What
> I want to know what is the stable version of MySQL in XP.
That's 3.23.49, and you can download it here ('Windows downloads'):
http://www.mysql.com/downloads/mysql-3.23.html
Greetings
Reto Baudenbacher
-
Before posting, ple
Dear Helpinghand,
I am a new user of MySQL and my new operating system is WinXP. I want to
know what is the stable version of MySQL in XP. So if anyone know this
please help me.
I'm looking forward hearing from you.
Khyrul Islam
---
$retval = .= " ".
"- ".$a["title"]."";
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: need some help...
Hey Guys,
I need help indentifiying why I have an
ntax - I never use printf, so mine is probably wrong, but
that's the problem.
- Jonathan
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 1:46 PM
To: [EMAIL PROTECTED]
Subject: need some help...
Hey Guys,
I need help indentifiying wh
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=mysql_fetch_array($r)) {
$retval.=" - %s",$a["url"],$a["picurl"],$a["url"],$a["title"])";
}
It just gives me a parse error on the page for the $retval. = line
Thanks!
-
i have Mac OS X Server and i think MySQL is preinstalled, but it's not
running so i tried to start it and got the typical socket error 2002.
then i tried this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon wit
i have Mac OS X Server and i think MySQL is preinstalled, but it's not
running so i tried to start it and got the typical socket error 2002.
then i tried this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon wit
Hi there,
I've been trying around for some time now and i just don't see a solution to
my problem:
I have a table called "feiertage" ("Holidays"):;
mysql> select * from feiertage;explain feiertage;
++
| datum |
++
| 2001-12-24 |
| 2001-12-25 |
| 2001-12-26 |
| 2002-0
I was wondering if anyone could help me converting some PostgreSQL
queries with sub-queries into a similar form usable (hopefully) by both,
or at least into a form that I can use in place of the PostgreSQL ones.
I'm going to post them - I hope no one minds. If this is the wrong
mailing list for
mysql must own the database directories.
chown -R mysql /var/lib/mysql
( or whatever the database directory is )
Mike Eggleston wrote:
> Folks,
>
> I know I am new here, and I really need your help. You see, the MySQL
> server is saying that it cannot find the host.frm file. Now, I can see i
Folks,
I know I am new here, and I really need your help. You see, the MySQL
server is saying that it cannot find the host.frm file. Now, I can see it
clear as day, and I think that I have the configurations correctly. However
I really am a programmer, not a server admin. Could someone out th
MySQL Support:
I need some help about import data of Microsoft SQL
Server to MySql Server 3.23.39. Please, send me more information about it, thank
you for all
>From: [EMAIL PROTECTED]
>To: "saraswathy saras" <[EMAIL PROTECTED]>
>Subject: Re: some help in PHP
>Date: 19 Jun 2001 09:22:42 -
>
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass th
Kyzen Computers wrote:
>
> I was wondering if someone can help me, I am new to the list and was looking for
>some help on how I can use mysql with my website to keep track of who comes in and
>giving them logins
>
> I have just read mysql and don't know anything PHP
I was wondering if someone can help me, I am new to the list and was looking for some
help on how I can use mysql with my website to keep track of who comes in and giving
them logins
I have just read mysql and don't know anything PHP or CGI but if some one tells me how
to incorporat
Just my opinion, but I prefer numeric keys that the users *can't*
see, to alpha keys that the users can see:
1. numeric keys are faster
2. using numeric keys that the user can't see allows you
to open up(for UPDATE) ALL the fields that the user can see
including a field like School N
Think of the tables in your database as linked sets.
I have a college database where school description as info associated
in three other tables, allowing one school description, one or more
contacts, requirements for one or more programs, and each program has
one or more degrees associated, i
Hello,
I tend to do either what Hardy suggested depending on the needs of your
database. If the trouble ticket table is to be associated with both
faculty and staff, and that fac/staff can have more than one trouble
ticket I like to create a relational table.
To do this you create a separate ta
Try going to www.mysql.com and search for "foreign key" in the
search box - I found 28 matches - here are the 1st 3 matches:
1. MySQL Manual | 5.4.5 Foreign Keys [4]
2. MySQL Manual | 5.4.5.1 Reasons NOT to Use Foreign Keys constraints [4]
3. MySQL Manual | 9.3.6 Using Foreign Keys [4]
make sure
that no bad data gets put in them though.
Cal
http://www.calevans.com
-Original Message-
From: Chris Toth [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 9:56 AM
To: MySQL List
Subject: need some help here...
I'm having a extremely hard time grasping the
I'm having a extremely hard time grasping the concept of multiple tables. So
far, I've been using just one table when designing a database. But now I
have to design a database for a trouble-ticket system for our department.
I've written out the design of the tables, but the part I don't understa
Maybe you should read the manual for the answer! It is well explained under
Limitations!
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> "Rih Naoufal" <[EMAIL PROTECTED]> 2001/01/18 01:45:07 >>>
i have a problem using mysql
queries like = "select id from table1 where id in (select id2 from table2)"
i have a problem using mysql
queries like = "select id from table1 where id in (select id2 from table2)" doesn't
seem to work in the mysql version i have .
if anyone knows how to resolve the problems, please reply to my message
thank u all
67 matches
Mail list logo
