John Hunter wrote:
>
> I have set up the master and slave now and am getting a problem. When
> the slave tries to connect, it appears to be attempting to enter a
> value that is already in one of my database tables, and gives the
> error:
>
> [root@newman mysql]# tail /var/log/mysqld.log
> 0203
I am having trouble convincing my SQL admin at the hosting company that
something is wrong with the server / speed. It is really odd, but in
myPhpAdmin for example, on the left hand side the list of databases
comes
out properly for about 95% of the list, then it starts dumping HTML into
the
fram
hi,
When I am starting the mysqld-max daemon there appears two errors !!
I have intalled it on the another machine !! At this machine only, i am
facing this problem, previously it was running O.K.
anybody who can tell me how to resolve this problem...??
[root@dev1 sbin]# ./mysqld-max --user=root
hi,
When I am starting the mysqld-max daemon there appears two errors !!
I have intalled it on the another machine !! At this machine only, i am
facing this problem, previously it was running O.K.
anybody who can tell me how to resolve this problem...??
[root@dev1 sbin]# ./mysqld-max --user=root
Incident Information:-
Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject: mysql Digest 15 Mar 2002 05:26:01 - Issue 1797
Message from [EMAIL PROTECTED] was quarantined because it
contained banned content.
You usually use begin work before a bunch of inserts or deletes from a
database
i.e.
BEGIN WORK
INSERT
INSERT
DELETE
INSERT
. . .
COMMIT WORK OR ROLLBACK WORK
It is the start of a transaction and it allows you to guarantee some of the
ACID properties of your database..
"This statement signals the successful end-of-transaction. A transaction is
a group of SQL statements whose changes are logically connected and can be
made permanent or undone as a unit. All updates made during this
transaction are made permanent, all row locks are released, and active SQL
SELEC
Yes, it is connecting to the same server each time, it is very strange. I
have tried moving the entire database to a different server, and I seem to
encounter the same problem as well. It is almost as if the tables
themselves have an issue which is causing the problem.
-Original Message
Hi
Any body tells me what the use of "Begin work" in SQL .
Manish Mehta
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
At 01:30 15/03/2002 +0100, KJK::Hyperion wrote:
Hi!
Many thanks you for notice us about. We will care it.
Regards,
Miguel
>[NOTE: to make the spambot happy, here are "sql" and "query"]
>
>Hi
>
>This is an automated mail I'm sending to all vendors, developers,
>maintainers, etc. of software I us
Hi All,
I have good Sybase experience and I have installed
MySQL in a Linux box. Can u please answer my following
queries:
1. When I run safe_mysqld I get "Starting mysqld
daemon with database from /var/lib/mysql 020314
17:00:01 mysqld ended" do this mean a successfull
start or failure ?
2. Ho
At 23:05 -0500 3/14/02, Chris Stark wrote:
>Hi Everyone,
>
>I am in kind of a jam, and I could use some help. Hopefully someone out
>there has encountered something similar to this. I have a MySQL database,
>and I am using Java to make the connection to the database. At one point in
>the execut
At 20:27 -0700 3/14/02, Mike Hillyer wrote:
>I am trying to make a database system in MYSQL, but I need to restrict
>access to certain records in a table, is there any way to only allow access
>to records in a table that have a field matching a certain value?
MySQL's access system can restrict ac
Hi Everyone,
I am in kind of a jam, and I could use some help. Hopefully someone out
there has encountered something similar to this. I have a MySQL database,
and I am using Java to make the connection to the database. At one point in
the execution of my app, I need to issue an ALTER TABLE co
The REPLACE command may be what you're asking about.
SELECT REPLACE('This is a foo','foo','foobar');
will return "This is a foobar".
SELECT REPLACE(city,'Denver','Albuquerque') from foo;
In table "foo", every occurrence of "Denver" in column "city" is replaced by
"Albuquerque".
Regards,
Dou
I am trying to make a database system in MYSQL, but I need to restrict
access to certain records in a table, is there any way to only allow access
to records in a table that have a field matching a certain value?
Mike
-
Before
At 8:35 +0800 3/15/02, [EMAIL PROTECTED] wrote:
>Everyone,
>
>Have u tried automating SQL commands using MySQL client?...
>
>A batch commandmy problem is...how can I run the mysql client that loads
>the command from the file[command file]?
Go to the manual listed at the bottom of your message
At 1:25 + 3/15/02, GEORGE KONSTANTINOY LEKEAS wrote:
>Hi All,
>
>I would like to ask a simple question about the way
>MySQL handles string variabels. Say i have a variable
>whose value is foo and I want to change it to foobar.
>
>Instead of doing it the 'typical' way, I would like to
>ask whet
has anyone had trouble applying the patch to mysql++-1.7.9
tx,
paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thr
At 2:18 +0100 3/15/02, Laban wrote:
>Hi
>
>I need a query that counts the number of posts each user have made in my
>forum and then sort the userlist by that. How?
>
>table posts
>id, int (post id)
>thread, int (which forum the post belong to)
>poster, int (Who posted. ID from users table)
>string
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
select u.name, sum(p.id)
from usertable u, posts p
where u.userid = p.poster
group by u.name
order by 2 desc
//chris
www.mydba2000.com
>From: "Laban" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Query
>Date: Fri, 15 Mar 2002 02:18:27 +0100
>
>Hi
>
>I need a query that counts the numbe
> "Van" == Van <[EMAIL PROTECTED]> writes:
Van> No. Just have the slave connect to the master using the ip
Van> address.
I have set up the master and slave now and am getting a problem. When
the slave tries to connect, it appears to be attempting to enter a
value that is already i
That's probably your problem. You don't want to read "fucking the
manual", you want to read "the fucking manual"!
Sorry. I couldn't resist!
:)
Your best bet isn't gonna come from a mysql doc. But from a SQL design
theory book/resource.
-Original Message-
From: Matthew Walker [mailto:[
I want to find a good site that will help me set up foreign keys
/properly/ for InnoDB so that I can have it do referential integrity
checks, and all that jazz. Does anyone have any good references on how
foreign keys should be set up in general, and how they can be used with
InnoDB in particular?
Hi All,
I would like to ask a simple question about the way
MySQL handles string variabels. Say i have a variable
whose value is foo and I want to change it to foobar.
Instead of doing it the 'typical' way, I would like to
ask whether there is any mysql command that will allow
me to say read th
Hi
I need a query that counts the number of posts each user have made in my
forum and then sort the userlist by that. How?
table posts
id, int (post id)
thread, int (which forum the post belong to)
poster, int (Who posted. ID from users table)
string, text (post text)
category, int (forum catego
Try ...
CREATE DATABASE /*!32312 IF NOT EXISTS*/ databasename;
... then try reading the manual!
- Original Message -
From: "Radhakrishna Mohan Tadepalli" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 11:40 AM
Subject: Create database if does not exist.
I
To select the rows you are looking for, you can use:
select * from messages
left join topics on topics.topic_id=messages.topic_id
where topics.topic_id is null;
This works fine for selecting. But for some reason the corresponding SQL
for a delete fails:
mysql> delete from messages
-> left j
Everyone,
Have u tried automating SQL commands using MySQL client?...
A batch commandmy problem is...how can I run the mysql client that loads
the command from the file[command file]?
Anybody tried it,
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobi
[NOTE: to make the spambot happy, here are "sql" and "query"]
Hi
This is an automated mail I'm sending to all vendors, developers,
maintainers, etc. of software I use that, apparently, links statically to
the compression library "zlib", or to any library that depends from it
(f.e. libzip, lib
Greetings!
I've been using MySQL for years now and love it's flexibility,
scaleability, and general useability. However, I think I might be
beginning to bump into a wall in cleanly and efficiently representing some
data structures within merely a relational system. My hope is that
someone on t
>Description:
When I run a MATCH query against a full-text index using the "IN BOOLEAN MODE"
option, the mysqld server
crashes.
>How-To-Repeat:
see the information below
>Fix:
I haven't figured it out yet.
>Submitter-Id: none
>Originator:Owen Borseth
>Organization:
>Thanks for your advices.
>
>
>In the offical mysql webpage, there is a paragraph tell us how to usinng
>telnet test mysql server connectivity.
That test tells you only whether or not there's a MySQL server listening
on the port. It doesn't tell you that you should actually try to communicate
wi
Thanks for your advices.
In the offical mysql webpage, there is a paragraph tell us how to usinng
telnet test mysql server connectivity.
---
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
If you get the error message Can'
Hi,
We have Mysql standard distribution (ver 3.23.32) for
Solaris and we just realised that we needed InnoDB
support. What would be the easiest way to add InnoDB
table type? Is it possible to do it without affecting
the tables and databases that are already present.
thanks,
Sanjay Chigurupati
_
At 14:46 -0600 3/14/02, Todd Williamsen wrote:
>I didn't realize you were trying to telnet to a client. You cannot do
>that. You need to telnet to the SERVER. Whatever the server is
He *is* telnet-ing to the server (port 3306 is the server port).
But it doesn't make sense. A Web server might
I don't know if this will help you but try this:
# mysqld --help | grep "dir:"
basedir: /
datadir: /var/lib/mysql/
tmpdir: /tmp/
So, you'll find mysql log files in your datadir (is this case,
/var/lib/mysql/).
my.cnf is usually at /etc/my.cnf
If you don't have it, find a configura
On Thu, 2002-03-14 at 00:04, [EMAIL PROTECTED] wrote:
> Please, i'll need some help.
> I've installed mysql-3.22.32 in my machine, and when i run (from
> /usr/local/mysql)
> ./bin/safe_mysqld &
> this is the bug that present (from my *.err file)
> /*
lol list spam filter is quite severe
sql, query
- Original Message -
From: "Sylvain Hamel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 14, 2002 3:47 PM
Subject: character encoding problems with org.gjt.mm.mysql jdbc1.0
> environment : java jdbc, with MM driver, jd
Howdy -
You are trying to telnet to the MySQL server.
3306 is the MySQL Server default port, not the telnet port.
If you are trying to run the MySQL client, then:
1) telnet mysqlserverhostname
2) run the Mysql client within your telnet session (mysql -uroot -proot, for
example)
If you are tr
I didn't realize you were trying to telnet to a client. You cannot do
that. You need to telnet to the SERVER. Whatever the server is
You need to make sure the user you are trying to use has access rights
for the user for telnet
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTE
While doing "make" on a Dec 3000 OSF1 V4.0 I got the following error:
echo timestamp > linked_libmysql_r_sources
make all-recursive
No Suffix list
Making all in include
No suffix list.
Make: % rule can only use a single '"'/ Stop.
Exit 1
There currently isn't a y2k patch installed. I haven'
On Thu, 14 Mar 2002, Todd Williamsen wrote:
telbet to webserer is OK,
I use
telnet thesamename 80
get following messge"
>>Show me the output of the following:
>> SHOW GRANTS FOR 'username'@'hostname';
output:
mysql> show grants for 'root@localhost';
ERROR 1064: You have an error in your SQL syntax near 'grants for 'root@localhost'' at
line 1
I noticed that my user table doesn't seem to have all the fields it
At 14:58 -0500 3/14/02, Jianping Zhu wrote:
>I use:
>telnet mysqlserverhostname 3306
>
>and get following response:
>
> Host 'mylocalcomputer' is not allowed to connect to this MySQL server
>What does this mean? and how to fix the problem?
The MySQL client-server protocol is a binary protocol.
I
Can you telnet into anything else? How about a webserver? Try port 80
or 25 if you have a mail server. If you can't, you need to make sure
you have telnet rights
-Original Message-
From: Jianping Zhu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 1:58 PM
To: [EMAIL PROTECTE
At 11:17 AM 3/14/2002, you wrote:
>On Thursday 14 March 2002 9:32 am, BD wrote:
> >
> > Why or why couldn't MySQL have used case insensitive names in the first
> > place? Store everything in lower case internally, but allow the user to use
> > "Invoice_Number" or "invoice_number" or "INVOICE_NUMBE
From: "Al Johnson" <[EMAIL PROTECTED]>
> Nothing in the MySQL error logs. Don't know what you are refering to as
> the "replication log". There is no binlog for the slave and there are no
> other logs in the data directory or log directory. Is this something that
> has to be enabled?
I was refe
I use:
telnet mysqlserverhostname 3306
and get following response:
Host 'mylocalcomputer' is not allowed to connect to this MySQL server
What does this mean? and how to fix the problem?
Thanks
-
Before posting, please chec
Treat the master and slave as if the firewall wasn't there.
It shouldn't be any different than a router. The outside computer shouldn't
care what it is called on the internal network.
If that's not fact, then its my strong opinion :)
-Original Message-
From: John Hunter [mailto:[EMAIL PR
I have tried the last 10 releases of webmin and cannot get it to work with
MySQL. I have a standard install of Mysql 3.23 into /usr/local/mysql. Webmin
keeps complaining that it cannot find the libraries.
The MySQL libraries are here: /usr/local/mysql/lib/mysql
I have set that path both in the c
John Hunter wrote:
>
> I have a mysql server behind a firewall. The firewall forwards port
> 3306 requests to the server, so the outside world can use it. I want
> to replicate this database with a slave outside the firewall. So the
> slave would request port 3306 on the firewall, but get the
Hi:
I work with Linux Cobalt (identic to RedHAT), gcc-2.7.2 and MySQL-3.22.32-1.
I need install DBD-mysql-2.1011, but I received the next error in the
instalation:
(I execute make):
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/usr/lib" /sbin/perl myld
cc -shared -L/us
I have a mysql server behind a firewall. The firewall forwards port
3306 requests to the server, so the outside world can use it. I want
to replicate this database with a slave outside the firewall. So the
slave would request port 3306 on the firewall, but get the internal
server instead.
My
Hi Joe,
On Thu, 14 Mar 2002 11:00:33 -0800
Joe Krusick <[EMAIL PROTECTED]> wrote:
> Hi: Installed the following packages (with no errors) from the Red Hat
> Linux V7.1 RPM files. It installed MySQL3 3.23.36-1,
> MySQL-devel3.23.36-1, MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4.
>
> Howe
>> We are having a serious problem with a simple replication setup using
>> MySQL. One small database with 12 tables is being replicated one way
-
>> one master, one slave. Write transaction load is small, about 1
record
>> per second, usually on only one of the tables. Read load is also
light.
>
ok, more specific:
here is a table:
CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1)
If I do an insert into the FOO table with the following:
INSERT INTO FOO (foo1,foo2) VALUES (1,1)
Everything works as planned.
If I do an insert into the FOO table with the following:
INSER
Hi: Installed the following packages (with no errors) from the Red Hat Linux
V7.1 RPM files. It installed MySQL3 3.23.36-1, MySQL-devel3.23.36-1,
MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4.
However, following instructions, I typed in, at the command line, "mysql" and
received the followi
Product : MySql
Version : 3.23.45
Error : Invalid duplicate key error for large
numeric primary key's
Description
---
When a large numeric primary key is created
ID NUMERIC(38)
PRIMARY KEY (ID)
And you insert two records with different I
What is the default table engine used in the "binary" version of mysql-max -- innodb
or Berkeley? If not innodb, how do I get the innodb to be the default? Can someone
point me to the manual section?
-
Before posting, please
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi:
I'm using MySQL 3.2.3.39 for Win98.
Has anybody been able to develop applications using Mingw32 compiler?
If so, where can I get a version of the libmysqlclient library that
will work with this compiler?
Thank you.
- --
Alfredo J. Cole
http
Rob,
Thursday, March 14, 2002, 7:01:02 PM, you wrote:
RQ> I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I
am getting an error message that says my host is not allowed to connect. I then tried
to run a GRANT query
RQ> under the mysql on the Linux machine to cr
I installed following two files
MySQL-VERSION.i386.rpm
MySQL-client-VERSION.i386.rpm
but I can not fild my.cnf and mysql log files.
Why?
Thanks
Jianping Zhu
Department of Computer Science
Univerity of Georgia
Athens, GA 30602
Tel 706 5423900
--
At 10:41 +0100 3/14/02, Rune Steinseth wrote:
>Hi all,
>I have changed database for my Java app to MySQL. The
>app was developed with SQL Server. Some of the logic
>is dependent on getting the no. of rows updated
>returned after an UPDATE query. MySQL does only
>return the rows that are really
IMHO - I would use ADO over the MyODBC layer to retrieve disconnected
recordsets representing your report data from MySQL, then pass said adors to
Crystal Report's viewer.
To learn more about this approach, search seagate.com for ado disconn. rs,
which utilizes "ttx" files (tab delimited text
is anyone getting errors when trying to install mysql++, after
installing the patch for gcc3?
i've gotten a flood of errors which i've fixed, step by step, by adding
"std::" to various
variables. manip.cc is spitting out error messages like this one:
manip.cc:141:choosing
'std::basic_ostream&std:
Hi All;
I have just recieved a request to build a database using mySQL and I have a
bit of a dilemma.
The database is to be used for relations between politicians and their constituents,
and I have to have tables for constituents and their information. I would like
to have one main database a
On Thursday 14 March 2002 9:32 am, BD wrote:
>
> Why or why couldn't MySQL have used case insensitive names in the first
> place? Store everything in lower case internally, but allow the user to use
> "Invoice_Number" or "invoice_number" or "INVOICE_NUMBER" in the SQL
> statement and it should ref
I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am
getting an error message that says my host is not allowed to connect. I then tried to
run a GRANT query under the mysql on the Linux machine to create a valid user in the
hosts table.
I am using version 3.22
Has anyone used MySQL as the datasource for AutoCAD? Specifically AUTODESK MAP?
Autodesk lists as a capability:
"# Link to ODBC-compliant databases including Microsoft Access, Excel, Oracle, dBase,
FoxPro, Paradox, and SQL Server."
Sounds like MAP _should_ work with MyODBC.
Has anyone tried thi
as you said, the table is empty. mysql_fetch_object should return NULL.
that's why the block in the while statement doesn't got executed.
while (($row = mysql_fetch_object($result))){
if($row->team_id == "$team_id"){
echo "It is in there";
}else{
echo "We will need to add it to the tab
At 02:05 AM 3/14/2002, you wrote:
>Hi,
>I run mysql on windows as well as linux.
>table creation and access right are given by java program.
>
>Problem im facing is.,
>i create a table with name TEMP
>in windows in creates table with name "temp" and linux "TEMP"
>while giving rights thru GRANTst
OK. So I just read in CHANGES FOR 3.23.37 (patch by Ralph Mason) that
there is now support for UDFs in Windows . So anyone know where I might
find some Windows specific examples (or info) on them?
Thanks,
Craig
At 09:47 AM 3/14/2002 -0600, you wrote:
>Perhaps this is common knowledge, but is
Thank You. This did the trick. I knew that it had to be something
simple. I wasn't even thinking of a "if(!$row)" statement.
Steve
At 10:05 AM 3/14/2002, you wrote:
>- Original Message -
>From: "Steve Buehler" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, 14 March, 2
Yana,
Thursday, March 14, 2002, 5:00:40 PM, you wrote:
Y> Helo!
Y> Is there any other way to set permissions to the list of
Y> tables in mysql db (big list!) with similar names (f.e. c%),
Y> then running a script on it?
No, it's impossible. You should use database name, table name etc or
'*' to
Danny,
Wednesday, March 13, 2002, 2:30:10 PM, you wrote:
DK> I'd like to know how I can do the following:
DK> I want to query a single table like this:
DK> select field1, field2, field3 from table1 where field1='something' and
DK> field2=0;
DK> This query will result in more then one match. I
At 08:14 2002-03-14, Konstantin Tsolov wrote:
>right, of course ;-) (i neglected the join part)
>
>so, now i know exactly whom to ask ;-)
>
>i have the following bother (it's in the planning state):
>
>i have the idea of setting up a two-way replication system with 2 mysql
>servers for my radius d
Tomasz,
I tested also with mysql-4.0.1 and it worked.
But are you using a non-latin1 character set?
If yes, the bug which was fixed in 3.23.49 might cause the problem.
Did you compile MySQL yourself? If yes, what compiler?
Please download the official MySQL-Max-3.23.49a binary from www.mysql.
Hi Andrew,
Let me first say that I am used to using mysql through PHP rather than
command line . . .
And, as I understand it mysql does not support any sort of timers.
I need to use a Unix command like cron to automate either a mysql
command or php script to output a selection from a few mysq
Dear folks,
Now i try to migrate my Visual Basic Application from
MS SQL Server to My SQL, I met problem when my crystal
report connect ot My SQL, Below is my code:
CrystalReport1.connect = "DSN=testDB;uid=amy;pwd=test"
CrystalReport1.Destination = 0
CrystalReport1.ReportFileName =
"c:\localfo
At 07:22 2002-03-14, Heikki Tuuri wrote:
>Tomasz,
>
>are you using a non-latin1 character set?
No, didn't change the charset. As You can see from my reply to Victoria
yesterday, will need to, eventually (for different reasons, though, not
books), but right now I am in a proof-of-concept stag
I have totally different task.
I don't want to give users any other privileges but SELECT.
But because I use MERGE tables for showing reports to users
I must give for these tables UPDATE and DELETE privileges.
And here I am talking about several hundreds tables for each user.
MySQL doesn't have wi
* Richard
[...]
> When the same code is run but without the line:
>
> AND individual_id ='AB00090004' AND Category = 'DXS1047'
>
> a fragment of the results is:
>
> +--+---++---+-+-+
> | category | Individual_ID | Inactivate | count | minkey | m
At 01:57 2002-03-14, Heikki Tuuri wrote:
>Tomasz,
>
>are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no
>foreign keys.
>
>I tested this on mysql-max-4.0.1, and it worked.
Well...
[root@flow11 httpd]# mysqladmin -p version
Enter password:
mysqladmin Ver 8.23 Distrib 4.0.1-alpha
Hi.
For what are files with extension .TMM and .TMD?
Are residual files of mysqldump?
I killed a mysqldump, and I see these files on the directory of the database
but I don't know if they were before the mysqldump.
Iago.
-
B
After I went through the following steps successfully,
(The previous problem I had regarding inability to untar files was solved by
downloading stuff on that computer where it was untarred. Before that I was
trying to untar stuff downloaded on to a samba share !!!)
shell> groupadd mysql
shell> u
Perhaps this is common knowledge, but is there still no support for UDFs in
Windows. If not, are there any work arounds for trying to perform
complicated calculations on the server?]
Thanks,
Craig
mysql, query
-
Before post
I have a strange, but probably easy to fix problem. I need to check to see
if something is in a table...that part is easy, but if the table is empty,
it doesn't go through my "while" statement so that I can create something
in it. I am sure that if there was something in the table, that I wou
Thanks for your help Victoria.
Iago.
-Mensaje original-
De: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Enviado el: jueves 14 de marzo de 2002 11:48
Para: [EMAIL PROTECTED]
Asunto: Convert ISAM table to MyISAM
Iago,
Thursday, March 14, 2002, 10:17:10 AM, you wrote:
IS> I'm going t
The record you want to update is locked by another client.
Check return value of your update()
What you have to do is approx. the following:
while( record_locked)
{
sleep(...)
if( update(...) == OK )
break;
}
Roberto Freitas Alexandre wrote:
> MySQL
>
> Hi all,
>
> I am rece
This might not be the best way, but for the people here at my office who
aren't familiar with command line interfaces, I've setup MyODBC and MS
Access. This let's them add/edit user's account info directly. The only
thing you can't do (afaik), is change a user's password.
-- Mike Miller
-- [EMAIL
This has nothing to do with this list...
It's just that i'm sorry for the message i sent today, i agree with ppl
who answered me and realised i was being..well...you know what.
Once again, sorry, i won't do it again and thank you for the answers.
--
dsoares
(sql)
--
MySQL
Hi all,
I am receving this error message sometimes when I tried to update a record.
I am using Delphi 3, ODBC connection and TTable object.
What I have to do ?
Somebody can help me ?
Tks,
Roberto Alexandre
-
Be
>
>Hi I have 2 mySQL fragments that pull up 2 differing results and I have no
>idea why. The two pieces of code are identical bar one line which is :
>
>AND individual_id ='AB00090004' AND Category = 'DXS1047'
>
>The code that produces the correct code is:
>
>select Raw3_2.category,
> Ra
Hi I have 2 SQL fragments that pull up 2 differing results and I have no
idea why. The two pieces of code are identical bar one line which is :
AND individual_id ='AB00090004' AND Category = 'DXS1047'
The code that produces the correct code is:
select Raw3_2.category,
Raw3_2.Individua
Helo!
Is there any other way to set permissions to the list of
tables in mysql db (big list!) with similar names (f.e. c%),
then running a script on it?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php
You sure can do it..
Just put your sql commands into a .sql file and use mysql < file.sql syntax
to to have them executed by mysql. And you can always use cron in Unix to do
it periodically.In your Unix box do:
man crontab
man cron
to learn more about cron jobs. You can also consult to
http://www.
and yet there is another novel option to this particular problem. you can
pay someone to teach you how to do it. in just about any case where money
is in fact exchanging hands, results are expected. then you'd have an actual
reason to bitch.
jay downs
- Original Message -
From: <[EMAI
From: "schwingenschloegl jan" <[EMAIL PROTECTED]>
> >i wonder if its possible to perform multiple WHERE statements in one
> >mysql SELECT statement like:
> >
> >SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR
> >field3=3D'three';
> >
> >it works with as many AND and
> >it works wit
1 - 100 of 138 matches
Mail list logo
