Another thread pointed out that this runs on doze and Mac, I would venture to
say a lot if not most, on this list are *nix people, so the have gotton bad
press and have not targeted the correct userbase. Myself, if you spam me, I
will not look at you products. spam kills!
John
On Thursday 07
All releases of MySQL were GPL'd, see article:
http://www.mysql.com/news/article-23.html
John
On Wednesday 06 March 2002 15:17, Zengfa Gao wrote:
> Hi,:
>
> I heard that when we use MySQL on windows, we need to
> pay fees. But I can't find anything on MySQL document
> to talk about this.
>
> Do
Take a look at mysqldump
John
On Tuesday 19 February 2002 12:14, Sterling J. Anderson wrote:
> I am going to be copying some tables from one DB to another and was
> wondering if it is possible to have MySQL output the SQL Create Table
> syntax?
> I know there are products that will do that (ie.
Only the first TIMESTAMP field gets updated when an updat to a record is
made, so if you want to maintain the time a record was created, and when it
was updated, use two timestamp fields, the first field will be the time
updated, but to do this you must initialize the second timestamp field wit
On Wednesday 06 February 2002 12:29, Alok K. Dhir wrote:
> The way I look at it, MySQL gives you a choice of table types, so you
> can pick the one best suited to the task at hand. For raw speed where
> you can do without transactions, you can go with MyISAM. Otherwise you
> have Innobase. I'm
You must also define the tables you want to 'look' at in the 'FROM' clause
On Wednesday 30 January 2002 12:08, George M. Ellenburg wrote:
> Hello.
>
> If anyone has a quick moment, I would appreciate some suggestions with
> regards to the following select statement:
>
> SELECT widget_src FROM wid
Hi all,
I'm doing some experimenting with debian, has anybody created any .deb
packages for MySQL?
TIA,
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
In possibility 1, if the database is truly running on local, you should be
able to:
a)mysqldump --all-databases > all_that_dump.sql
b)mysql (logon stuff for remote machine) < all_that_dump.sql
Because the database is running on local the client (mysql) should also be
loaded.
Have a great da
Sinisa,
A good way to prove that mysqldump is doing what it should, might be to do a
describe TESTBADDUMP;
I think this will prove that mysqldump is just dumping what is in the table
def, which is all you can expect.
Have a great day...
John
On Monday 18 June 2001 09:46, Sinisa Milivojevic w
Try quoting (' ') the 0 in your create:
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default '0' );
-^
You should then get the result you want.
Have a great day...
John
On Monday 18 June 2001 08:54, [EMAIL PROTECTED] wrote:
> mysqldump r
Hello
I created a perl script that might help. Because I like to have a full backup
of my databases and table backups (I know I can split the full backup, but
I'm too lazy ;), I created a perl script that queries MySQL for the table
names in the database and then creates a shell script with in
Jeff,
This has been discussed before and I find it easier to just sort by the
'from' header in the message. Check the archives for more disscussion.
Have a great day...
John
On Thursday 22 February 2001 06:08, Jeff Gannaway wrote:
> Here's an idea for the list memebers and list master
>
>
Christian,
a DEFAULT value in a CREATE (or ALTER) statement must be a static value, try
using a TIMESTAMP field instead.
To use 'ERROR' in as an 'ENUM' DEFAULT it must be included in the definition,
i.e. ENUM('ERROR','TRUE')
Hope this helps...
John
On Thursday 08 February 2001 09:09, Christi
On Thursday 01 February 2001 11:43, Dickson Alastair T wrote:
> > >But you still have to buy the ORACLE software right?
>
> Nope. I got my Enterprise Edition Oracle8i free.
>
> The *support and training* is paid for (ooouch, very expensive),
> unlike mysql (free and from "the horses mouth")
>
> :
nly be there as a guide
> but would never give us the answer. I guess the quality of teaching and
> graduates have dropped greatly since I left high school.
>
> Cheers
>
>
> - Original Message -
> From: "John Cichy" <[EMAIL PROTECTED]>
> T
Human nature and education...
In most cases as youngsters we are 'given' the answers and the methods for
solving our problems. As we get older we continue to expect this and un-able
to function when told to figure something out.
My first computer class in High school (NCR Mainframe/BASIC), I h
16 matches
Mail list logo
