bluejack wrote:
On Tue, 28 Oct 2003 14:00:02 -0800, Kevin Fries <[EMAIL PROTECTED]> wrote:
That's not how it works. The following demonstrates the feature I think
you want.
mysql test
test> create table testnull ( X varchar(10) not null );
Query OK, 0 rows affected (0.11 sec)
test> insert into
mos wrote:
At 04:00 PM 10/28/2003, you wrote:
That's not how it works. The following demonstrates the feature I think
you want.
>mysql test
test> create table testnull ( X varchar(10) not null );
Query OK, 0 rows affected (0.11 sec)
test> insert into testnull values ( null );
ERROR 1048: Column '
I am upgrading to Panther and I need to install MySQL. Does anybody
know if the Mac OS X Installer Package v10.2 (Standard) works with
10.3? If it doesn't then what would be the best installation method on
a clean 10.3 installation?
Thanks,
-Sam Carpenter
--
MySQL General Mailing List
For
On Tuesday 28 October 2003 11:24 am, Dathan Vance Pattishall wrote:
> Think of a binary tree.
>
> Parent_id auto increment
> Child_id
>
> Details of the famly
>
> The head of the family has a child_id == parent_id
>
> All members of the family have different child_ids but the same
> parent_id
>
> T
Thanks for all your help, but my main problem now is, how to show the
relationships. I mean, OK, I trace the names in my database, but how to show
the relationship to the user, searching for it?
Should I draw a complete tree that means all the people involved between the
actual two, or I
Héctor,
Changing various buffer sizes can improve performance significantly,
with key_buffer_size as the first thing to tune.
Also, make sure you are using not debugging version of the server.
Please also take a look in this section of the documentation
for details:
http://www.mysql.com/doc/en/
James,
> We had a strange instance happen here with one of our MySQL servers.
> We have multiple MySQL installations, and one of the MySQL servers had a
> problem with daylight savings time.
>
> Basically, when we ran a select now(); MySQL reported time that was two
> hours ahead of the actual t
Hmmm... I fixed the problem but I still don't know what caused it. That same query now
produces the below EXPLAIN result and now
runs 70% faster.
I ran OPTIMIZE TABLE on Spells and Classes, that made Spl rows 1, then I forced the
Cls table to use the Object index and it worked.
Now, I can't get
Thanks for the information. I to found a work around-a much uglier
approach.
For all ALTERs of a src table to work when synonyms of tables are
present: perform the ALTER on the slave itself and add to
skip-slave-errors=1060
This is a quick work around. Very very ugly.
- Dathan Vance Pattishall
Hello,
We had a strange instance happen here with one of our MySQL servers.
We have multiple MySQL installations, and one of the MySQL servers had a
problem with daylight savings time.
Basically, when we ran a select now(); MySQL reported time that was two
hours ahead of the actual time. The syst
At 15:09 28.10.2003 -0600, gerald_clark wrote:
Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status,
Could you look at youre hostname.err file and see if it says checking
table?
Also try mysql -A sampdb
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Anderson, James H [IT] [mailto:[E
Hi, I'm not sure I understand indexes properly.
In this EXPLAIN, I expected the Cls (Classes) table to be of type ref with
the key being ObjectID. I'm joining both identically as far as I can tell,
on one of the columns in the primary key, which is set to a key itself, but
Cls is joining on ALL. W
Around Tue,Oct 28 2003, at 12:15, Nitin, wrote:
> Hi all,
>
> I'm developing a web based ancestry program. The user wants it to be static, that
> means, it isn't for all to use, but his family. Better to say, it'll contain only
> his family tree.
>
> Now, I cant think of the proper db design,
At 04:00 PM 10/28/2003, you wrote:
That's not how it works. The following demonstrates the feature I think
you want.
>mysql test
test> create table testnull ( X varchar(10) not null );
Query OK, 0 rows affected (0.11 sec)
test> insert into testnull values ( null );
ERROR 1048: Column 'X' cannot be
>so funtions that can be performed by relation algebra are a subset of the
>functions performed by a relational database?
>however isn't it required for a relational database to perform all the
>functions of relation algebra?
Saqib, there are multiple relational algebras. No db fully implements C
At 03:49 PM 10/28/2003, you wrote:
Is it possible to define required fields in a MySQL table?
By that I mean if the row is updated and the field value is still null,
the update for the row is rejected and an error is produced.
The "NOT NULL" clause in the table definition simply converts NULL val
On Tue, 28 Oct 2003 14:00:02 -0800, Kevin Fries <[EMAIL PROTECTED]> wrote:
That's not how it works. The following demonstrates the feature I think
you want.
mysql test
test> create table testnull ( X varchar(10) not null );
Query OK, 0 rows affected (0.11 sec)
test> insert into testnull values (
BTW, nothing's changed in my.cnf...
.my.cnf
---
[client]
host=localhost
user=jim
password=password
No query, I just entered 'mysql sampdb'. It hung indefinitely; I had to kill
the window.
Since I couldn't get into mysql I don't know the value of any variables.
-Original Message-
Fro
That's not how it works. The following demonstrates the feature I think
you want.
>mysql test
test> create table testnull ( X varchar(10) not null );
Query OK, 0 rows affected (0.11 sec)
test> insert into testnull values ( null );
ERROR 1048: Column 'X' cannot be null
test>
> -Original Mess
Is it possible to define required fields in a MySQL table?
By that I mean if the row is updated and the field value is still null, the
update for the row is rejected and an error is produced.
The "NOT NULL" clause in the table definition simply converts NULL values
to '' or zero for string and n
Can you post youre my.cnf options / your query in question / how long
have you seen it hang / what status it is in / and your show status
vars.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status, creation_date,
last_login_date) values ('35F7A
Much to my surprise and chagrin, I'm having a problem using MySQL after upgrading to
the latest release of Mac OS X this past weekend. As far as I can tell, the server
seems to be running, but when I attempt to execute the mysql command it just hangs.
Any ideas?
Thanks,
jim
--
MySQL General
source='sort.c' object='sort.o' libtool=no \
depfile='.deps/sort.Po' tmpdepfile='.deps/sort.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -O3
-DDBUG_OFF -c `test -f sort.c || echo './'`sort.c
/bin/sh ../libtool --mode=link gcc -O3 -DDB
Begging to differ, no vendor that I'm aware of claims to be compliant with a
paper or textbook. They tend to comply with an adopted standard such as:
ANSI/ISO/IEC 9075-1(through 5):1999
ISO/IEC 9075-1(through 5):1999
Collectively known as SQL:1999. While I'd offer that MySQL *is* a relational
dat
It has been a while since I have looked, but I believe the National
Genealogical Society has a data model for family tree software. The
following links are to the NGS and GEDCOM is the file format standard.
I think it should be an easy conversion to a database structure. If you
do something that
Hi!
For decades, people have debated in comp.databases.theory and elsewhere how
a 'relational database' should be defined.
Codd's original 1970 paper sketches the relational algebra as a query
language of a relational database, though Codd is not very precise about
what the query language exactly
On Tue, 28 Oct 2003 11:56:54 -0800, Jon Frisby <[EMAIL PROTECTED]> wrote:
MySQL may or may not conform to some standard or another, and it may
or may not perform the tasks that you, personally, want it to, but
in fact it *is* a relational database, as opposed to a flat file or
an object database.
so funtions that can be performed by relation algebra are a subset of the
functions performed by a relational database?
however isn't it required for a relational database to perform all the
functions of relation algebra?
Saqib Ali
-
http://validate.sourceforge.net <--- XHTML/HTML/DocBoo
Martijn Tonies wrote:
Nevertheless, I received the information that MySQL don't support
relacional functions between tables of the same database. I'm not sure
about this, and I'd like to confirm this information. Does MySQL allow
relacionl functions between tables recognizing "foreign keys"?
Ex
Hi guys!
Ok, I'm closer to beat Rushmore (VFP optimizer) now!
After some reading about MySQL optimization techniques,
here is the summary of what I've done:
1. Add a compound index to the table
2. Use EXPLAIN to check out the query (with GROUP BY on multiple fields)
3. Create the summary table
And
well... when I do db design, I tend to start with the objects of my system. The one
that comes to mind in your case is people.
so you'll need a people table.
well what are the details of a person?
first_name
Last_name
Middle_name1
Middle_name2
Maiden_name
[any other basic bio data]
so you'l
On 28 Oct 2003 at 13:59, Dan Greene wrote:
> Is there a way to do this on a live running (i.e. production) server?
http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list
OPTIMIZE TABLE but... it will bring down your server if the table being
optimize requires any sort of traffic. Depending on which mysql version
your using OPTIMIZE TABLE will take longer since you can't allocate more
memory as you can on the command line with myisamchk, unless you restart
the serve
Is there a way to do this on a live running (i.e. production) server?
> -Original Message-
> From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 28, 2003 1:49 PM
> To: 'Iago Sineiro'; 'MySql Mail List'
> Subject: RE: Howto reduce size of MYISAM files after dele
> -Original Message-
> From: Parminder Singh Chauhan [mailto:[EMAIL PROTECTED]
>
> After long struggle I (A newbee to linux) was able to setup mysql4.0.16
> and I don't know what I have done, I set the root password which I don't
> know. Now I can't access the mysql.
> Is there anyway o
Shutdown the mysql server
Goto the datadir (/var/lib/mysql)
Goto the db directory
Type
myisamchk -r -S -a *.MYI this will reclaim the bad blocks caused by the
delete.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->
As ROOT on linux goto /etc
Edit my.cnf
Enter skip-grant-tables
Restart the mysql server
Change the password.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Parminder Singh Chauhan [mai
Hi.
I delete a lot of records of one MyISAM table in MySQL 4.0.16. After that I
execute mysqladmin refresh and now the size of the files of the table is the
same than before.
Is something wrong or is necessary doing something more to reduce the size
of the files?
Thanks in advance.
Iago.
--
--- Begin Message ---
Well, my database should be able to check some entry data and decide if these
data will be accepted or rejected in a table that records all the received data.
For example: I'll have a table 1 that contains a list of all the equipments that
can send information to the database
After long struggle I (A newbee to linux) was able to setup mysql4.0.16
and I don't know what I have done, I set the root password which I don't
know. Now I can't access the mysql.
Is there anyway of changing root password.? and how?
I tried to delete the content of /usr/local/mysql/var/mysql and
Think of a binary tree.
Parent_id auto increment
Child_id
Details of the famly
The head of the family has a child_id == parent_id
All members of the family have different child_ids but the same
parent_id
Then you can do some really cool recursive fast searches.
- Dathan Vance Pattishall
-
Can you check you keys_used status var. You may have run out of your
key_buffer cache so things might take a much longer amount of time.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From:
Vinita,
it is most probably this bug fixed in 4.1.14:
"
Fixed a bug: if in a FOREIGN KEY with an UPDATE CASCADE clause the parent
column was of a different internal storage length than the child column,
then a cascaded update would make the column length wrong in the child table
and corrupt the c
bluejack wrote:
On Tue, 28 Oct 2003 14:13:45 +, Raiko Gonzales <[EMAIL PROTECTED]>
wrote:
perhaps this questions is not directly MySql related but MySql is very
related with my question. I'm learning Paul Dubois MySql and Perl for
the web and I have a lot of problems make working the Mail::
At 2:13 PM + 10/28/03, Raiko Gonzales wrote:
Hello,
perhaps this questions is not directly MySql related but MySql is
very related with my question. I'm learning Paul Dubois MySql and
Perl for the web and I have a lot of problems make working the
Mail::Sendmail module.
Here's the concerning
On Tue, 28 Oct 2003 14:13:45 +, Raiko Gonzales <[EMAIL PROTECTED]> wrote:
perhaps this questions is not directly MySql related but MySql is very related with my question. I'm learning Paul Dubois MySql and Perl for the web and I have a lot of problems make working the Mail::Sendmail module.
In
Hello,
perhaps this questions is not directly MySql related but MySql is very
related with my question. I'm learning Paul Dubois MySql and Perl for the
web and I have a lot of problems make working the Mail::Sendmail module.
Here's the concerning script :
#!/usr/bin/perl -w
# testmail.pl - Send
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I have
problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status, creation_date,
last_login_date) values ('35F7A660096411D89BC0D1907F
Hi there,
Cool, I'm not imagining things :)
> 1) creating a *unique* temporary table using the SESSIONID, in a
> separate DB where the tomcat 'user' has DROP privileges, and use
> a method implementing HttpSessionBindingListener to drop that
> table when the session terminates;
I cur
a question...
is any DB that complies to the "Relational Algebra" a "Relational DB"???
Saqib Ali
-
http://validate.sourceforge.net <--- XHTML/HTML/DocBook Validator
On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote:
>
> I tend to agree with the past two posts that mysql is in fact relational,
Try doing a web search for the program geneweb. It's done by someone in
France but there are English versions as well. It's freeware. It's a
web based genealogy program and has a built-in database. No need to
reinvent the wheel.
--
MySQL General Mailing List
For list archives: http://lists.my
Hi,
> >> If you are trying to determine whether MySQL is a relational database,
> >> the answer is yes.
> >
> >Ehm... the answer is "no".
> >
> >It's getting better, that's for sure.
>
> MySQL may or may not conform to some standard or another, and it may
> or may not perform the tasks that you, p
I tend to agree with the past two posts that mysql is in fact relational,
and would like to add that if we are going to make blanket statements that
something IS or IS NOT that we qualify our responses. personlly i would
like to know why Martijn views it as being a non relational db, without
argu
10/28/03 8:11:16 AM, "Martijn Tonies" <[EMAIL PROTECTED]> wrote:
>>
>> If you are trying to determine whether MySQL is a relational database,
>> the answer is yes.
>
>Ehm... the answer is "no".
>
>It's getting better, that's for sure.
MySQL may or may not conform to some standard or another, and
Hi Martijn,
With respect, I must disagree with your assertion that MySQL is not a relational
database. I did a Google on "definition of a relational database" and found a good
definition at
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci212885,00.html. If you
read this you will f
> >Nevertheless, I received the information that MySQL don't support
> >relacional functions between tables of the same database. I'm not sure
> >about this, and I'd like to confirm this information. Does MySQL allow
> >relacionl functions between tables recognizing "foreign keys"?
> >Excu
Michael McTernan wrote:
My problem, that so far no one has been able to answer, is that I'm using
connection pooling with the Tomcat server.
TransactionA gets connection A from the pool.
TransactionA creates a temporary table for some query.
TransactionA is done, and returns the connection to th
Okay - I can't figure this out as a single sql statement.
However
Assuming there aren't likely to be duplicate rows you could do:
create table temp2 (table definition) select max(endtime), non_unique_id
temp1
group by non_unique_id;
then you could select a.endtime, a.need_id, b.unique_id
fro
On Tuesday, Oct 28, 2003, at 15:19 Africa/Accra, Erich C. Beyrent wrote:
Hey folks,
I am having a dreadful problem here, and I cannot get to the root of
it. It
appears that every time I do an INSERT, the insert happens twice. I
have
spent several days on Google, but with no luck.
Some backgro
I just recently helped someone else with a similar issue
is your PHP code (and therefore your insert) getting executed when the form is being
displayed to the user initially, and then again when the form is submitted?
> -Original Message-
> From: Erich C. Beyrent [mailto:[EMAIL PRO
Hey folks,
I am having a dreadful problem here, and I cannot get to the root of it. It
appears that every time I do an INSERT, the insert happens twice. I have
spent several days on Google, but with no luck.
Some background - I am using PHP and Smarty on a site. Here is one of the
tables in my
I have upgraded my mysql version to 3.23.58 and am coming up with a couple
of errors using phpmyadmin to "Insert data from a textfile into table" I
didn't get this on the previous versions of mysql. Here are the errors:
SQL-query :
LOAD DATA INFILE '/tmp/phpKFlQ2b' INTO TABLE `annsubscribers
10/28/03 6:50:26 AM, Juliana Gubert Ehrensperger <[EMAIL PROTECTED]> wrote:
>Nevertheless, I received the information that MySQL don't support
>relacional functions between tables of the same database. I'm not sure
>about this, and I'd like to confirm this information. Does MySQL allow
>relaci
Dear Prashant,
This list is for MySQL questions, rather than PHP questions. Please try
the PHP general mailing list ([EMAIL PROTECTED]).
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
> -Original Message-
> From: Prashant A [mailto:[EMAIL PROTECTED]
> Our Site is running on Linux/Apache/PHP/MySQL Combination.
> I am unable to retrieve the Values passed from HTML
> FORM(test1.html) in a PHP Page(test1.php)
>
> Is it something to do with the Web Server Settings or any t
you need to use $_POST['test1']
http://www.php.net/register_globals
php, by default has register_globals=off. for security reasons...so you'll
need to use $_POST, $_GET, $_FILES, $_REQUEST etc.
hth
jeff
Thank You. I found out that I had to run mysql_fix_privilege_tables program.
Thanks
Steve
At 08:07 AM 10/28/2003, you wrote:
Hi there,
I guess you are going to have to grant this at the database level,
unfortunately for you. These privileges are stored in the mysql.db and
mysql.host tables, or
Dear Sir
Our Site is running on Linux/Apache/PHP/MySQL Combination.
I am unable to retrieve the Values passed from HTML FORM(test1.html) in a PHP
Page(test1.php)
Is it something to do with the Web Server Settings or any thing else...?
The code is as follows;
Test1.html
Test
Yes it does.
- Original Message -
From: Juliana Gubert Ehrensperger
To: SQL List
Sent: Tuesday, October 28, 2003 8:50 AM
Subject: Foreigner keys in MySQL?
Hello all,
I'm joined to a research project and by now we need to specify a
software to build a database.
Al
Hi,
If you mean foreign key constraints, it's available with InnoDb tables under
MySQL, as are atomic transactions (commit and rollback). I'm using this
with MySQL4.0 and it works a treat :)
Thanks,
Mike
> -Original Message-
> From: Juliana Gubert Ehrensperger [mailto:[EMAIL PROTECTED]
Ok. Someone else was talking about this earlier in the list, but I didn't
see the answer that I am looking for. I have just setup a new RedHat 9.0
server with MySQL 3.23.58. My program that worked on an older version of
MySQL doesn't work on this one. The problem is that the temporary tables
Hello all,
I'm joined to a research project and by now we need to specify a
software to build a database.
Although I don't have so much information about this kind of
software, I've been considered MySQL a good option, as it's an open
source database and this project has been developed in a
> > mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
> TABLE quantis_mkr;
> > Query OK, 271392 rows affected (4 min 2.95 sec)
> > Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
> >
> > How can I see those warnings?
> > I checked the error log but nothing shows up there.
> >
>
Hi
can anybody tell me the most common reason WHY an index file get's
corrupted?
I have tested this on differernt versions of MySQL (3.23.37 - 4.1) on Linux
and on Windows.
It happens on tables containing
A MEDIUMTEXT or LONGTEXT column,
A fulltext index on these columns
I am mostly work
I accept, that i was wrong, but you need to have a better look too. ALL is
as good as ALL PRIVILEGES.
- Original Message -
From: "Patrik Fimml" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "Victoria Reznichenko"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2
Hello all,
We recently upgraded from mysql 3.23 to 4.0 just a week ago. It all went
very well, and the performance gains have been simply incredible!
But now the server has started to act strangely. Every now and then,
usually every few days, the server starts to refuse connections, saying
that th
As far as I know, you aren't going to have a problem. But I am not
familiar with connection pooling with Tomcat, so I can't say for sure on
this subject. You might just have to do some testing to see if they share
the temp table or not.
Steve
At 05:51 AM 10/28/2003, you wrote:
Hi Steve,
Tha
[EMAIL PROTECTED] wrote:
>
> I've reinstalled my system (Mac OS 10.3 Server).
> In trying to get MySQL going again. I can run mysql_install_db, but I
> can't access the mysql db and I can not set a root user password.
> If I try to login: mysql -u root
> it says access denied to [EMAIL PROTECTED
> i dont think there's any privilege called "ALL PRIVILEGES". You need to say
> just "ALL", like:
>
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> '12345678' WITH GRANT OPTION;
> GRANT ALL ON *.* TO newuser@"%" IDENTIFIED BY '12345678' WITH
> GRANT OPTION;
Maybe you should read the docum
Hi Steve,
Thanks for your reply. I agree that TEMPORARY TABLES are really great, and
I'm using them in a similar way to your description, and I think I
understand their purpose.
My problem, that so far no one has been able to answer, is that I'm using
connection pooling with the Tomcat server.
"Ben Darlow" <[EMAIL PROTECTED]> wrote:
>
> I've recently set up a new linux box and installed MySQL 4 (for the
> record, Knoppix/Debian and the 'unstable' MySQL 4 package). I've had no
> problems connecting using phpMyAdmin, but when I try to connect remotely
> using MySQL Control Center or SQLyo
At 03:04 PM 10/27/2003, you wrote:
Does anyone know whether the use of persistent connections with php will
allow a temp table created by a script to linger around and cause a problem
with the next execution of the script when it tries to create the temp table
again?
It won't. If the client looses
TEMPORARY TABLES are suppose to work this way. They are only there during
a connection and then dropped when the connection to the database is
closed. One thing they are great for is when you have temporary information
that needs to be kept and worked with. One of my programs has to pull
thin
On Tue, 2003-10-28 at 12:07, Guilhem Bichot wrote:
> On Tue, 2003-10-28 at 00:15, Guilhem Bichot wrote:
> > On Mon, 2003-10-27 at 22:01, Dathan Vance Pattishall wrote:
>
> > So the conclusion is: unfortunately, the symlink support in MySQL was
> > not designed for "synonyming", as far as DDL (Data
Hello,
I've reinstalled my system (Mac OS 10.3 Server).
In trying to get MySQL going again. I can run mysql_install_db, but I
can't access the mysql db and I can not set a root user password.
If I try to login: mysql -u root
it says access denied to [EMAIL PROTECTED]
If I simply type "mysql" (n
vinita vigine MURUGIAH <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm using ver 4.0.12, checked for bugs in ver
> 4.0.12(http://bugs.mysql.com/search.php) but couldn't find this one.
Thanks for report, but I wasn't able to repeat "Lost connection" error on v4.0.16.
Many bugs were fixed since that time
On Tue, 2003-10-28 at 00:15, Guilhem Bichot wrote:
> On Mon, 2003-10-27 at 22:01, Dathan Vance Pattishall wrote:
> So the conclusion is: unfortunately, the symlink support in MySQL was
> not designed for "synonyming", as far as DDL (Data Definition Language -
> CREATE TABLE / DROP TABLE / ALTER TA
> Now, how can I save only these 1000++ data into a file in my pc?
Normaly you should get the data into a file with that
something you sent the query to mysql with. What is that
something in your case?
Regards,
TomH
--
PROSOFT EDV-Lösungen GmbH & Co. KG
Geschäftsführer: Axel-Wilhelm Wegmann
AG
no, it'll save it in the data directory of the database only, reason is
mysql doesn't have permission to write to any other directory.
"full path and file name" could be just file name like "data.txt" or full
path of that directory like "/var/lib/mysql/db_name/data.txt"
Nitin
- Original Mess
Hi, how to write this :"full path and file name"? can i copy it to my local
pc rather than the server?
best regards,
Pey Ling
From: "Nitin" <[EMAIL PROTECTED]>
To: "Pey Ling" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 5:09 PM
Subject: Re: please help out
> Easy,
you can use temporary tables if need to work on the resultset else use two
different queries. I think, that's the only option.
Nitin
- Original Message -
From: "Victor Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 2:59 PM
Subject: Re: alter
Matt, Thanks for your reply. It helped me to find out the reason of
problem. Fortunately the reason was so simple:
my /etc/ld.so.conf file contained path /usr/lib/mysql and I thought
/sbin/ldconfig would build the cache so mysql will be able to see
/usr/lib/mysql/ntp2timestamp.so, but it didn't
Hi Victor,
> > Desperately need some way to get around the fact that UNION is not
> > possible to use on mysql prior to version 4…
> >
> > Was just about to launch a site when it showed up that the hosting
> > provider was running version 3.
> >
> > Help!
>
> Come on now - don't make me change
Hi Larry,
I was wondering a similar thing, but for JDBC using connection pooling. In
your example you say that 2 people will hit the script at the same time; if
they are using independent connections this should cause no problems since
TEMPORARY tables are local to the connection so don't interfe
2003-10-26 kl. 16.56 skrev Victor Spång Arthursson:
Desperately need some way to get around the fact that UNION is not
possible to use on mysql prior to version 4…
Was just about to launch a site when it showed up that the hosting
provider was running version 3.
Help!
Come on now - don't m
If this is documented anywhere, I sure can't find it, so --
The query log fields are headed: Time, Id, Command, Argument.
What is 'Id'?
TIA!
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
Easy, use:'select * INTO OUTFILE "full path and file name"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n" from user where race='chinese' and
state='US'Nitin- Original Message -
From: "Pey Ling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October
Dear all,
Hi, i have a database called 'admin' and a table called 'user'.
Inside table 'user', there are a lot of fields, i.e: name, email, race, state, and
etc. There are totally 10 records.
When I wrote the sql query 'select * from user where race='chinese' and state='US''.
It shows me
1 - 100 of 106 matches
Mail list logo
