fenway

You've resurrected a thread from a year ago -- start a new topic.

I don't understand the question.

64MB packet size? Why? Post the query, and the explain output, the create table, and the size of the data/index files.

Usually you store both side of a link, one pair per row.

Those sound like PHP errors..

What was wrong with your initial code?

You mean by rounding?

mysqlfreaks was hacked -- most, if not all, of the content I contributed was lost -- along with many other valuable members. We were homeless, so we moved here.

The comment was with respect to aliases, not column lists. "Extra data" is fine for normal, under-utilized sites -- besides, most DB wrappers can help you.

Unfortunately, that's hard-coded in the source.

That depends if you have a truncate/drop statement in there. And make sure your text editor is unicode-aware.

There is still a way to do this with locate, but two columns is better anyway.

One row per entity is absolutely required.

You can reset auto-increment.

SUBSTRING_INDEX() is your friend.

Because typing doesn't cost anything but clarity.

TCPDF ????

INSERT IGNORE?

If you asking how to pass parameters via a URL, this is the wrong forum.

How and why? have you consulted the mysql refman yet?

Then put whatever words you want to be searchable in a dedicated column, and use FULLTEXT.

Because you can store it there, if you prefer -- it's just not advisable.

And with mysql_connect(), this user works?

If you never need to access data from multiple clients, then sure, why not, different DBs is just fine.

Not PHP -- use SUBSTRING_INDEX().