Can you send me the configure file + makefile configured for cygwin ? Version 3.23.58
please thanks alot!
nd regards,
Fred.
> Hi Fred,
>
> InnoDB does not support AUTO_INCREMENT on secondary columns of a
> multi-column index.
>
> > `id_registro` int(11) NOT NULL auto_increment,
> > PRIMARY KEY (`id_formula`,`id_registro`)
>
> There: id_registro is the second column of the index.
>
>
> Matt
Hi Matt. Thanks a lot again !
It worked pretty good.
There is no problem about the app, because
the use of the indexes is in charge of the DBMS (MySQL). The
app "doesn't know" about the tables and indexes details.
Best Regards,
Fred.
> Hi Fred,
>
> Also, you
Will mysql handle the waiting
queries well? I include details on my setup at end.
Regards, Fred.
System Info:
MySQL version - 3.23.40
OS - Linux 2.2.14
CPU - P3 550Mhz
Memory - 128M
=
Fred Clausen - Systems Administrator
Unique Interactive, London, UK.
E-mai
Can anyone explain the following results to me?
I am trying to find all values +/- 30% from a number...
value is declared as: | value | int(10) unsigned
Note that 1.3*63000 is 81900...
The first two are apparently correct:
mysql> SELECT count(*) FROM bench WHERE year = 95 and
-> value >=
>
>Maybe you should try
>
>SELECT count(*) FROM bench WHERE year = 95 and
>-> value BETWEEN (0.7*63000) and (1.3*63000) ;
>
Hmm -- I thought, yes! But...
mysql> select count(*) from bench where year = 95 and
-> value between (0.7*63000) and (1.3*63000);
+--+
| count(*)
the same
CREATE. I believe the ibdata1 file as well as the
.frm files contain -- ironically, since the whole point of databases is to
avoid redundant data -- redundant schema-related
information. If they are not in sync the mapping between the .frm and ibdata1
information will probab
I had the same problem. Disabling it isn't enough. I had
to use the sc command from the Windows command prompt to
delete the service. Just enter sc on the command line and
a description of the command will be displayed.
Fred
-Original Message-
From: Scott Hamm [mailto:[
Hi guys--
I am having some trouble importing a csv file correctly as a table in my
new database. In particular, there are 4 NA's in a column with 10,000+
other rows that have decimal values for that column.
How can I get MySQL to read in these "NA's" as some sort of null that is
accepted by the
Hi--
I'm trying to do the following:
SELECT db.emp.emp_fname, db.emp.emp_fname, db.sale.sale_date,
db.sale.sale_no, db.sale.sale_total_amt
into outfile 'test123.csv'
FIELDS terminated by ','
FROM db.emp
LEFT OUTER JOIN db.sale
ON db.sale.emp_id = db.emp.emp_id;
The query without exporting the fil
QL connection was lost.
Does anyone have an idea of what is going on?
On Wed, Jul 25, 2012 at 9:22 PM, Dhaval Jaiswal wrote:
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
&g
Thanks!
On Thu, Jul 26, 2012 at 12:05 AM, wrote:
> 2012/07/26 06:52 +0530, Dhaval Jaiswal
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
>
> as above give your join condition before INTO OUTFILE.
>
> Right
t
work.
Thanks again
On Tue, Jul 31, 2012 at 5:36 AM, Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Fred" == Fred G writes:
>
> Fred> Thanks Dhaval. Putting the join condition before INTO outfile
> doesn't seem
> Fred> to work, either.
>
What are the best ways to conduct financial data mining in MySQL? From
browsing the World Wide Web, it looks like using R to access MySQL and
using some pre-built R financial data analysis packages is the way to go.
Is there anything built-in to MySQL 5.2 Workbench, or, any other
possibilities tha
Hi--
I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank
values become 0 when I define the datatype to be a DECIMAL (in our case
(DECIMAL(12,2)). Since there is the potential for values to be 0, this
poses a problem for us. I initially wanted to make all the DECIMAL values
bec
wrong
way to solve the problem.
On Sun, Aug 5, 2012 at 9:53 AM, Hassan Schroeder wrote:
> On Sat, Aug 4, 2012 at 8:14 PM, Fred G wrote:
>
> > But I'm sure that I must be missing something here. Is there a way to
> use a
> > DECIMAL-like operator that treats blanks as bl
the table, I use a temp table to import to
> as varchar, convert the column, the just select from temp table into prod
> table.
>
>
>
> -Original Message-
> From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
> Sent: Monday, August 06, 2012 2:05 PM
> To:
Hi all--
I googled around a bunch but couldn't find a good answer to this question.
How do I open the ERD diagram I made in MySQL WorkBench 5.2CE, which is a
.mwb file-- on another computer that does not have MySQL on it? I want to
be able to print out the file and so I need to be able to open i
Everything seems to go fine for me if I change the two 2007-3-23
to 2007-03-23.
Fred
-Original Message-
From: Rob Desbois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 5:02 AM
To: mysql@lists.mysql.com
Subject: datetime type conversion problem
I am having issues with type
is between 5 and 10,
SELECT ID FROM theTable WHERE colorID >= 5 AND colorID <= 10
-Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
xactly how you'd do this with a SQL query, short of using 'n' joins.
Of course if it's possible, it'd be best to modify the table such that
you separate colorID into two columns, and then use an AND.
-Fred
danchik wrote:
thats effectively an OR statement, isnt it?
h
Hi
I want to upgrade my mysql 3.23 to 4.1 as I want to convert a mssql app that
has lots and lots of subselects. I hear that 4.1 now supports this (I hope).
I used apt-get to install 3.23 so how can I install 4.1 over the top and not
get into any trouble is what Im after?
Ive tried apt-get inst
Thanks for your help! I might wait or look elsewhere
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, 23 June 2003 12:16 PM
To: Lecul, Fred
Cc: '[EMAIL PROTECTED]'
Subject: Re: APT-GET Help with upgrade to 4.1
On Mon, Jun 23, 2003 at 12:00:
be out of place not to mention the security implications:
You should 1. not be querying your DB as the root database user if
possible, and 2. you should stick your password (which shouldn't match
your UNIX password) in a textfile readable only by you so that you don't
pass the pa
may have something to do with it. I
have addded the following in that file:
mysqld : ALL : ALLOW
mysqld-max : ALL : ALLOW
I did not change the default port of 3306. I assume mysqld automatically
opens up the port and begins listening for connections right?
Thanks for any help!!
Fred Aswad
--
My
there that will allow you to
do joins accross different databases from different vendors running on
different types of servers (oracle, mySQL, msSQL, DB2, etc..) and optimize
the result sets globally so that the entire database is not sent
sever-to-server...
--
Fred Stiening
findanisp.com
On Tue,
Hi
Im new to mysql and am trying to connect externally.
I have hashed out the skip-networking in the my.cnf, created a new user and
gave permissions but it seems it just doent want to accept the connection. I
am trying to connect using free-Mascon.
Any idea's on what I can do?
Frederic Lec
Tried that and it didn't work
Is it possible that the port 3306 is blocked? And if it is, how can I open
this?
Thanks
Fred
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Friday, 4 April 2003 12:09 PM
To: Lecul, Fred
Cc: '[EMAIL PROTECTED]'
Subjec
Hmm...
Yeah, its not connecting!
Im getting:
ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server
Any idea's??
Fred
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Friday, 4 April 2003 1:42 PM
To: Lecul, Fred; [EMAIL PROTECT
ize 33554432
tmpdir C:\WINNT\TEMP\
version 3.23.47-nt
wait_timeout28800
Fred Lovine
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
have an error in your SQL syntax near 'RENAME TABLE X1 TO
> X2' at line 1
> mysql>
>
> --
--
>
>
>
> Regards,
>
> ~ SubbaReddy .M
>Sr. Programmer, Frontlinesoft, Hyderabad
>http://www.frontlinesoft.com
>ICQ: 56093095
>
>
> - O
nd the workaround as stated before is to just use lowercase table names.
BTW, the following works fine:
CREATE TABLE X1 (x smallint);
insert into X1 values(5);
RENAME TABLE x1 TO x2; <-- note names are lowercase
--Fred
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Se
Steve,
Hmmm... I wonder if this is a result of the 'Klez' worm... may not be her
fault!
FCW
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 12:00 PM
To: mysql
Cc: Brandy Trudeau
Subject: Re: confirm unsubscribe from [EMAIL PROTECTED]
Any
there another I could do it?
Fred Kamwaza
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
uld ...");
there is no error but it is not working.
Please not that I am using the same server.
Fred Kamwaza.
> I don´t know what API or languaje are you usin, but i think in c, perl,
> php you should open two conection with two diferent names
>
> $link=mysql_c
localdomain';
FLUSH PRIVILEGES;
Have a look at the grant command.
I have a question about myCC. I can't connect to a local linux machine for
the life of me from my win2k box. I've done the following:
GRANT ALL ON test.* TO 'fred'@'192.168.0.230';
FLUSH PRIVIL
Folks,
I have a question about myCC. I can't connect to a local linux machine (ip
192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using
myCC. I've done the following:
GRANT ALL ON test.* TO 'fred'@'192.168.0.230';
FLUSH PRIVILEGES;
bu
Sorry everyone,
I must've forgotten to set the password with an 'identified by' clause, or I
needed to grant to *.*:
grant all on *.* to "fred"@"192.168.0.230" identified by 'fred';
it works now. thanks!
Fred
> -Original Message-
>
tance...
\\|//
(@ @)
---oOO---(_)---OOo
| |
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta |
| Office: 01.770.596
UNIX version of Y2K problem...
\\|//
(@ @)
---oOO---(_)---OOo
||
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta |
| Office: 01.770.596.1443
ly if you are a telecom provider and your rates vary
by the NPA-NXX (area code-prefix). The "area code-prefix" are
foreign keys into your rate tables.
\\|//
(@ @)
---oOO---(_)---OOo
| |
| Fred Dinkler |
| SVP Techno
ngthy runs.
\\|//
(@ @)
---oOO---(_)---OOo
| |
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta |
| Office: 01.77
side?
Thanks,
Fred
Atlanta
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsub
;
I use 'WINNT\my.ini' just fine as documented in 4.16.5 of the Manual
and it works well.
Regards,
Fred
\\|//
(@ @)
---oOO---(_)---OOo
| |
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta
want to do. Anyway, the ini file work fine.
Fred
-Original Message-
From: Mike Baranski [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 4:28 PM
To: Dinkler, Fred; Philip Daggett
Cc: Mysql List (E-mail)
Subject: Re: MySQL: my.cnf in Windows 2000
Just go (in windows explorer) t
lly
> > ignored > my supposed intelligence and few days
> later she> jumped in with both feet. > I > made
> merciless fun of her, and was ready to lay the> old
> ''I told you so'' > on > her whe
base
driver for mssql installed (please correct me if I'm wrong).
Cheers,
Fred Woolsey
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 3:37 PM
To: [EMAIL PROTECTED]
Subject: My attitude (Was:Migration to mysql from MS SQL Server)
fixes
the problem.
Thanks in advance,
Fred Woolsey
-Original Message-
From: Andres Adamoli [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 1:28 PM
To: [EMAIL PROTECTED]
Subject: Service not starting properly
Hello people, here's my problem.
I've been using mysql for a
ite (which
runs under Solaris). IMHO, it's the best GUI (for Windows, at least) for
MySQL out there.
Cheers,
Fred Woolsey
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 10:38 AM
To: Dexter Coelho; [EMAIL PROTECTED]
Subject: Re: How to
the connections to 5... opening 4 more queries leaves the number of
connections at 5...
Not very scientific, but I hope it helps.
Cheers,
Fred Woolsey
-Original Message-
From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 11:56 AM
To: [EMAIL
I believe WinMySQLAdmin (if running on Windows) or the Unix/Linux/Solaris
equivalent (I assume there is one) shows in its Processes window all users
connected to the server and their associated process IDs.
Cheers,
Fred Woolsey
-Original Message-
From: Ing. Gustavo Edelstein [mailto
Rob/All,
While I would hardly consider myself a commercial developer, I have done
some work in app development in Access/VBA with MySQL as the database
engine. Feel free to contact me if you like.
Cheers,
Fred Woolsey
[EMAIL PROTECTED]
-Original Message-
From: Bill Adams [mailto
Quite a neat trick... but might there be problems with cross join
performance if the table is large? This is based on the assumption that
MySQL first creates the cross product, then culls out the rows that don't
meet the criteria.
Cheers,
Fred Woolsey
-Original Message-
From:
Forgot to change the "To" address to the list...
FCW
-Original Message-
From: Woolsey, Fred
Sent: Friday, October 26, 2001 10:12 AM
To: 'Barbara Ferrell'
Subject: RE: how to run sql script in NT
Barbara,
You can "redirect" the script to mysql as input
OK, maybe I exaggerate, but at least you'll find the info you need.
Cheers (and remember, "wer immer streibend sich bemueht, den koennen wir
erloesen."- apologies to Goethe)
Fred Woolsey
-Original Message-
From: Todd Williamsen
To: [EMAIL PROTECTED]
Sent: 10/26/2001 8:25 PM
Su
than stellar
performance. Both drivers are, I believe, available from the MySQL site
http://www.mysql.com.
Cheers,
Fred Woolsey
-Original Message-
From: Raymond Tsang [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 10:09 PM
To: '[EMAIL PROTECTED]'
Subject: ASP with
e Get
External Data menu command, then processing the tables in Access.
Hope this helps.
Cheers,
Fred Woolsey
-Original Message-
From: Alexander Shaw [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 6:29 AM
To: [EMAIL PROTECTED]
Subject: ODBC Call Fails
Hi all,
Not sure if this i
Benj,
Perhaps because MySQL is not a "native" Windows RDBMS, possibly being
perceived by Microsoft fans as a Linux-only thang. Someone unfamiliar with
MySQL may incorrectly assume that PHP for Windows doesn't have MySQL
support.
Cheers,
Fred Woolsey
-Original Message-
the
linking database.
Fred Woolsey
-Original Message-
From: A. Clausen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 2:35 PM
To: [EMAIL PROTECTED]
Subject: Re: conceptual question.
I was taught that when it comes to files, use the DBMS designed for files,
namely the file
Hello
Is it possible to put the result of a Mysql request in a file
and how to do this ?
I try
mysql >SELECT name from table where name like 'B%'; > file.txt
but error !
Thanks for your help
Frederic
-
Before posting, pl
I concur. PHP is straightforward, powerful, and free! You can go to
http://www.php.net to download it.
Cheers,
Fred Woolsey
-Original Message-
From: Simon Green [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 12:48 PM
To: 'Sven Hammann'; [EMAIL PROTECTED]
S
Hello ,
I am looking for a solution in order to monitoring mysql daemon to
restart automatically the daemon when is down.
I was thinking maybe there is a possibility like services watching in
the cobalt interface
thanks in advance
@+
Fred mailto:[EMAIL PROTECTED
After upgrading our database to 3.23.52 on WinNT
Server, we are encountering the above error. Error
msg:
"MySQLAdmin Entry point not found. The procedure entry
point created tool help 32 snap shot could not be
located in the dynamic link library kernel32.dll"
Tried uninstalling and re-install, bu
at 'localhost' failed
"error: 'Access denied for user: 'admin@localhost' (Using password: YES)'
I thought '%' in host means "any host".
What am I missing?
(and I DID read The Fine Manual...)
Regards,
Fred
Atlanta
---
ot
> it?
>
Give their account different GRANTs on the master than on the slave(s)
and make sure that GRANTs (the `mysql` database) are not replicated from
the master to the slaves.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
ctly what you want to be
different between slaves and master.
> Is there another way?
>
Not that I know of. I just looked at the startup options but couldn't
find anything for this purpose.
Regards,
Fred.
> - Original Message -
> From: "Fred van Engen"
the linefeed as it is:
INSERT INTO support_files (session_id,file_type,file_body) VALUES (123,456,'\0\0\'abc
x');
Your mail reader may mess things up, but there is a single line-break in
the example, just after abc.
Regards,
Fred.
--
Fred van Engen
ed when the
table was created. The BINARY attribute means that column values are
sorted and compared in case-sensitive fashion according to the ASCII
order of the machine where the MySQL server is running. BINARY doesn't
affect how the column is stored or retrieved."
(http://www.mysql.com/d
t to save a few
CPU cycles and already know the length. Look at the implementation of
mysql_query:
int STDCALL
mysql_query(MYSQL *mysql, const char *query)
{
return mysql_real_query(mysql,query, (uint) strlen(query));
}
> Well, whatever the reason, I guess this is what API gu
or timestamps than a
signed int.
Also note that the range for timestamps is 1970 until 2038 (or 2106? for
unsigned ints), where DATE and DATETIME have a much greater range. Using
a UNIX timestamp for birthdays might not be appropriate.
Regards,
Fred.
--
Fred van Engen
l get in trouble if you have long running selects. These will
delay all following selects on the slave when an update is waiting for
the long query to end.
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36
l? Especially the third set is important.
Mysqld probably runs under an account (mysql) that is not yourself or in
your group, so the file needs to be world-readable. Use 'ls -l' to show
these permissions.
Also, did the copying or renaming change the case of the filename, e.g.
because you a
ith this table only.
>
Your records don't have a fixed size because of a text column. I believe
this triggers MySQL to use a variable size for each column, converting
char to varchar. Functionally, it shouldn't make a difference I guess?
Regards,
Fred.
--
Fred van Engen
n x m combinations, with n and m the number of records in table1 and
table2. You really want to do this for small tables only.
Consider an additional table to hold each of your 1, 3, 4, 6, ...
values together with the unique id of a record in table1.
Regards,
Fred.
--
Fred van Engen
> in this area:
> `affiliate_website aw WHERE aw.siteid = 1000`
>
A bit before that.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax:
new every day.
>
How about the 'help' command? You'll learn even more ;)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax:
ERT_ID() because some other process
may have inserted another record in the mean time.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 3
tabase operations.
>
If the primary goes down, how do you know that the database is in a good
state, even if the filesystem itself is consistent? I don't think MyISAM
gives you any guarantees in that regard. The secondary would need to run
myisamcheck on the tables be
er
clients to do some work. In an interactive application, your users will
love you for this :)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fa
ter_id = $row['register_id'];
> echo $register_id = At this time the value is blank when I print the value
>
}
}
}
}
>
> Please, If someone know how to print the record value and Select function in php
> send to me.
>
Read the manual, c
t; command that I just did??
>
Sorry, you'll need a backup. If your backup is not recent enough and you
have a binary log (e.g. for replication), you can use that log to restore
the database state.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
it would be useless in multi-user cases. It gives you
information on what you just inserted, not what someone else did with
another connection.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1362
Regards,
Fred.
--
Fred van Engen
--+
1 row in set (0.00 sec)
mysql> select (5 | 7) & ~(5 & 7);
++
| (5 | 7) & ~(5 & 7) |
++
| 2 |
+----+
1 row in set (0.00 sec)
mysql>
Regards,
Fred.
--
Fred van Engen
databases to
> MS SQL databases. It would be highly appreciated if you could send me the
> details at the earliest.
>
Sorry, but I have no experience with this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Te
version for the right syntax to use near
> '[EMAIL PROTECTED] IDENTIFIED BY 'update'' at line 1
> mysql>
>
Try [EMAIL PROTECTED] instead. UPDATE is a reserved word in SQL.
Regards,
Fred.
--
Fred van Engen XB Netwo
ach page. Any help would be appreciated.
mysql> pager /usr/bin/less
mysql> tee somefile.log
I guess this is documented somewhere, or try:
mysql> help
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]
the
> Funds_Recd table?
>
I guess you want to use a GROUP BY because the SUM makes no sense
without it. You seem to want results for unique combinations of Job,
Sub and Task. This means:
GROUP BY Jobs.Job, Jobs.Sub, Jobs.Task;
Regards,
Fred.
--
Fred van Engen XB
the first alpha release in august 1999 (few people would
use that)
I see no dates for 3.21.x, but it should have been the production
release in the beginning of 1999 and was probably supported for a while
after 3.22.x was the production release in march.
--
Fred van En
ically, on unices at least.
Check the mysql error log to find out if it crashed.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
.0.13.
mysql> select version();
If you use an earlier version than 4.0.13, you could try to upgrade.
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
Well, you did that now :)
I don't use InnoDB currently, so maybe som
he 2.2G table's index? MySQL
waits until disk space becomes available again. You wouldn't see much
disk activity while it is waiting.
Keep in mind that MySQL makes a copy of your table while it is adding
the index. You'll need twice the space of your initial table, plus
space
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote:
> On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
> > I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
> > create indexs for it, I couldn't finish after 4 hours.
>
> You
mp table.
It probably allows for NULLs in some fields in your temp table as well.
Not much you can do about it, but just to make sure you're aware of this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
s would need to be
checked, even if the number of matches were less than 10001.
If your query is guaranteed to use an index, you add ORDER BY ... DESC
combined with a LIMIT to go to the last page of your form. You won't
know the actual count to display then.
Regards,
Fred.
> ---
Hi,
On Tue, Jul 22, 2003 at 11:30:47AM -0400, Mojtaba Faridzad wrote:
> thanks Fred! that's better. actully I took a field with one character but
> it's better to run SELECT '1' FROM
>
> as I know, if there is not ORDER BY in the query, mySQL doesn't need
ery should work, with 'level < 3' of course.
SELECT uid FROM members WHERE level < 3 AND name between 'a' and 'b',
> but it does not work
>
Show us your sample data (SELECT uid, level, name FROM members) and the
results you get for the q
ror().
> $result = mysql_query($sql, $conn);
> while ($record = mysql_fetch_assoc($result)){
> while (list($fieldvalue) = each ($record))
> echo $fieldname.;
I'm not sure what the point (.) is doing here.
Check for error messages in the webserv
define foreign
> key constraints to guard the integrity of your data."
>
TYPE = InnoDB only works if MySQL is compiled with InnoDB support,
which is the default in binaries from MySQL. If you compile it yourself
you need to configure --with-innodb .
Regards,
Fred.
--
Fred van Engen
e
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/opt/mysql-3.23.56/libexec/mysqld: ready for connections
So, look for something similar in your log. If it is there, then make
sure that you have innodb configured in my.cnf.
Regards
(\u)Use another database. Takes database name as argument.
Connection id: 171359 (Can be used with mysqladmin kill)
mysql>
So it looks like you could try the 'source' command. Copying the query
through your clipboard is another option.
Regards,
Fred.
--
Fred van Engen
1 - 100 of 243 matches
Mail list logo
