Hi,
I want to store a .txt file in a table in a MySQL database, typically what
is the best type of data type/ column to use for this. The .txt will not
exceed 100K.
Thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Kevin Cowley wrote:
OK
I've just been completing some benchmarking comparing compiled queries (new
in 4.1.1 and above) with standard parsed queries.
For both INSERT queries "insert into table( col1, col2,col3) values(?,?,?)"
and SELECT queries "select col1, col2,col3 where col1 between ? and ?" t
erri wrote:
I'm trying to compile 4.0.18 version on Aix 5.2 ML2 (IBM 7044-270 with Two
cpu Power3-II), with gcc-2.95 with this parameters(note in mysql.com):
CC="gcc -pipe -mcpu=powerpc -Wa,-many" \
CXX="gcc -pipe -mcpu=powerpc -Wa,-many" \
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti"
Joshua J. Kugler wrote:
I have a program that is using (via a front end library) libmysql. If I set
up a signal handler before I initialize libmysql, my signal handler is not
called when that signal is sent to the process. If I move the line of code
that sets the signal handler to *after* the
A HUGE thank you to everyone who helped me with this. Everything is working
as expected now. That connection stuff (along with the blank user entry)
got me!!!
> Finally, are you really sure you want someone to be able to connect as
> (effective) root from *anywhere* on the net? Personally, I res
Dan Nelson wrote:
In the last episode (Apr 29), Lou Olsten said:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access
to everything. Here's what happens:
- Sign in
Lou Olsten wrote:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything. Here's what happens:
- Sign in as root on the local host.
- GRANT ALL PRIVILE
At 16:21 -0500 4/29/04, Dan Nelson wrote:
In the last episode (Apr 29), Lou Olsten said:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with
access to everything. Her
...blind as a bat, it was right in front of me in basic SQL .
Thank you kindly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, 29 Apr 2004 23:59:05 +0200
"Bjoern Wuest" <[EMAIL PROTECTED]> wrote:
> Dear All
>
>
> I work on a small application with database support. For development I use
> the MySQL database which is just doing fine. During testing I experienced a,
> in my opinion, strange bug.
>
>
> I have the
I have a program that is using (via a front end library) libmysql. If I set
up a signal handler before I initialize libmysql, my signal handler is not
called when that signal is sent to the process. If I move the line of code
that sets the signal handler to *after* the line that initializes li
Kevin,
I've been using 4.1.1 since it was released and I've never heard of compiled
queries. Are you talking about prepared statements?
Donny
> -Original Message-
> From: Kevin Cowley [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 29, 2004 1:35 PM
> To: [EMAIL PROTECTED] Mysql. Com
>
Dear All
I work on a small application with database support. For development I use
the MySQL database which is just doing fine. During testing I experienced a,
in my opinion, strange bug.
I have the following source code:
>>
Connection conn = p_GetConnectionFromPool();
try {
just drop the 'distinct' - should give you what you want
mysql> select count(last_name) as "LnameCnt", last_name from table_ABC group by last_name;
hth
steve
[EMAIL PROTECTED] wrote:
I am using MySQL 4.0.18 and trying to generate a list of the number of row in a table with the same last name, b
hmmmif you are on the same machine, does it work if you do not specify the '-h
localhost'?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the version of your mysql client? If it is pre 4.1 then it is likely being
bitten by the password length change from 4.0.xx to 4.1 from 16bytes to 41bytes.
You'll need to read the note on passwords in the 4.1 docs.
Hope this helps.
--
MySQL General Mailing List
For list archives: ht
I am using MySQL 4.0.18 and trying to generate a list of the number of row in a table
with the same last name, by last name.
Is there any way to do this without creating another table?
Here is what I am trying:
mysql> select count(distinct last_name) as "LnameCnt", last_name from table_ABC gro
Thanks. Tried it with no luck. Moreover, I get the same results as below
when I try to connect with the mysql client from a different machine.
Really bizarre behavior. I have a 4.1 alpha running at home on my XP box.
I will do some testing there tonight to see if it's something I'm doing
unique
In the last episode (Apr 29), Lou Olsten said:
> I thought I had a handle on this, but now I'm all screwed up.
>
> MySQL 4.1.1a-alpha-max-debug-log
> Windows 2000 Server
>
> I'm trying to create a user roby with a password of 'foo' with access to everything.
> Here's what happens:
>
> - Sign i
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything.
Here's what happens:
- Sign in as root on the local host.
- GRANT ALL PRIVILEGES ON *.* TO rob
Paul, please see below...
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 1:00 PM
Subject: Re: [client] var not working
> At 12:22 -0400 4/29/04, Lou Olsten wrote:
> >Thanks, Paul. You
On Thu, 29 Apr 2004 16:05:56 -0400 (EDT)
[EMAIL PROTECTED] wrote:
> hi,
> i have a huge database and i want to transfer the data to a
> file. can i
> tranfer the result of a query to a file for eg.
>
> if i say select * from tablename;
>
> it selects all the tables. but the mys
hi,
i have a huge database and i want to transfer the data to a file. can i
tranfer the result of a query to a file for eg.
if i say select * from tablename;
it selects all the tables. but the mysql window is small to see all the
records when the database has many records.can i send
The connection I am trying to make is from a website where the hosting
machine will not have Myodbc installed and the database I am trying to
connect to is on another Internet visible server where MySQL is installed
and myodbc is installed.
-Original Message-
From: Victor Pendleton [mailto
I want to count the passing and failing scores of a group of tests
so I have a table with a row that describes each test
Each test has a minimum passing score. Each test can be run an
arbitrary number of times so I have a table of scores, which uses
test id as a "foreign key".
what I would like
You will need to have MyODBC installed. You do not need to create a DSN.
-Original Message-
From: Joy Johnson
To: 'Victor Pendleton'; 'michael johnson '; '[EMAIL PROTECTED] mysql. com '
Sent: 4/29/04 1:50 PM
Subject: RE: Connect string for ASP
I presume I do not need myodbc installed anyw
ConnectStr = "Driver={MySQL ODBC 3.51 Driver};server=;DB=;UID=;PWD="
-Original Message-
From: michael johnson
To: [EMAIL PROTECTED] mysql. com
Cc: Joy Johnson
Sent: 4/29/04 1:33 PM
Subject: Connect string for ASP
Dear All
I am using ASP. Can anyone give me the connection code to connect
OK
I've just been completing some benchmarking comparing compiled queries (new
in 4.1.1 and above) with standard parsed queries.
For both INSERT queries "insert into table( col1, col2,col3) values(?,?,?)"
and SELECT queries "select col1, col2,col3 where col1 between ? and ?" the
compile query is
Dear All
I am using ASP. Can anyone give me the connection code to connect to a MySQL
database without using ODBC DSN?
Thanks
Michael Johnson
Director
BPEnet EMEA
Sun iForce Premier Solution, Sales, Change Management & Development Partner
Part of the BPEnet Group Limited
13 Austin Friars
London
In the last episode (Apr 29), Sam Peterson said:
> We are designing a new solution and I have not been able to find
> functionality anywhere in the MySQL documentation or literature.
>
> With an Oracle database you can bring up the database, recover what
> is needed, all while leaving the listene
Paul,
I tried doing that in one trial run, and I wasn't getting the $200 figure so
I gave up on that.
It seems like doing an order by that statement wouldn't have given me the
sort I wanted.
Don't know why that is though - in theory you should be right, I can try it
a bit more if your curious.
Be
Paul DuBois wrote:
*snip*
Sounds like you want:
ORDER BY ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2)
Perfect. (I'm saying, "duh" over here to myself!)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
If it`s a InnoDB table :-? my case
--- Paul DuBois <[EMAIL PROTECTED]> escreveu: > At 12:27
-0300 4/29/04, Leandro Melo wrote:
> >Hi,
> >i got a table wich its pk is an auto_increment
> field.
> >I have 10 elements in this table, wich makes the
> pk_id
> >field = 10.
> >I inserted incorrectly an
Both of you are right Daniel, and Robert.
I've written a PHP class that "tabelizes" the query directly and I haven't
built in formatting options. Doing so would make the object more complicated
then I would like it to be, so I wanted to see if there is a mysql solution
to this.
I think I'll end u
At 12:14 -0500 4/29/04, Yoed Anis wrote:
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
A note first. The column "establishments" is an int(10), as you see I am
taking this number through a f
Yoed Anis wrote:
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
Hint: you've made this a "string" comparison using CONCAT, i.e.,
alphabetical, not numerical, sorting rules apply.
How a
I think when adding the $ the number gets convert to a string. And then
the query orders it by alpha numberic.
> I'm having trouble with this query:
> SELECT
> CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
> as price FROM table ORDER BY price
>
> A note first. The c
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
A note first. The column "establishments" is an int(10), as you see I am
taking this number through a formula, and I want the result of this fo
At 12:22 -0400 4/29/04, Lou Olsten wrote:
Thanks, Paul. You appear frustrated that I didn't look in the docs first.
Um, no.
I gave instructions for finding the answer to a question that you were
asking. I don't think that translates into any frustration about your
use of the manual. I didn't kn
If you are getting table full error,may be your table
size is exceeding the maximum default size allowed.
check the table size and default size.
You can change the maximum size of the table using
Alter table command.
Somthing like following,but it is better so back up
the database before doing thi
Will Richardson wrote:
Hello,
I have a table with 3 columns:
mysql> desc srv_ref_cities;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| state_id | char(2)
We are designing a new solution and I have not been able to find
functionality anywhere in the MySQL documentation or literature.
With an Oracle database you can bring up the database, recover what is
needed, all while leaving the listener down. The listener in Oracle
just allows clients to conn
Thanks, Paul. You appear frustrated that I didn't look in the docs first.
I had been to that page (and thoroughly read it) after Victoria's reply.
Prior to the reply, I tried searching but wasn't sure what to search for, so
didn't find what I was looking for. The real gist of my question was:
<>
Hello,
I have a table with 3 columns:
mysql> desc srv_ref_cities;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| state_id | char(2) | YES | | NULL|
On Thu, 29 Apr 2004 12:27:46 -0300 (ART)
Leandro Melo <[EMAIL PROTECTED]> wrote:
> Hi,
> i got a table wich its pk is an auto_increment field.
> I have 10 elements in this table, wich makes the pk_id
> field = 10.
> I inserted incorrectly anoter row in this table (the
> 11th) and imediately dele
At 12:27 -0300 4/29/04, Leandro Melo wrote:
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it. Although, i'd like
that the next time i inse
Hi,
Unless he is having some weird nightmare that doesn't involve reality, then I am
pretty sure he is talking about this in the my.cnf:
innodb_data_file_path = ibdata1:400M:autoextend
A while back I remember that the autoextend was not in the sample my.cnf files. I
think this was around 4.0.1
At 23:32 +0530 4/28/04, [EMAIL PROTECTED] wrote:
Hi,
I am trying to insert the records in the database. After the insertion of
3millions records, it fails to insert the records further. Can someone help
me in this problem. How do I go and increase the capacity of the database.
Moreover if someone
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it. Although, i'd like
that the next time i insert a row in this table, it's
index be stil
At 23:28 +0200 4/28/04, Jochem van Dieten wrote:
Ricardo wrote:
Which collation are you using in MS SQL Server? And
in MySQL?
MS SQL Server 8
Collation = Latin1_General_CI_AS
MySQL 4.0.16
character_set = latin1
The charset determines which characters can occur. The collation
determines the sort
Is there a simple way to determine how fragmented a Innodb table is ?
Thanks,
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:38 -0400 4/29/04, Lou Olsten wrote:
Per a response from Victoria (thanks, BTW!) I see that I can reload
my InnoDB RI's data by turning off SET FOREIGN_KEY_CHECKS = 0 during
the restore. I then tried to go to the machine where the dumps were
going to be restored and set this variable in th
"Lou Olsten" <[EMAIL PROTECTED]> wrote:
> Per a response from Victoria (thanks, BTW!) I see that I can reload my InnoDB RI's
> data by
> turning off SET FOREIGN_KEY_CHECKS = 0 during the restore. I then tried to go to the
> machine where the dumps were going to be restored and set this variable i
Place the SET FOREIGN_KEY_CHECKS=0 in the beginning of the file that
contains the backup or run this command from the command line before you
import the file.
-Original Message-
From: Lou Olsten
To: [EMAIL PROTECTED]
Sent: 4/29/04 9:38 AM
Subject: [client] var not working
Per a response
hi Lou,
I believe this is a recent feature so make sure you on on 4.0.18 if
possible, I know is was added before 4.0.14. I am not sure this
works on 3.23.
Ken
- Original Message -
From: "Lou Olsten" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 10:38 AM
Sub
I've solved the problem starting the server using the
option --character-set=dos.
The side effect is that searches become
accent-sensitive.
Best wishes.
--- Ricardo <[EMAIL PROTECTED]> escreveu: > I have a
problem with SELECT DISTINCT if the target
> field contains special characters.
>
> Exa
Per a response from Victoria (thanks, BTW!) I see that I can reload my InnoDB RI's
data by turning off SET FOREIGN_KEY_CHECKS = 0 during the restore. I then tried to go
to the machine where the dumps were going to be restored and set this variable in the
[client] section of my.cnf. But when I
The oracle and MySQL create syntax is not completely compabitable. You will
have to identify and correct the errors.
For example text data type in MySQL may need to be either VARCHAR(N) or
CLOB.
...
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 4/28/04 11:37 PM
Su
No you don't. Mysql will run perfectly happily as a standard user.
If you're installing from an rpm you will however need root privilege unless
the rpm is configured as relocatable - and the standard mysql ones aren't.
What you need to do is get yourself the source tarball (.gz) and not the
rpm.
You will need root privilege in order to install and start MySQL. After
the installation, you may have to edit some confs to get MySQL to start
automatically at every boot. Thereafter, you can access the database
server be creating a user account for Mysql admin (root), plus unlimited
number of
Hi,
I have found this too. I think it is as a result of a change introduced in
4.0.18. From http://www.innodb.com/ibman.php#InnoDB.history :
MySQL/InnoDB-4.0.18, February 13, 2004
- Do not allow dropping a table referenced by a FOREIGN KEY constraint,
unless the user does SET FOREIGN_KEY_CHECKS
Hi,
Thanx the answer! I have tried it, but didn't work correctly.
The result was 1,2,3 :((
"Nitin" <[EMAIL PROTECTED]>
2004-04-29 09:54 AM
To: Zoltan Gyurasits/GYO/COMP/[EMAIL PROTECTED]
"Michael Stassen" <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
I hope it should work:
Select table1.ID from table1 left join table2 on table1.value=table2.value
where table2.value is null
OR if you want distinct IDs
Select distinct table1.ID from table1 left join table2 on
table1.value=table2.value where table2.value is null
though I didn't test it, if it
Victor Pendleton wrote:
> If you are going to do this, may I suggest starting MySQL with a non
> standard port number?
Yeah, right. And a hacker will not perform a portscan? And he will not
recognize a response from that port (e.g. "Host '' is not allowed
to connect to this MySQL server")???
Rega
Hi,
Sorry. My english is not so good. :(
I try to explain.
I have table1 :
ID value
--
1 100
1 101
1 102
1 200
2 100
2 300---
2 310 |
3 100 |
|
and table2:
"Lou Olsten" <[EMAIL PROTECTED]> wrote:
> If I'm using mysqldump to dump a database with referential integrity in place, does
> MySQL
> build the information in such a way that the referenced tables are loaded first to
> avoid
> invalid inserts into a table with a foreign key in place? I'm tryin
66 matches
Mail list logo
