Hello,
As you all know InnoDB doesn't support full text search. My application
is a huge news system with about 100 new news per day. All of my tables
are in InnoDB becouse of foreign keys. Today I find out that the main
feature of news system - searching - is not available. It's quite big
problem.
sure you can. And i don't mind you disagreeing with me either =)
Although, if the solution/site is meant to be used by other than people
who know something about the webserver i don't think it's a good solution.
I can imagine writing something that reads the htaccess-file and edits
it... but i do
http://since.vip.sina.com/smscai.html";>http://since.vip.sina.com/pic2/smscailogo.gif"; width=730 height=70 border=0
alt="射雕英雄传彩信">
http://since.vip.sina.com/shoujijiaoyou.html";>http://since.vip.sina.com/pic2/yzjiaoyou.gif"; width=730 height=59 border=0
alt="亚洲真情交友中心">
http://www.cctvt.com/[E
[ sql, query ]
Hi all,
I've got a problem and I really can't solve it by myself :-(
I want a Select-Statement which gives me following output:
Projectname / Subprojectname / user / hours
---
testproject / subproject1/ mas / 1
testproject / subpr
If I do a query on a table which has a column of the 'text' type, I get the
following error: "Positioned request cannot be performed because result
set was generated by a join condition". This is on a simple select with a
join between two tables.
I'm using a wrapper class from codeproject.com to
Don't forget that the images can be stored *outside* the root dir. Access
them using ../../ until you reach your img dir. There's no way to get to the
images directly then.
Paul
-Original Message-
From: lasse [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 12:14 AM
To: unlisted-rec
Hello,
I have this problem with MySQL 4.0.12. When I run the following SQL query, I
get this result:
mysql> select last_move_date_time, days_per_move,
(unix_timestamp(last_move_date
_time) + 7 * 24 * 60 * 60 - 1048188722) as time_left from two_player_game
where
id = 44970;
+
Wynne,
- Original Message -
From: "Wynne Crisman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Friday, March 21, 2003 5:18 AM
Subject: Re: fulltext search
> Since InnoDB tables don't support fulltext searching yet, what is the
> recommended w
sunil sharma said:
> Dear Friends
>
> I am new in this list
> I am using mysql on linux
>
> My problem is about the backup of mysql database
>
> We are having 50 Databases and each database is of
> minimum of 300 MB in size and maximum of 2 G.B size
>
> I am planning to take incremental backup of
Tab,
>> file). Anyway, it can't help to try the following:
>> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
> Thanks, I'll try that... But in the meantime, is there something I can
> do to get Mysql to show me more information about the syntax error? I
> think that the diffe
Jerry M. Howell II wrote:
sunil sharma said:
Dear Friends
I am new in this list
I am using mysql on linux
My problem is about the backup of mysql database
We are having 50 Databases and each database is of
minimum of 300 MB in size and maximum of 2 G.B size
I am planning to take incremental back
Not an issue since you don't need to edit the htaccess file for every file.
You set it for the whole directory.
The only reason for preventing ppl to access files would be theft of
bandwith. If you worry about ppl being able to get the images then you
shouldn't publish them at all. You can't pr
I have been using mysqldump -a to backup my clients sites.
I have discovered a problem with this aproach. I decided to
try and restore it with mysqlimport on my local hd and it'll
restore it up to a certian point then stop. What I'm looking
for is any other recomendations to backup and restore 7
sunil sharma said:
> Dear Friends
>
> I am new in this list
> I am using mysql on linux
>
> My problem is about the backup of mysql database
>
> We are having 50 Databases and each database is of
> minimum of 300 MB in size and maximum of 2 G.B size
>
> I am planning to take incremental backup of
Hi all,
I tried around a long time. Has no one an idea?
my query:
-
SELECT u.login, p.name, sp.name, t.minutes
FROM t_user u
LEFT JOIN t_project p ON 1
LEFT JOIN t_subproject sp ON p.id = sp.project_id
that gives me every subproject and the project where it belongs to for
every user.
Now
Benoit,
- Original Message -
From: "Benoit St-Jean" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 4:54 AM
Subject: Stopping InnoDb recovery and fixed columns
> I recently had a bad experience with a "feature" of
> InnoDb. Whenever the server crashes,
Hi Everybody
Could you know How can I add Connect/J Support to the MySQL
I downloaded mysql-connector-java-2.0.14.tar.gz then un-package
it after that I copied mysql-connector-java-2.0.14-bin.jar file to under the
tomcat/lib directory after that restarted tomcat for this
Wendell,
- Original Message -
From: "Wendell Dingus" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 5:42 AM
Subject: RedHat 8 SRC RPM 4.0.12 Build
> Is the inability for 4.0.12 (and previous) SRC RPMs to build on RedHat 8
the
> fault of something in M
In phpMyAdmin 2.3.0 the 'Or Location of the textfile ' instead of running a sql
statement does this have to be a txt file or can it be a .sql file?
Or if it is a .sql can I just rename the file so it is a txt file?
Why is importing a large file inot MySQL so damn difficult. It would be so easy
f
The following should do the trick
mysql> LOAD DATA file_name.ext INFILE INTO TABLE table_name
Paul
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 3:58 AM
To: [EMAIL PROTECTED]
Subject: RE: sql or import file
Hi Paul
Its a backup of phpbb so its
Andrew,
> In phpMyAdmin 2.3.0 the 'Or Location of the textfile ' instead of running a sql
> statement does this have to be a txt file or can it be a .sql file?
> Or if it is a .sql can I just rename the file so it is a txt file?
The file extension doesn't matter. The .sql files PhpMyAdmin wants i
Sorin,
> SELECT u.login, p.name, sp.name, t.minutes
> FROM t_user u
> LEFT JOIN t_project p ON 1
> LEFT JOIN t_subproject sp ON p.id = sp.project_id
> that gives me every subproject and the project where it belongs to for
> every user.
> Now I want the SUM of the time (t.hours) worked on the sub
Hi all,
I posted my question a short time ago and didn't receive any answers. So
I am trying describe it better.
I want to select For every user (from table t_user), every project (from
t_project) and from every project I want to select every subproject
which has the id of the project (t_subpr
Hi,
I am facing a problem with "net stop mysql" command to stop mysql. I waited
for 10 mins and it never stops. This happens whenever I add a new innodb
data file. Following are the versions of s/w I am using.
OS - Windows professional, with service pack 2
Mysql - 3.23.48 and 4.0.12.
Thanx i
Hi,
ConnectTel is pleased to announce the release of XQX
Version 1.0-Beta.
XQX is a XML interface to relational databases. It
allows access to
Relational Databases using a XML interface.
XQX is an innovative product which enables enterprises
to make their
data accessible, in an easy and effectiv
Sorin,
> If there are entries which are:
> 60 / amg / 5
> 120 / amg / 5
> (in this example '5' is the id of the calculation-subproject)
> Then the result should be:
> +---+---+---+---+
> | login | name | name |
Stefan Hinz wrote:
Okay, here for another wild guess:
SELECT u.login, p.name, sp.name, SUM(t.time)
FROM t_user u
LEFT JOIN t_project p ON 1
LEFT JOIN t_subproject sp ON p.id = sp.project_id
LEFT JOIN t_time t ON ?? = ??
WHERE u.login = 'amg'
GROUP BY p.name
Where I'm not sure if you will need t
Sorin,
>> Okay, here for another wild guess:
>> SELECT u.login, p.name, sp.name, SUM(t.time)
>> FROM t_user u
>> LEFT JOIN t_project p ON 1
>> LEFT JOIN t_subproject sp ON p.id = sp.project_id
>> LEFT JOIN t_time t ON ?? = ??
>> WHERE u.login = 'amg'
>> GROUP BY p.name
>> Where I'm not sure if you
Hi there, I have a friend that is running mysql 4.10 gamma on his
windows XP machine and he is having problem with an java application
that uses jdbc to connect to mysql..
from what I coudl see it sometimes worked and it sometimes did not
work... why I had no idea... but after digging somewhat
On Friday 21 March 2003 11:13, Filip Rachunek wrote:
> I have this problem with MySQL 4.0.12. When I run the following SQL query,
> I get this result:
>
> mysql> select last_move_date_time, days_per_move,
> (unix_timestamp(last_move_date
> _time) + 7 * 24 * 60 * 60 - 1048188722) as time_left from t
On Friday 21 March 2003 08:01, sivakumar wrote:
> Hai, am having the problem in creating CD of my project(Online
> Tutorial).While creating the CD only am having the problem. Actually am
> working in SSH(linux),right.
>
> I have to make a dump of my source code and mysql ..to copy (from server to
>
Gerald R. Jensen wrote:
> I just ran your query (create and both inserts), and it
> worked like a charm on a Win32 MySQL 3.23.52.
>
> Just out of curiousity, why are putting the \r in?
>
Gerald (and all who were interested),
I didn't put the \r in, actually...mysqldump did. The solution to the
On Thursday 20 March 2003 23:25, Andreas wrote:
> I'm trying to get going with InnoDB.
> As for now I created several tables which relate to each other with some
> foreign key restrictions.
>
> mysqldump --all --opt writes 6++ MB stuff in a textfile that mysqld
> won't accept without SET FOREIG
On Thursday 20 March 2003 22:42, John Hardin wrote:
> It would be really nice if there were some way (a variable) to make
> MySQL totally ignore certain directories in the datadir - for example,
> "lost+found", "RCS", and suchlike.
>
> The listed dirs should not show up in SHOW DATABASES and you s
Howdy All,
The MySQL Reference Manual lists 2 limitations on the way the mysql client
parses /* ... */ comments, these being:
Single-quote and double-quote characters are taken to indicate the
beginning of a quoted string, even within a comment.
If the quote is not matched by a sec
On Thursday 20 March 2003 21:10, Juan Nin wrote:
> Imagine I have a table with 3 colums (column1, column2, column3), which are
> of type INT.
>
> I want the data in column3 to be generated automatically from the one in
> column1 and column2 when it is inserted
> For example a sum, that the data in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christian Andersson wrote:
Hi there, I have a friend that is running mysql 4.10 gamma on his
windows XP machine and he is having problem with an java application
that uses jdbc to connect to mysql..
from what I coudl see it sometimes worked and it so
On Thursday 20 March 2003 21:56, dleetest at kw dot com wrote:
> It seems that this error occurs only when I try to access mysql tables with
> many rows. Just wonder if anyone knows what is the cause and how to prevent
> it.
There are a lot of possible causes. Check these link, they can help you
On Wed, 2003-02-19 at 08:14, Damir Dezeljin wrote:
> Firstly excuse my poor english ;)))
>
> I read the entire mail thread. I'm useing MySQL for our own data storage
> (I use it to store our oceanographic data for internal use) - I guess that
> I don't need a commercial license for this.
>
> I ha
On Tue, 2003-02-18 at 18:06, Ben Clewett wrote:
> This will be my last posting. I don't belive I am being constructive
> and have no wish to instantly be hated by the whole of MySQL.
>
> Michael T. Babcock wrote:
> > Ben Clewett wrote:
> >
> >> MySQL say that this is an extension of the applica
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
MySQL on Windows platform or is there a reason why it might be slow o
Hi,
I'm working for a client that has an auction application using MySQL.
We have a program to simulate the load when N users have an auction
page open. The auction page pings the server for updates every
few seconds, and that ping results in two UPDATEs and 64 SELECTs.
I have cut the statement
Good Morning!
I'm trying to install the MySQL RPM's on a newly set up RH 8.0 box. Things
seem to go well until I try to install the "server" RPM, which fails stating
that it can't find libmysqlclient.so.10 on the computer. What do I have to
do to get around this problem?
Thanks!
David Christen
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> Why do you want to store the sum of columns? You can just sum them when
> you retrieve data.
The database has got about 1 million records, and it gorws day by day
The query I need returns lots of records, and calculating it while
retrieving data
Hello David,
Since you were kind enough to clarify some matters on licensing I was hoping you would
also be open to suggestions. Instead of charging a flat fee for each copy of MySQL
that is resold why not charge a percentage up to a certain point. It might make it a
bit easier for developers w
On Tue, 2003-02-18 at 13:55, Bernhard Döbler wrote:
> Hi,
>
> the OpenSource GPL'd version of InterBase 6.01 is called Firebird and is available
> from: http://sourceforge.net/projects/firebird
>
> On Hannover CeBit'2002 I talked to a guy from MySQL AB. It was the
> time the Firebird 1 release
Look at the HAVING clause.
c are columns, t are tables
SELECT c1, c2, c3, sum(c4)
FROM
WHERE t1.c1 = t2.c1
AND t2.c2 = t3.c2
HAVING sum(c4) > 0
-ms
-Original Message-
From: Sorin Marti [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 2:36 AM
To: [EMAIL PROTECTED]
Subject: Re:
David,
> I would like to suggest that a third condition be included in this list. It
> seems that either of the other 2 comment characters, * -- * or * # * are
> also recognized by the parser within /* ... */.
"-- " means "comment to the end of the line". So,
SELECT "Hello" /* This is a
At 18:12 +0100 3/21/03, Stefan Hinz wrote:
David,
I would like to suggest that a third condition be included in this list. It
seems that either of the other 2 comment characters, * -- * or
* # * are
also recognized by the parser within /* ... */.
"-- " means "comment to the end of the l
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Aman Raheja wrote:
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
MySQ
Hi,
mysql seems to log bad queries, is there any way to keep this from
happening?
thanks,
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
Hi,
I'm new to the list having just tried to install MySQL v4.0 onto Linux
Redhat v7.3 using an RPM distribution.
According to the docs I should be able to set a password for the MySQL
root user by running mysqladmin, but I don't see this program. Where
should I expect it to be?
This is
At 05:27 AM 2/18/2003, you wrote:
Hi,
I am a MySQL admin. I like it very much. It is very quick,stable and
easy in configuration.
But I have a boss, who has been told about InterBase. He told me I should
interest in the InterBase, because it is programmed by russian, who made a
great project and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Mar 2003, Christensen, Dave wrote:
> I'm trying to install the MySQL RPM's on a newly set up RH 8.0 box.
> Things seem to go well until I try to install the "server" RPM, which
> fails stating that it can't find libmysqlclient.so.10 on the
At 17:50 + 3/21/03, John Poltorak wrote:
Hi,
I'm new to the list having just tried to install MySQL v4.0 onto Linux
Redhat v7.3 using an RPM distribution.
You need to install both the server *and* the client RPM files.
According to the docs I should be able to set a password for the MySQL
ro
Ok now I've got my database completely copied on another server, so now
I'm doing a trial run of upgrading the copy-db to 3.23.56. I unzipped
the stuff and ran the SETUP.exe and after setting the parameters, the
SetUp programs runs a little bit and then pops up this error message:
An error occurr
At 13:26 21/03/2003 -0500, Tab Alleman wrote:
Hi,
Ok now I've got my database completely copied on another server, so now
I'm doing a trial run of upgrading the copy-db to 3.23.56. I unzipped
the stuff and ran the SETUP.exe and after setting the parameters, the
SetUp programs runs a little bit and
Hi everyone,
I am using MySQL 3.23.49 and have started having a problem with the "load
data infile" command.
I recently created a new user with select,insert,update,and delete on one
table only (tableA). Because I want the user to be able to use "load data
infile" to load records into tableA, I
we're using mysql-max4.04 on solaris 2.8. all tables are InnoDB tables.
I see in the data directory a series of -bin files. I'm assuming
these are the index files. Is this correct? the sum total size of these
files are larger than the files I've allocated for data. How can I
manage these files? Wh
At 9:33 -0800 3/21/03, Mark wrote:
Hi,
mysql seems to log bad queries, is there any way to keep this from
happening?
thanks,
- Mark
That's impossible. Queries are written to the binary log only after
they execute. (Queries are logged to the general log before they
execute, but your message subjec
Had my first mysqld crash today after a solid 4 month uptime.The details
are below.
The DB restarted, and I haven't been able to detect any corruption. Is
there anything I should be running to ensure the integrity of the Innodb
databases?
Running: mysql-max-3.23.51, Innodb databases, Dual I
> Most probably you are running a server and the setup program
> fails to rewrite the file. Before run the setup.exe stop the
> current server.
Most probably you are correct. :)
I stopped the server and ran the set-up again, and this time it got much
further, but I then encountered a new erro
Hey all,
I can't seem to wrap my head around this, please see if you can help me out. I
have 2 tables. One with some basic info but they are structured as follows.
info table:
IDNum(PK)
LName
FName
Title
Deladd
City
State
Zip
codes table:
IDNum (used only so that there could be a primary key :-/
Jeff-
Actually, thsee sound like the binary log files used primarily for
replication. If you're on host doctorpants, they'll be
doctorpants-bin.001
doctorpants-bin.002
doctorpants-bin.index
and so forth. If you don't want a write query log and aren't doing
transactions, remove the binlog option
At 14:04 21/03/2003 -0500, Tab Alleman wrote:
> Most probably you are running a server and the setup program
> fails to rewrite the file. Before run the setup.exe stop the
> current server.
Most probably you are correct. :)
I stopped the server and ran the set-up again, and this time it got much
I wouldn't run 3.23.51, there have been major security patches since then.
I always mess up the byte math, but it looks to me like you have 2 gigs of
ram in your box and you are allocating 2.3 gigs to mysql. With 263
connections you would have been using about 1.4 gigs, if you have anything
else r
Ryan McDougall wrote:
I can't seem to wrap my head around this, please see if you can help me out. I
have 2 tables. One with some basic info but they are structured as follows.
info table:
IDNum(PK)
LName
FName
Title
Deladd
City
State
Zip
codes table:
IDNum (used only so that there could be a prim
Well, then I would buy a $50.00 product using MySQL, and then
your $5000.00 product. Oh, and subtract the $500.00 license fee.
I already have a license.
I prefer to pay a flat fee for each license, not a fee based on the
price of your software.
John Griffin wrote:
Hello David,
Since you were k
I downloaded the RPM's from the Chicago mirror site and saved the files in a
directory "/data/downloads/mysql". I then maneuvered there using the GUI
file manager and double-clicked on the file names. That caused a GUI to
open up and it displayed status as it checked things out. When it displaye
Joe,
- Original Message -
From: ""Jennifer Goodie"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 9:45 PM
Subject: RE: mysqld got signal 11; (CRASH max-3.23.51) What do I need to do
to clean up?
> I wouldn't run 3.23.51, there have been major securit
Buy a hundred at a time.
John Griffin wrote:
Actually, I am trying to address the problem of having to buy a $200 MySQL license for every $50 software product I sell. If you have a solution for this problem I would like to know what it is. This is a licensing issue that I haven't found a good sol
Gerald,
One hundred MySQL licenses still works out to $90.00 USD. Even if it worked out to
half that would still leave me with no margin and so no compensation for my time. I am
trying to find a way of using MySQL in a very low cost market and still have still
have pocket change after each sale
I think this works too:
Select * from Tablename where drinks <> 'pepsi';
> -Original Message-
> From: Andrew Wilson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 20, 2003 4:49 PM
> To: '[EMAIL PROTECTED]'
> Subject: "where drink is not equal to pepsi
>
>
>
> Hi guys,
> Hopefully
Actually, I am trying to address the problem of having to buy a $200 MySQL license for
every $50 software product I sell. If you have a solution for this problem I would
like to know what it is. This is a licensing issue that I haven't found a good
solution for.
John
-Original Message
John,
> Actually, I am trying to address the problem of having to buy a $200
> MySQL license for every $50 software product I sell. If you have a
> solution for this problem I would like to know what it is.
> This is a licensing issue that I haven't found a good solution for.
Try with the MySQL
great. the files are exactly as you describe.
we are doing transactions when we load. auto commit is off, and the
loader commits rows after a certain number has hit the database.
however, if I understand you correctly, once a load is complete and
everything has been committed, we are free to delet
John,
> One hundred MySQL licenses still works out to $90.00 USD. Even if it
> worked out to half that would still leave me with no margin and so
> no compensation for my time. I am trying to find a way of
> using MySQL in a very low cost market and still have still have
> pocket change after each
I've finally set up replication for one of the MySQL servers I
administer, and it seems to be working. I'm puzzled, however, by
what I see in the general query log.
I'm using replicate-wild-do-table to restrict the replication to only
two of the databases on the master server (since I understa
miguel solórzano wrote:
> Some program has locked C:\mysql\bin\libmySQL.dll, if you can
> delete it.
Indeed, my server didn't even want me to delete the file, until I checked the process
list and realized what was locking it: winmysqladmin. Duh... I shut that down and
everything went smoothly.
Hello, MySQL list subscriber!
We will be performing maintenance on the servers hosting the MySQL
mailing lists this weekend, which will result in some periods of
unavailability, and possible delays in mail delivery.
Sorry about the interruption and inconvenience, and thanks for
your patience!
We
I currently am running linux 7.1 and have MySQL 3.23.54 running on my box. I have
heard that there are some security issues with the version of mysql that I am running,
plus, phpnuke 6.5 needs the newer version of mysql.
I am a newbie to linux and mysql, and need a bit of hand holding I think.
[EMAIL PROTECTED] wrote:
> Can someone help
> point me in the right direction? Thanks
I just finished a practice upgrade (on a back-up server) myself and will
be upgrading the real server during off-peak hours soon. We are running
win2k servers so I can't speak directly to any linux issues, but
I posted earlier this week about how to select from two different tables with
an OR -- selecting rows from either table and putting them into one.
That was easily accomplished with a UNION statement (AFTER upgrading to
MySQL 4.0.x).
Now I'm doing almost the opposite. I have two tables, TestCas
On a linux box you do not have to stop everything like on Windows. We
always leave our current version running, install the upgrade in a new
location with a new data dir (a snapshot of the live one). We run the new
install on a different port than the live install so we can test it and what
not b
Do you have two identical tables? If not, then doing a select the way you
propose won't yield any rows. If they are identical, then you've already got
the data, and so wouldn't need to select anything. I'm sure I'm
misunderstanding exactly what you're trying to do, so maybe you could
explain it a b
Thank you for your reply. OK, I understand that. So what are the steps to install
the file. Isn't there an RPM or something. Do I take the 4.0 binary and place it an
any folder on my box? Then go to that directory and type a lynix command to unpack
and install the files? Then, go to the co
These links may help:
2.5.2 Upgrading From Version 3.23 to Version 4.0
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
2.1.1 Installing MySQL on Linux
http://www.mysql.com/doc/en/Linux-RPM.html
2.6.1.1 Linux Notes for Binary Distributions
http://www.mysql.com/doc/en/Binary_notes-Linux.html
2.2
sql,query
You have written the following:
My code:
http://nopaste.php-q.net/8594
My site:
http://66.12.3.67/webdb/webdb13/assignment_1a.php
My goal:
http://66.12.3.67/webdb/webdb19/assign01/index.php
==
Can anyone help me get this resolved please?
What's the error you're getting? What OS are you running on? If it's *nix,
make sure the file you are trying to load, and the full path to that file,
is readable by the user mysql runs as. I once had some files in a user's
home directory I was trying to load and although the file was
world-readable
not really for mhsql list, more for php list but,,,
select your database after connection.
use echo statement to look at you queries.
check your punctuation
Roger
-Original Message-
From: Karl James [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 6:51 PM
To: [EMAIL PROTECTED]
Subje
I am trying to install on a AIX box. I do not want to install into
/usr/local. I have put everything in /sybase/mysql/mysql. I am running into
alot
of problems with things expected to be in /usr/local/mysql. What do I
need to run in order to tell mysql everthing is in /sybase/mysql/mysql
T
On Friday 21 March 2003 05:42 pm, Brian McCain wrote:
> Do you have two identical tables? If not, then doing a select the way you
> propose won't yield any rows. If they are identical, then you've already
> got the data, and so wouldn't need to select anything. I'm sure I'm
> misunderstanding exact
I just sent a note but here is more info. I was able to mysql_install_db
successfully. But when I run safe_mysqld -- user=mysql & this
is what appears in the err file
030321 16:00:24 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.ht
On Fri, Mar 21, 2003 at 01:16:46PM -0700, Jeff Mathis wrote:
> great. the files are exactly as you describe.
>
> we are doing transactions when we load. auto commit is off, and the
> loader commits rows after a certain number has hit the database.
> however, if I understand you correctly, once a l
At 17:11 -0800 3/21/03, Bonnie Poole wrote:
I just sent a note but here is more info. I was able to mysql_install_db
successfully. But when I run safe_mysqld -- user=mysql & this
is what appears in the err file
030321 16:00:24 InnoDB: Operating system error number 13 in a file
operation.
% p
I would
like to avoid the necessity of specifying all of the fields -
instead use the following syntax:
INSERT INTO teachers VALUES
(1,12345,NULL,'Harry','Smith','707-773-4523',2',...
However, the first field is an autoincrementing field. Will MySQL
ignore my value and overwrite it with the "aut
Hi all,
I am fairly new to SQL and this is a really complex query for me.
Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra
each person in the tbl_personnel table can have 0 - 3 records in the
tbl_personnel_dras table. The tbl_personnel_dras table is just the
person_id (fro
At 20:04 -0800 3/21/03, Todd Cary wrote:
I would
like to avoid the necessity of specifying all of the fields -
instead use the following syntax:
INSERT INTO teachers VALUES
(1,12345,NULL,'Harry','Smith','707-773-4523',2',...
However, the first field is an autoincrementing field. Will MySQL
ignor
At 22:28 -0600 3/21/03, Paul DuBois wrote:
At 20:04 -0800 3/21/03, Todd Cary wrote:
I
would like to avoid the necessity of specifying all of the fields -
instead use the following syntax:
INSERT INTO teachers VALUES
(1,12345,NULL,'Harry','Smith','707-773-4523',2',...
However, the first field is a
Hi,
I am using MySQL 3.23.
I use SHOW TABLES to obtain a list of tables from my database and
then put this list in an HTML select form on a web page. What I need
to
know, is there a way of obtaining this table list, using SHOW TABLES,
in ascending or descending order the same way you woul
1 - 100 of 104 matches
Mail list logo
