Hi,
How could I do this insert/select?
create table category
(
id tinyint(4) NOT NULL auto_increment,
name varchar(20) NOT NULL,
parent tinyint(4) NULL,
primary key(id)
);
insert into category (name, parent) values('cc_1',null);
insert into category (name, parent) select 'cc_2a',
+---++
> | id | name | parent |
> ++---++
> | 1 | cc_1 | NULL |
> | 2 | cc_2a | 1 |
> ++---++
> 2 rows in set (0.00 sec)
>
> mysql>
> -- excerpt --
>
>
> []s,
> Conrad
http://www.entropy.ch/software/macosx/mysql/remove-old-mysql.html
--
* Stephen Rosenberg
* http://www.lifug.org
* [EMAIL PROTECTED]
* [EMAIL PROTECTED]
On 9/6/02 11:02 AM, "Ilyas Keser" <[EMAIL PROTECTED]> wrote:
> Mysql creates over 900 files at an installation.
>
>Description:
When transfering a database application to use an Alpha Linux server
rather than intel Linux previously working regular expressions fail to work.
It appears to be due to a length limit. This effects both binary downloads
and home compiled distributions.
>How-To-Repeat:
Sim
Ilyas try this site, Marc has great instructions on setting everything up
and all the downloads you need...
http://www.entropy.ch/software/macosx/mysql/
--
* Stephen Rosenberg
* http://www.lifug.org
* [EMAIL PROTECTED]
* [EMAIL PROTECTED]
On 9/6/02 5:36 PM, "Ilyas Keser" <[EM
user permission to connect to one of the databases from anywhere.
I have the files actually on the server right now, and trying to use the domain name
or ip address and keep getting denied.
Is there something else I need to look at that I'm forgetting or missing?
--
Stephen Schneider -
Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)?
It would be handy to debug some scripts.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've started using the SELECT with no other clauses but I am still
curious about a PRINT-like command. It is for SQL scripts.
Rhino wrote:
- Original Message - From: "Stephen Cook" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Sunday, May 07, 2006 3
in the
same way as MySQL does, particularly "string expression" and "function",
I think we will find that the SQL SELECT will do all of the things that
Stephen has come to expect from the PRINT statement in MS SQL Server.
I've just put together an SQL Script that I think de
There are such things as extensions to the standard, and many languages
besides BASIC that have the ability to output a character string. No
need to be snippy.
I will look into the --silent option, thanks!
Peter Brawley wrote:
Stephen Cook wrote:
I appreciate it but SELECT isn't quite
-SQL ones since that is what I get paid for).
I'm not here to discuss people's religious beliefs, I'm here to learn
what MySQL can and can not do.
Peter Brawley wrote:
Stephen Cook wrote:
There are such things as extensions to the standard, and many
languages besides BASIC tha
There apparently isn't a PRINT or RAISERROR function like there is in
SQL Server, I've asked about this before.
I created a stored procedure to dump debug text into a table (which is
timestamped) and another to output the rows in there in a SELECT. It
isn't the same but it's something.
Dan
Hi,
For my current website project I'm developing a fine-grained access control
system.
I have the schema mostly worked out, although it will be having additional
data added to parts of it later.
For the record, I have 6 tables:
users (contains all my individual users)
usergroups (contains all
You can use the INFORMATION_SCHEMA.TABLES view to generate the GRANT
statements for you. Write a query along these lines:
SELECT CONCAT('GRANT SELECT ON test.', TABLE_NAME, ' to ''foouser'';')
FROM INFORMATION_SCHEMA.TABLES
WHERETABLE_SCHEMA = 'test'
AND TABLE_NAME LIKE 'foo_
depending on what you use this information for, you might want to keep
two tables, one with the current information, and one of the history. it
would keep the "current" one relatively small, but allow for looking up
historical data if necessary.
nephish wrote:
Hey there,
i have been messing
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't l
it is because of the dollar sign that it works so much quicker.
Scott Hamm wrote:
I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to
MySQL to learn the migration process and executed the following:
SELECT
*
FROM
QA
LEFT JOIN
Batch
ON
Batch.QAID=QA.ID
LEFT JOIN
QAErr
MySQL is a relational database. XML is a text file.
the biggest difference is that MySQL will let you organize, sort,
match/link (joins), and otherwise manipulate the data you have. XML is
just text with tags in a heirarchy; anything other than reading it in a
text editor will take programming
ore information about MySQLi here :
http://uk.php.net/manual/en/ref.mysqli.php
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am curious, can MySQL be used for Directory Sevices and act as an LDAP Server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
just as well to install one of the many MySQL
GUIs out there. I actually quite like MySQLs suite of tools now. Query
Browser is still a bit buggy, but its getting better each iteration.
http://dev.mysql.com/ - just check out the links in the box on the right
hand side.
Stephen
--
MySQL Gener
p.ID#">#qryLookUp.Description#
Where ID and Description are the column names in the look up table.
Hope this helps
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
His answer was correct, and somewhat politer than "RTFM".
As for finding your "own damn answers", see again Mr. Green's original
reply.
Beauford wrote:
Sorry, but I don't take kindly to idiots. I don't care if he's gods gift to
MySQL. If there isn't enough info for him to give an informed an
You must not install 5.0 over 4.1, put it somewhere else.
Also, instead of naming the service "MySQL" both times, call it
something else (i.e. "MySQL41" and "MySQL50"). If you use the Windows
installer distribution, it is one of the options; if you are doing it by
hand then you already know ho
s/query-browser/1.1.html) and MySQL
Administrator (http://dev.mysql.com/downloads/administrator/index.html)
for GUIs to manage your database server.
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What's the deal with SPAM on the list?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my spam f
Jim Winstead wrote:
This is addressed in the FAQ for the mailing lists.
http://lists.mysql.com/faq.php#replyto
Jim Winstead
MySQL Inc.
Times and technology change. Take a look at the changes to MySQL server
and the internet in general since 2000.
That's all I'm going to say as there a
Maybe it is because I am a programmer, but (unsigned) 0 - 1 = 4294967295.
What's the big deal?
Gleb Paharenko wrote:
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
mysql 5.0.15-standard
UPDATE SET = -1
when the is 0 gives me
I am scripting out the creation of a database so I can make changes and then
run the script to generate a clean copy (by running it in MySQL Query
Browser).
The script DROPs all the tables, then CREATEs them again along with all the
indices and whatnot. However, if I run the script after having r
(and of decent size) going I'll start using the other options; right
now I'm just playing with a throwaway database to get a feel for the syntax.
On 3/13/06, Andreas Krüger <[EMAIL PROTECTED]> wrote:
>
> Stephen,
>
> the behavior of MySQL server sounds bizarre, as
A commonly used example (at least at my last 3 jobs) would be a table of
demographics for people (whether they be employees, clients, whatever).
You can have one table and allow NULLs for some of the fields (id,
LastName, FirstName, MiddleInitial, Title, NameSuffix, AddressLine1,
AddressLine2,
On Sun, 15 Feb 2009, John wrote:
> How do I disable showing ALL the databases on the server for a normal user
> that only has access to a single database? So that when a user runs show
> databases, they only get a list of ones they can access. I've seen this done
> before.
>
> Sorry if it's a newb
> I've been poking around google looking for tutorials and/or quick start
> guides on optimizing the mysql server. We just upgraded our DB server from
> 2
> Gb of RAM to 16. But I don't know how to reconfigure mysql to take full
> advantage of it. Although, just installing the RAM seems to have
_entry >0
GROUP BY ee_entry
ORDER BY COUNT( * ) DESC
LIMIT 5
)
ORDER BY ee_entry DESC , dt ASC
But I received an error:
#1235 - This version of MySQL doesn't yet support 'LIMIT &
IN/ALL/ANY/SOME subquery'
Thanks for your help,
Stephen
--
MySQL General Mailing List
For list a
Can't get slow querys to log. Does this not work in myisam?
*snip*
[mysqld]
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
*snip*
restarted mysqld - no log.
Created in file in /var/log/mysql/
*snip*
-rwxr--r-- 1 mysql mysql 0 May 7 10:33 mysql-slow.log
*snip*
still no
nse that the longer your
transaction block is, the more time you spend holding (read) locks, and
thus excluding writers.
Hope that helps,
--
Stephen Tu
On Wed, Jul 11, 2012 at 5:46 AM, Reindl Harald wrote:
> > mysql> show profiles;
> >
> +--++--+
> > | Query_ID | Duration | Query
> > |
> >
> +--
QUESTION: What are the most secure permissions settings for administrator
access to connect to my server without using a static IP address?
MY ISP changes my DSL ip address almost daily so when I log on to MySQL
Administrator with 'myusername'@'currentipaddress' using password
'mypassword'
I
I have two tables.
TableA is current data.
TableB (created with 'Create Table A like Table B' ) is an archive where
deleted data is inserted from Table A before being deleted from table B with
"INSERT INTO TableA Select * , Null, NOW (), 'ACTION', 'USER' from TableA.
The null column in TableB
This works fine for me:
http://www.mysql.com/products/tools/administrator/
-Original Message-
From: Esbach, Brandon [mailto:[EMAIL PROTECTED]
Sent: Monday, February 18, 2008 12:22 PM
To: [EMAIL PROTECTED]
Cc: MySQL User Group
Subject: RE: Backup table structure, not data
I ended up usi
I got this recently and haven't replied to the list in a while. I responded
to the list owner.
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Monday, February 25, 2008 12:13 PM
To: mysql@lists.mysql.com
Subject: Re: Bogus unsubscribe!
> I just got an email fro
You should send that one to The Daily WTF... http://thedailywtf.com/
Jay Blanchard wrote:
[snip]
I recently last week Had and experience with an Very small Company,
where as
they had around 15 Machines all hooked "Star topology" and a central iis
ASP
Web server that only showed the date, and a
http://lists.mysql.com/[EMAIL PROTECTED]
that link ought to help you.
Jacques Brignon wrote:
Hi,
I keep receiving this message by several dozens each day, how can this
be stopped?
Regards
Jacques
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
Envoyé : jeudi
I always go with REPLACE(REPLACE(STRING, '\n', ''), '\r', ''), since
depending on where your data came from there may be one or the other, or
both. Although if there is a shorthand/more efficient way I'd love to
hear it.
[EMAIL PROTECTED] wrote:
Ok.. I found the problem.. I needed to add a \
; > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user 'root'@'localhost' (using password:
> YES)'
> > * end *
>
> That is asking for your *old* password.
I did not create any password before.
d
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
* end *
Stephen
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Chris <[EMAIL PROTECTED]> wrote:
- snip -
> So you *have* set the root password before.
>
> From your previous emails:
>
> # mysqladmin -u root password yourrootsqlpassword
>
> That set the password to "yourrootsqlpassword".
>
>
>
> If you need to reset it, see documentation:
>
> http
I'd go the other way and use a trigger to validate the data, and roll
back the transaction if it isn't in valid format (assuming you are using
transactions). This way, ANY app that puts data in that field gets the
validation. An error in an application or typing by someone who has
direct table
I think that offering some sort of feedback other than result sets would
be nice for debugging.
Peter Brawley wrote:
>I hope this isn't a silly question, or something covered in a FAQ. . .
>but is there any reason to not have at least some primitive print
>formatting commands in MySQL? Or a
replace [, user] with [, vmailuser]???
Please shed me some light. TIA
B.R.
Stephen Liu
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, 0 rows affected (0.00 sec)
mysql>
I suppose it has been done ???
B.R.
Stephen
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ne 4.3
To safe guard, it would be better to run 'FLUSH PRIVELEGES'.
Can I re-run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
then
FLUSH PRIVELEGES;
???
Tks.
B.R.
Stephen
Send instant messages to your online friends http://uk.messeng
gt; FLUSH PRIVELEGES;
>
> Yes. I think on this recent a version, it will have no effect, but
> will not harm anything.
Noted with tks.
B.R.
Stephen
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Stephen Liu wrote:
> >> If you want to
> >> get rid of the user entirely, use DROP USER.
> >
> > Could you please explain in more detail??? Where shall I add "DROP
> > USER"
>
> The
If you can import your excel doc into MS Access I'd suggest:
http://www.mysql.com/products/tools/migration-toolkit/
I just started using and love it - easy intutitive GUI tool for importing
data into nySQL databases.
Good luck.
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROT
I've recently converted a CRM database with about 20k entries. I exported
the data to ACCESS had to tweak the field names and value then Inserted all
into mySQL with mySQL Administrator. During the conversion out of the CRM
into ACCESS the unique Primary Key for each contact, which is also the
F
____
> Ext3-users mailing list
> [EMAIL PROTECTED]
> https://www.redhat.com/mailman/listinfo/ext3-users
>
--
Stephen Samuel http://www.bcgreen.com
778-861-7641
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I executed an insert...select and some empty fields were inserted into a
table. I'm trying to delete these empty fields but a look up for:
FIELD = ''
FIELD = 'null'
FIELD = '0'
FIELD = '[SPACE]'
Returns nothing.
What should I be looking for to delete these empty fields?
Thanks.
--
MySQL G
I was able to delete them using the CreateDate timestamp.
For future reference what is the difference between = and is
if I may ask.
Thanks.
-Original Message-
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 1:20 PM
To: Stephen Sunderlin
Cc: mysql
Thanks!
-Original Message-
From: Gary Josack [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 2:47 PM
To: Stephen Sunderlin
Cc: mysql@lists.mysql.com
Subject: Re: Finding empty feilds
NULL does not equal "", " ", "null", "0", 0 or an
and running. I just
want something similar for Linux.
Rekall looks like a tool that would meet my needs, but I'm getting
frustrated with the install process. Has anyone gone through that and
found a better way? Or does anyone have an alternate recommendation?
Thanks
Stephen
--
MySQL Gene
LONG datatypes may throw a monkey
wrench in the works.
Good luck.
Stephen
(Sr Oracle DBA by day - Jr MySQL DBA by night)
On Tue, 22 Mar 2005 10:48:53 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Z X C V <[EMAIL PROTECTED]> wrote on 03/21/2005 08:32:24 PM:
>
> >
his system has been running fine for months
until now.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a good place/book to lookup formulas for tunning mysql ?
What size should the table_cache be ? I have 2,770 tables
What size should the key_buffer be ? I am only using 38 MB out of 265
MB, yet my Index Length reported by mysql-administrator is 2.72 G
Total number of records are 61 M
- Original Message -
From: "Andy (da man) Rosenblatt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 29, 2003 4:05 PM
Subject: HELP!
> hi
> I bought a book with your mySQL program and seemed to have installed it
worng and i cant stop it. I never set a user name or
- Original Message -
From: "Chris Boget" <[EMAIL PROTECTED]>
To: "Greg Jones" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 8:32 AM
Subject: Re: Query Help
> > Access. However, when I run it against MySQL I get an error.
> > select l.ltsysid,l.lientraknum, c
- Original Message -
From: "Ville Mattila" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 4:07 AM
Subject: Join only the latest entry...
> Hello there,
>
> I have a table including information about my projects, the structure
> has each id and name. Then
I agree with Dan.
We looked into this years ago.
We have MANY machines with many tables used this way.
It is easy when you realise that one SQL command can access multiple
databases, using db1.tablea ... db2.tableb syntax.
Stephen
- Original Message -
From: "Dan Greene" <[EM
.
- Allow the use of InnoDB etc.
- Allow mysqld to have full control.
I recommend you just use SQL for everything.
Regards,
Stephen
- Original Message -
From: "Stéphane Bischoff" <[EMAIL PROTECTED]>
To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, December 1
message to
[EMAIL PROTECTED]
The posting today by Jim Winstead of MySQL AB indicates that SpamCop might
be involved. The message is not clear to a non email techo like myself, so I
expect to see more comments in that thread.
Good luck,
Stephen
- Original Message -
From: "Freddie Sor
Hello Jim,
Would you please look at my comments under the thread "Not receiving list
emails", in case that puts further light on this matter.
Thanks,
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
In general, is it more efficient to do many queries or one "large" query
with many joins?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I downloaded MySQL AIX 4.3.x and was looking to see if it would run on an as/400.
The as/400 ( iSeries ) has an AIX runtime library support (PASE), when I try to
execute mysqld I
get:
Dependent module libnsl.a(shr.o) could not be loaded.
Does MySQL actually use this library ?
If not is there a
- Original Message -
From: "Jon Haugsand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 2:57 AM
Subject: Re: XML in MySQL
> * [EMAIL PROTECTED]
> > geez mysql is an open source product you cannot expect so much too soon
over
> > a very expensive commercial prod
Does the ip address of where you are trying to access the mysql database
from (client), change?If you have a dynamic ip address
your ISP should have a grant something to the effect of:
grant all on database.* to [EMAIL PROTECTED] identified by 'password';
This would allow your client to be a
It depends on what you want to know.
I used _Fundamentals of Database Systems_ (Elmasri and Navathe) when I took
a DB course. It was pretty good, though my impression is that there might
be a "classic" which is better.
The problem with the more MySQL-specific books is that you might not learn
th
it using switch "-r" or "-o"
--
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
into this limitation, so all I can reason is
that either a) the functionality's in there, and my Google skills have
failed me, or b) there are valid reasons for the lack of inclusion, and
there's a simple workaround. If either is the case, please, let me know!
Thanks in advance.
-
m logging everything remotely. If the solution is not real-time,
theoretically someone can gain unauthorized access and remove traces of
their entry before the logs are batched up and sent. This is what I want
to prevent.
Stephen Touset
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Stephe
> hmm well sorry to be unclear i know this works but it would return more
> results than needed also i cant expect users to add this themselves, like
i
> would have to add the astrerix to every word in that case like i do to get
> all words ;\
I don't know the MySQL issues (I'm now using some FULL
);
mysql_query(&mysql, updateStr);
}
However, when I do this, I get:
Commands out of sync; You can't run this command now
Anyone have any ideas on how to to accomplish this?
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ed. Any rows that I haven't
processed yet should keep the old timestamp.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as it took to get
one. So, for example, I can process thousands of records in four
seconds or just one.
I did resolve my problem, however. I created a temporary database
connection to do the updates.
...Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a database that is constantly moving large numbers around.
At the moment when a simple INSERT into Table_Name
('3573286532896523465328654654365436543'); is run
the value entered into the table is a zero. The field type that I am inserting
into is DOUBLE(200,0) unsigned.
Also this is all
rname IN ('stotts','statts','stutts')
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html#IDX1235
Regards
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ian Grant wrote:
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti <[EMAIL PROTECTED]> wrote:
Kentucky Families wrote:
... If I use a VARCHAR or TINYEXT field to enter these values and
I want to be able to retrieve all records where the surname field
contains the whole word Stott
Manish wrote:
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers
in -
mysql-connector-java-2.0.14-bin.jar
Do these drivers work with MySQL 4.1.8? hey seem to be working fine with
4.0.14 version of MySQL.
Is there any compatibility data available for all these JDBC drivers a
similar on the connection procedure. Does anyone know or have
any suggestions as to where I can find such
information?
Thanks,
Stephen Finn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
databases that we are using. Neither is very big but one
is updated very frequently and the other one is not. However, even
though the databases are small, the ibdata1 file is 136M. Is there a
way to prevent this file from growing too big?
...Stephen
--
MySQL General Mailing List
For list
databases but one gets
backed up much more frequently than the other. The whole operating
system and application is stored on the flash drive.
HEAP tables might be the solution. How would I archive these to disk on
shutdown?
...Stephen
-Original Message-
From: mos [mailto:[EMAIL PROTEC
I just looked into this. It looks like HEAP tables don't support the
BLOB field type and we are using it.
...Stephen
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 6:19 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Data
ing I could get running on QNX.
...Stephen
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 10:23 AM
To: [EMAIL PROTECTED]
Subject: RE: Installing MySQL Databases on RAM Drive
Ok, then it makes sense to use compact flash just for backup and not the
primary
I reformated the hard
drive and reinstalled. In order to install, I copied the
/usr/local/mysql directory from a working system.
Stephen Rasku
Tantalus Systems Corp.
Your Power. Your Data. One Wireless Network.
T: 604-299-0458 x220 F: 604-451-4111
www.tantalus.com
--
MySQL General Mailing List
Never mind. I installed MySQL from a different location and now it
works.
...Stephen
> -Original Message-
> From: Stephen Rasku [mailto:[EMAIL PROTECTED]
> Sent: September 23, 2004 9:32 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL client hangs
>
>
> I am run
> Hello MySQL programmers,
>
> suppose we have an Enhanced ER diagram,
> with entities as classes/ subclasses connected through
> some IS-A relationship.
>
> How can this be Coded in MySQL Please?
>
> My prerequisites are the basic database texts from
>
> http://www-db.stanford.edu/~ullman/dscb.h
ribed above.
Any pointers or help would be much appreciated.
Regards
Stephen McMullan
ANAM Wireless Internet Solutions
http://www.anam.com
+353 1 284 7555
Castle Yard, Saint Patrick's Road, Dalkey, County Dublin, Ireland
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Morten,
I'd like to help you with actual code, but I can't, because the version of
MySQL I use doesn't implement foreign key constraints.
In my own code (written in the C API), I plan on checking these constraints
myself. But I can't implement them in the tables themselves.
Best,
Steve Fromm
I got a bounced email with an attachment entitled macex.mex.scr, about 72.3
KB, which if IIRC is probably the Sobig.F virus. It appears to have been
sent to people on this list (even though the list wasn't in the "to:" line)
because the body of the email discussed MySQL.
Since Sobig.F forges the
What I'd like to do is create a textfile and then import the whole thing
into a table. So, naturally, I've a few questions.
Do I need to include the column heads as a line in my textfile, or can I
simply go straight to the data?
Assuming, no column heads are necessary--because they're already t
1 - 100 of 280 matches
Mail list logo
