rory oconnor inquired:
> I have a new client that wants to use filemaker on his mac to enter data
> for site information. I'm sure that I can take that and export the
> files and import into the site's MySQL database...but I'm wondering if
> it is possible to link his filemaker database to the My
David Yee queried:
> Hi. How can I import a text file containing all fixed-length records into
> MySQL? Is there a way to do it with LOAD INFILE? The text file was
> originally designed for import into Oracle. Thanks.
http://www.mysql.com/doc/ 'import'
http://www.mysql.com/doc/m/y/mys
Jeff Habermann asked:
> well. Now, because of this deletion, there are sequence gaps in the "idx"
> field. We would like to be able to use those numbers again for incoming
> clients...Is this possible?
It looks like you can, but IMHO, it would probably be more effective to add
a DELETED flag to
Hi all,
I have installed a clean RedHatLinux 7.1, and 7.2, and have selected
the PHP and mysqlshare components to install. I also have configured the
httpd.conf to use the php modules with Override ALL option. But when I want
to run any php, including the one that need to access the mysql serv
Depends on the language you are writing in, and the level of your
programming skills.
If your users/guests have database entries, it would be a rather trivial
task to set their timezone in a column in the database, then write your app
to calculate their local time based on the offset from GMT. Yo
Subject: database design
From: "deco" <[EMAIL PROTECTED]>
===
I'm having a problem getting this to fit...
I have a file with a bunch of data stored... This data represents messages,
one after the other, with message header followed by message data.
I'm porting this to a mysql database. The thin
*** WYSYŁKA JEDNORAZOWA - PRZEPRASZAMY JEŻELI NIE TRAFILIŚMY W PAŃSTWA ZAINTERESOWANIA
***
Wraz z najlepszymi życzeniami świątecznymi przekazujemy za pośrednictwem Państwa konta
e-mail ([EMAIL PROTECTED]) krótki przegląd atrakcji z naszej oferty:
1. Dla Twojego DOMU I RODZINY proponujemy proje
I have a question about determining which case
occurred when there are no matches - using two tables.
Scenario:
- two tables, one for photos, and one for collections
- zero or more photos can belong to a collection
- the database may not know the collection_id requested
(i.e. the user on th
What i want to do seems simple, but i can not for the life of me figure out
how to do it.
Tables: These tables are not related in any way.
A
--
1
2
3
4
5
B
--
1,Bob
3,Jack
7,Janet
8,Gary
9,Kelly
I would like to combine tables A and B with a SELECT statement to get this:
SELECT
--
1,1,Bob
Hello Gerald,
But how people build web-applications then ? How can you use
web-hosting in GMT+1 if web-application will be in use in GMT+5 for
example?
Have anybody an experience of resolving this problem (without
embedding this functionality to backend app, because backend app is
allready contai
Hello Gerald,
But how people build web-applications then ? How can you use
web-hosting in GMT+1 if web-application will be in use in GMT+5 for
example?
Have anybody an experience of resolving this problem (without
embedding this functionality to backend app, because backend app is
allready contai
Per client? Per database? The only timezone setting in the MySQL manual is
for the server (tz), and permits you to set it to your local timezone so it
does not return values in GMT.
If you want clients to have different timezones, perhaps you should write
that capabilty into your front-end applic
I have a new client that wants to use filemaker on his mac to enter data
for site information. I'm sure that I can take that and export the
files and import into the site's MySQL database...but I'm wondering if
it is possible to link his filemaker database to the MySQL database
using ODBC? I hav
Hello mysql,
So nobody here (even at MySQL AB) knows how to set a timezone for a
MySQL client ? Not for whole server but per client? (or maybe for
database???)
I already posted this question here few days ago - and didn't get any
reply.
Please! Somebody help!
--
Best regards,
Maxim
On Thu, Mar 28, 2002 at 09:37:47AM +0300, Peter Zaitsev wrote:
> Also a good thing with DRBD you will not have to store and track
> replication log files and the setup will not require to take MySQL
> down to copy the snapshot of database.
Why would you need to take down MySQL for a backup (assu
Hi. How can I import a text file containing all fixed-length records into
MySQL? Is there a way to do it with LOAD INFILE? The text file was
originally designed for import into Oracle. Thanks.
David
-
Before posting, please
This is my first time posting to this list, so please forgive me if I am not
doing this correctly. I will break this into post into two parts: what i
want to know and why. Is there a way to get auto_increment fields to fill
in gaps in the numbering sequence if some records have been deleted?
He
Ian Linekrans <[EMAIL PROTECTED]> writes:
> Hi All !
> The configuration:
>
> - Redhat 7.2 (Enigma) pre-build installation.
> - Mysql with the following rpms installed:
> MySQL-3.23.49a-1.i386.rpm
> MySQL-client-3.23.49a-1.i386.rpm
>
> The installatio
Hi all,
I have a uge table data about 700mb pii 333 200mb ram. mysql 4.02.
I try to add a full text index
alter table listing add fulltext (about,title,description);
but it seems to do noit effect the ib files in the datadir seems to keep the
same length no grow.
when querying it say no full tex
Joe,
Replication is pretty much instantaneous (depending on network speed),
since the servers communicate using the binary log files. Having said that,
there is no replication scheme for any database product that can guarantee
(over asynchronous replication) that some data won't be lost or m
At 06:20 AM 3/28/2002, you wrote:
>On 27-Mar-2002 Ken Anderson wrote:
> >
> >
> >
> >
> >
> > What is the fastest way to check if a table exists?
> > Do a select and catch the error?
> > Try to create the table, and catch the error?
> > Other options?
> > Thanks,
> > Ken
>
>Yes, in php:
>
>
Let's say A and B are running together.
Then someone does a large update query and A is done with, while B is in
the middle of it, and A crashes.
You can switch over to B, which won't contain the data, but it'll have a
good snapshot of what the data was before the crash.
When you recover the A
I don't think mysql has a feature like that. Check the manual at
www.mysql.com.
I think you will need to make another table to count the hits per category.
Then do a join between the two tables to get the results you want.
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]
Hi all,
I make a huge sql dump to mysql client
ie :
mysql < dump.sql
the dump.sql is nearly 650 MB.
I get some strange file near my table files :
12 -rw-rw1 mysqlmysql8678 mar 28 22:26
/var/lib/mysql/doz/#sql-9a8_17.frm
63428 -rw-rw1 mysqlmysql64880640
Ok thanks guys.
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimite
You need to use the use command
Mysql> \u [databasename]
Now you may run the query
Mysql> select * FROM dbname.table;
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 4:25 PM
Cc: [EMAIL PROTECTED]
Subject: pb while querying in strange db n
I am trying to configure mysql for redundancy using replication and the
built-in mysql master/slave configuration. What I don't understand, even
after much reading, is how to recover from a failure. If host B is slave to
host A, and A goes down, B could then be manually or automatically
configured
we have to escape name
select * from `db-name`.`table-name`;
works.
great mysql.!
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Bef
Hi all,
I ve got a database with the name
db-name
when making :
select * from db-name.table;
I get a error.
something is wrong in your syntex near : -name ...
How can I tell mysql that db-name is a database name ?
Thanks.
_
Do You
Yeah, but thats not what I'm asking, how can I get this info from the table?
Does mysql have a built-in feature that stoes the hit information and if so,
how do I pull this info from the table?
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
U
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
UPDATE tbl SET Number = Number + 1 WHERE blah;
Alex Behrens wrote:
>
> Hey Guys,
>
> I'm working on a script that displays reviews by a category for my site and
> I want the pull-down menu to be ordered by the amount of hits each category
> or review
> has, is it possible to sort by the amoun
Hey Guys,
I'm working on a script that displays reviews by a category for my site and
I want the pull-down menu to be ordered by the amount of hits each category
or review
has, is it possible to sort by the amount of hits for a row value?
My table is structured as follows:
Name, Url, Author, E-
Thanks very much to every who helped me with my MySQL problem!
I will probably go with the three table solution as it also eliminates the
need for yet another table!
Cheers,
Ben
-
Before posting, please check:
http://www.my
If you only want it ascending, take out the DESC as in:
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC LIMIT
3";
- Original Message -
From: "David Rice" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 12:19 PM
Subject: Queries help (part
From: "Aman Raheja" <[EMAIL PROTECTED]>
> Suppose I want to select items 10 to 30 from a table tab, which has 36
rows.
> What could be the sql query ?
> Thank you.
> Aman
>
> PS: I am using cgi-perl.
How are these items identified as "items 10 to 30" in the table?
Does that mean that when you
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC LIMIT
3";
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:20 PM
To: [EMAIL PROTECTED]
Subject: Queries help (part II)
Hey thanks i got it to work sort of
$query = "SELEC
Hey thanks i got it to work sort of
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date DESC LIMIT
3";
that works
but i want it to show them ascending and when i change it to
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC; DESC
LIMIT 3";
it doesn't work
This worked for me:
SELECT * FROM table ORDER BY id ASC LIMIT 9,21;
There's probably a better way to do that though.
tyler
- Original Message -
From: "Aman Raheja" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 2:04 PM
Subject: select a certain num of items i
Olivier,
please check that the data types of corresponding columns in the referenced
tables are the same, and that you have created the necessary indexes in also
the referenced tables.
I tested the following:
C:\m\client_debug>mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Suppose I want to select items 10 to 30 from a table tab, which has 36 rows.
What could be the sql query ?
Thank you.
Aman
PS: I am using cgi-perl.
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.
Mark,
Tutorials: Start at the PHP home page and look for the links page.
DevShed would be a good start.
Regards,
=dn
- Original Message -
From: "Mark Stringham" <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>; "Peter Lovatt"
<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: 28
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
...
> Which begs the questions:
> - in what way are you analyzing "behavior"? and
> - in what way are you analyzing this list-community?
"There's too much to read," is the simple answer to the first question.
Over the las
Hi Makis,
default-character-set = greek
Try that, best wishes,
Ken
P.S. also for anyone else asking here are all the charsets included
in MySQL by default. You can also create your own.
mysql> show variables like "char%";
++
Nick,
> This is pretty familiar to me because I'm analyzing the behavior of
people
> in on-line discussions, so I'm gathering such data.
Which begs the questions:
- in what way are you analyzing "behavior"? and
- in what way are you analyzing this list-community?
=dn
MySQL list busting
---
DL -
Points well taken -
I am using php and doing simple validation
EX - if ($fname !="") {
add fname string to search variable;
}
And if none of the fields have been filled out I'll return an error msg.
As you mentioned, Peter's logic still applies here and it has given me
enough to work wit
In your situation (or any situation, IMHO),
multi-value fields defeat the purpose of good database
design.
I think you are on the right track if you are willing
to tolerate a little redundancy for the sake of
simplicity (as a one-to-many relationship). If you
really want to structure it as a many
Mark, Peter,
The query below assumes that the user will search of FirstName and none
or more of the other fields - which was not how the question reads (to
me).
To answer the question it would be useful to know how you are accessing
MySQL - are you using PHP (as per example code below) for examp
D'oh. Forgot he wanted after now :)
Thanks.
On Thu, 2002-03-28 at 10:46, DL Neil wrote:
> David, Steven,
>
> > I think this is what you want?
> >
> > select * from table order by date_column ASC; ( for ascending order..)
> > select * from table order by date_column DESC; ( for descending
> ord
Is there a master.info file somewhere?
What's your my.cnf look like?
If you want, you can email me the file and I'll be happy to try and
help.
--
sh
On Thu, 2002-03-28 at 10:40, Jonathan Wilzig wrote:
> Sorry to repost. I got one answer and stumped the guy trying to help (thanks
> again btw).
David, Steven,
> I think this is what you want?
>
> select * from table order by date_column ASC; ( for ascending order..)
> select * from table order by date_column DESC; ( for descending
order..)
>
> Replace 'table' with the name of your table and date_column with the
> name of the column that
Hi,
I have setup a table with user login name and password. The password is
encrypted with the MySQL's password(). How do I compare these info with the
user's input.
I had
$query = "select * from auth where
usrname='$logname' and usrpass=password('$logpass')";
mysql_query($query);
But I can'
Sorry to repost. I got one answer and stumped the guy trying to help (thanks
again btw). If anyone has seen this or has any ideas, any help would be
greatly appreciated.
---
RH 7.2.
mysql-3.23.44
I have a single server running mysql. I have added one database I use. For
some unknown
Hey David.
I think this is what you want?
select * from table order by date_column ASC; ( for ascending order..)
select * from table order by date_column DESC; ( for descending order..)
Replace 'table' with the name of your table and date_column with the
name of the column that contains the dat
I am quite new to coding and have managed so far but, i've been havin
trouble with queries.
Okay well here goes, it is quite simple but i can't figure it out, and
haven't found any helpfull documentation
I have a mysql database, and i want to sort a table by date Where the
resulting records wi
Well after some pondering I found a pretty easy work around:
SELECT main.id, description, maincat.name, subcat.name from main
LEFT JOIN maincat ON maincat.id=main.maincatid
LEFT JOIN subcat ON subcat.id=main.subcatid
WHERE MATCH (description) AGAINST ('keywords')
OR
WHERE MATCH (maincat.name) AGA
By the way you're using the terms, I would guess you're hoping
to make a new database, and place it "on the web".
In that case, Mysql is probably at too low a level of
detail for your needs. To solve your problem you
would need to learn:
HTML
CGI
middleware (ASP, PHP, etc)
MySQL
SQL
database
Is there something similar for Greeks too?
(not that matters very much as I run on internet host but in case..)
Makis
> -Original Message-
> From: Ken Menzel [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 10:25 PM
> To: Philip Semanchuk
> Cc: [EMAIL PROTECTED]
> Subject: Re
Hi
$query = 'SELECT *
FROM Table
WHERE
FirstName LIKE "%'.$firstname.'%"' ;
if($lastname)$query.= ', AND LastName LIKE "%'.$lastname.'%"';
if($region)$query.= ', AND Region LIKE "%'.$region.'%"';
if($loan_officer)$query.
* Harry Rorarius
> I thought Mysql was a server that could be used as a online database?
Yes, it is...
> If it is, is there some material I have not read that tells me how to do
> this?
Probably :o)
> I understood most of the information I read about Mysql. I was under the
> understanding sql
Hi all,
I d like to sql a huge sql that I have before submitting to the server.
I notice that when 1 erreor is encounter the serveru stop to precess.
I d like to list all the errors that are in that sql file.
Because I generate it n want to know all my erreors at one time in order to
repair all
I have a simple search form that allows the user to search a contact db
based on criteria that they choose.
Search by -
first name - text box
last name - text box
region - drop down
loan officer - drop down
I want the user to be able to receive results if they choose all possible
criteria or jus
Harry,
It is you need to make a WEB front end to access it
-Original Message-
From: Harry Rorarius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 10:49 AM
To: Mysql list
Subject: hmm
ok
I thought Mysql was a server that could be used as a online database?
If it is, is ther
hi,
I've downloaded mysql-max-nt v.3.23.49, have setup InnoDB startup support. I
am now in the process of creating tables. When these are standard tables no
problem, eg:
create table test (id integer not null, primary key(id)) type=InnoDB;
works fine !
I have problems when I have tables with f
On Thursday 28 March 2002 9:48 am, Harry Rorarius wrote:
> I thought Mysql was a server that could be used as a online database?
Yes
> If it is, is there some material I have not read that tells me how to do
> this?
What are you trying to do? You have not been at all clear in y
Dmitry Grigoryev writes:
> Hello
>
> I have followed problem:
>
> Table:
> CREATE TABLE test (
> field1 mediumtext
> );
>
> Insert:
> INSERT INTO test VALUES ('222(100 Kb of '2')222');
>
> Select1:
> SELECT field1 FROM test;
> OK. I get 100 Kb of '2'.
>
> Select2:
> SET CHARACTER SET cp12
ok
I thought Mysql was a server that could be used as a online database?
If it is, is there some material I have not read that tells me how to do
this?
I understood most of the information I read about Mysql. I was under the
understanding sql is the way to make a online database
Harry
---
> -Original Message-
> From: Ben Holness [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 28, 2002 7:43 AM
> Have I understood the two table concept correctly?
> How does the third table fit in?
>
> I guess that if two (or more) of the entries overlap, I could make things
> even
Hi Chris/Nick/Scalper,
Thanks for the replies. I am not too sure how to implement this in tables,
so I will give an example:
Let's say I have three lists - a,b and c. List a contains 10,000 entries,
list b contains 2,500 entries and list c contains 75,000 entries.
I have a table of lists, with
mySQL does not support nested 'selects'. Read the manual, please :)
Ben Edwards wrote:
> having problems working out sql where exists syntax.
>
> Tried
> select *
> from sections s
> where exists (
> select 0
> from pages s
> where s.pag
* Harry Rorarius
> > The specified CGI application misbehaved by not returning a complete set
> of
> > HTTP headers. The headers it did return are:
> >
> >
> > syntax error at F:\web\cgi-bin\mysql_setpermission.pl line 71, near
I don't think mysql_setpermission.pl is a CGI script... you should ru
Ben,
Thursday, March 28, 2002, 5:07:49 PM, you wrote:
BE> having problems working out sql where exists syntax.
BE> Tried
BE> select *
BE> from sections s
BE> where exists (
BE> select 0
BE> from pages s
BE> where s.page = p.page
B
Since I never saw much people speaking french using
this mailing list I though translating this message
for english users
Hi,
I use MySQL 3.23 under Solaris 7. The size of the Database
is 1Gig 5.
What are the limits for propoer MySQL operation.
Is there a faster way to copy a DB than using Dump
Whoa,
I've had this message 3 times now. Is there a problem somewhere?
George
- Original Message -
From: "Ben Edwards" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 3:38 PM
Subject: where exists sql problem
> having problems working out sql where exists syn
Ok, first, please send only e-mail, we saw it the first time. Second, MySQL
does not support nested queries or sub selects or what you are using.
Please see the JOIN syntax in the MySQL documenation:
http://www.mysql.com/doc/J/O/JOIN.html
nickg
-Original Message-
From: [EMAIL PROTECT
having problems working out sql where exists syntax.
Tried query
select *
from sections s
where exists (
select 0
from pages s
where s.page = p.page
)
Any ideas,
Ben
--
[EMAIL PROTECTED]+44 (0)7970 26
I use putty:
http://www.chiark.greenend.org.uk/~sgtatham/putty/
This software has a local tunnel feature so I can tunnel port 3306
requests on the local machine through the ssh port and back to 3306 on
the remote machine. This isn't ssl, but it answers your problem. Of
course sshd must be runn
Here we speak english.
Ici on parle anglais.
Tu peut copier les fichiers binaires des tables de mysql (*.MYD *.MYI *.frm)
dans le DATADIR
ex : linux /var/lib/mysql
par contre il doit y avoir
des problemes avec l intégrité des données.
Je te conseil de lire la doc de mysql en francais ss nex
having problems working out sql where exists syntax.
Tried
select *
from sections s
where exists (
select 0
from pages s
where s.page = p.page
)
Any ideas,
Ben
--
[EMAIL PROTECTED]+44 (0)7970 269 5
At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said :
>?http://www.mysql.com/doc/C/R/CREATE_INDEX.html
Granted, I should have looked before I spoke for the first question.
> > 2 - Do I have to do anything special like stop requests to the
>> server while I add the index.
>
Bonjour,
J'utilise Mysql 3.23... sous un environnement Solaris 7. La taille de la
base de donnée est de 1Go 5.
Quelles sont les limites pour le bon fonctionnment de mysql ?
Existe il un moyen plus rapide de faire des copies de bases que le dump ?
Merci
Cordialement,
Tony Jarriault
--
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
voytek,
Thursday, March 28, 2002, 3:45:48 PM, you wrote:
>>You must first install original MySQL (rpm) package and then you can
>>install MySQK-max RPM. You can read about mysqld-max at:
>> http://www.mysql.com/doc/m/y/mysqld-max.html
>>
>>If you want to use InnoDB tables you should specify
erich,
Wednesday, March 27, 2002, 5:22:00 PM, you wrote:
e> Does anybody have an idea how to select data from a local database into another
e> host server ?
e> For information, I'm currently using mySQL 3.23.
mysqldump?
You can read about mysqldump utility at:
http://www.mysql.com/doc/m/y/m
J,
Wednesday, March 27, 2002, 4:46:08 PM, you wrote:
JvDBKA> I'm running RH Linux 7.0,and Mysql Version: 3.23.22-beta, and the
JvDBKA> mysqld.log grows very rapidly.
JvDBKA> Is there a way to turn it off ?
JvDBKA> Logrotation is not really an option in this case, the only
JvDBKA> possibilities a
Hi Ben:
Performance would definitely be better if you store the data in the
database as opposed to simply storing references to files. Sounds like you
could solve this with 2 tables with one for the actual lists (assuming the
structure of all your list is the same) and the other for the list
> -Original Message-
> From: Ben Holness [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
...
> My question is this: Would it be more efficient to have each entry in the
> list stored in this table in the database, or would I be better
> off having a
> reference to a file tha
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
You can try to force an index with:
SELECT * FROM Posts USE INDEX(index4) WHERE Board = 'board1' ORDER BY
Board DESC, Number DESC
Mike
-Original Message-
From: Michael Bonfert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 9:06 AM
To: [EMAIL PROTECTED]
Subject: Problem w
On 3/28/02 1:39 PM [EMAIL PROTECTED] wrote:
>
> What I want to do is have a database that keeps track of large distribution
> lists. Each list has a unique ID, an owner (which is a reference to an ID in
> another table) and a creation date.
>
> My question is this: Would it be more efficient to
- Original Message -
From: "Harry Rorarius" <[EMAIL PROTECTED]>
To: "Mysql list" <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 9:18 AM
Subject: Fw: sql
>
> - Original Message -
> From: "Harry Rorarius" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 28
rpm -e the mysql product from the CD's to uninstall the originals.
then rpm -ivh MySQL-Max-3.23.49a-1.i386.rpm to install the mysql-max
product and you're golden.
Curtis
Voytek Eymont said:
> I need some newbie help...
>
> I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that cam
- Original Message -
From: "Harry Rorarius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 7:46 AM
Subject: sql
> I am a new comer to the sql world. I have some but brief knowledge of
perl.
> here goes!
>
> I am using mysql on a Winnt platform and I have per
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
On Thu, 28 Mar 2002 14:46:01 +0200, Egor Egorov wrote:
>You must first install original MySQL (rpm) package and then you can
>install MySQK-max RPM. You can read about mysqld-max at:
> http://www.mysql.com/doc/m/y/mysqld-max.html
>
>If you want to use InnoDB tables you should specify InnoDB
Hi all,
I am in the process of designing a MySQL database that will run on Redhat
7.1, but I am fairly sketchy on MySQL and performance.
What I want to do is have a database that keeps track of large distribution
lists. Each list has a unique ID, an owner (which is a reference to an ID in
anothe
I am a new comer to the sql world. I have some but brief knowledge of perl.
here goes!
I am using mysql on a Winnt platform and I have perl 5 installed on it. I
did setup dbi in perl and I know that mod is working. I have been trying to
get one of the scripts that came with the copy of mysql
(
Voytek,
Thursday, March 28, 2002, 6:54:13 PM, you wrote:
VE> I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came with
VE> it,
VE> the installed MySQL did NOT have InnoDB support;
VE> I then d/l off mysql.com
VE> MySQL-Max-3.23.49a-1.i386.rpm
VE> I installed it using:
VE> rpm
thien,
Thursday, March 28, 2002, 11:05:27 PM, you wrote:
t> I am a developer of My SQL, and I am developing an application use unicode
t> so I would like to ask you which version that support Unicode and where can
t> I get it.
t> Now I am using My SQL version 3.23.49
t> thanks alots
MySQL doesn'
Ryan,
Thursday, March 28, 2002, 7:22:47 AM, you wrote:
RC> I'm working on a MySQL permissions problem, and would welcome some
RC> suggestions and/or comments, or to be pointed in the right direction. The
RC> goals I have are:
RC> a) Limit users to specific db's (no access to mysql.*/etc.)
You
1 - 100 of 111 matches
Mail list logo
