Ok Im still having some serious speed problems and obviously since more
records are being added every day the problem is getting worse. Here is the
query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Employers
INNER JOIN Jobs
re reported on either master or slave.
>
> Is this to be expected, or is there some way of configuring the systems to
> report an error?
>
I have not registered to the mailing list yet, so please reply to
the mail address below.
> Richard Highton Tele
My phpBB forums, say if i make a post, then it goes to the post, but
nothings there, so i have to go to index.php for it to show (and it will log
me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it
would show the posta nd if i chnaged something (ex. colors) i would have
then the
master takes over from the slave.
Is this possible? If so HOW?
Thanks in advance,
Richard Pijnenburg
Klik-on Internet Solutions
Query,sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the
ideas would be greatly appreciated!
Cheers!
Rick
"Work like you don't need the money. Dance like no one is watching. And love
like you've never been hurt." - Mark Twain
> From: Richard Baskett <[EMAIL PROTECTED]>
> Date: Wed, 31 Jul 2002 13:41:56 -0700
> To: Da
t;
> Subject: Re: Speed issues...
> From: "Jared Richardson" <[EMAIL PROTECTED]>
> ===
> "Richard Baskett" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]...
>> This is my first post here.. So be nice! ;)
>>
>> I have
and there shall be no
more death, neither sorrow, nor crying, neither shall there be any more
pain: for the former things are passed away." - Revelation 21:4
> From: Dan Nelson <[EMAIL PROTECTED]>
> Date: Wed, 31 Jul 2002 15:09:24 -0500
> To: Richard Baskett <[EMAIL PRO
egory and JobsLocation first when
> they're constrained with LEFT JOIN.
>
> --
> Dan Nelson
> [EMAIL PROTECTED]
>
> From: Dan Nelson <[EMAIL PROTECTED]>
> Date: Wed, 31 Jul 2002 13:42:41 -0500
> To: Richard Baskett <[EMAIL PROTECTED]>
> Cc: Tod Harter <[E
take
them out! yes?
Cheers!
Rick
"When the solution is simple, God is answering." - Albert Einstein
> From: Tod Harter <[EMAIL PROTECTED]>
> Organization: Giant Electronic Brain
> Date: Wed, 31 Jul 2002 09:57:20 -0400
> To: Richard Baskett <[EMAIL PROTECTED]>,
This is my first post here.. So be nice! ;)
I have a database with a little over 60,000 records and when I do a search
on that db it takes a little over a minute and a half to return results.
This is very unacceptable, but Im just not sure what I can do to remedy
this. Here is what the query loo
I'll try not to extend this thread any more than it needs (it's gone
pretty far now). If you want to view the list via Usenet newsgroup,
just do it. It's been available on my service provider for several
months at mailing.database.mysql. If you prefer via email, fine.
Rik Forgo
JIST3
Army Test
ster. And, it is a bit more self-documenting than the
> other methods, even if it uses more space.
>
> I'm only likely to have a few thousand records (though each may contain
> a lot of text) which will change infrequently. I can leave it to the
> module that retriev
seconds; Aborting
make: *** [test] Error 1
Does any one know what Im doing wrong??
Thanks in advance,
Richard Pijnenburg
Klik-on Internet solutions
The Netherlands
Sql,query
-
Before posting, please check:
http
un/master.pid was not
created in 30 seconds; Aborting
make: *** [test] Error 1
Does any one know what I'm doing wrong??
Thanks in advance,
Richard Pijnenburg
Klik-on Internet solutions
The Netherlands
Sql,query
---
eived.
Thanks in advance.
Richard Davis
University of London Computer Centre
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
What instances can cause a Table to crash?
Is this caused by a bug in itself, a power failure, or something else?
Richard
>> William_dw,
>> Tuesday, July 23, 2002, 10:34:16 AM, you wrote:
>> WS> I'm hoping someone can give me a pointer as to what's
un/master.pid was not
created in 30 seconds; Aborting
make: *** [test] Error 1
Does any one know what I'm doing wrong??
Thanks in advance,
Richard Pijnenburg
Klik-on Internet solutions
The Netherlands
Sql,query
---
.frm', but I think that I've fixed this now.
>
> What happens when you try the 'mysql' command? I get the response
> "can't connect to local MySQL server through socket
> '/var/usr/mysql/mysql.sock'"
> And indeed there is no such file.
> D
The MySQL daemon does not run. I installed the binary RPM's from the RH cd,
MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
execute correctly. The I run safe_mysqld &, and I get:
[root@thor rfox]# /usr/bin/safe_mysqld &
[1] 2212
[root@thor rfox]# Starting mysqld daemon wi
Jenny Christy wrote:
> Hello All,
>
> Can anybody tell me the query or procedure by which i
> can generate the .sql file. So that I dont need to
> write the query again and again on prompt.
>
> Just by executing the .sql file(or script language), I
> will able to create table, insert the data o
Have any of you guys come across this,
http://www.firstworks.com/sqlrelay.html, as a way of managing fault
tolerance from clients accessing mysql databases?
Richard
-
Before posting, please check:
http://www.mysql.com
This is a known "problem", not a bug in mysql.
You can get the affected rows by entering this sql statement: "delete
from Sqs where 1>0"
Greetings, Richard
-Ursprüngliche Nachricht-
Von: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 15. Juli 2002 1
Jeremy Zawodny wrote:
>On Sat, Jul 13, 2002 at 09:25:32AM +0100, Richard Clarke wrote:
>
>>Heikki & Others,
>>
>> I read through the 4.0.2 Changelog but I couldn't find indication of
>>the following bug fixes.
>>
>>1. Was the bug with drop/
#x27;t.
2. Do Unions now work with big tables?
Richard
sql blah query blah
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
t; select * from items NATURAL JOIN shop_directory;
Empty set (0.00 sec)
What gives... why isn't it joining on directory_id. Using an inner join
with where condition it works fine.. but INNER JOIN should work also.. no?
"The NATURAL [LEFT] JOIN of two tables is defined to be semant
Hi,
I have a MyISAM table which has a run_id which together with user_id forms
the
primary key for the table. run_id is not null and auto-increment. I delete
records from this table, and add new records. I want the run_id to keep
incrementing and not reuse values, but here is the actual behavior:
But the default table type is already MyISAM
> That is the normal behavior for ISAM type files.
> Convert them to MYISAM.
>
> Richard Fox wrote:
>
> >>Hi,
> >>
> >>I have a mysql table which has a run_id which together with user_id
forms
> >>
This question relates to both mysql in general and the mysql++ C++ API in
particular, thus the adressing to both lists.
I have a DateTime object (really a formatted string) say "2002-07-10
11:38:38". I want to subtract some variable number of hours (from 0 to 11)
from it. How do I accomplish this
>
> Hi,
>
> I have a mysql table which has a run_id which together with user_id forms
the
> primary key for the table. run_id is not null and auto-increment. I delete
> records from this table, and add new records. I want the run_id to keep
> incrementing and not reuse values, but here is the actu
Can your INT id be overflowing, i.e. reaches the max value for int and
starting at 1 again?
Rich
- Original Message -
From: "Steve Hay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
> Hi,
>
> Continuing my troubles wi
Todd Cary writes:
> Is there a quick and simple way to move a MySQL DB from one server to another
> MySQL server? Can I just copy the tables?
>
for as far i know, you can just copy the directory ( DB ) from one server to
the other.
i've done it a couple times. and it stil works :)
> Todd
oing a multi-table join, or is that
> the only way to handle this???
>
This sounds similar to what's described here:
http://www.mysql.com/doc/e/x/example-Maximum-row.html
Hope this helps,
Richard
--
/
\ Richard M Davis
/ Digital Archives
\ University of London Computer Centre
/ Te
?
Thanks in advance.
Richard Davis
University of London
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail &l
Try this query:
SELECT
yourcolumn+1
FROM yourtable
ORDER BY id desc
LIMIT 1;
greetings,
richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
in 30 seconds; Aborting
make: *** [test] Error 1
My config line is:
./configure --prefix=/usr/local/mysql --enable-large-files
--without-debug --with-mysqld-user=mysql
I hope some one can help me.
Thanks in advanced.
Rich
Mathieu DESPRIEE writes:
>
> Hi all,
>
>
> I want to setup (on linux systems) a pair of redundant mysql servers,
> working this way :
> * one master and one backup
> * the master handles all the requests, the backup updates its data
> frequently (and, if possible, CONSISTENTLY) from the mast
try killall mysqld and then try to start it
Anil Garg writes:
> Hi,
> the sql process(on doing ps) shows the following process:
> /usr/local/bin/safe_mysqld --user=mysql
> when i kill this process and try to restart it with command:
> safe_mysqld --user=mysql
>
> it says "a mysql process al
in 30 seconds; Aborting
make: *** [test] Error 1
My config line is:
./configure --prefix=/usr/local/mysql --enable-large-files
--without-debug --with-mysqld-user=mysql
I hope some one can help me.
Thanks in advanced.
Rich
hp (the manual)
>>http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubs
mysqld and msqladmin are completely nonfunctional.
mysqladmin does not parse ANY option (hence cannot run shutdown,
report status, etc.)
mysqld breaks on ALMOST EVERY option in my.cnf, and aborts with
"signal 11" when run from the command line with ANY OPTION, like
--datadir.
3.23.49 worked fi
chine.
Any help would be greatly appreciated.
Richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail &l
chine.
Any help would be greatly appreciated.
Richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail &l
chine.
Any help would be greatly appreciated.
Richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail &l
Minor points:
Why didn't you add -I/usr/include/mysql to compile options instead of
changing to ?
Try posting to [EMAIL PROTECTED] instead, it's low traffic but the
correct list for mysql++
I upgraded to GCC 3.0.4 for other reasons and built mysql++ with that, and
never ran into the errors you
| C450 | C450 |
+--+-++
1 row in set (0.00 sec)
mysql>
I hope this helps.
Richard
>> I want to use SOUNDEX for name queries, but I don't
>> seem to be doing it correctly.
some insight.
Richard
p.s. please take no offence, I'm simply trying to say that the poster seems
to know nothing and has a long way to go.
- Original Message -
From: "Steven Kreuzer" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 9:47
>
> > INSERT INTO my_table VALUES (foo, foo), (bar, bar), (z, z)...
>
>From my own experience, by using this method, that is doing one insert per
200 or more rows I can increase the insert speed from between 5x - 10x. A
couple more performance improvements where made as well so that value isn
They are bugged in 4.0.1 (apparently fixed in 4.0.2) so I wouldn't rely on
them too much.
Richard
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 01, 2002 11:33 AM
Subject: Re: Unions
> A
perfect if you are doing any statistical calculations which involves
gathering the top 100 (or n) rows per id.
Richard
- Original Message -
From: "Kevin Fries" <[EMAIL PROTECTED]>
To: "'Richard Clarke'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Or another approach could be (using same example tables)
mysql> set @a:=0; set @b:=0; set @c:=0;
mysql> select
id,@b:=IF(id=@a+1,id,concat(@a+1,"..",id-1)),@a:=id,@flag:=IF(@b=id,id,"MISS
ING") from seq;
++---++-
--+
On the MySQL download page, 3.23.50 is not available, only 3.23.49a. Is
that the same thing?
Rick
-Original Message-
From: David BORDAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 5:34 AM
To: Inbal Ovadia
Cc: [EMAIL PROTECTED]
Subject: Re: mysql-3.23.50
I think you'll find
I don't know if this is just weirdness on my system but I thought I would
pass this on in case anyone runs into this problem. I'm converting some
Java/JDBC code from a commercial DBMS to MySQL. The existing code executed
the SQL statement "Select @@identity" after an INSERT to retrieve the
autoi
sql> reset master;
Ric
- Original Message -
From: "Iago Sineiro" <[EMAIL PROTECTED]>
To: "MySql Mail List" <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 6:14 PM
Subject: Can I remove innobd binarie files?
> Hi all.
>
> In the innodb directory I have these files (prototipo is the n
This is OT, perhaps post to comp.lang.perl.*?
Ric
p.s. try use DBI or use lib qw(/path/to/module)
- Original Message -
From: "Amy Zediak" <[EMAIL PROTECTED]>
To: "MySql List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 3:01 PM
Subject: @INC
>
>
> I'm a little confused on ho
I'm sure this question should be put in the docs. It's asked at least once a
fortnight. Welcome to the wonderful world of Mysql variables.
create temporary table productorder select *,(@a:= IF(@b=product,@a+1,1)) as
cnt, @b:=product from
products order by product,price;
mysql> select * from produ
Hi,
I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a
password is required for access.
Both GRANT and REVOKE give errors saying "Table 'User' is read only". A text
search in the manual for "read only" did not yield anything.
Is this an OS attribute that should be dealt with ma
Hello,
I'm new to MySql. I plan to switch my Java/JDBC web application to use
MySql. The application requires transactions so, as I understand it, I need
the table types to be BDB or InnoDB. Can anyone offer comments on which file
type is preferred? Is one more stable than another? Is there a sign
What about alot of conncurrent users running unions?
> This could eat up alot of memory.
> Is there a switch to stop unions from using heap tables?
>
> mike
>
>
> Heikki Tuuri wrote:
> >
> > Richard,
> >
> > > I will look at the UNION problem later
If I understand correctly, you have to define a char field as binary if you want the
database to treat it as a 'case sensitive' field. Is there any way via a SQL query to
force case sensitivity to be used for a non-binary char field? i.e.: for comparing
strings in a case sensitive way. Or is
Andy,
I believe that that file is an on disk temporary file that was created
during the query. I would suggest you wait for the recover to finish as I
think (hope) your data will be returned to a fairly normal state when it
does.
Ric.
- Original Message -
From: "andy" <[EMAIL PROTECT
"Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, May 19, 2002 1:01 PM
Subject: Re: 4.0.1 Bugs
> Richard,
>
> the assertion failure below is very probably caused by the SHOW CREATE
TAB
Pierre,
I'm not so sure what you are asking here but from this statement,
More importantly are there functions in mySQL I can call to convert a
standard date, ie "mmdd" to the expected mySQL value?.
I can tell you that mysql is quite happy to accept mmdd formatted dates
without any
Not a direct answer to your question here, but why keep backups on the same
server and in the same storage medium?
Ric.
- Original Message -
From: "kibserv-FtS Setiqueue" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, May 18, 2002 9:44 PM
Subject: Database and
give tables and queries here since they form a large set of
statistical analysis queries. Only information I can helpfully give is that
the same set of roughly 30 queries is run every 5 seconds 24/7. After about
5-7 days the db server segv's on both our 4.4-release machines.
Ric.
- Ori
List,
I wondered if any movement has been made to determine the cause of the
following "bugs" that I have come across using Mysql 4.0.1.
1) selectunion causes a temporary table full type error when the
datasets aren't even that large and when there is bags of disk space.
2) Under FreeBSD
Or goto http://www.innodb.com of course.
Ric.
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Sherzod Ruzmetov" <[EMAIL PROTECTED]>
Cc: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 11:49 PM
Subject: Re:
please see below
-- Forwarded Message --
FROM: "euro.support" <[EMAIL PROTECTED]>
TO: "Richard Morton" <[EMAIL PROTECTED]>
DATE: Fri, 17 May 2002 10:26:06 +0200
RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA249
Hello All,
I have a LEFT JOIN nested inside an INNER JOIN that generates a mySQL
syntax error. I'm new to mySQL so I wonder if anyone could help me
understand the problem. The query runs fine under PostgreSQL, MS SQL, and
MS Access.
SELECT
Recording.Entry, InstCode.InstType, Recording
e: 9 days 7 hours 25 min 52 sec
Threads: 2 Questions: 30874532 Slow queries: 1135 Opens: 3336 Flush
tables: 7 Ope
n tables: 86
How can I get this to work for hostname as well as localhost, hopefully
without distrupting any of the database users?
Thanks,
-
dvance for any help/information.
-------
Richard Idalski
System Administrator
Nando Media
Office: 919.836.4805
AIM: Ryusonuke
www.nandomedia.com
--
-
Before posting, please check:
http://www.mysql.com/
Hi,
I have had a similar problem...
This also occurs with ' or ".
in any field you expect this character use:
REPLACE("c:\mysql\test","\","/")
Returns the string str with all all occurrences of the string from_str
replaced by the string to_str:
mysql> select REPLACE('www.mysql.com', 'w', 'Ww')
's. Can anyone point me in the right
direction for finding these for Linux Libc 6?? Any Help is very appreciated.
---
Richard Idalski
System Administrator
Nando Media
www.nandomedia.com
--
-
Bef
ng the wrong thing.
Any further thoughts?
Thanks!
On Saturday, April 27, 2002, at 01:31 PM, Jeremy Zawodny wrote:
> On Sat, Apr 27, 2002 at 08:25:26AM -0400, Richard F. Rebel wrote:
>>
>> Hello,
>>
>> Perhaps I don't understand indexes but I was wondering h
aps MAX() uses the sort buffer? If so, how can I work out what to
increase the sort buffer to, aside from guessing.
Thanks for any help
Richard
-
Before posting, please check:
http://www.mysql.com/manual.php
Thanks for your input!
It is fixed now, by using the , instead of an and however, the thing that
threw me was that it didn't complain about it!
Thanks Again.
Richard
-Original Message-
From: Chris Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 5:10 PM
To: S
mysql> update contact set alternatepreference='C' and AltContactID='1' where
con
tactid=2;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
any ideas why the UPDATE did not perform an update?
Thanks
Rich
---
Hi,
Has anybody heard how the next version of either MyODBC (3.51) or MySQL
(4.0.1) are coming along and when they will be declared stable?
I started developing with 4.0.1, and although I have had no failures to
date, I was said that they would be declared stable in dec/jan. it is now
several mo
Hello,
When attempting to create some tables using the MySQL 4.0.1 alpha and
3.23.49, I'm getting a generic error message, "General error: Can't
create table './industria/ORDEREDITEMS.frm' (errno: 150)." The other 6
tables, all using similar features, are created without a problem.
perror just sa
().
If you need to know the internal machinations of mysql, I can only suggest
that you study the source code.
- Original Message -
From: Mick Watson <[EMAIL PROTECTED]>
To: Richard Emery <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 7:34 AM
Sub
Are you saying that you want a table with a maximum of 127 records ? Or,
that due to your TINYINT, you are RESTRICTED to 127 records?
If you are restricted to records, change TINYINT to INT.
If you want to have ONLY 128 records, change TINYINT to TINYINT UNSIGNED,
which will permit records 1 thro
mysql is acting correctly.
GROUP BY is used to consolidate data for SUMming, COUNTing, etc. Your
SELECT statement makes not such request. You have simply requested the
value of a specific field. Data are stored in mysql databases randomly.
Therefore, when you request a field's data, you are ge
I have a java application accessing MySQL via the mm.mysql type 4 jdbc driver. It
appears that when I insert a record with a DATETIME type in it, it's subtracting an
hour from the time.
Does anyone know why this might be happening? Is it a timezone or daylight savings
time issue? My server
show your table structures
show us your data
show us the commands you used to export the data
show us the commands you used to import the data
can't read your mind...
- Original Message -
From: Marcia Clover <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 15, 2002 12:11 PM
CREATE TABLE new_table SELECT * FROM old_table LIMIT 0;
- Original Message -
From: Jason <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 15, 2002 10:44 AM
Subject: Is there a sql query to Copying tables
Is there an easy way to copy/use the structure (not data) of a skele
This is mysql 4.0.1-alpha.
Ric
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 5:08 PM
Subject: Re: Re: unkown table is full
> Richard Clarke writes:
&
There is plenty of space. In excess of 5 gigs.
Ric
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 2:02 PM
Subject: Re: Re: unkown table is full
> Richard,
> Friday, April 05,
'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/redhat/BUILD/mysql-3.23.49'
make: *** [all-recursive-am] Error 2
Has anyone seen this before?
Thanks,
Richard
-
Before posting, please chec
> where can I find a simple php to generate a default html table
> from a MySql table ?
Try this (but specify your own username, password, database name, and query string
in the first three lines):
");
$numcols = mysql_num_fields($res);
// output field names for column headings:
for ($i=0;
mysqld --remove
use
mysqld --help
for more info.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:41 PM
To: MySQL-Mailingliste
Subject: Mysqld as service
Hi
How can i deinstall the mysqld as a service?
Thx for help
mfg
El
I am playing around with portable sql queries (mysql, oracle and
postgres). When executing:
ipplan=> BEGIN;
BEGIN
ipplan=> INSERT INTO area (areaaddr, descrip, customer) VALUES
(16777216, 'kjshdf', 1) ;
ERROR: Cannot insert a duplicate key into unique index
area_areaaddr_key
ipplan=> SELECT cust
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps. You also have the option of using datetime data
types. I'm not quite sure what you are asking nor what difference it makes
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From: "Luke van Blerk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 9:17 AM
Subject: InnoDB tables
> Hi everyone,
>
> I've been reading up about InnoDB tab
Hello Mr CEO,
Hmmm... go away?
Ric
- Original Message -
From: "Hugh O'Loughlin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 06, 2002 1:31 PM
Subject: Do any of your applications work?
Responsible Person,
We have been asked by a client, to use your products
join tables in the
> local and the server db's.
--Richard
> It's perfectly possible to join tables from different databases, as long
> as the databases are managed by the same server. Just qualify your
> table names with a leading database name.
>
> For example, a join
or sequentially.
However, I suggest you just try it if you can, and let us know what you find.
--Richard
> Can you please tell me, is it possible to do queries that join MySql tables that
> are in different databases?
>
> I have a couple of Delphi database programs that use Parado
Thanks to all the reponders. Just what I needed!
sql, query = filter pass
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 2:26 PM
Subject: Re: unkown table is full
> Richard,
> Thursday, April 04, 2002, 2:42:52 AM, you wrote:
>
> RC> create table test select *
ts to it, such as
"DELETE FROM table1" or DROP DATABASE. You can protect it in a variety of ways
such as: put it in a password protected directory, have it test for and reject
operations you don't want to happen,
require additional parameter(s) which validate the user, etc.
-
All
Could someone please update me as to when the 3.23.50 version of
MySQL/InnoDB will be released ?
We are experiencing issues with the loss of foreign key constraints when
using the ALTER TABLE command.
regards,
Chandran Honour.
Technical Director, BrowserAngel.
[EMAIL PROTECTED]
+44 (0)20 7
Duh! EXTRACT()
Sorry!
-Original Message-
From: Crook, Richard W [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:04 PM
To: '[EMAIL PROTECTED]'
Subject: string date thing
Hi all,
It's my first posting here so sorry if this is a silly newbie question for
501 - 600 of 836 matches
Mail list logo