On Mon, Oct 22, 2001 at 11:42:23AM -0600, Steve Meyers wrote:
>
> If you use a good 64-bit hash, I doubt you'll run into any
> uniqueness problems. MySQL will support that as a 64-bit BIGINT.
> You especially should not have any problems if you hash each column,
> then do the primary key across
On Tue, Oct 23, 2001 at 08:08:08AM +0200, Michal Zejdl wrote:
>
> Blank shot - have you enough FD?
> sql
I really think so...
ulimit -a:
max user processes 32768
open files 32768
And within /etc/my.cnf:
[safe_mysqld]
open-files-limit=32768
set-variable= open
Hi!
There was some confusion in the making of the
4.0.0 binaries. The Intel rpm contains InnoDB-.43
which does not support foreign keys, while the
source distribution and the Intel .tar.gz binary
contains .43b which supports foreign keys. Sorry
for the confusion!
Some things are broken in all 4.
Hi,
I just installed Redhat 7.1 will all the options (full install)
When I try to connect to MySQL I am getting this error
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check th
On Mon, Oct 22, 2001 at 08:49:44PM +0200, Sergei Golubchik wrote:
>
> > > It would actually be nice if the full source were available off
> > > the website as is, not just in the .tar.gz file. What I mean
> > > is, just untar the source to http://www.mysql.com/source/ and
> > > let people browse
Thank you. I was trying too long to do this in SQL.
> -Oryginalna wiadomoæ-
> Od: Dan Nelson [mailto:[EMAIL PROTECTED]]
> Wys³ano: 22 padziernika 2001 23:38
> Do: Daniel _a_
> DW: Lista MySQL
> Temat: Re: Tree in SQL
>
>
> In the last episode (Oct 22), Daniel _a_ said:
> > I have a tabl
Hi
I have one table and the depth is not always the same.
Anyway thanks :)
Daniel Łaś
e-direct Polska sp. z o.o.
WWW: http://www.e-direct.pl
E-mail: [EMAIL PROTECTED]
45-072 Opole ul. Reymonta 45
tel. +48 77 44 26 073
fax. +48 77 44 26 074
> -Oryginalna
Wouter de Jong wrote:
>
> Does anyone have a clue about what could be going on ?
Blank shot - have you enough FD?
sql
--
Ing. Michal Žejdl e-mail: [EMAIL PROTECTED]
Sokolovská uhelná, a.s. tel.: +420 168 46-5418
Sir/Madam,
I am having Linux RedHat v7.1 running on my P3 mac. I have successfully installed
the MySQL (the source version/distribution - MySQL-3.23.43-1.i386.rpm and the related
RPMs). I am also able to access the database at the prompt but I am not able
to access the database through
If the depth of the tree is always the same, it is actually fairly easy. For
instance, if there are three levels:
SELECT c.group_id FROM table a, table b, table c WHERE a.group_id = 12345 AND
b.group_id = a.parent_group_id AND c.group_id = b.parent_group_id
If you don't know the depth, you'll
Many thanks. Worked fine. Sadly, almost every one of the varchar columns I
checked return near the max length. Is there still a huge performance
penalty, if most of the rows come close to hitting the max of the defined
varchar length? I suppose it depends on your data, and how you use it.
I'm resending this to the general list, since I received absolutely no
reply at all on the Win32 list, and I'm hoping someone here is familiar
enough with the Win32 port to comment..
Original Message
Subject: Problems running mysql client under Emacs on Win32
Date: Sat, 20 Oct
Hi,
did anybody ever use the new mm.mysql-2.0.4 (or another 2.x version)
library that
is introduced as stable on the download section?
Is it stable enough to use on production servers? Any positiv / negative
comments
on that?
I am having problems with the 64k size limit bug in the earlier versio
Has anybody turned on raid for the windows version?
Turning this feature on in Unix appears simple, but what about windows...
I have MySQL version 3.23.43 Linux & windows and I need them both configured
the same way.
Butch Bean
-
Hi all,
I am going to try and describe my problem as best as possible. here it goes.
Am running FreeBSD v3.0
I can connect to mysql when i telnet to localhost
I cannot connect to mysql from another loacation
When i try and shut down mysqld it tells me: "Segmentation fault (core
dumped)"
It is ru
Hi,
Check section 4.8.2 of the (4.0.0-alpha) manual, or type help at the MySQL
Command line.
Quentin
-Original Message-
From: Neil Zanella [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 23 October 2001 11:49 a.m.
To: MySQL Mailing List
Subject: mysql CLI: executing SQL from a file
Hello,
On Mon, Oct 22, 2001 at 09:07:06PM +0200, Warren van der Merwe wrote:
> Hi there
>
> Was there a problem with replication on the above build? My
> production sites were running 3.23.38 and I upgraded to 3.23.41 and
> since then the replication has not been working. On of my production
> machines
please notice that in 2nd query i sent, there's same table linked twice,
because i need to link tree-like records.
how do i delete records from 1st table and not 2nd if they have same real
name?
like this:
DELETE tasks FROM tasks as t_child LEFT JOIN tasks as t_parent ON
t_child.parent_id=t_par
>Description:
I have a table full of pages for a church website I am developing. Each has
some data (text) and a title, page id, updated (date) and created(date). I
want to select a list of pages with their id and title and updated date
according to when they were created (by created). When I s
Hello,
I would like to know if it is possible to issue a command from the
mysql command line interface which will read SQL commands contained
in a file and execute them immediately without having to cut and
paste them one gpm buffer size at a time.
Thanks,
Neil
--
Hi!
On Oct 22, Moshe Gurvich wrote:
> yeah, noticed it after clicked send..
>
> let's say i upgrade to MySQL 4.0 and run this query:
>
> DELETE FROM tasks as t_child LEFT JOIN tasks as t_parent ON
> t_child.parent_id=t_parent.task_id
> WHERE t_parent.task_id IS NULL
>
>
> will this work?
no.
Chris Book writes:
> load data local infile 'file.txt' into table mytable fields optionally
> enclosed by '"' escaped by '"' terminated by ','
I'm not sure how mysql handles the case where the escape
character is the same as the field enclosing character, and
I can see a problem here if you hav
yeah, noticed it after clicked send..
let's say i upgrade to MySQL 4.0 and run this query:
DELETE FROM tasks as t_child LEFT JOIN tasks as t_parent ON
t_child.parent_id=t_parent.task_id
WHERE t_parent.task_id IS NULL
will this work?
meaning it will delete records from 1st mentioned table in J
i had similar problem until used line delimiter different than default "\n"
try this:
load data local infile 'file.txt' into table mytable fields optionally
enclosed by '"' escaped by '"' terminated by ',' LINES TERMINATED BY '-= aNy
we1Rd cHar 0r Str1Ng =-'
:)
-Original Message--
Hi!
On Oct 22, Moshe Gurvich wrote:
> thank you very much;
>
> i'm using right now v3.23 as recommended for production servers, but
> anyway..
>
> now, using the way you suggested, will this work:
>
> DELETE FROM tasks
> FROM tasks as t_child LEFT JOIN tasks as t_parent ON
> t_child.parent_id=
Hello,
This is what I'm trying to do:
load data local infile 'file.txt' into table mytable fields optionally
enclosed by '"' escaped by '"' terminated by ','
My file looks like this
1,"data1"
2,"data2"
3,"data3"
etc
my table is defined with (id integer not null, data varchar(200) not null).
Th
select max(length(column)) from table
-Original Message-
From: Tony [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:36 PM
To: [EMAIL PROTECTED]
Subject: Oracle conversion...
Is there a quick and easy way to determine the maximum used length of a
varchar column? I've built a
Is there a quick and easy way to determine the maximum used length of a
varchar column? I've built and imported an Oracle DB into a MySQL one and
now I'd like to greatly reduce the number of varchars that were being used in
the original (e.g. Oracle) DB on my MySQL version.
I am digging into
Hi
I have a table in database which describes tree structure of article groups.
In this table I have:
1. group_id - group identifier
2. parent_group_id - identifier of parent group
I need to select history, from top to wanted group.
I can't change the database design and ofcourse this is MySQL 3.
I used MyAccess2000, it connects through ODBC inside Access. You can create
tables, import Access to MySQL or MySQL to Access and it will display table
SQL and indexes, its $30usd http://www.accessmysql.com/
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Mond
The Jonathan Tutorial
Access -2- MySQL in 8 Not-Extremely-Easy-But-Not-Hard Steps
1. Go to mysql.com
2. Download and install MyODBC
3. Set up a new ODBC connection for the new mySQL server
4. Open up the database in access
5. Go to the File menu and choose to Export (Tables?)
6. At the bottom of
try this:
http://www.mysql.com/downloads/contrib.html#SEC653
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:12 PM
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL, but I
I am new to this fast database and love MySQL, but I need to know how to
import or convert Access database to MySQL. ANyone know how I would go
about that? Also this is for a web site and I need to change the asp
code to PHP. Its not a lot, only a few pages, but its a headache for
someone that
thank you very much;
i'm using right now v3.23 as recommended for production servers, but
anyway..
now, using the way you suggested, will this work:
DELETE FROM tasks
FROM tasks as t_child LEFT JOIN tasks as t_parent ON
t_child.parent_id=t_parent.task_id
WHERE t_parent.task_id IS NULL
thanx :)
Hi!
On Oct 22, Moshe Gurvich wrote:
> so what's the remedy?
> how to do this task in MySQL without using subselects?
>
> > delete from followups where task_id not in (select task_id from tasks)
> >
Multi-table deletes (MySQL 4.0.0+)
DELETE followups FROM followups LEFT JOIN tasks USING(task_id
Nope its not the permissions problems.it does not
have host-bin.1 file.
Maybe i will try reconfiguring and recompiling it all
over again.
do tell me if anything else like any configuration
changes need to be done
Deepanshu
--- Mark Maunder <[EMAIL PROTECTED]> wrote:
> Deepanshu Shukla wro
Trond Eivind Glomsrød wrote:
> "Moshe Gurvich" <[EMAIL PROTECTED]> writes:
>
> > I'm trying to run:
> >
> > delete from followups where task_id not in (select task_id from tasks)
> >
> > but it gives me an error:
> > Error: 1064 - You have an error in your SQL syntax near 'select task_id from
> >
so what's the remedy?
how to do this task in MySQL without using subselects?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Trond Eivind Glomsrød
Sent: Monday, October 22, 2001 1:13 PM
To: Moshe Gurvich
Cc: [EMAIL PROTECTED]
Subject: Re: how to sub-selec
"Moshe Gurvich" <[EMAIL PROTECTED]> writes:
> I'm trying to run:
>
> delete from followups where task_id not in (select task_id from tasks)
>
> but it gives me an error:
> Error: 1064 - You have an error in your SQL syntax near 'select task_id from
> tasks)' at line 1
>
> where's the problem a
Carl Troein wrote:
> Bill Adams writes:
>
> > > This is odd. The only machine in cricalix.net (which I own/run) is a
> > > linux box. Who has a badly configured server out there?
> > Even more odd is that the 'from' address I saw was [EMAIL PROTECTED]
> > I thought my company server was spammi
I'm trying to run:
delete from followups where task_id not in (select task_id from tasks)
but it gives me an error:
Error: 1064 - You have an error in your SQL syntax near 'select task_id from
tasks)' at line 1
where's the problem and how to work around?
thank you
---
Outgoing mail is certifie
Bill Adams writes:
> Duncan Hill wrote:
>
> > On 22 Oct 2001 [EMAIL PROTECTED] wrote:
> >
> > This is odd. The only machine in cricalix.net (which I own/run) is a
> > linux box. Who has a badly configured server out there?
> >
> > (sql, database)
>
> Even more odd is that the 'from' address
Hi there
database, mysql
Was there a problem with replication on the above build? My production sites
were running 3.23.38 and I upgraded to 3.23.41 and since then the
replication has not been working. On of my production machines ran 3.23.38
and that updated 100% until I upgraded it to 3.23.41
Pretty much.
- Jonathan
-Original Message-
From: Yiu Wing [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 7:44 PM
To: Mysql List; Jonathan Hilgeman
Subject: Re: Server + database on a CD??
> Jeremy is correct. I've done it before - but if possible, it is better to
> have a pr
Hi!
On Oct 22, Jeremy Zawodny wrote:
> On Mon, Oct 22, 2001 at 11:36:37AM -0600, Steve Meyers wrote:
> >
> > It would actually be nice if the full source were available off the
> > website as is, not just in the .tar.gz file. What I mean is, just
> > untar the source to http://www.mysql.com/sour
> Jeremy is correct. I've done it before - but if possible, it is better to
> have a program that copies the databases to a writable storage disk like
the
> hard drive or a network drive, in case you want to update it later (you
> don't have to burn a new CD every time)
Interesting. How do you a
[EMAIL PROTECTED] wrote:
> >Description:
>The following is the error message:
> #scripts/mysql_install_db
> Could not load program ./bin/my_print_defaults:
> Dependent module libz.a(shr.o) could not be loaded.
> Could not load module libz.a(shr.o).
> Error was: No such file or directo
I realized that I was using an older version of libmysqlclient. So I recompiled and
linked the msql-mysql-modules against mysql-3.23.41...
Bill Adams wrote:
> o If there is no call to 'flush tables', even a small data load will cause
> myisamcheck to report "warning: 1 clients is using or hasn
On Mon, Oct 22, 2001 at 11:36:37AM -0600, Steve Meyers wrote:
>
> It would actually be nice if the full source were available off the
> website as is, not just in the .tar.gz file. What I mean is, just
> untar the source to http://www.mysql.com/source/ and let people
> browse it there if they wis
Actually, as per their Privacy Policy:
"When you subscribe to MySQL mailinglists to receive MySQL news and
product information, you must provide email address. We never sell or rent
your email address you provide when subscribing to our elists. Please
note, that MySQL mailing lists are archived b
In the last episode (Oct 22), Steve Meyers said:
> It would actually be nice if the full source were available off the
> website as is, not just in the .tar.gz file. What I mean is, just
> untar the source to http://www.mysql.com/source/ and let people
> browse it there if they wish to. People o
> > The problem is that he has it as a primary key, so he wants it to be
>
> > unique as well as indexed. The best solution (and MUCH MUCH MUCH
>
> > more efficient) would be to hash each of the four columns, and create
> > a primary key on that. Integer keys are much faster and memory-
>
Duncan Hill wrote:
> On 22 Oct 2001 [EMAIL PROTECTED] wrote:
>
> > Antigen for Exchange found Unknown infected with
> > [EMAIL PROTECTED] (Norman) virus. The file is currently
> > Removed. The message, "SV: Here you have, ;o)", was sent from Pål
> > Wester and was discovered in Public Folders\Ma
On Mon, Oct 22, 2001 at 08:02:49AM +0100, Ronan Minogue wrote:
> Jeremy,
>
> Firstly thank you for the reply.
>
> On the MySql web site there are benchmark response times provided
> for the execution of queries on NT 4. e.g. reading 2,000,000 rows
> by index requiring 367 seconds.
>
> Are you
It would actually be nice if the full source were available off the website as is, not
just in the .tar.gz file. What I mean is, just untar the source to
http://www.mysql.com/source/ and let people browse it there if they wish to. People
often ask questions on the list that could be answered
> What is the best choice for my index on this query?
>
> SELECT id_team,
> sum(IF(m.id_visitor = t.id_team,m.visitor_score,
> m.home_score)) AS But_pour,
> sum(IF(m.id_visitor != t.id_team,m.visitor_score,
> m.home_score)) AS But_contre
>
Jeremy is correct. I've done it before - but if possible, it is better to
have a program that copies the databases to a writable storage disk like the
hard drive or a network drive, in case you want to update it later (you
don't have to burn a new CD every time)
- Jonathan
-Original Message-
On Mon, Oct 22, 2001 at 11:14:58AM -0400, Victor wrote:
> Hello
>
> As I understand it, MySQL with InnoDB or BDB support can support
> transactions. Is there a doc on the shortcomings of these tables and
> which one is better? MySQL documentation has a shortcomings page for
> InnoDB (but couldn't
This is where LEFT JOIN comes in:
select
folders.folder_name,
folders.folder_id,
count(folder_items.item_id)
from (folders left join folder_items on folders.folder_id =
folder_items.folder_id)
where
folders.folder_type='favourites'
group by folder_name
Basically you need to decide which side yo
On Mon, Oct 22, 2001 at 11:23:50AM +0200, Jean-Louis Leroy wrote:
> Is it feasible to make mysql run from a CD and have it access
> databases stored on the CD? TIA...
It is.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Ce
There are a couple ways to do this. As some others have suggested, you could drop the
keys first, insert the data, and then restore the keys. I think this is the second
fastest method. Here are my picks, in speed order:
1. LOAD DATA INFILE -- this is very fast, and will not update the keys u
Hi All,
I'm trying to select a number of columns from 2 tables using an inner join.
One of the columns I'm selecting is a count and when the count is zero it doesn't
return that row.
I'd like to return all rows, even if the count of one of the columns is zero.
Can somebody show me how to fix my
Not that I don't understand your viewpoint, but you have to realize that
almost any and every mailing list is published in more than one place. Any
person who posts to this list is knowingly publishing to an unknown
audience. I find it odd that you are comfortable with publishing to one
unknown a
Steve Meyers wrote:
> The problem is that he has it as a primary key, so he wants it to be
> unique as well as indexed. The best solution (and MUCH MUCH MUCH
> more efficient) would be to hash each of the four columns, and create
> a primary key on that. Integer keys are much faster and me
Adrian,
I will suggest once more that you replace all tabs with a space as well, and maybe all
carriage returns as well (for good measure).
This time I'll write out the queries for you:
UPDATE hotel SET nome_hotel=REPLACE(nome_hotel, "\t", " ");
UPDATE hotel SET nome_hotel=REPLACE(nome_hotel,
> > Sinisa,
> >
> > On behalf of those of us who take advantage of the 'ready made' versions (eg my
>Win download) [or who should not be
> > allowed near naked flames, C compilers, or buttons marked "Do NOT press"], could
>these examples of 'internal
> > documentation' be reproduced and made ava
or, from a shell prompt:
[ernie@ns1 ernie]$ cat script.sql|mysql
> -Original Message-
> From: Kevin Smith [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 12:19 PM
> To: TOMASSONI Dominique; 'MySQL_mailing_list'
> Subject: Re: Execute a file containing a sql script
>
>
> m
Robert Alexander wrote:
> I just found out, while looking for other things, that what seems to be the entire
>content of the MySQL list is being published on the web.
>
> I, for one, really don't like this idea. I have a reasonable expectation that what I
>post here is for viewing by subscriber
>Description:
The following is the error message:
#scripts/mysql_install_db
Could not load program ./bin/my_print_defaults:
Dependent module libz.a(shr.o) could not be loaded.
Could not load module libz.a(shr.o).
Error was: No such file or directory
WARNING: The host 'bonsai.austin.ibm.
Hi all,
I just found out, while looking for other things, that what seems to be the entire
content of the MySQL list is being published on the web.
I, for one, really don't like this idea. I have a reasonable expectation that what I
post here is for viewing by subscribers to this list, the MyS
On Monday 22 October 2001 18:25 pm, Priya Ramkumar wrote:
> Hi Tom,
>
> Thanks for your response. It takes around 1 hour & 40 minutes to
> insert 28000+ records. Also, I find that the first few thousand
> transactions are quite fast but slows down later. I have MySQL on
> Linux. I have a concaten
mysql> source /path/to/file
- Original Message -
From: "TOMASSONI Dominique" <[EMAIL PROTECTED]>
To: "'MySQL_mailing_list'" <[EMAIL PROTECTED]>
Sent: Monday, October 22, 2001 5:08 PM
Subject: Execute a file containing a sql script
> Hi,
>
> I'm a beginner in MySQL (also in english) so s
Hi everybody!
I need to download MySQL version 3.22.15-Gamma for Solaris.
Does anyone know where I can find it?
PLEASE
thank you very much
/ Johan
Johan Brunius
DebiTech AB
System Developer
Stadsgården 6
S-116 45 STOCKHOLM
SWEDEN
[EMAIL PROTECT
Hi,
I'm a beginner in MySQL (also in english) so sorry for my uninterristing
questions.
I've installed MySQL 3.23.43 on a Linux RedHat 7.0 system, and it seems to
work normally.
How to execute a sql script which is inclus in a text file (ex : script.sql)
?
With Oracle, you know, it's done with
DL Neil writes:
> > Wendy Dillon writes:
>
> Sinisa,
>
> On behalf of those of us who take advantage of the 'ready made' versions (eg my Win
>download) [or who should not be
> allowed near naked flames, C compilers, or buttons marked "Do NOT press"], could
>these examples of 'internal
> docume
On Monday 22 October 2001 08:41, jim barchuk wrote:
> Hi Martin!
>
> > I have been trying to connect to mySQL for a couple of days now with
> > no result! I try to log in via telnet..to my remote server..I get in
> > the system but when I try to log in to the database, nothing!! I use
> > this:
>
> Wendy Dillon writes:
...
> > Is there any documentation for the MyISAM C API yet apart from the source
> > code?
...
> Hi!
>
> In 4.0.0 source code, you will find Docs subdir and in it myisam.txt.
>
> Rest is up to you ...
Sinisa,
On behalf of those of us who take advantage of the 'ready mad
I'm having problems with WinMySQLAdmin. Please could anyone advise.
MySQL 3.23.42-nt is installed by Administrator on NT 4.0 SP6 machine in D:\Program
Files\MySQL. It has to be installed by Administrator in order to create and start the
MySQL NT service. The service is created and starts OK.
A
hi,
try your first SELECT statement, but with
ORDER BY table1.table1_row
maybe this helps (I didnt try it).
Anton Tichawa
> -Original Message-
> From: Bruno Faé [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 5:44 PM
> To: [EMAIL PROTECTED]
> Subject: Query Error
>
>
Hi Martin!
> I have been trying to connect to mySQL for a couple of days now with
> no result! I try to log in via telnet..to my remote server..I get in
> the system but when I try to log in to the database, nothing!! I use
> this:
>
> mysql -h localhost -u futureenter -p
>
> it then asks for a p
Hi !
I´m trying to query some news with multiple rows in my database. I´m
receiving an error when i use:
"SELECT table1.*, table2.table2_row FROM table1,table2 ORDER BY
table1_row"
but, if I try:
"SELECT table1.table1_row, table2.table2_row FROM table1,table2 ORDER BY
table1_row"
or
"SELECT ta
What is the best choice for my index on this query?
SELECT id_team,
sum(IF(m.id_visitor = t.id_team,m.visitor_score,
m.home_score)) AS But_pour,
sum(IF(m.id_visitor != t.id_team,m.visitor_score,
m.home_score)) AS But_contre
FROM
On 22 Oct 2001 [EMAIL PROTECTED] wrote:
> Antigen for Exchange found Unknown infected with
> [EMAIL PROTECTED] (Norman) virus. The file is currently
> Removed. The message, "SV: Here you have, ;o)", was sent from Pål
> Wester and was discovered in Public Folders\Mailing Lists/MySQL
> located at
Hello
As I understand it, MySQL with InnoDB or BDB support can support
transactions. Is there a doc on the shortcomings of these tables and which
one is better? MySQL documentation has a shortcomings page for InnoDB (but
couldn't find one for BDB)
http://www.mysql.com/doc/I/n/InnoDB_restrictions
All,
I would like to put in my two farthings and second DL's opinion of
MySQLFront- it is a great tool. I use it for a number of tasks, including
porting my development database (which I run under IIS 5.0 on Win 2k,
together with PHP 4.0.6) to my "production" database on my web site (which
runs
On Monday 22 October 2001 09:55 am, you wrote:
> Just want to copy the table structure of a table i Have but dont have the
> the create statement and dont want to have to type it again , it has a lot
> of fields. Can I easily replicate a table.
Dexter,
You can use Mysqldump to produce just the
Hi!
Please upload your file.sql, gzipped or zipped, to:
ftp://support.mysql.com:/pub/mysql/secret
and let me know the filename.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime
if you have it, install phpMyAdmin it is a cool application, and quite easy
to configure, then dump the table structure.
hth
norman
-Original Message-
From: Dexter Coelho [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: How to copy table
> Just want to copy the table structure of a table i Have but dont have the
> the create statement and dont want to have to type it again , it has a lot
> of fields. Can I easily replicate a table.
Hi Dexter,
I took a look at a number of the MySQL management tools as mentioned in
articles/disc
>Description:
a mysql -p db < file.sql fails when sql contains TEXT fields that are long
>How-To-Repeat:
create table with text column,fill it with text,
mysqldump this table into file.sql
mysql -p db < file.sql
>Fix:
linewrapping the mysqldump file is a workaroun
Dexter wrote:
>Just want to copy the table structure of a table i Have but dont have the
>the create statement and dont want to have to type it again , it has a lot
>of fields. Can I easily replicate a table.
or:
>SHOW CREATE TABLE table_name;
will show the SQL necessary to recreate a table.
-r
I performed the following query :
select max(date_time) from vse_history where symbol_id = 1;
and mysql crashes. I'm not very good with SQL so I wonder of I'm doing this
right at all. I want the record with the highest datetime value where
symbol_id = 1
I'm using 3.23.43-max-nt on Windows2000.
Antigen for Exchange found Unknown infected with [EMAIL PROTECTED] (Norman)
virus.
The file is currently Removed. The message, "SV: Here you have, ;o)", was
sent from Pål Wester and was discovered in Public Folders\Mailing Lists/MySQL
located at nascom/First Administrative Group/ET.
-
Dexter wrote:
>Just want to copy the table structure of a table i Have but dont have the
>the create statement and dont want to have to type it again , it has a lot
>of fields. Can I easily replicate a table.
Hi Dexter, I had the same problem and seem to remember finding the answer
hidden in th
Hi Mysqlers,
Just want to copy the table structure of a table i Have but dont have the
the create statement and dont want to have to type it again , it has a lot
of fields. Can I easily replicate a table.
thanks
Dexter
_
Get y
Hi,
We are having serious load problems suddenly at one of our MySQL-servers.
There are running about 830 databases on this one. The machine was up for 40 days,
running peacefully (load avg. of 2) but suddenly it went to an average of 25.
We've been trying to find a reason, but SHOW PROCESSLIS
You can define unique keys
CREATE TABLE MyTable (
X char(50),
Y char(25),
Z char(15),
Count_ int(11),
INDEX X (X),
INDEX Y (Y),
UNIQUE XY (X,Y));
and use a sql like INSERT IGNORE INTO MyTable VALUES(X,Y,Z) keep in mind
that the keys will grow fast.
The IGNORE stops error messages when the un
Wendy Dillon writes:
> Hi everyone,
>
> I realise that a number of people have already asked this but as it was a
> while ago thought more info may now be available:
>
> Is there any documentation for the MyISAM C API yet apart from the source
> code?
>
> In previous discussions of accessing My
Hi everyone,
I realise that a number of people have already asked this but as it was a
while ago thought more info may now be available:
Is there any documentation for the MyISAM C API yet apart from the source
code?
In previous discussions of accessing MyISAM directly I see 2 issues that are
f
Jeremy Zawodny writes:
>
> Monty recently proposed some changes to MySQL's client/server protocol
> which will enable "real" prepared statements. So I'd guess it'll
> happen somewhere in the 4.x tree.
>
> > Also just out of curiousity, how much of a performance hit does
> > mysql take in compil
1 - 100 of 116 matches
Mail list logo
