es it go?
>
> Thanks,
> Scott
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 25, 2005 2:21 PM
> To: Brian Mansell
> Cc: mysql@lists.mysql.com; Scott Purcell
> Subject: Re: Fulltext Simple Qu
cell
Subject: Re: Fulltext Simple Question
Brian Mansell <[EMAIL PROTECTED]> wrote on 05/25/2005 03:09:03 PM:
> Scott -
>
> Check this excerpt out (
> http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL
> Documentation. I hope it helps!
>
> --bem
Brian Mansell <[EMAIL PROTECTED]> wrote on 05/25/2005 03:09:03 PM:
> Scott -
>
> Check this excerpt out (
> http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL
> Documentation. I hope it helps!
>
> --bemansell
>
> ...
>
> "Every correct word in the collection and in the q
Scott -
Check this excerpt out (
http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL
Documentation. I hope it helps!
--bemansell
...
"Every correct word in the collection and in the query is weighted according
to its significance in the collection or query. This way, a wo
Hello,
I am running 4.0.15 for Win95/98 and am working through the docs.
I created a "text" type field with a 'fulltext' index. As I am experimenting, I
have run into a couple of questions:
First off, I was having trouble getting results. So I added the word "foobar"
to one of the descriptions:
Hello.
Changing the basedir variable doesn't automatically changes the datadir
variable.
This can produce the problems. I've reported a bug:
http://bugs.mysql.com/bug.php?id=7873
You can use my suggested patch or specify the options in the option file. See:
http://dev.mysql.com/doc/
I've got a question the mysql.server script (came with 4.0.12 and 4.1.8
at with the Linux binary distribution) . My shell scripting knowledge is
not even good enough to be called 'limited', but here goes:
I'm trying to use mysql.server (Redhat 9) to start MySQL in a
non-standard location.
On
Carlos Sunden <[EMAIL PROTECTED]> wrote:
>
> "InnoDB is included in binary distributions by default as of MySQL 4.0."
>
> Hello
>
> Is InnoDb always used when installing MySQL whether RPM or binary is used?
Yes.
If you don't need InnoDB, start MySQL server with --skip-innodb option.
>
> I am
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 June 2004 10:43 am, Carlos Sunden wrote:
> I am not completely sure what this is although I've read about it.
www.innodb.com.. Gives you all the info you can handle.
Jeff
- --
Not quite human any longer.
-BEGIN
"InnoDB is included in binary distributions by default as of MySQL 4.0."
Hello
Is InnoDb always used when installing MySQL whether RPM or binary is used?
I am not completely sure what this is although I've read about it.
Thanks!
Carlos
-
D
"adrian Greeman" <[EMAIL PROTECTED]> wrote:
> There is a particular form of SQL query you can use I believe when you
> are adding data to a table and want to include an ID number from another
> lookup table but you only know the name reference and not the ID
>
> eg it might be an "author" table wi
017
-Original Message-
From: adrian Greeman [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 1:12 AM
To: [EMAIL PROTECTED]
Subject: simple question on WHERE SELECT query
There is a particular form of SQL query you can use I believe when you
are adding data to a table and want to include an
There is a particular form of SQL query you can use I believe when you
are adding data to a table and want to include an ID number from another
lookup table but you only know the name reference and not the ID
eg it might be an "author" table with an author_id and author_name and
you want to enter
You can install MYSQL on your Windows machine and use this user interface
for managing the database http://www.mysql.com/downloads/mysqlcc.html
From: "Dusan Spisak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Just simple question...
Date: Fri, 06 Feb 2004 16:03:23
Hi,
Am Freitag, 6. Februar 2004 16:03 schrieb Dusan Spisak:
> Hello everybody!
>
> I need to create some simple database. I've started to build it up in
> Microsoft Access. MS Access was really great for me, it was very easy and
> user friendly, intuitive. Without any manual I've managed to create
Hello Dusan:
MS Access is actually a user front end and not a database engine at all.
Many people don't understand this. A front end talks to a database
engine, known as a data source in the lingo. MS Access defaults to
using one of Microsoft's databases, I believe it is called jet or
someth
From: Dusan Spisak [mailto:[EMAIL PROTECTED]
> Here is my question:
> Is it possible to use MySQL in the similar way to Access?
> Without any servers and administration and clients and
> controlcenter...? I don't need any network at all, I just
> would like to create and run some small database
bit of a learning curve to start with, but if you are in I.T.
professionally it's a good thing to have in your toolbox.
From: "Dusan Spisak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Just simple question...
Date: Fri, 06 Feb 2004 16:03:23 +0100
Hello everyb
Hello everybody!
I need to create some simple database. I've started to build it up in Microsoft
Access. MS Access was really great for me, it was very easy and user friendly,
intuitive. Without any manual I've managed to create a table, to create some views and
queries and to prepare reports f
Benjamin PERNOT wrote:
I want to get a list of all the parents with the age and the name of the older
child they've got. Let's say that a parent can't have 2 children with the same
age.
I can solve my problem by using multiple queries but that's not very clean and a
bit heavy (especially if the
Hi,
I have a simple problem that I don't know how to solve with mysql.
I have 2 tables, a parent table and a child table.
parent:
---
| p_id | name |
---
| 1| A |
| 2| B |
| ... |... |
| 112 | C |
| 113 | D |
Yes it is correct, but please don't hijack someone else's thread.
Admin-Stress wrote:
I have a numeric table field, named "CREDIT".
How can I add a number (+50) to that field for all the table record ?
is this correct
UPDATE ThisTable SET CREDIT=CREDIT+50
Please help,
Thanks
___
I have a numeric table field, named "CREDIT".
How can I add a number (+50) to that field for all the table record ?
is this correct?
UPDATE ThisTable SET CREDIT=CREDIT+50
Please help,
Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuar
On 24-Jun-2003 Fred Whipple wrote:
> Don't forget to use '-B' in order to make the output silent except for
> the results:
>
and -N to suppress column names.
> 2. you should stick your password (which shouldn't match
> your UNIX password) in a textfile readable only by you so that
Joseph Bueno wrote:
Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the
result of a SQL statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB << EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
But this is mor
On Mon, Jun 23, 2003 at 06:37:17PM -0500, Zach wrote:
>
> I am writing a shell script using Born Shell. I am trying to get the result of a SQL
> statement into a variable.
You mean Bourne shell.
> For example:
>
> /usr/bin/mysql -uroot -prootpass BOB << EOF
> SELECT * FROM Bobstable WHERE Name=1
Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the
result of a SQL statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB << EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
Thanks in advance!
May be:
myva
I am writing a shell script using Born Shell. I am trying to get the result of a SQL
statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB << EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
Thanks in advance!
At 16:58 -0400 6/6/03, Vivian Wang wrote:
I have three files which are .frm, .MYD and .MYI.
How I can use those three files become one table again?
Thanks.
They already are one table. You don't need to do anything.
MySQL implements each MyISAM table using three files.
This is normal.
--
Paul DuBoi
I have three files which are .frm, .MYD and .MYI.
How I can use those three files become one table again?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I know that the file size limit for mySQL tables is
limited by the operating system. I want to confirm
that this is not a database size limit. Pardon my
being a novice, but I just want to be sure.
Thanks for the help, Joe
__
Do you Yahoo!?
Yahoo! We
order by date_format(mydate,'-mm-dd') desc
-Original Message-
From: Carter, Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 11:30 AM
To: 'Doug Durham'; '[EMAIL PROTECTED]'
Subject: RE: simple question
The problem is the command is no
-
From: Doug Durham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 11:59 AM
To: Carter, Scott
Subject: RE: simple question
Since the default ORDER BY is ascending, and you want the most recent
first, have you tried
...
ORDER BY lastused DESC
- Doug
At 11:37 AM 11/19/2002 -0600
At 11:37 -0600 11/19/02, Carter, Scott wrote:
There might be ten different records with a fname of scott and the dates
might be 2002-11-18, and 2002-11-10 and 2002-10-15. When the query results
are returned the ORDER BY clause seems to have no effect on the results. I
would want the record with
queryed I need to show the newest user
first.
Thanks - Scott Carter
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 9:46 AM
To: Carter, Scott; '[EMAIL PROTECTED]'
Subject: RE: simple question
At 9:06 -0600 11/19/02, Carter, Scott w
ith "scott" and
in what order are they returned?
Thanks - Scott Carter
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 5:51 PM
To: Carter, Scott; '[EMAIL PROTECTED]'
Subject: Re: simple question
At 17:19 -0600 11/18/02
nt: Monday, November 18, 2002 5:51 PM
To: Carter, Scott; '[EMAIL PROTECTED]'
Subject: Re: simple question
At 17:19 -0600 11/18/02, Carter, Scott wrote:
>I want to sort my results by a date that is contained in the database table
>the query is performed on. The ORDER BY clause does
At 17:19 -0600 11/18/02, Carter, Scott wrote:
I want to sort my results by a date that is contained in the database table
the query is performed on. The ORDER BY clause does not seem to do the
trick. How do you do this?
Thanks - Scott Carter
With ORDER BY. You'll have to provide more details
I want to sort my results by a date that is contained in the database table
the query is performed on. The ORDER BY clause does not seem to do the
trick. How do you do this?
Thanks - Scott Carter
-
Before posting, please che
* Simon Green
> After running this simple question I get this error. I have looked at the
> my.cnf file and all looks fine and the system has 1.256 G of memory.
> Can some one please tell me where I have gone wrong.
>
> select in_names.Username
> from in_names,
Thanks for this...
So I think I need some joins!
Simon
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: 24 June 2002 12:19
To: Mysql (E-mail)
Cc: Simon Green
Subject: Re: Out of memory on simple question.
* Simon Green
> After running this simple questio
Hi
After running this simple question I get this error. I have looked at the
my.cnf file and all looks fine and the system has 1.256 G of memory.
Can some one please tell me where I have gone wrong.
select in_names.Username
from in_names, in_names2
where in_names.Username != in_names2
Why do you want to restrict the names to be unique?
//Anders - SQL, QUERY
-Original Message-
From: Shaun Bramley
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 3-5-02 20:16
Subject: Re: Simple Question relating to Indexing
I'd like to first thank Carl and Anders for
hno-Mage
* http://www.calevans.com
*
-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 1:17 PM
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Subject: Re: Simple Question relating to Indexing
I'd like to first thank Carl and Anders for your quick
Sent: Friday, May 03, 2002 1:11 PM
Subject: RE: Simple Question relating to Indexing
> > Hello all being relatively new on the SQL scene I must say some of the
> > concepts are a little new and strange to me. My really big question is
what
> > is the difference between an index
> Hello all being relatively new on the SQL scene I must say some of the
> concepts are a little new and strange to me. My really big question is what
> is the difference between an index and a key? are the synonamous with each
> other?
A key will identifying a row or several rows. Just like yo
zations but they should help you. Or not...
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 10:45 AM
To: [EMAIL PROTECTED]
Subject: Simple Question relating to Inde
Hello all being relatively new on the SQL scene I must say some of the
concepts are a little new and strange to me. My really big question is what
is the difference between an index and a key? are the synonamous with each
other?
Thanks in advance
Shaun Bramley
query
mysql
---
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 11:02 AM
To: [EMAIL PROTECTED]
Subject: simple question on joining tables
Hi everyone,
I am starting my first mySQL project .
I want to create 2 tables
Table User : userId , FisrtName, LastNAme, Gender with userId
Hi everyone,
I am starting my first mySQL project .
I want to create 2 tables
Table User : userId , FisrtName, LastNAme, Gender with userId defined as
the primary key that auto-increments
I want that each time I insert a new row in this table, the field "userId" is
inserted as well in anoth
* Michael Ayres
> +---+---+
> | a | b |
> +---+---+
> | 1 | 1 |
> | 1 | 2 |
> | 2 | 2 |
> | 3 | 1 |
> +---+---+
>
> I would like to retrieve the set of all a where b !=2
> so in the above example, only 3 would be returned...
Use a LEFT JOIN:
SELECT t1.*
FROM t1
LEFT JOIN t1 AS t2 ON
hey all,
using mysql ver 3.23.36
got stuck with something, here's a simplified example of it:
+---+---+
| a | b |
+---+---+
| 1 | 1 |
| 1 | 2 |
| 2 | 2 |
| 3 | 1 |
+---+---+
I would like to retrieve the set of all a where b !=2
so in the above example, only 3 would be returned...
but a simple
othe
table?
David
>
>
> Hello,
>
> I have a relatively simple question to ask. Any help is
> great appreciated.
>
> Let us say that I want to create a classic table
> that would have columns for a persons name, eye color,
> age, etc.
>
> However, I al
Hello,
I have a relatively simple question to ask. Any help is
great appreciated.
Let us say that I want to create a classic table
that would have columns for a persons name, eye color,
age, etc.
However, I also want to store a list (somewhere) of that particular
persons favorite foods
At 2:17 PM -0400 6/1/01, Peter H. Burris wrote:
>I know that when it comes to deleting users from the user table, I could
>revoke all privileges and use an SQL 'delete from' command, but I wonder
>if there's an easier script/method for dropping a user? I've been combing
>the manual for a couple d
[EMAIL PROTECTED]>
Sent: Saturday, June 02, 2001 2:17
Subject: deceptively simple question
> I know that when it comes to deleting users from the user table, I could
> revoke all privileges and use an SQL 'delete from' command, but I wonder
> if there's an easier script
I know that when it comes to deleting users from the user table, I could
revoke all privileges and use an SQL 'delete from' command, but I wonder
if there's an easier script/method for dropping a user? I've been combing
the manual for a couple days and while I can create users and grant/revoke
pr
At 19:31 17-4-01 +0100, John Dean wrote:
>Hi
>Did you leave an old version of the shared libs lying around?
The old version is packed with PHP..
Bye,
B.
query sql
-
Before posting, please check:
http://www.mysql.com/manu
Hi
Did you leave an old version of the shared libs lying around?
At 10:16 17/04/2001 +0200, Administrator wrote:
>I've installed Mysql server version 3.23.36 from source distribution
>(*.tar.gz). When I show the php4 credits () in my browser
>it shows:
>MySQL Support enabled
>Active Persistent Li
>Why it display other version of client api than I install.
>
>It would be nice that You answer me.
Did you compile PHP with --with-mysql=/path/to/mysql
Bye,
B.
-
Before posting, please check:
http://www.mysql.com/manual
I've installed Mysql server version 3.23.36 from source distribution
(*.tar.gz). When I show the php4 credits () in my browser
it shows:
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.22-beta
Why it display other version of client api than I install.
It w
Simple question: I can't find the latest binary for mysql 3.23.x for Solaris "Intel"
version. Can someone tell me if they even have a Intel version of 3.23???
Technology Consultant
310-426-5619 (h) / 888-431-7571 (p)
http://www.access1.net/esteban1
Does anybody know the *proper* way to use 'ignore' in
load data infile? The manual is no help, and when I use:
Load Data Infile (Path to file/file.txt) ...ignore or whatever I tried,
I get an error mentioning duplicates (Might be the result of primary key)
The point is, I want to create a table
to the server, it
> won't let me in. Do you think I should do that first?
>
> Thanks for your time
>
> Joel
> - Original Message -
> From: kentj <[EMAIL PROTECTED]>
> To: Joel Holtzman <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, Fe
A gui that works on the linux box is kmysql.
Joel Holtzman wrote:
> Hello, I always wanted a gui interface to use on my win 98 pc to connect
> to mysql, and create/edit tables. However, i always get an access denied
> error, saying I'm not allowed to connect to the mysql server.
>
> However,
Joel Holtzman wrote:
>
> Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql,
>and create/edit tables. However, i always get an access denied error, saying I'm not
>allowed to connect to the mysql server.
>
> However, via telnet, I am fine.
By default MySQL serve
Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and
create/edit tables. However, i always get an access denied error, saying I'm not
allowed to connect to the mysql server.
However, via telnet, I am fine.
The support for the software sucks, and all the other
Hello, and thanks for your time.
Basically, I am using telnet to create tables/columns, and all is ok, except
I do not know the correct syntax for using blob text.
For example, if I create a table named 'members' with id/name/description
it would look like:
CREATE TABLE movieform (
I
Nick Gianakas wrote:
> Hi all,
>
> I just started learning mySQL yesterday. I'm using it for a web application
> (simple CGI stuff).
>
> To begin, I wrote a simple program that just initializes a mySQL connection
> and then closes it.
>
> Here's my problem:
> I'm getting compile errors when I li
Hi all,
Sorry if the list receives this twice--I posted before confirming my
subscription.
I just started learning mySQL yesterday. I'm using it for a web application
(simple CGI stuff).
To begin, I wrote a simple program that just initializes a mySQL connection
and then closes it.
Here's my p
Hi all,
I just started learning mySQL yesterday. I'm using it for a web application
(simple CGI stuff).
To begin, I wrote a simple program that just initializes a mySQL connection
and then closes it.
Here's my problem:
I'm getting compile errors when I link the libmysqlclient.a archive to my
p
71 matches
Mail list logo