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
Hi,
Thank you very much that was what I looking for.
Best regards,
Cristi
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
iNFERNo <[EMAIL PROTECTED]> writes:
Hi,
First of all thank you all for the quick replys.
Now here's:
select * from events limit 10;
+--+---
In article <[EMAIL PROTECTED]>,
iNFERNo <[EMAIL PROTECTED]> writes:
> Hi,
> First of all thank you all for the quick replys.
> Now here's:
> select * from events limit 10;
> +--+--
> --+++--+-+---+--+---+--
>
> +
> | id |
nal 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: "iNFERNo" <[EMAIL PROTE
- 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
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
$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
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 or CGI but if some one tell
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 incorporate the scri
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
48 matches
Mail list logo
