I'm new to MySQL, and only have limited experience in modifying some legacy
dBase IV code.
One of the minor aggravations I occasionally encounter when using management
systems is how best to handle names, particularly the many individual name
segments of names. Typically the name field is of
please clarify use of set autocommit
SET AUTOCOMMIT = 0 == mean start transaction
... - some actions
COMMIT == transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
COMMIT
Hi!
Sorry if I ask this on the wrong list but it seemed like the best choice
:)
I'm trying to install a MySQL binary downloaded from MySQl
(mysql-standard-4.0.13-ibm-aix4.3.3.0-powerpc) on a AIX 4.3 (oslevel
4.3.3.0)
I have IBM's C for AIX ver 4.4.0 and gcc version 3.2.3 installed on the
I have just installed 'MySQL-server' and
'MySQL-client' onto a Mandrake 9.1 system.
The two RPMs installed without error and running mysql
from the shell was fine and did what was expected of
it.
I have now rebooted the system and when I go to the
shell to issue the 'mysql' command I get the
Hi Artem,
I understood the AUTOCOMMIT command different.
SET AUTOCOMMIT = 0 == deactivate AUTOCOMMIT
SET AUTOCOMMIT = 1 == activate AUTOCOMMIT
The commands
BEGIN
. some instructions
COMMIT
are used to start or finish a transaction.
Anybody, please correct me if I talk rubbish ;-)
Hi i have a challenge for you. I'm struggling with this self join query. I have a
table which among several contains theese fields: id, strname, iparentid
id is primary key and iparentid show who the child of id. There are 4 level deepth in
this table, i.e. like this
sorry, should have said - I get the record created, but with a null
value in the blob - as you would for a file larger than the
max_allowed. but I've checked numerous times (and have gone up to
longblob) and still can't load above around 1mb.
I should also mention that it's running on the same
sorry insane is ozzy slang for awesome, the best whatever u want to call it
.
well , ok from what i know and have asked about , they are precompiled
functions , actually embedded into the server which do routines , so
therefore all u have to do is call the procedure from the API, therefore ok
now
I'm using under WINDOWS NT4 sp6 the 4.0.13 version as a slave from a 3.52
master. During the night to I use a bacth file (starting on 22.30 )to stop
the mysql and copy all then file of mysql. But till the 3.52 version (on my
slave) using
the same scripts no problem. Now when the computer execute
I am trying to install MySQL-server onto my Mandrake
9.1.
When I first install 'mysql' using the latest RPMs all
goes well and it places the mysql.sock into
'/var/lib/mysql'
But when I reboot and then come back to run mysql I
get an error indicating that it can't connect though
mysql.sock.
When
Hello,
Sone or later your get tired with this table construct. I recommande you
to split this table into 4 tables:
Tables:
- country
ex.: id_country country_name
- company
ex.: id_company company_name
- activity
ex.: id_activity activity_name
-
Agree with you Armand, but i'm not in charge of the database so i can't do anything
about it. I've just been asked to create a query which shall be used in a report.
Regards
Paal
Armand Turpel [EMAIL PROTECTED] wrote: Hello,
Sone or later your get tired with this table construct. I recommande
Hi.
Please help.
During long delete operation from one InnoDB table there was PC shutdown due to power
supply failure. After that I was unable to start database server so I have started it
with set-variable = innodb_force_recovery=4 option and I have dropped all databases
with InnoDB tables.
Hello, mysql,
p_asset CREATE TABLE `p_asset` (\
`ano` int(11) NOT NULL auto_increment,\
`asset_name` varchar(50) NOT NULL default '',\
`asset_type` int(11) default NULL,\
`asset_format` varchar(50) default NULL,\
`asset_keywords` varchar(200) default NULL,\
`asset_duration` bigint(20)
I am mildly surprised that nobody has answered this yet - bit you did post
on the weekend - so I will put in my $0.02.
On http://www.mysql.com/doc/en/Multiple_servers.html your NFS idea is
described as a bad idea. I concur. I believe that MySQL makes a lot of
use of cacheing - locking updates
MaFai wrote:
Hello, mysql,
p_asset CREATE TABLE `p_asset` (\
`ano` int(11) NOT NULL auto_increment,\
`asset_name` varchar(50) NOT NULL default '',\
`asset_type` int(11) default NULL,\
`asset_format` varchar(50) default NULL,\
`asset_keywords` varchar(200) default NULL,\
Armand-
Why is it not recommended to store images in a database? I've not heard this...
bob.
At 09:51 PM 6/29/03 +0200, you wrote:
Hi,
You have to insert a new blob field where you can store binary data. But
it is not recommanded to store images in a database. I recommande you to
store
Nevermind. I installed Postgresql. It compiles perfectly on NetBSD.
Thanks for the pointers though and sorry for sending my emails to the
wrong mailing list. I don't like to use pkgsrc because it usually
installs all of these other packages; I only have 3 GB on my harddrive, so I
have to worry
Bob:
This question comes up over and over on the list ... do a search for
'images' of the list archive and you can read the accumulated pros and cons.
Gerald Jensen
- Original Message -
From: Bob Ostermann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 30, 2003 7:35 AM
At 9:21 +0300 6/30/03, artem wrote:
please clarify use of set autocommit
SET AUTOCOMMIT = 0 == mean start transaction
... - some actions
COMMIT == transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
COMMIT
Hi Gerald-
I understand the pros and cons of db vs filesystem, and for images (static,
rarely changing) it makes sense. I was pursuing any info about large chunk
transfers or fragmented storage issues for large field tables.
I'm working with a table containing historical information for 67,000
Ivan,
if you have already dumped all InnoDB tables, then there is no need to keep
ibdata files and ib_logfiles. You can delete them and recreate them from
scratch and reimport the tables.
But in the printout which you pasted below you do not have
innodb_force_recovery set to 4?
When I test
Hello,
i build one query in my mysql:
mysql select timestamp from lastauth where month(from_unixtime(timestamp) = 6);
Empty set (0.00 sec)
Query is empty, but:
my timestamp table:
++
| timestamp |
++
| 1056981323 |
++
1 row in set (0.00 sec)
mysql select
[EMAIL PROTECTED] wrote:
Hello,
i build one query in my mysql:
mysql select timestamp from lastauth where month(from_unixtime(timestamp) = 6);
Empty set (0.00 sec)
Query is empty, but:
my timestamp table:
++
| timestamp |
++
| 1056981323 |
++
1 row in set
Joseph Bueno [EMAIL PROTECTED] :
[EMAIL PROTECTED]
wrote:
Hello,
i build one query in my mysql:
mysql select timestamp from lastauth where month(from_unixtime(timestamp) =
6);
Empty set (0.00 sec)
Query is empty, but:
my timestamp table:
++
| timestamp |
artem wrote:
please clarify use of set autocommit
Here's an unsolicited opinion: AVOID using autocommit within
applications. Based on my experiences with other DBMSs, it's a very
likely source of hard-to-find program bugs. The problem occurs when
it's turned on and off in a program --
Hi,
I'm building a planning system for a newspaper. Article ideas are defined
as articles with no deadline, no publication date or no reporter assigned.
I wan't to show all entries from table un_article that matches those three
criterias.
I have three tables:
CREATE TABLE un_article
(
a_id
[snip]
That will only result in deletion,I want it to be displayed
and simultaneously deleted.more precisely the effect of following
two commands in one
SELECT from data where name='harsh';
DELETE from data where name='harsh';
[/snip]
Write a .sql script with both queries and call it from the
I'm running into a problem updating a blob column. The table is:
CREATE TABLE product(
product_id int(11) NOT NULL auto_increment,
name varchar(60) NOT NULL,
cat_id int(11) DEFAULT 0 NOT NULL,
releasedate date,
price decimal(10,2),
description text,
imagedata blob,
PRIMARY KEY
On 28 Jun 2003 at 10:12, Nils Valentin wrote:
I understood that the backup done by f.e mysqldump would dump the
create statement only for the index - not the actually data fo the
index. That would make the backup option create smaller files than
lets say if you copy it 1x1 on the OS command
I would like to be able to set a user variable on startup of MySQL. I
have review the documentation and searched the archives and I haven't
seen anything about being able to do, or not do this.
Can this be done? Since I'm unable to find reference to it, my guess is
no, but I thought I'd give
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Dual Xeon
1.8 GHz CPU
1024 MB Ram
3x 18 GB SCSI
HDD RAID 5
In other words will mysql benefit from the dual
Todd Burke wrote:
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Dual Xeon
1.8 GHz CPU
1024 MB Ram
3x 18 GB SCSI
HDD RAID 5
I would recommend using RAID
I have tried installing MySql on Apache 2.0.46 and PHP latest version. I actually
thought that my installation was okay, I was even able to use PHPMYADMIN to create
another user. I basically created a user with my name and gave it all the same rights
as the root user.
Somehow, each time I
Greetings!!
I'm trying this insert and it will not run in batch mode. I think the '' syntax is
right but what else am I missing??
insert into registry set registry_program=EA, registry_key=BASE_PATH,
registry_value=f:auction;
Robin E. Kopetzky
Black Mesa Computers/Internet
I have to take a text input from users and store
it in table,to avoid ' error i can replace ' with \',
is there any other solution as that might slow down the process ?
harsh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
It's true that mysqldump doesn't put the data for the index itself
into the dump file. That does not automatically mean that the dump
files will be smaller than the .MYD, .MYI, and .frm files combined.
The dump
Greetings,
Lenz Grimmer [EMAIL PROTECTED] writes:
On Tue, 24 Jun 2003, David Griffiths wrote:
A 64-bit CPU won't have the 4-gig memory limit that a 32-bit processor
will; even worse, Linux is apparently limited to about a 2-gig process.
It depends - there is a BIGMEM patch from Andrea
i don't believe there is another solution,
but anyway, how many characters per second can your users type that this string
replacement could be a measurable slowdown of the process?
-yves
-Ursprüngliche Nachricht-
Von: harsh [EMAIL PROTECTED]
An: My Sql List [EMAIL PROTECTED]
Hi, I'd like to know if there's a way to change where the datadir is
located.
I've installed mysql in a Sun Solaris, in the /usr/local/mysql
directory, but I want the databases to be located in another filesystem.
Is there a way to relocate them?
Thanks in advance,
--Claudio
I'm having a lot of trouble with a simple query. Does anyone have any idea
why this might not be working?
The query:
SELECT * FROM `asio_linkpop_queries` WHERE `domain` =
'www.legendsandlore.com' AND `date` 1056957929
The row in the database:
domain | date
www.legendsandlore.com | 1057000554
Just shutdown mysql, move the data and create a symlink.. or start
safe_mysqld with --datadir= option
On Mon, 30 Jun 2003, Claudio Alonso wrote:
Hi, I'd like to know if there's a way to change where the datadir is
located.
I've installed mysql in a Sun Solaris, in the /usr/local/mysql
Hi,
I did post a request for help earlier today, on how to select rows from
two tables based on missing information in a third. I have now come some
way on my own. I have two different queries that together does what I want.
But I don't know how to combine them to one. Would appreciate any
The standard solution is to use binding.
JDBC and Perl DBI both support it, and I imagine most other environments
do as well.
In such case, your query will turn from:
INSERT INTO someTable values ('foo\'')
Into:
INSERT INTO someTable values (?)
You're use a prepared statement, and before
oops, i forgot this one...
isn't that parameter binding only available from mysql 4.1 on?
at least, when i browse through the php doc, it's part of the improved mysql
extension (mysqli), available for mysql 4.1.
does anyone know about version 4.0?
-yves
-Ursprüngliche Nachricht-
Von:
anders thoresson schrieb:
I'm building a planning system for a newspaper. Article ideas are
defined as articles with no deadline, no publication date or no reporter
assigned. I wan't to show all entries from table un_article that matches
those three criterias.
I have three tables:
CREATE
On 30 Jun 2003 at 22:43, [EMAIL PROTECTED] wrote:
oops, i forgot this one...
isn't that parameter binding only available from mysql 4.1 on?
at least, when i browse through the php doc, it's part of the
improved mysql extension (mysqli), available for mysql 4.1. does
anyone know about version
All,
I have the user table which contains user record
| Host | User| Pass | Select...|
---
|% || | N... |
The db record is
| Host | Db| User | Select...|
--
| %| Test1 ||
- Original Message -
From: Kevin Stone [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 30, 2003 1:34 PM
Subject: Comparison Operators?
I'm having a lot of trouble with a simple query. Does anyone have any
idea
why this might not be working?
The query:
SELECT * FROM
Well, you do not show what UPDATE privileges your user possesses, so I
am not sure where your problem lies. However, 2.23.57 has a fix that may
be relevant to your situation:
Fixed security problem where mysqld didn't allow one to UPDATE rows in
a table even if one had a global UPDATE privilege
so mysql can take full advantage of the dual cpu w/out a recompile?
Thanks
--Todd
On Mon, 30 Jun 2003, Mike Wexler wrote:
Todd Burke wrote:
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Todd Burke wrote:
so mysql can take full advantage of the dual cpu w/out a recompile?
Mysql create a separate thread for each connection. So a single
connection won't use more than one CPU. If you have lots of active
connections, then yes, it will take advantage of the dual cpu without a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 30 Jun 2003, Peter Moscatt wrote:
I am trying to install MySQL-server onto my Mandrake 9.1.
When I first install 'mysql' using the latest RPMs all goes well and it
places the mysql.sock into '/var/lib/mysql'
But when I reboot and then
Well, with that in mind, does the user have the appropriate INSERT
privileges?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 3:49 PM
To: Mike Hillyer; Twibell, Cory L; [EMAIL PROTECTED]
Subject:
Ok, the user has the appropriate privileges in the db table.
The user can select, insert, update, deletewhatever.
What he CAN'T do is a MULTI-TABLE UPDATE using just the db
privileges table.
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003
Hmm, if you have UPDATE privilege on A and SELECT on A and B then it
should work. Do you have UPDATE granted on B (though I know you should
not need it)?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30,
Yes, I have the UPDATE for table B. I belive this is a bug.
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 4:47 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with privilege tables - IMPORTANT
Hmm, if you have UPDATE privilege on
That is my conclusion as well. I think you should post it as such
barring any comments otherwise.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 4:51 PM
To: Mike Hillyer; [EMAIL PROTECTED]
check out http://www.phpbuilder.com
thay have a lot of things and that is one off them.
--
eschew obfuscation.
-Original Message-
From: Digital Directory USA [mailto:[EMAIL PROTECTED]
Sent: 29 June 2003 19:28
To: [EMAIL PROTECTED]
Subject: inserting images to mysql - is it possible?
I
Please somebody help me.
I have installed MySql 4.0.13 and it works up until I try to apply security settings
to the root user at localhost.
I see the mysql database and I check the privileges and there is no password for the
roo user. But when I assign a password to make it secure, I can run
Did you flush the privileges after you gave root a password?
The error you get is a result of not using a password to login.
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:05 PM
To: [EMAIL PROTECTED]
Subject: Access Denied for User: [EMAIL
2003 7 1 04:11David Brodbeck :
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
It's true that mysqldump doesn't put the data for the index itself
into the dump file. That does not automatically mean that the dump
files will be smaller than the .MYD, .MYI,
You can try one or the other
mysql -h localhost -u root -ppasswd db
or
mysql -h `uname -n` -u root -ppasswd db
in solaris
On Mon, 30 Jun 2003, Twibell, Cory L wrote:
Did you flush the privileges after you gave root a password?
The error you get is a result of not using a password to login.
Thought I might share this with others.
I recently upgraded MyODBC from 2.50-39 to 3.51.06
When I ran simple select statements from an ASP page in which the fields
were empty, I would get the following errors:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation
64 matches
Mail list logo
