Hello everybody,
ich have a few problems with text fields. I want to get the text data of
a mysql text field. The saved texts are longer than 256 characters. But
if I use a select statement mysql returns only 256 characters!
Do anybody know why and what I have to do?
Greetings Tom
> I am new to MySQL and have just installed the MySQL rpm files to my Linux
> box.
>
> I have run "mysql_install_db" with no problems and I have then run
> "safe_mysqld &" this comes up with the messsage
>
> "starting mysql daemon with databses from /var/lib/mysql
>
> mysqld daemon ended"
>
> I as
Ok, I am trying to execute the CREATE TABLE command through telnet and the "test.sql"
file is residing in the directory /home2/fullboreidiot/test.sql and I put in the
command how I'm assuming it would be executed:
mysql> mysql fullboreidiot < /home2/fullboreidiot/test.sql;
and I get the follow
I got connected finally... actually I've connect several times but each time
something else happens that changes things.
I typo'd the myslq.sock line in the /etc/my.cnf file
but... I need to make sure my DBI is installed correctly.
I followed the instructions based on the manual... but do not u
ok, fyi, the below worked fine.
now...
as readers here may know, this db newbie had problems getting MySQL
up and running -much like the other person with pwd problems. i
erased the drive (OS X pb/Tenon iTools), reinstalled and all is well,
it even starts itself.
A newbie question...
Does Mysql support SELECT.. INTERSECT? if not, are there any other
options I can use to implement the same function?
Thanks.
Jowena
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http
Hello list... problems installing on Linux red hat.
background...
I've been a computer user since 1983 I'm really good at windows... haven't
done much Linux. Long story...but a programming partner/associate passed
away leaving me "unlearned" on our server.
problem... need to install mysql...
I g
hello,
I am working on project where my database is mysql. I need whole list
of error codes eg code when there is primary key violation, or other
such database related problems.I have tried perror but that all are
system related problems.I want code for database related problems.
vaibhavi
I've had questions about this too. What happens if I have a primary key, and
the text file has the columns that are in the existing table, with records.
And I want to insert them. How do I get rid of that duplicate error? I read
the manual, about 'ignore' but I can't get it to work.
Any ideas?
I
All-
I'm doing an installation of MySQL where, at least temporarily, a bunch of
clients are running against a server that's on another network behind a
firewall. (The security solution is appropriate.) I'm going to have to
maintain a list of client IPs and have the firewall maintainer allow MySQ
> ...and this will load the table into your database. Now, in the book
> it doesn't specify whether or not you have to be on the computer with
> the server, or if you can send the .sql file command from your
> computer to the remote server, sort of like a file transfer protocol
> as well. Basica
The .sql or txt file has to be on your LINUX machine.
However, I recommend you should create the .sql or txt files in the LINUX
machine using vi , pico or whatever your favoprite text editor mitght be.
Looking forward to your feedback.
dannyh
[EMAIL PROTECTED]
On Mon, 12 Feb 2001, C.o.m.b.u.
The .txt or .sql file you are using must be on the remote server -- either
through FTP or created on that server and then you can issue the command
remotely to populate the database.
--
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
-- your next best friend
I thought it is probably an easy question to answer, so sorry if it is repetitive, but
I am new:
I am reading the book "MySQL" by Paul DuBois, and in it, it is mentioned that when
creating a table, you can do it through a client such as telnet (which is what I'm
doing...ttSSH), and you can eit
I'm using the following table to store information about a merchant user.
He uses his email address as his username to login. Since I'm going to
be doing WHERE clauses on that field, I'd like it to be indexed for speed.
If I have a UNIQUE property on the email field when I create the table, do I
n
I've got a real weird problem happening after building 4.0.4pl1 and mysql
3.23.32 on my test machine. I previously had 4.0.1 up and running with an
earlier version of mysql - I think it was 3.22.xx - and this combination
worked fine.
I *seem* to successfully connect to my mysql database... it's
Has anyone tried running the TPC-W benchmarks on MySQL? I'm not talking about making
the results official (I assume too much $$$) but just to implement them and see how it
goes.
cheers,
thalis
-
Before posting, please check:
try here:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
hth
At 1:38 PM -0600 2/11/01, Anna wrote:
>- Original Message -
>From: "S MODI" <[EMAIL PROTECTED]>
>
>> Hi,
>>
>> I am, currently a student a final year student studying IT For Business
>> at Aston
More news:
I took back an "old" 3.22.32 release from the backups that I knew worked. I
restored it and it did.
There must be some libraries or some stuff that the newly compiled stuff
gets linked with or something else that is causing the trouble.
The problems seem to be resolved (for now) but pl
This is a question for PERL group but anyhow, read again the chapter in MySQL
on printing results from MySQL using PERL. It prints continentA because
that's what you have asked for.
On Sunday 11 February 2001 15:36, Andreas Antes wrote:
=>I have created 2 columns:
=>col1 varchar(20)
=>co
Proof:
Copied it all to another (Win32) Mysql:
It works perfectly.
The Linux system must've taken a beating somewhere.
Thanks for helping
C:\mysql\bin>mysqlshow
+---+
| Databases |
+---+
| aal |
| copas |
| fedil |
| icq |
| iip_
As a suggestion, try phpMyAdmin if you want to insert
records manually. Also, it will provide you with
examples (viewing the source code, that is) on how the
inserts, updates, etc. work. phpMyAdmin can be
downloaded from
http://www.phpwizard.net/projects/phpMyAdmin/
Good Luck!
William Decker
S
hi,
some links more at
http://it97.dyn.dhs.org/
click on scripting
Good luck
i.t
Anna schrieb:
> - Original Message -
> From: "S MODI" <[EMAIL PROTECTED]>
>
> > Hi,
> >
> > I am, currently a student a final year student studying IT For Business
> > at Aston University In Birmingham.
>
Hi,
I can only repeat that I have databases that were working before. I can try
them on other systems if you want but I'm pretty sure they're alright.
Something must've gotten messed up in the system since even after switching
back to 3.22 the same stuff happened.
I'm quite confused where this cou
Multiprotocol Integrated Database Authorization System
The centerpiece of this release of Midas is a multi-threaded NIS
server that uses a MySQL database as its data store. This design
eliminates some of the limitations of Sun's ypserv, specifically those
associated with the dbm file f
- Original Message -
From: "S MODI" <[EMAIL PROTECTED]>
> Hi,
>
> I am, currently a student a final year student studying IT For Business
> at Aston University In Birmingham.
> As part of my final year project I need to produce an online
> questionnaire with database functionailty.
>
> I
I have created 2 columns:
col1 varchar(20)
col2 varchar(20)
when I add content to the columns it looks like
this for example:
col1
contentA
NULL
contentB
Now when I try to print out the content in Perl
using this code:
while($dirty_words = $sth->fetchrow_array) {
print "$dirty_words\n";
}
Fortunes are being made online everyday! Now is your chance to become involved with
one of the most explosive Internet industries...Internet Gaming!
But wait there is much more...LIVE Webcast Lotto and Bingo, International Sports
Betting, and Virtual Stock Trading.
We are PLAYING GAMES, HAVING
> Erick:
>
> Do not try to copy the database files themselves. Instead use mysqldump to
> dump the structure and contents to text files, which you can easily copy
> across the network from your Windoze to Linux.
>
> My advice is to create an empty database on the Linux machine,
> and set your
> pe
> last night i took a MySQL database (a folder i got out of the
> MySQL/data folder) home and copied into the data folder on my
> machine, is this ok?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_3_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www
At 7:10 PM + 2/11/01, php php wrote:
>Hi!
>I've just joined ur mailing list!
>i've never used mysql!
>i'm wondering if there is only one way to insert data to a table?
>i use the command line, no interface!
Yes, you write SQL statements. But even if you write MySQL programs in
a programming
Hi,
I am, currently a student a final year student studying IT For Business
at Aston University In Birmingham.
As part of my final year project I need to produce an online
questionnaire with database functionailty.
I have produced an HTML form, but now I need to be able to write the
answers to t
One other thing.. As you said you're using php you could
be interested in phpMysqlAdmin which has a lot of functionality.
Date: (PHP Question?)
Yes, You have to convert it to '-MM-DD HH:MM:SS'. I miss oracles TO_DATE
function.
Look in the PHP manuals as I don't program in PHP right now.
I wou
mysql is easy if you're familiar with SQL92 standards,
if you are a Oracle-guru you will see that mysql doesn't
support half as many things... One things I really miss
is subqueries.
Most of the time I get all my answers from the DOC:
http://www.mysql.com/doc/
search for keywords and you'll prob
Hi
At 09:36 11/02/2001 -0600, Cal Evans wrote:
>Mark,
>
>I like CASE but I wish they would add MySQL Reverse Engineering capabilities
>to it. The interface is clean and similar to what one expects from it's more
>mature brothers. (ERWin, ER/Studio)
>
>A couple of people emailed me and told me to l
I agree that a time-limited, but otherwise fully functional demo is better, especially
in the case (pardon the pun) of database modelling. It would certainly be worth
sending them a message telling them so. You never know - they might agree with you.
Mark Chalkley
-
Here you go:
select DATE_FORMAT( DateTime, '%M %D %Y' ) as formatted_date,
Platform,
Public,
other_fields
from Features
where Platform='pc'
and Public='Y'
order by DateTime asc
limit0,3
;
Now, you should rename the DateTime field as Bob sudgested,
and y
Hi!
I've just joined ur mailing list!
i've never used mysql!
i'm wondering if there is only one way to insert data to a table?
i use the command line, no interface!
i have the mysql GUI but obviously it does not offer it it just offers
showing tables and their data !
i'm used to Asp with Oracle or
1: No.
2: It depends on a lot of things. If your site traffic is heavy and you can
split your data into discrete elements, you could possibly get better
performance by splitting your data into separate databases and running them
on different servers.
Cal
http://www.calevans.com
-Original M
hi,
i'm a stu so don't all the time in the world... who does!
last night i took a MySQL database (a folder i got out of the
MySQL/data folder) home and copied into the data folder on my
machine, is this ok?
unfortunately i cannot simply 'see if it runs' because i am having
those terrible soc
Hi!
Does MySQL open all tables in database when I select data from one table?
Will it be faster to split db to number of smaller db associated with concrete PHP
scripts?
Thanks for the input.
I like this tool better than the other 2. Other than the fact that it's
reverse engineering can be easily broken and cannot infer relationships in
the logical model it's a very nice tool.
Same rant on size limited demos. At least with this one I can build larger
models, I
For security reasons, I don't want to run mysql as root of the OS. However, the
only way I can run mysql is if I log into the server as root. So I guess I have
to create another superuser with:
GRANT ALL ON *.* TO lgaal@localhost IDENTIFIED BY 'whocares' WITH GRANT OPTIONS;
Is this correct? and
Erick:
Do not try to copy the database files themselves. Instead use mysqldump to
dump the structure and contents to text files, which you can easily copy
across the network from your Windoze to Linux.
My advice is to create an empty database on the Linux machine, and set your
permissions using
hello,
i ve been trying out a database in windows nt and it
works. but now i want to move the database to a linux
platform, is there some way i can just copy the data
files and they will work? with privileges and all?
what is the best and the fastest way to do this?
thanks/erick
_
Mark,
I like CASE but I wish they would add MySQL Reverse Engineering capabilities
to it. The interface is clean and similar to what one expects from it's more
mature brothers. (ERWin, ER/Studio)
A couple of people emailed me and told me to look at
http://www.heraut.demon.nl but I'm not thrilled
>Hi All,
>
>I have a JOIN statement:
>
>SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON
>d.domain_id=b.domain_id
>WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C'
>GROUP BY domain_name
>
>In addition to the fields this statement returns, I would also
>Hi,
>
>I`m selecting information from my MySQL as follows...
>
>Select * FROM Features WHERE Platform='pc' and Public='Y' Order by DateTime
>ASC LIMIT 0,3
>
>I am storing the field DateTime as a date when selected it looks like this
>2001-05-05 but I want to change it so it looks like May 5th 200
On Sat, 10 Feb 2001, Larry Marshall wrote:
> On issuing the command:
>
> rpm -i MySQL-32.23.32.-1.i386.rpm
>
> the following error listed:
I understand that mysql rpm that comes with RH7 is buggy.
I dowloaded the tarball and compiled it. Runs like a dream.
--
/"\
\ /ASCII RIBBON CAMP
On Sat, 10 Feb 2001, Mailing List Address wrote:
> Yes I tried that too... Same stupid stuff happening
Then have you tried creating the mysql db and
tables?
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
Hi All,
I have a JOIN statement:
SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON
d.domain_id=b.domain_id
WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C'
GROUP BY domain_name
In addition to the fields this statement returns, I would also like it
t
Good day,
I'm planning to configure LDAP server with MYSQL. I have downloaded both
applications. I went through their installations procedure and they are
simple. Anybody has tried configuring LDAP over MYSQL where the data will be
kept at the MYSQL database. If yes, can you please tell me what i
i installed MySQL from the Tenon site into OS X pb with the installer.app.
then i did the following:
[doria:~] root# cd /usr/local/mysql
[doria:/usr/local/mysql] root# scripts/mysql_install_db
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your s
Hi,
I am using the MySQL server and it's myodbc_mysql client programme.
When i connect to the local machine, it works perfectly. But i don't
know how do i connect to remote machine when using it in pure ODBC
fashion.
--
Available way is like follwi
No, you can scroll through your input lines using Up and Down Arrow, then
you can edit the particular line using Left and Right Arrow and Backspace.
At least this is a way things are supposed to work on a terminal.
Maciek
> -Original Message-
> From: RAJARSHI ADHIKARY [mailto:[EMAIL PROT
At 11:39 PM 2/10/2001 -0800, Stephen Waits wrote:
>Never mind on the "it doesn't work on my system" more like it didn't
>work on my brain :) Works fine.
Oh, phew.
>Theoretically it could be as fast as Carsten's method couldn't it? If
>it hit a record on the first shot? Otherwise it's pounding
56 matches
Mail list logo
