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
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
- Original Message -
From: Aji Andri [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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.
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
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
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
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
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
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
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
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
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
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 in
tables
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
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
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,
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,
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
Hi,
I got this table:
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| id | int(10) unsigned| | PRI | 0 | |
| value|
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|
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
mysqlcreate database `myDBName`;
mysqluse `myDBName`;
mysqlsource C:\tables.sql;
that's it!
On Apr 2, 2005 10:26 AM, Niki
22 matches
Mail list logo