Sorry, I'm a top quoter. This is what I want to do. I'm still told there
re problems with my keys.
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`person_id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`email` varchar(255) default NULL,
PRIMARY KEY (`person_id
I want to make a relational link from `data` to `shopping` so when I
insert a new record in `shopping`, I will see the contents of
`data`.`name` and `data`.`email` as drop-down menus in `shopping`.
This is InnoDB so I should be able to do this by SQL, right?
Thanks,
John
DROP TABLE IF EXISTS `
Which version? Which export type? Strings TEXT, VARCHAR would be quoted.
INT would not, I think.
Their forum might be a better place. www.phpmyadmin.net.
2wsxdr5 wrote:
I just tried to use the output of the export function on phpmyadmin and
got a million errors. After looking at the file I fo
I'm using PHP Version 4.3.9 and MySQL 4.1.12. I recently upgraded from
PHP 4.1.x and MySQL 4.0.x.
Basically my SQL worked until my upgrade. "ORDER BY relevancy DESC" no longer
works?
SELECT *,MATCH (AU,ST,SD)
AGAINST ('johnston' IN BOOLEAN MODE)
AS relevancy FROM ccl.ccl_main
WHERE MATCH (AU,ST
repair.
Unfortunately the server.err file is not giving me any output, nor
.log and I don't have a .status file either.
Thanks,
John.
On Sat, 26 Feb 2005 21:42:27 +0200, Heikki Tuuri
<[EMAIL PROTECTED]> wrote:
> John,
>
> - Original Message -
> From: "Jo
Hi,
We have a large InnoDB table to which we recently added an index. That
index creation thread was issued a kill yesterday due to length of
time, unfortunately according to 'show innodb status' the rollback is
now 162 hrs away from completion (1 every 5 secs).
We are not using per-table tablesp
On Tuesday 18 February 2003 15:36, Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
> John Taylor <[EMAIL PROTECTED]> writes:
>
> > I get the error:
> > ERROR 1227: Access denied. You need the REPLICATION SLAVE privilege for this
>operation
>
> >
Hi,
I'm having a bit of a nightmare getting replication working.
Both slave and master are 4.0.10-gamma
If I install fresh copies on two clean machines, and follow the
instructions in manual.txt, everything works fine.
The problem is that I need to do this in a production environment,
so I c
