> > How about select max(floor(field)) from table ?
> >
> > TK
>
> Good idea, but...
>
> Using floor produces the following error:
>
> Warning: SQL error: [MERANT][ODBC PROGRESS driver][PROGRESS]Invalid number
> string (7498), SQL state S1000 in SQLExecDirect in c:\program
> files\nusphere\apac
Hi,
I use the Leszynski/Reddick conventions when programming front ends. We have
made changes to the table definitions, so that the prefix refers to the
table instead. The example would look like this:
tblNews
newID
newusrID
newPosted
newSubject
newContent
tblUser
usrID
usrnewID
usrName
This g
Description:
If a special UPDATE request is sent to the MASTER server mysqld server
in SLAVE mode goes down by the signal 8 (at FreeBSD 4.2 REELEASE).
The only way to continue normal work is to stop MASTER and to copy
data manually. Then start servers again.
dear all ,
i make two indexes on a table(as follow) .
And i execute the command explain select * from
terayon200109.tlcounter200109 d where d.timerecord = '0109012300' to
measure the performance. Unfortunately, it seems no any advanatages cover,
would U tell me what is wrong ? how to amend th
Hi Simon,
One way to solve the problem is this query:
select max(field+0) from table;
Since numeric 0 is added to field, mysql silently converts field column
into numeric first and makes the calculation accordingly.
Beware that pure character strings give zero when converted to numeric type
so
Is it feasible to make mysql run from a CD and have it access
databases stored on the CD? TIA...
--
Jean-Louis Leroy
Sound Object Logic
http://www.soundobjectlogic.com
-
Before posting, please check:
http://www.mysql.com/manu
On Sat, 20 Oct 2001, Clyde Jones wrote:
> Did you try that? replace should recursively replace ALL double spaces,
> if it is a problem just run and rerun the query
>
> UPDATED hotel
> set nome_hotel replace(nome_hotel, " ", " ")
>
> until all the double spaces are gone.
Ok. I tried it but
25M tables in one database -- wow. How big were the tables?
Was this with MySQL? Which OS and filesystem did you run this on?
Given that MySQL stores each table in three separate files in the database
directory, that would imply 75,000, files in the directory containing
the database -- and
Hi,
How I could to storing files in a mysql database?
Regards
Gazi Altafin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Joe,
It's possible to create a table for each image. However, as others have
suggested, in most cases, it makes more sense to have an images table, with
all the images, and with a unique image ID for each image (you can create
your own or use autoincrement). You can then have tables like review
Hi
I have a PHP program which adds records to a MySQL table. The number of
records in the table after the execution of the program is around 28,000. I
also have select & update queries in the program on the same table. The
process takes a very long time to complete all insertions to the table. I
Priya,
Need more information ... how long does it take to insert 28,000 records?
On what kind of platform? How much data do the records contain? What kind
of primary keys and indices do you have?
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Priya Ramkumar [mailto:[EMAIL P
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
concatenated primary key of multiple fields. And I also have a unique index
o
Priya,
I suspect that the primary key and index are causing your problems -- each
time you insert, MySQL must create the indices and validate for uniqueness.
Can you remove the indices and try it that way? If that is very fast (as I
suspect it will be), then you can focus on coming up with a mo
On Sat, 20 Oct 2001 12:48:36 -0500
Eric <[EMAIL PROTECTED]> wrote:
I wouldn't be opposed to implementing this as a part of the join
optimizer in MySQL, in fact, I've been reading through it for a few
days now... However, it seems like it would be a large project as the
join optimizer does not t
On Sun, 21 Oct 2001 14:24:12 -0700 (PDT)
Deepanshu Shukla <[EMAIL PROTECTED]> wrote:
Hi!
This list, [EMAIL PROTECTED] is devoted to the internal functioning of MySQL
server.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /
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
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
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
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
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
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
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
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.
-
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.
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
>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
> 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
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
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
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
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
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
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
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
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
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,
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
>
>
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
> 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
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:
>
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
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
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
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
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
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
>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.
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
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
> > 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
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,
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
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
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
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
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
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: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
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-
> 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
>
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
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
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
> > 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-
>
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
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
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
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
[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
> 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
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
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 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
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
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
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
"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
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
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
> >
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
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
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 :)
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
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
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
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
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.
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
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
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
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=
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--
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
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
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.
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
--
>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
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
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
1 - 100 of 116 matches
Mail list logo
