The MySQL online manual says that MySQL cannot use indexes efficiently
unless the columns have the same type and the same length.
I can see no release notes that this problem has been fixed.
My question: Is this still a problem?
Here is the extract from the latest manual:
7.29 EXPLAIN Syntax
Hello!
I tried to insert one row to mysql database (ver. 3.23) via myodbc
(ver.2.50.39.00).
I made test program (vc6) which look like this:
#include windows.h
#include stdio.h
#include sql.h
#include sqlext.h
int main(int argc, char* argv[])
{
SQLSMALLINT nCols;
SQLHENV
Hi,
I want an OR test. If someone searches on last name and enters nothing in
the other fields, I want to find the record(s). Similarly, if they enter a
first name and no other data, I want to find the record(s).
The part I realize I am missing is to first test to see which fields have
Hi,
Go to:
Project-Settings-Link... and add at: Object/Library Modules :
libmySQL.lib
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
Hi,
Lock Table before update:
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Christoph Lütjen [EMAIL PROTECTED]
Description:
On boot of linux, mysql doesn't start automatically because mysql.log
file is owned by root. One has to whange owner by hand to
mysql and then restart mysql.
How-To-Repeat:
on next day a new mysql.log file is created with root as owner.
Fix:
Description:
Using delete with no where statement results in a faulty message about
updated lines
How-To-Repeat:
SQL-statements follow:
mysql select * from asses_cats;
+---+---+
| ac_id | label |
+---+---+
| 1 | test1 |
| 2 | test2 |
+---+---+
2 rows in
Hello:
We are facing a serious problem with the MySQL server installed on our web
server (BSD/OS). The server was working fine till last week. Since then it
started crashing. It crashes 2-3 times a day. Every time we have to kill
the process and restart the server (UNIX). Not only the MySQL
* Martijn Haak
Description:
Using delete with no where statement results in a faulty message about
updated lines
How-To-Repeat:
SQL-statements follow:
mysql select * from asses_cats;
+---+---+
| ac_id | label |
+---+---+
| 1 | test1 |
| 2 | test2 |
- Original Message -
From: Sven Bentlage [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 5:18 AM
Subject: mixed up variables
Can anybody help me figure out how to correct that?
Thank you for your help.
sven
code:
my $sth = $dbh-prepare(
select *
from
Hi,
check the niced processes (on BSD #ps aux). These are processes which have
been assigned a higher priority
and there for kill your server.
Also the man page from top (the CPU STATE comes from top ?) writes that the
nice % should also be seen in
user and system % which is not the case in
Hello guys,
Am new to mySQL. I had installed mySQL version 3.23.49 on my pc running on
windows 98. My problem is when I tried to populate a database using the
command:
load data local infile uprhs.txt into table uprhs;
I get an error message ERROR 1148: The used command is not allowed
[snip]
I watch the .MYD file grow to about 4.2 GB and stop with this error from
mysqlimport.
mysqlimport: Error: Can't open file: 'temp.MYD'. (errno: 144)
mysqlimport: Error: The table 'temp' is full, when using table: temp
I've tried starting safe_mysqld with the --big-tables option, and that
Hello, I have no idea why but I received this email from you, I know there
are currently a lot of viree flying around recenlt y, maybe this is related?
Regards,
Justin Willis
IT Manager
Zenith Entertainment Ltd
T: 0207 6641602
F: 0207 9355907
M: 0788 7730038
Hi ,
CFc I've decided to provide a snapshot release system of the data on the
CFc work.mysql.com server for 4.0.x you can access the nightly builds here:
CFc
CFc http://www.mysqldeveloper.com/snapshots/
thank you very much for the option to download the snapshot.
Just my Intention is to by
after trying to execute the scripts/mysql_install_db i get this error
message:
my_print_defaults: not found
Didnt find usr/local/libexec.mysqld
you should do a make install before executing this script
any suggestions?
amy
-
Hello, mysql,
How to get Age from field date-time that contain dateofbirth and then display as
xx year yy month zz days.
Best regards.
Kittiphum Worachat
[EMAIL PROTECTED]
2002-05-15
-
Before posting, please check:
I have a problem that i don't know if mysql can solve, my customer wants the
date format to be
YYWWD (year,week, day of week)
Its no problem with geting a date from the database in this format typing
select DATE_FORMAT('020515', '%y%v%w');
Now to the problem, is there any way I can make an
Hi
my_print_defaults: not found
Didnt find usr/local/libexec.mysqld
you should do a make install before executing this script
So, did you do make install? In that case check out the location above,
and try to find libexc.mysqld. And make proper changes
Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers
datecalculations and has specifics on Age calcs.
-Nick
Hello, mysql,
How to get
Age from field date-time that contain dateofbirth and then
display as xx year yy month zz
days.
Best regards.
Kittiphum Worachat
Mainly what hooked me on mySQL was the static record layout for MyISAM
tables.
I have to import into new tables
about 120 million records every three months.
I wrote a Quick Delphi 6 app to do this(very fast).
Once I figured out how the byte header for deleted and null Fields work
at the
You need to link in the mysqlclient library. Select Project- Settings from
the VC menu bar, then select the Link Tab and add mysqlclient.lib to the
Object/Library Field. You will need to do this for the Release and Debug
version. You will also need to add the path under the Input Category of
Hi.
I have quite i buzy MySQL-server running MySQL 3.23.49. The Database has
~100 tables. One of them, here referred to as table_0, is quite buzy.
Turning on the Innodb Monitor gives me the following clue. A lot of
transations are listed like this:
---TRANSACTION 0 1029552346, OS thread id
Tristan,
Wednesday, May 15, 2002, 2:58:26 PM, you wrote:
TT Am new to mySQL. I had installed mySQL version 3.23.49 on my pc running on
TT windows 98. My problem is when I tried to populate a database using the
TT command:
TT load data local infile uprhs.txt into table uprhs;
TT I get
sylvain,
Wednesday, May 15, 2002, 12:05:48 PM, you wrote:
sDescription:
s On boot of linux, mysql doesn't start automatically because mysql.log
s file is owned by root. One has to whange owner by hand to
s mysql and then restart mysql.
sHow-To-Repeat:
s on next
Schoenland,
Wednesday, May 15, 2002, 2:33:47 AM, you wrote:
Seoen Well, I am new to the list.. so if i ask something stupid, just slap me
Seoen on the back of my head, k? =)
Seoen I was playing a little with my phpmyadmin and deleted user root. Now I
Seoen don't get access anymore..
Seoen Is
Andrew,
Tuesday, May 14, 2002, 10:56:43 PM, you wrote:
AL On Tuesday 14 May 2002 06:10 am, Egor Egorov wrote:
If not, can I write the Query results of the SELECT statement out to a
new table and delete the original table?
Yes, you can use CREATE ... SELECT statement.
AL Thank you for
Those files got so big that I had no more space on my hard drive and
queriess would stop returning without any message telling me what was
going on. All for the log files? Doesn't that seem like something that
should be changed (atleast for the default install) ? It seems to me
that there
Hi Ovanes,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih this is to add
the MAX_ROWS table option when creating the table, just make it a
really large number like 50. You can verify this effect by
BEFORE
I am trying to build mysql-4.0.1 from the source...
When it gets to libtool it is having problems finding gcc... How can I cahnge the
path to the full path of the gcc compiler?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking
of course, the safe way is to always reset the password when such a
thing happens.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Encrypting with PASSWORD() function
Walter,
Tuesday, May
after running make test i received 3 errors relating to rpl01, 4,
and and 7. This error message is displayed:
AT line 6: query 'slave stop' failed: 1199: This operation requires a
running slave, configure slave and do SLAVE START
At line 6: query 'load data infile
Hi all,
Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a
half year. Our way to rotate the binlog files was to stop all software
inserting data into the Prod. DB and then reset the master and the
replication server. This works fine but produces a downtime of aprox. 10
Hi all,
Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a
half year. Our way to rotate the binlog files was to stop all software
inserting data into the Prod. DB and then reset the master and the
replication server. This works fine but produces a downtime of aprox. 10
Okay, I believe the problem I am having is make is having some problemsis in
libmysql.c when the getenv fucntion is used.
I commented out the following lines in libmysql.c and then the program errored in the
next line with getenv. Anyone have a workaround for this code on HP-UX 11.00?
if
At 04:34 PM 5/14/2002, you wrote:
I'd be interested in how both of you compared them.
Thanks,
--jeff
Jeff,
I'm using MySQL for a webserver and didn't really want to use
Firebird (Interbase) for that type of application. It is my feeling that IB
requires more maintenance than MySQL.
j.random.programmer,
Wednesday, May 15, 2002, 3:00:26 AM, you wrote:
jrp Can someone (who knows this sort of thing) give a
jrp layman's introduction to the interplay between
jrp various gcc versions and various mysql versions
jrp (3.49, 3.50, 4.01 etc) ? I have some linux boxes
jrp and don't
Augey,
Wednesday, May 15, 2002, 4:25:15 PM, you wrote:
AM Those files got so big that I had no more space on my hard drive and
AM queriess would stop returning without any message telling me what was
AM going on. All for the log files? Doesn't that seem like something that
AM should be
Group,
I have been using (very happily) mysql on unix boxes. I am in a new job and
there is not a unix box in sight!!! ouch!
This is a windows 2000 shop. Here is the situation and I am looking for any
and all suggestions:
1) I have mysql, apache, perl, etc running on my own box and I
Hi:
I am trying to download GUI for mysql server, however, there are several
choices at the site, would you please give some advise of which one I should
download please?
Regards,
Anne Hall
IntelliSTAR(sm)
Providing High-Tech, High-Touch services for over 6 Years!
http://www.intellistar.net
Hi,
as far as I know the only way that can be correct is to have one of the
committers rename the files them selves that have duplicate names. Since
windows isn't smart enough to realize that ABC doesn't mean abc.
Good luck getting it working under windows ;-)
Viliam Batka wrote:
Hi ,
Without knowing what you need to be able to do in a MySQL GUI:
I have MyCC 0.8.2 from MySQL AB and dbTools 1.0.13 from www.dbtools.com.br.
I like both. MyCC is alpha and a little finicky at times...but easy to use.
dbTools is interesting and has a lot of potential.
HTH
Mike
- Original
Here is my message again:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in
Hello list,
what's the difference and relation between MySQL-Max and the stuff at
www.innodb.com? Both technically and license-wise... Thanks.
Vaclav Dvorak [EMAIL PROTECTED]
IDAS, s.r.o.http://www.idas.cz
-
Before
As an addendum to my last message:
If you want to do db dev through the GUI, I would suggest the MyCC from
MySQL AB over dbTools. MyCC provides more in the way of server process and
variable exposure within the GUI itself.
Mike
- Original Message -
From: Anne Hall [EMAIL PROTECTED]
Dear Sir/Madam,
An odd question. Can a SYBASE database and a MySQL database interact? That
is, can routines be written that, at a specified time or time intervals,
syncronize specified data between these two databases? An comments or
opinions would be appreciated.
Thanks
-chris
Christopher E.
I installed one version of MySQL but had to reinstall MySQL. Thus, I
manually deleted the first installation, including /tmp/mysql.sock.
The second installation mysteriously did not install another copy of
mysql.sock. Gerry-mandering the configuration through the following line
avails nothing:
- Original Message -
From: Scott J. Pearson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 7:13 PM
Subject: mysql.sock difficulties
I installed one version of MySQL but had to reinstall MySQL.
Thus, I manually deleted the first installation,
including
Hi all, I am trying to connect to my mysql database with a perl script...
I can connect from commnad line both passing a password or at password prompt...
I can connect successfully with the following line in my script..
my $dbh = DBI-connect(DBI:mysql:database=mysql;host=localhost, root,
Perl is your friend.
el
In message [EMAIL PROTECTED], Ch
ristopher E. Aston writes:
Dear Sir/Madam,
An odd question. Can a SYBASE database and a MySQL database interact? That
is, can routines be written that, at a specified time or time intervals,
syncronize specified data between these
Hi!
Melvyn == Melvyn Sopacua [EMAIL PROTECTED] writes:
cut
Melvyn I don't get the checksum errors anymore - after I changed the table def.
Melvyn However - myisamchk is not doing a good job with the large keys (restored
Melvyn them by LOAD TABLE hardware FROM MASTER which produced the
On Wednesday, 15. May 2002 14:54, Mattias Persson wrote:
query above. The manual says
%v Week (1..53), where Monday is the first day of the week. Used with '%x'
%u Week (0..53), where Monday is the first day of the week
When is there a week 0?
Hi,
Week = 0 only is valid for %u.
%v
Hi,
I'm just testing the new multi-table delete in MySQL-4.0.2 and I wonder if
I'm doing something wrong with this query :
mysql DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING
searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2
as c WHERE
Hi Tristan,
Both the client and the server must have that option enabled. You
must also have the right setup in your grant tables to load files.
Try loading it locally (with out the LOCAL flag) and see if that helps.
Tristan Trio wrote:
Hello,
Am new to mySQL. I had installed mySQL
Hi!
Myk == Myk Melez [EMAIL PROTECTED] writes:
Myk Steven Roussey wrote:
Are the tables defined the same on both servers?
Myk Yes, the tables are defined exactly the same.
Is the data the same?
Myk Just about. The data on the working server is a copy of the database on
Myk the
Hi!
Trying to catch up with some old emails...
Ireneusz == Ireneusz Piasecki [EMAIL PROTECTED] writes:
Ireneusz Hi. I'm running on linux box 6.2 with glibc 2.1 and i compiled from src.rpm
Ireneusz mysql.
Ireneusz The compiler is gcc 2.95.2.
Ireneusz So, the new version of mysql 3.23.50 can
I've gotten this same assertion failure twice.
I'm very confident in this machine's stability since it has survived 36 hours
worth of CTCS, so I'm not going to look for a hardware problem just yet.
At first I thought it may have been the glibc issue with threads overwriting
each other's stacks
Hi Mike,
Thanks. I appreciate the insight. I think I remember the sweeping
maintenance of the tables from the stuff I read at the Firebird sourceforge
site -- called vacuuming, right? That seemed like a serious pain in the
butt. Also, I couldn't find any easy solutions for replication, which is
Hi All,
What is the convention for documenting the contents/purpose of a column in MySql?
Most databases I have worked with had a way where text could be entered for each
column that described the purpose and or contents of the column. It seems to me that
this is something that should
SQL beginner using Macromedia Ultradev. Can you help?
Please be gentle I'm not a programmer!
I am using
Select DISTINCT Month
FROM tblNews
The problem is that the months are shown alphabetical not in calendar order.
How can I change this?
Thanks for the insight.
--jeff
- Original Message -
From: Mike Grover [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 6:07 AM
Subject: RE: Best book on MySQL
Mainly what hooked me on mySQL was the static record layout for MyISAM
tables.
I have to import into
From: Peter Sampson [EMAIL PROTECTED]
Select DISTINCT Month
FROM tblNews
The problem is that the months are shown alphabetical not in calendar order.
I'm assuming that your months are stored as names like:
January, February, March
or
Jan, Feb, Mar
If so, I think that sorting in
I have my MySQL database up and running, but its empty...did i miss a
step?
Thanks
Amy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi list,
i know that 3.23.50 is a pre-released version. But if someone can tell me
when this version will be declared as stable so i will upgrade my linux
production servers running redhat 7.2 and gcc 2.96 with the tar.gz build
mysql.
Thanks
David
filter : sql,query
When I create a temp table, If I put to much in it,
I get a Temp Table [Table name] is Full error.
I changed my tmp_table_size to a ver large number.
Still same error, Any Ideas?
This is windows 2000
MySQL 4.01
Config Loaded Form my.ini in winnt dir.
Show Variables for server shows new
Hi Chris,
Dear Sir/Madam seems a little formal for a public mailing list!
Anyway, we use perl scripts to transfer information from Microsoft
SQL server (which was and is somewhat compatable with SyBASE) use the
freeTDS sybase/mssql drivers to mysql. I modeled the databse with
ErWIN first
Hi amy,
No the database(s) them selves are empty until populated with tables,
and data.
Amy Zediak wrote:
I have my MySQL database up and running, but its empty...did i miss a
step?
Thanks
Amy
-
Before posting,
* Rodney Broom
From: Peter Sampson [EMAIL PROTECTED]
Select DISTINCT Month
FROM tblNews
The problem is that the months are shown alphabetical not in
calendar order.
I'm assuming that your months are stored as names like:
January, February, March
or
Jan, Feb, Mar
At 15:40 -0400 5/15/02, Amy Zediak wrote:
I have my MySQL database up and running, but its empty...did i miss a
step?
Thanks
Amy
Do you mean:
- Your server is up and running, but there are no databases at all
- Your server is up and running, and there is a database named mysql
but it
Hi Mike,
Possibly out of available memory. (Or disk space assuming that's what
it's hitting)
Mike Grover wrote:
When I create a temp table, If I put to much in it,
I get a Temp Table [Table name] is Full error.
I changed my tmp_table_size to a ver large number.
Still same error, Any
At 11:48 -0700 5/15/02, mike markovich wrote:
Hi All,
What is the convention for documenting the contents/purpose of a
column in MySql?
There is none.
Most databases I have worked with had a way where text could be
entered for each column that described the purpose and or contents
of the
At 9:59 -0600 5/15/02, Colin Faber wrote:
Hi,
as far as I know the only way that can be correct is to have one of the
committers rename the files them selves that have duplicate names. Since
windows isn't smart enough to realize that ABC doesn't mean abc.
Good luck getting it working under
Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM
tables on which I am unable to do updates or inserts. I get error
message #1036 'Table is read only.' I am able to sign on to the database
through the root, set myself up as a superuser in the user table, and
have been able to
Paul,
Thanks for responding. The ability to document columns, tables, databases, etc. seems
pretty important to me. Why is this not an issue to others? Am I approaching this
issue the wrong way? Your thoughts would be appreciated.
Mike
-Original Message-
From: Paul DuBois
Hey all,
I'm attempting to create a new table within a database. I have tried from the mysql
client and also from dbtools. Here is the error message I am receiving:
ERROR 3: Error writing file './path_to/file.frm' (Errorcode: 28)
I am trying to add the table as root. I have checked the file
So i change the properties of Month to Integer in tblNews?
Create another table called MonthNames? Now I'm lost a bit, please can you
clarify?
I can populate the MonthNames table with jan feb march etc
Please can you clarify the next bit, I not familar with n JOIN ON n
Month?
- Original Message -
From: mike markovich [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 3:54 PM
Subject: RE: Column Header/ Column Description
Paul,
Thanks for responding. The ability to document columns, tables,
databases,
At 13:54 -0700 5/15/02, mike markovich wrote:
Paul,
Thanks for responding. The ability to document columns, tables,
databases, etc. seems pretty important to me. Why is this not an
issue to others? Am I approaching this issue the wrong way? Your
thoughts would be appreciated.
Mike
I
That's why there is a seperate area called documentation . why let MySQL
software run slower and/or eat up more memory space with a useless feature.
You can always document your specifications in a document, it doesn't have
to be stored on the tables themselves. If you really want that
Peter,
Please give us more insight on this. Is the column where you store dates (or
months) is a date datatype column?? If yes you can just do
SELECT ... FROM table_name ORDER BY MONTH(column_name);
It'll help to see your table structure to help you.
Thanks.
Gurhan
-Original Message-
Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try
your code in the HTML/ASP part of the webpage
The table structure is
Month
Headline
Image
Caption
Content
I can have many entries with the same month.
Distinct makes a page with Click here for MONTH news.
Clicking on
Hi Bradley,
Use perror program to see what the error code means..
# perror 28
Error code 28: No space left on device
Seems like you ran out of space..
Gurhan
-Original Message-
From: Bradley Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 5:01 PM
To: [EMAIL
This is the error:
Microsoft][ODBC Microsoft Access Driver] ORDER BY clause (ID) conflicts with
DISTINCT.
This is the code used:
SELECT DISTINCT Month FROM tbl_LatestNews ORDER BY ID
Table Structure:
Month, Headline, Image, Caption, Content
I
- Original Message -
From: Gurhan Ozen
This was addressed privately, but that's not a big deal. :) (I forgot
to hit reply-all. :P)
Peter Sampson wrote:
So i change the properties of Month to Integer in tblNews?
Say you have two tables:
mysql show tables;
++
| Tables_in_test |
++
| MonthNames
Most of my database work has been on DB2/400. (This the native database for IBM's
AS/400 series.) The reason this is important to me is because I'm transferring data
from DB2/400 to MySQL. The MySQL database is optimized for reporting purposes. Most
users will access the data via ODBC and,
Hello,
I'm looking for a solution to a database problem I'm having. The
current implementation is a file based database of roughly 57
million entries. I'm wondering if anyone has had any experience running
a mysql based database with 50-100 million entries ? I was told that
mysql was optomized
Michael,
the assertion below looks like table corruption. Please check with CHECK
TABLE your tables. If some is corrupt, dump, drop, and reimport it.
The symbols file was forgotten from .49a and we cannot resolve the stack
trace. You might want to try .50 in which the symbols file exists.
I
On 15 May 2002, at 16:06, Mark Matthews wrote:
I'm interested in hearing what databases you have used that have this
functionality? SQL server and Oracle do not, for example.
MS Access does. Also, it seems a bit inconsistent that MySQL has
metadata (the comment) associated with each table,
- Original Message -
From: Peter Sampson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 9:06 PM
Subject: Simple SQL
SQL beginner using Macromedia Ultradev. Can you help?
Please be gentle I'm not a programmer!
I am using
Select DISTINCT Month
FROM tblNews
Vaclav,
MySQL-Max and MySQL/InnoDB as referred to at www.innodb.com are the same
product. Innobase Oy does not distribute or sell directly MySQL-Max. All
distribution and sales are done through MySQL AB.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and
Thanks very much.
Bradley
Gurhan Ozen wrote:
Hi Bradley,
Use perror program to see what the error code means..
# perror 28
Error code 28: No space left on device
Seems like you ran out of space..
Gurhan
-Original Message-
From: Bradley Brown [mailto:[EMAIL PROTECTED]]
Hi,
Could anyone please tell me how I could load a text file into a specific
column in mysql.
I tried LOAD DATA INFILE but didn't work
Thanks,
J.Richards
-
Before posting, please check:
http://www.mysql.com/manual.php
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 4:54 PM
Subject: Re: Column Header/ Column Description
On 15 May 2002, at 16:06, Mark Matthews wrote:
I'm interested in hearing what databases you have used that have this
* Peter Sampson
Maybe it doesn't work because I'm using a SQL wizard in Ultradev, I'll try
your code in the HTML/ASP part of the webpage
The table structure is
Month
Headline
Image
Caption
Content
Peter, you say you're not a programmer, and I'll try to explain a little
about the more
Can some please help me?
I created a MySQL table with newsgroup articles in them, and indexed them on
article_num,
article_num int unsigned not null primary key
But now, as I found out that searching on message_id, using a WHERE clause
tends to get very slow. So, I was wondering whether I can
Haven't found any open source ERD editors out there. BUT, realized that
Visio has ERD diagramming capability, out of the box. Visio seems pretty
prevalent around enterprises. If you look, you might find it and can
describe your data model using one of several de acto standard
methofologies.
Metadata in the database is NOT a bad idea! It's a basic part of the
relational model, Codd's 4th rule. (E. F. Codd is the originator of the
relational model.) While no one has implemented all 12 of Codd's rules, this
is pretty basic/easy.
Here's the 4th rule: The database description is
Michael Widenius wrote:
You can check if the index are ok with CHECK TABLE; If this says the
index is ok, they are not corrupted.
Apparently this doesn't work in all cases. CHECK TABLE told me
everything was fine, but dumping the data to a dump file via mysqldump
and then re-importing it
All,
I can't seem to find anything about character code sets supported by
MySQL. The only thing I found was a note about adding support for sorting
on Unicode at http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html.
What character sets does MySQL support? Is Unicode the default for
national
Hi.
Please start a new thread next time, instead of replying to a
completely unrelated topic. Thank you.
It sounds as if you want
ALTER TABLE your_table ADD INDEX( message_id )
It is probably enough to only index some part of that field and save a
lot of space:
ALTER TABLE your_table ADD
1 - 100 of 128 matches
Mail list logo