--- [EMAIL PROTECTED] wrote:
> Peter Matulis <[EMAIL PROTECTED]> wrote on 11/15/2005 02:47:56
> PM:
> > but in phpmyadmin I get these types of warning for five
> tables:
> >
> > table 1:
> > UNIQUE and INDEX keys should not both be set for column `ema
I am still trying to create a schema. I do not get errors when I do
so but in phpmyadmin I get these types of warning for five tables:
table 1:
UNIQUE and INDEX keys should not both be set for column `email`
table 2:
More than one INDEX key was created for column `mail_id`
More than one INDEX ke
--- Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Sujay Koduri wrote:
> > You havent specified the datatype for the column 'id'.
>
> Right, this should be fatal.
> But I also take issue with other parts:
>
> >
> > CREATE TABLE users (
> > id PRIMARY KEY,
> > priority integer NOT NULL DEFAULT
{ this is a resend, forgot subject in original posting }
Hello, I am using MySQL 4.0.24 on OpenBSD 3.8.
I am having difficulty creating a SQL schema. My attempts contain
lines like:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT
start the server before connecting to it.
*** REPLY SEPARATOR ***
On 7/3/2002 at 3:24 PM Rahadul Kabir wrote:
>[root /root]# mysqladmin -u root password '30waverly'
>mysqladmin: connect to server at 'localhost' failed
>error: 'Can't connect to local MySQL server through socket
How did you install MySQL? Package, source, binary?
*** REPLY SEPARATOR ***
On 7/3/2002 at 3:06 PM Rahadul Kabir wrote:
>hi
> im getting the message :
>Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (111)
> when i try to connect to mysql
>
>Th
---+
| mysql |
| test |
+--+
What's going on here?
Peter Matulis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
