Hi,
I need some help. I got a 161 tables that I am trying to create schem
on, the problem is I can get any of my boxes to show you know
+---+
| |
+---+
Here is the command I am doing
my -Ae "show tables;" | while read a ; do my -Ae "desc $a"; echo >>
myfile.txt ; done
what I get
On 10/16/06, mos <[EMAIL PROTECTED]> wrote:
Timothy,
You can make the varchar column case sensitive by using the
binary
attribute or use the isstrcmp(value1,value2) for an exact match.
See http://lists.mysql.com/mysql/170390
varchar(255) binary
or select binary 'a'='A' ...
Mike
T
Ted - sorry, not sure what this is showing me. Is the image data
supposed to be in the "data" field in the Photo table? It's not
there, or it's corrupt?
Dan
On 10/15/06, Ted Johnson <[EMAIL PROTECTED]> wrote:
74
- Original Message
From: Dan Buettner <[EMAIL PROTECTED]>
To: Ted John
At 08:26 AM 10/15/2006, you wrote:
Hi,
My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key case
insensitive. Is this normal? This is not the behavior I prefer. Any help
would be appreciated, thanks.
Timo
At 11:55 AM 10/15/2006, you wrote:
On 10/15/06, Freebat Wangh <[EMAIL PROTECTED]> wrote:
mysql> explain select lw.id, lw.sender as guest_id from gossip lw where
lw.owner = 21821 order by lw.id desc limit 18540, 20\G;
*** 1. row ***
id:
At 08:39 PM 10/14/2006, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date fields
I thought those here might like to know my experience with Hosting at
godaddy.com. It is cheap at $3.50 or so a month. However there are
huge limitations on what you can do. My first annoyance was when I
found out that they used MySQL version 4.0 instead of 4.1 or 5. To
their credit though
On 10/15/06, Freebat Wangh <[EMAIL PROTECTED]> wrote:
mysql> explain select lw.id, lw.sender as guest_id from gossip lw where
lw.owner = 21821 order by lw.id desc limit 18540, 20\G;
*** 1. row ***
id: 1
select_type: SIMPLE
t
On 10/15/06, freebat <[EMAIL PROTECTED]> wrote:
This approach will make the query filesort.
why?
You use the index owner_id to filter the rows and the primary key index to
perform the sort!
or not?
test it with explain:
explain select lw.id , lw.sender as guest_id from gossip lw where
lw
This approach will make the query filesort.
Shen139 wrote:
I don't understand why you are using an index like `owner_id` composed
by `owner` and `id`!
I think that you should change it removing `id` from the fields list:
...
PRIMARY KEY (`id`),
KEY `owner_id` (`owner`)
...
On 10/15/06
On 10/15/06, Timothy Wu <[EMAIL PROTECTED]> wrote:
Hi,
hi
My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key
case
insensitive. Is this normal?
Yes, it's normal!
To force mysql to use case-sensiti
I don't understand why you are using an index like `owner_id` composed by
`owner` and `id`!
I think that you should change it removing `id` from the fields list:
...
PRIMARY KEY (`id`),
KEY `owner_id` (`owner`)
...
On 10/15/06, freebat <[EMAIL PROTECTED]> wrote:
this is the table:
CREATE TA
74- Original Message
From: Dan Buettner <[EMAIL PROTECTED]>
To: Ted Johnson <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Sunday, October 15, 2006 9:22:04 AM
Subject: Re: Re: Re: Readind a Dump W/o Expanding It
How were they stored in the database?
You got me on that. I just took
Hi,
My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key case
insensitive. Is this normal? This is not the behavior I prefer. Any help
would be appreciated, thanks.
Timothy
How were they stored in the database? Which way did you end up
restoring the data? And the dumpfile you have - how has it been
handled? I ask because if it contains binary data and was FTP'd from
one machine to another the wrong way, that could have done it.
Dan
On 10/15/06, Ted Johnson <[EMA
this is the table:
CREATE TABLE `gossip` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`owner` int(11) NOT NULL,
`sender` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `owner_id` (`owner`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
table status:
mysql> show table st
Hello all,
using MySQL C API function "|mysql_query()" with a query producing a
result set, I have to fetch *all* records, if I use
"||mysql_use_result()" to avoid a client side cursor. So it's written in
the manual section |22.2.3.70.
But if I want to use prepared statements with MySQL C API fun
That worked! Thanks! However, when I restored the database, it seemed to have
trashed all the images. What do?
TIA,
Ted
- Original Message
From: Dan Buettner <[EMAIL PROTECTED]>
To: Ted Johnson <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Saturday, October 14, 2006 9:59:31 PM
Sub
18 matches
Mail list logo