Do this.
Save the create tables commands in a textfile on your harddrive called
'C:\tables.sql'
Load mysql from the command line.
@ the prompt, type the following
mysql>create database `myDBName`;
mysql>use `myDBName`;
mysql>source C:\tables.sql;
that's it!
On Apr 2, 2005 10:26 AM, Niki Lampr
Hi,
This is a known bug which will be fixed in MySQL 4.1.11.
See
http://bugs.mysql.com/bug.php?id=8675
and
http://bugs.mysql.com/bug.php?id=8147
Regards,
Jocelyn
Eli wrote:
Hi,
I got this table:
+--+-+--+-+-+---+
| Field| Type| N
Hi,
I got this table:
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| id | int(10) unsigned| | PRI | 0 | |
| value|
It took me awhile to understand this, but it does appear to be the
correct solution in my case. Thank you.
Bartis, Robert M (Bob) wrote:
Sounds like you need a 1:N relationship table to hold userInfo
separate from either the user or group table. Adding a infoIdentifier
would allow the number of r
Sounds like you need a 1:N relationship table to hold userInfo separate from
either the user or group table. Adding a infoIdentifier would allow the number
of rows added for a specific user to be sized based on the specific user needs.
This is effect would be the "key" part of a key-value pair,
What version of MySQL are you using? Also, are you issuing only "GRANT .."
statements or modifying the privilege tables manually as well?
Search for 'GRANT':
http://dev.mysql.com/doc/mysql/en/replication-features.html
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 1 Apr 2005, N
I have table with only one column set to latin1_general_ci collation,
and I get following error:
*Illegal mix of collations (latin1_general_cs,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='*
Client (PHP5 with mysql functions) uses utf-8 character set. MySQL is
4.1.10a. When I change co
Tom Crimmins wrote:
user table:
id (pk)
name
any other user info only dependant on the user
group table:
id (pk)
name
any other group info only dependant on the group
usergroup table:
user_id (pk)
group_id (pk)
any info specific to individual user/group combo
Yes, if I understand what you are sayin
On Saturday, April 02, 2005 12:48, Eric Gorr wrote:
> Peter Brawley wrote:
>> Eric,
>>
>> If I understand you correctly, you propose to encode user and group
>> info as table names. That's a mistake. To use an RDBMS like MySQL
>> effectively, you want to encode your information as rows of data i
Eric,
You do not want to encode data in table names. Mainly you want to
create the least redundant set representation of your data, realise
that representation as fixed related tables, then use SQL to fill &
query those tables. Do a little reading and play with a few toy designs
before you sta
Peter Brawley wrote:
Eric,
If I understand you correctly, you propose to encode user and group info
as table names. That's a mistake. To use an RDBMS like MySQL
effectively, you want to encode your information as rows of data in
tables whose names and structures do not vary.
Thank you for your c
Eric,
If I understand you correctly, you propose to encode user and group info
as table names. That's a mistake. To use an RDBMS like MySQL
effectively, you want to encode your information as rows of data in
tables whose names and structures do not vary. May I suggest you read
some of the tutor
better description>>
instructions to be followed for installation of ALICE
PHP chatbot. It is the first time I am using MySQL>
2. Create a database for the program to use in MySQL.
3. Create the tables in the new database using db.sql
which is in the sql directory.
tables
#
# Table structure for
I dont know how to do this very basuc, just atrated
working with MySQL and not sure about what I am
supposed to do.. Please help!!
2. Create a database for the program to use in MySQL.
3. Create the tables in the new database using db.sql
which is in the sql directory.
niki
Send instant mes
Not having done much database design in the past, I have what should be
a fairly simple design question.
I usage of mySQL will revolve around a common group + user system. There
can be multiple groups and each group will contain some subset of users.
Each group will have a custom set of data whos
I'm taking a database course and am curious about the support for
assertions in MySQL. It appears that they were added to SQL92, but I
don't see any information about them in the MySQL documentation (either
to say they are supported or to say they are not).
--
MySQL General Mailing List
For lis
Stefano,
The behaviour you are describing is normal, assuming that the column in your
MySQL table is defined as CHAR(255) or VARCHAR(255).
You didn't say which version of MySQL you are using. However, unless you are
using MySQL 5.0.3 or later, 255 is the largest size available for a CHAR or
VARCH
What is the structure of the table you are importing to? you might have
merely hit the natural limit of the column type.
- michael dykman
On Sat, 2005-04-02 at 06:51, [EMAIL PROTECTED] wrote:
> First of all I hope you can be patient for my english
> I'm working with data import into mysql f
Michael
This is a client side problem. Whatever is pooling/managing your
connections is not doing a very good job of it.
You haven't mentioned how you are managing your connections within your
Tomcat app. I know Tomcat has a managed connection pool but I'm less
than familiar with it. Persona
- Original Message -
From: "Aji Andri" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 02, 2005 2:13 AM
Subject: Newbie :create table multi, index
> hi seniors,
>
I assume that English is not your first language. "Seniors" means "old
people" and some people would be offended by being cal
Hi,
I have suse 9.2 and MySQL 4.21
My basedir is /var/lib/mysql
datadir /data/mysql/mysqldata
Both the directories and subdirectories and files are owned by user mysq,l
group mysql with rights 755. So I guess I have got the permissions part
right or so I hope.
Everything was working fine till I d
First of all I hope you can be patient for my english
I'm working with data import into mysql from a txt file. I'm using LOAD
DATA INFILE
command but I cannot correctly import a text column of 595 characters.
I receive this (very large) file from an external organization and this
file is made
w
22 matches
Mail list logo
