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
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
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