I have set up mysql under redhat 7.3 and imported the database from mysql
running on windows.
I have the root user running using passwords, but i cannot get the other
users to log on even thogh the passwords shoudl have been carrid across with
the import.
I have tried to reset the user
hi,hope anybody can help :
since a few days I have more and more trouble with sending and receiving
mails from and to this list.
sending to results very often in such a message :
Von:Mailer-Daemon [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Betreff:NDN: ERROR 1146
Datum: 23
hi list,
trying to do my first steps with mysql, i have done the following :
mysql USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql INSERT INTO mysql VALUES(localhost, sample_db,
Hi,
Is there a defined behaviour for handling the case-sensitivety for user- and hostnames?
I did not find any information on this at the docs for the 4.0.3 MAX version which I'm
using.
For example, the following database connections are valid:
root@localhost
Root@localhost
However, the
Hi,
If you have a host having the minus character '-' in the name the mysql command SHOW
GRANTS FOR fails.
Example:
SHOW GRANTS FOR root@MY-COMUPTER results in the error message
You have an error in your SQL syntax near '-COMPUTER' at line 1.
It looks like the command processor stops the
How do you select from two tables, without joining those tables?
I just want the results of one table slapped on the end of the results from
another table because I don't want the overheard of running two seperate
queries. For instance:
Lets say that I have these two tables (and thur values):
hans schneidhofer wrote:
hi list,
trying to do my first steps with mysql, i have done the following :
mysql USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql INSERT INTO mysql
On Mon, 23 Sep 2002 08:40:59 +0300 (EEST) Iikka Meriläinen
[EMAIL PROTECTED] wrote:
On Mon, 23 Sep 2002, Daniel Kiss wrote:
Hi!
At 00:56 2002.09.23._ -0300, you wrote:
Do I loose
too much performance using InnoDB tables in autocommit mode instead of
using MyISAM tables?
The
Oh man!
Yeah, you're right. That's exactly what I want but apparently it wasn't
implemented until v4??!?!?!
What did people do prior to version 4 when needing to query multiple tables?
Just endure the overhead of multiple connections to the database?
Thanks.
Neal
-Original Message-
I have installed MySQL on a PC with Windows NT. As the
MySQL dir is not on c:, I have copied the 'my.cnf'
file to c:, and I have edited it to MySQL work with
InnoDB tables. All has been working fine, but
suddendly, without change any, when I have tried to
start up MySQL with the command
Hi list,
I still have performance problem with my big MyISAM table.
In fact, mysql keep locking my table, even for doing select :(
I don't know why but it's very very annoying.
1% of my query are search ones.
Theses queries are slow, too slow.
So i'm thinking about splitting my table to lot of
Description:
Hello,
I wrote the following text in my last message (It was an answer to Monty):
Hello,
Monty
I have already sent to pub/mysql/secret the table definition and data
(clientes.txt)
and my.ini file in a compressed file named clientes.zip.
You can
--
Your message cannot be posted because it appears to be either spam or
Command 'your' not recognized.
simply off topic to our filter. To bypass the filter you must include
Command 'simply' not recognized.
one of the following words in your message:
Command 'one' not
Chris Stoughton wrote:
I have a table with a few million rows, wth 633 columns. I want to
create 10 inidices on this table, six single-column and four two-column
inidices. The database will be loaded once and remain static, and
queried many times. Please note that this is a small
Hello gurus,
Please help. Where is my mistake?
I get the following error...
MYSQL: query failed: You have an error in your SQL syntax near ') rei_ts' at line 1
When I run the query below
SELECT rei_ip \
FROM relay_ip \
WHERE rei_ip=${sender_host_address} AND
Odhiambo Washington wrote:
Hello gurus,
Please help. Where is my mistake?
I get the following error...
MYSQL: query failed: You have an error in your SQL syntax near ') rei_ts' at line 1
When I run the query below
SELECT rei_ip \
FROM relay_ip \
WHERE
Hello
I'm Gunter and I tried to compile the mysql Database on Solaris 9 for
Ultra Sparc arcitecture.
I use the precompiled gcc 3.2 compiler form www.sunfreeware.com.
This Compiler is linked to use the as and ld fom the Solaris operating
system.
Also I use the autoconf and the other gnu tools
And where would one obtain MySQL Navigator?
JMichael
Matt Hargraves [EMAIL PROTECTED]
09/22/2002 09:14 PM
To: Arthur Fuller [EMAIL PROTECTED], David Kramer
[EMAIL PROTECTED]
cc: mysql mailing list [EMAIL PROTECTED]
Subject:Re: MySQL Gui Install and
Description:
When I issue a SHOW VARIABLES request using the standard command
line client, I get a ERROR 2013: Lost connection to MySQL server
during query. The server error log reports:
mysqld got signal 10;
This could be because you hit a bug. It is also possible that
http://sql.kldp.org/mysql/
One good thing about this one though, they seem to be able to update theirs,
the most recent update (1.4) was on September 13th, the previous version
(1.3.12) was on June 4th. Hopefully the new version (which I haven't tried
out yet) will support some of the 4.x.x
Hello,
I m using WinXP / Office XP and need odbc support to create a circular
letter.
I have installed mysql, etc. all works fine.
But I cant get Word to work with odbc drivers. They seem to work, they
get connection
To my database but word says something like this :
couldn't obtain table lists
Owain,
Sunday, September 22, 2002, 8:37:55 PM, you wrote:
OM Is there an easy way to turn logging or SQL statement executions on or off without
having to restart with a changed my.cnf file? Just want to log queries to try and
sort out some performance
OM problems.
Nope.
--
For technical
Moestl,
Monday, September 23, 2002, 9:49:14 AM, you wrote:
MW Is there a defined behaviour for handling the case-sensitivety for user- and
hostnames?
MW I did not find any information on this at the docs for the 4.0.3 MAX version which
I'm using.
MW For example, the following database
Marvin,
Monday, September 23, 2002, 6:52:23 AM, you wrote:
MC MySQL newbie seeking help and/or advice on storing data into a database.
MC I have a poetry section I'm trying to add to my site that will allow users to
submit some of their work for public viewing. An example is located here:
Moestl,
Monday, September 23, 2002, 9:54:33 AM, you wrote:
MW If you have a host having the minus character '-' in the name the mysql command
SHOW GRANTS FOR fails.
MW Example:
MW SHOW GRANTS FOR root@MY-COMUPTER results in the error message
MW You have an error in your SQL syntax near
vinita,
Monday, September 23, 2002, 9:12:24 AM, you wrote:
vvM I can create a database called test,
vvM mysql create database test;
vvM Query OK, 1 row affected (0.03 sec)
vvM BUT I can't create any other databases???
vvM mysql create database tem;
vvM ERROR 1044: Access denied for user:
Joseph,
Thanks for the quick answer.
Very nice to know that adding an index forces a rebuild of all indices!
(Side note -- I was going to configure the database with a minimal set
of indices, and then watch to see how people use the database, and then
add indices on popular columns.)
I did
hans,
Sunday, September 22, 2002, 3:48:33 PM, you wrote:
hs trying to do my first steps with mysql, i have done the following :
hs mysql USE mysql;
hs Reading table information for completion of table and column names
hs You can turn off this feature to get a quicker startup with -A
hs Database
Davis, Tim wrote:
select count(*) from table1
go
select count (*) from table2
go
This will return 2 results, with count of each table. How would I do the
same thing in MySQL?
I'm not sure if you can; I tried:
select count(table1.id) as table1_count, count(table2.id) as
table2_count from
MySQL wrote:
You might also consider using two integer type fields - one for the
numerator and another for the denominator. This way storage and recovery are
easy and the mathematics are wide open.
_M
I suspect that a float add is faster than 3 integer multiplies and
sum.
It
Hi All,
I am new to mySQL.
I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm
While installation it asked me to change DB root password using mysqladmin
I looked for mysqladmin and didn't find it !! not all the files were
installed.
I looked into the documentation and it
FYI - this query seemed to work.
select * from nodes
left join nodes as n2 on n2.parent_id = nodes.node_id
left join jobs on jobs.parent_id = nodes.node_id
left join colors on colors.parent_id = nodes.node_id
where nodes.node_id = ?
and ((n2.parent_id is not NULL) or (jobs.parent_id is not
Hello,
I'm just starting out with MySQL. How do you set permission to allow for
access from a domain or IP. I found this in the docs. I this all I need?
GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH
GRANT OPTION;
DBA / Unix Administrator
Patrick Fowler
Wynit,
First off i am a newbie, so forgive any repatition and ideocy.
Ok i am trying to evaluate MySQL, i have a Mssql database which has been
specifically generated by my company. Therefore i have a ddl file which
will generate the tables, database name and relationships. I have poked
around mysql
mysql does not own its files.
toby - wrote:
ok guyz
im lost
im creating my tables and after i ve created em i tried to change two
of the fields to FULLTEXT and this is what i get :
Database zabanDb running on localhost
Error
SQL-query :
ALTER TABLE `ctnt_inf` ADD
It seems like MyODBC (or ODBC in general ?) cannot accept user variables.
The following query works OK when quering directly through the API but doesnt work via
MyODBC
Any suggestions to some workaround allowing the use of user variables???
SELECT id,
@s:=lang lang=da,
ORDER BY SentDate DESC
Ben Holness wrote:
Hi all,
I have a table with three columns:
Destinationvarchar(254)
SentDate timestamp(14)
UserID varchar(32)
I want to be able to get a list of the 100 most recently used numbers, based
on the timestamp (SentDate)
andykychan,
Monday, September 23, 2002, 11:16:09 AM, you wrote:
a I would like to know when the MySQL 4.1 will be released.
a We are looking forwards to hearing from you.
It will come in alpha before this year ends.
--
For technical support contracts, goto
Sherif,
Tuesday, September 24, 2002, 2:16:13 AM, you wrote:
SDM I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm
SDM While installation it asked me to change DB root password using mysqladmin
SDM I looked for mysqladmin and didn't find it !! not all the files were
SDM
Graham,
Sunday, September 22, 2002, 3:15:23 PM, you wrote:
GH I am aware that this is an error of my own making, however . . .
GH I am unable to install my sql because the scipt fails with
GH a duplicate key error
GH Preparing db table
GH Preparing host table
GH Preparing user table
GH
Patrick,
Monday, September 23, 2002, 4:24:13 PM, you wrote:
PF I'm just starting out with MySQL. How do you set permission to allow for
PF access from a domain or IP. I found this in the docs. I this all I need?
PF GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH
PF
Hello,
Recently I have installed MySQL-Max 4.0.3 in my production server, and
in the error log I found the following message (or very similar) several
times:
InnoDB: Assertion failure in thread xxx in file btr0pcur.c line
203
Why takes place this crash?
NOTE: Querys associated to
thnx gerald
but i still dont know what to do to fix this thing up
will someone pleez enlighten me on how to
thnx a million ...
toby .
From: gerald_clark [EMAIL PROTECTED]
To: toby - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: access denied
Date: Mon, 23 Sep
Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from
MyISAM to Innodb, because we have database tables that have many updates,
inserts, deletes and selects going on at the same time. My belief is that
InnoDB's better locking semantics (as compared to MyISAM) will give me
great! hope it works !
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:17 AM
To: MySQL Mailing List (E-mail)
Cc: Edward Peloke
Subject: RE: Complex SQL query problem...
FYI - this query seemed to work.
select * from nodes
left join
We are having a problem which seems to have appeared recently with
replication on our mysql servers.
- We have 3 servers set up with mysql 3.23.52 (they were running .49 but
we upgraded in an attempt to fix this problem, which did not work), set
up as a master and 2 slaves to the master.
-
I don't know how you have your system configured, but mine has the root only
functional on the localhost.
Bruce
- Original Message -
From: toby - [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 9:22 AM
Subject: Re: access denied
hi people,
just a quick question.
is there a way i can use the lock tables statement to lock all the tables
in a database which out having to specify all tables individually?
i dont really want to use a statement like:
lock tables table1 read, table2 read table3 read, table4 read, table5 read,
Hello,
If you're on *NIX platform, use this:
chown mysql *
in your data directory. To make things sure, chown every data file to
mysql user (I assume you've created it during install).
On Windows, check the permissions. I apologize for being inaccurate, but
you didn't specify what operating
At 9:40 -0500 9/23/02, Dana Diederich wrote:
Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from
MyISAM to Innodb, because we have database tables that have many updates,
inserts, deletes and selects going on at the same time. My belief is that
InnoDB's better locking
We're probably 98 percent selects. But that's part of the problem: the
selects build up at a fantastic rate when there are a flury of updates.
Hopefully, once we get to InnoDB, this won't be as likely to happen.
Cheers.
-Dana
-Original Message-
From: Paul DuBois [SMTP:[EMAIL
At 1:13 +1000 9/24/02, Chris Barnes wrote:
hi people,
just a quick question.
is there a way i can use the lock tables statement to lock all the tables
in a database which out having to specify all tables individually?
i dont really want to use a statement like:
lock tables table1 read, table2
Follow up question,
Well what if you have a user that you want to give permission to from any
computer in the domain.
Such as user: mysqluser with READ|SELECT|UPDATE from anywhere
in: mydomain.com
But not from any other domain.
Thanks,
Eric Lamendola
Slingo Inc.
And if not, Hey what
At 0:23 -0700 9/23/02, neal wrote:
Oh man!
Yeah, you're right. That's exactly what I want but apparently it wasn't
implemented until v4??!?!?!
Right.
What did people do prior to version 4 when needing to query multiple tables?
Just endure the overhead of multiple connections to the database?
At 9:35 +0200 9/23/02, David Bordas wrote:
Hi list,
I still have performance problem with my big MyISAM table.
In fact, mysql keep locking my table, even for doing select :(
That's how MyISAM works -- it uses table locks for everything.
Given that fact, if it didn't lock the table for reading,
Thanks for the suggestion but this would actually create a new table,
correct (the first statement that is)? I just want a resultset with these
values, without writing to disk.
On another note, yeah youre right not a different connection object, but I
presume I would need to run two seperate
At 9:55 -0700 9/23/02, neal wrote:
Thanks for the suggestion but this would actually create a new table,
correct (the first statement that is)? I just want a resultset with these
values, without writing to disk.
Then you must upgrade to 4.x so that you have UNION support.
Either that, or write
I just presume that this will add alot of overhead to the query. The reason
I wanted to be able to do something like a union rather than seperate
queries is because of overhead. I dunno ... am I wrong? Is it not that
bad?
Also, I tried the query you suggested ... can you really do this(?):
On Mon, Sep 23, 2002 at 11:20:49AM -0500, Paul DuBois wrote:
I had a question about the use of the UNION command in this
context.
The original poster asked about getting the name of the
_table_ as well as some other data, which would seem to be
relatively necessary for doing many types of
At 10:12 -0700 9/23/02, neal wrote:
I just presume that this will add alot of overhead to the query. The reason
I wanted to be able to do something like a union rather than seperate
queries is because of overhead. I dunno ... am I wrong? Is it not that
bad?
The way to find out is to try it.
For those of you looking for a Web browser based GUI for MySQL and/or
who might be considering going with a commercial Web application
server for connectivity to MySQL, you're cordially invited to check
out Blue World Lasso Professional 6 (LP6) which was just released
last week.
Lasso
At 13:16 -0400 9/23/02, Jesse Sheidlower wrote:
On Mon, Sep 23, 2002 at 11:20:49AM -0500, Paul DuBois wrote:
I had a question about the use of the UNION command in this
context.
The original poster asked about getting the name of the
_table_ as well as some other data, which would seem to be
for some reason when things get busy, we get a whole ton of locked threads
(see processlist below...), and at some point when there are enough threads,
the whole thing bogs down to a crawl. EVEN after i kill the process that's
holding it all up, it still stays all stuck up. I've seen people
I have a table that is populated with raw data on a pass by an
extraction program. Its other fields are left NULL and a secondary
program parses through this data to fill in the other fields. I would
like to move some of this logic out of the second program and into SQL
statements, but it
At 12:08 -0500 9/23/02, Paul DuBois wrote:
At 9:55 -0700 9/23/02, neal wrote:
Thanks for the suggestion but this would actually create a new table,
correct (the first statement that is)? I just want a resultset with these
values, without writing to disk.
Then you must upgrade to 4.x so that you
Jesse Sheidlower wrote:
How do you get the table name returned as part of the query
results? Or am I misunderstanding how one would work with the
results?
Try:
SELECT *,'TABLEA' FROM TABLEA
UNION
SELECT *,'OTHERTABLE' FROM OTHERTABLE
Herman
Oh yes, I almost forgot... The supported type aliases aren't mentioned in
the pseudo-BNF, and they probably should be for the sake of people who are
trying to learn MySQL after having used another DB product...
or BIT
or BOOLEAN
or DOUBLE PRECISION[(length,decimals)] [UNSIGNED]
Hi,
I try to store japanese into mysql :
PHP seems to works great with japanese strings.
$jap=,g,rfR[fhõ^øiZQlj,SO. ;
And then it displays kanjies.
But I didnt manage to store char into the database ?
How can I do ?
Thanks.
___
Jose,
if this occurs in an SQL query of type
... ORDER BY primarykey DESC
then this is probably the bug which is fixed in upcoming 4.0.4.
I hope 4.0.4 will be released in a few days.
Best regards,
Heikki
Innobase Oy
- Original Message -
From: jesus [EMAIL PROTECTED]
Newsgroups:
Hello,
We have 4000 db and 4000 user (more or less) in MySQL, each db has one
user assigned.
Some times, this is happened more often, show the next error:
ERROR: 1045 'Access denied for user: username@host (using password:
YES).
So we kill/restart the mysqld process
after
Rafa,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 23, 2002 10:54 AM
Subject: optimizer bug in selecting fields that don´t belong to the index
used by mysql/innodb
Description:
Hello,
I wrote the following text in my
Hi all:
I'm seeing a strange problem updating a field if
that field is referenced as a FK in another table.
Consider:
CREATE TABLE A (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(20),
PRIMARY KEY (id)
);
CREATE TABLE B (
id INTEGER
I downloaded MySQL 4.0.3beta on my XP system. I didn't find
mysql_fix_privilege_tables after installing. Am I suppose to pull it
from the unix download and do by hand?
Thanks,
Daniel
-
Before posting, please check:
Description:
While trying to run this query:
SELECT users_1.* FROM users AS users_1, users AS users_2
WHERE users_1.email_address = users_2.email_address AND users_1.id users_2.id
ORDER BY users_1.email_address
I got this error:
Can't create/write to file '/root/tmp/#sql107d_bdf_2.MYI'
clarify exactly what you mean. show an example.. you
question is confusing.
cw
--- shahana qureshi [EMAIL PROTECTED] wrote:
Please tell me how can I get the date and time
values
diffently in a single query from 'DateTime' field
and the difference of two DateTime fields in
HH:MM:SS
filter fodder: sql, query
Hi,
Hope someone can help with this.
I have a table subjects:
qsid smallint ...
name varchar(60)
The table contains eg.
Mathematics
English
Biology
... ...
I also have a table vx_students:
vxid smallint ...
pri_qskey smallint not null default 0
sec_subj
Hi
I'm experiencing very strange innodb behavior. I'm testing the following DB
structure: stn|dt|par1|par2|par3 , where stn is 1 to N, dt 1 to M, par1,
par2, par3, par4, par5, par6 are any values and stn+dt is a primary key.
So create statement looks like
CREATE TABLE t3 (stn SMALLINT UNSIGNED
Hi,
I have a column that can have 850 chars at max.
I think that I can only put this in a tinytext col type.
How can I hav an index to this col mysql refuse me to add one ?
Thanks.
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
Where might I find information about optimizing inserts to MySQL tables.
I've purchased 2 books, and so far, the only optimizations I see concern
reads, not writes.
The only advice I've received so far on optimizing writes is to have my
application dump the records to a text file first, and do
At 12:10 -0700 9/23/02, j.random.programmer wrote:
Hi all:
I'm seeing a strange problem updating a field if
that field is referenced as a FK in another table.
Consider:
CREATE TABLE A (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(20),
PRIMARY KEY
At 22:47 +0200 9/23/02, David yahoo wrote:
Hi,
I have a column that can have 850 chars at max.
I think that I can only put this in a tinytext col type.
Probably not. The maximum size of TINYTEXT is 255 bytes. You need
at least a TEXT type. (MEDIUMTEXT and LONGTEXT will also work, but
are
Hi,
I have a question. I have two tables that I want to post data too. Is there
a way to do a sql statement that lets me post data two tables at the same
time?
Thanks,
Chuck Payne
-
Before posting, please check:
Appears to be a database memory corruption problem. The binlog filename
had been trashed. Eventually,
mysql/innodb blew up trying to do a malloc.
We were accidentally running two copies of ibbackup at the same time at
around 6pm on 9/21 and 9/22.
We were accidentally running a third copy at
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
What should go into #, is it a *? but I should NOT given permission
to access other databases.
Thanks
Egor Egorov wrote:
vinita,
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
What should go into #, is it a *? but I should NOT given
permission to access
Autodia is a tool for automatically generating Dia diagrams from source
code files. For example, it helps in building inheritance diagrams. It
handles perl, java, C++, C, and Php.
This patch adds to it a (crude) handler for SQL. It generates the UML
boxes to describe the tables. It also
Where might I find information about optimizing inserts to MySQL tables.
In Paul DuBois's excellent MySQL from New Riders, there is a section about
loading data efficiently in which he talks a little about inserts. In a
nutshell, LOAD DATA is faster than INSERT, the fewer the indexes the
At 17:25 -0600 9/23/02, Derek Scruggs wrote:
Where might I find information about optimizing inserts to MySQL tables.
In Paul DuBois's excellent MySQL from New Riders, there is a section about
loading data efficiently in which he talks a little about inserts. In a
nutshell, LOAD DATA is
From: Moestl, Wolfgang [EMAIL PROTECTED]
Is there a defined behaviour for handling the case-sensitivety for user- and
hostnames?
According to the specification for the Domain Name System (DNS), Internet hostnames
are always supposed to be case-insensitive.
Since other entities in MySQL are
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
What should go into #, is it a *? but I
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
At 16:43 -0700 9/23/02, Jan Steinman wrote:
From: Moestl, Wolfgang [EMAIL PROTECTED]
Is there a defined behaviour for handling the case-sensitivety for
user- and hostnames?
According to the specification for the Domain Name System (DNS),
Internet hostnames are always supposed to be
Hi
I am a mysql user. I use a long blob field to store image data.
But whenever I make a deletion with my image data I find that the
hard disk availability is still intact. There is no change. What
could be the problem with my delete statement.
Please Help
Regards
Roslee AJ
Ok, Let's try this again, for some reason this didn't post from early today.
I have db that has two tables that I am needing to post the same information
into both tables, I can't use ID. So I am want to see if there is a sql
statement that will let me or how I can do with a php page.
I am
Paul DuBois wrote:
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to
I wanted to test the mysql++ example Loading binary file in a BLOB ...
because I'm looking for for a solution to load several MB up to a remote DB,
without FTP or things like that. Just 1 thread in DB, so performance should
be no problem.
Therefor I try to execute and benchmark this quite famous
I have db that has two tables that I am needing to post the same
information
into both tables, I can't use ID. So I am want to see if there is a sql
statement that will let me or how I can do with a php page.
I'm not a SQL guru, but I'm pretty sure SQL doesn't allow this. (Objects in
I know that the what kind of server should I buy? question
comes up regularly here, but the various discussions in the
archives don't seem to address my issue.
My current server is an old PII desktop with 64M memory and a
6GB hard drive, running FreeBSD. Thanks to the glories of
FreeBSD and the
This is the mysqlbug report:
##
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL
sql,query
At 11:49 +1000 9/24/02, vinita vigine Murugiah wrote:
Paul DuBois wrote:
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
Hi paul
Paul DuBois wrote:
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
HI Egor
OK, I want to create new databases, to do that I need
1 - 100 of 110 matches
Mail list logo