I know this is an old query, but still, problems . . .
I've tried these both, but something is amiss - probably my interpretation.
Every time I try to use LAST_INSERT_ID() I get a complaint that the
query has a problem.
E.G., $qry=$qry.;select LAST_INSERT_ID(); will blow up on me every
time
Ben,
I have added the following item to the TODO list of September 2002. I guess
it will appear only in the MySQL-4.0 branch, as 4.0 will be the new stable
branch within a few months.
...
September, 2002:
Add a global MySQL my.cnf option autocommit_default=0.
...
Best regards,
Heikki Tuuri
On Monday, 29. July 2002 06:33, databarn wrote:
Hi,
E.G., $qry=$qry.;select LAST_INSERT_ID(); will blow up on me every time
I've evaluated $qry, and it works just fine until I append the piece that
should let me recover the auto increment value that was created during the
insert process.
Glory!
I'm looking for a Provider for the myODBC Driver to
connect my Visual Basic code with my mySQL database.
I have in kknowledge one such provider known as
MSADSQL..but niether do i know where to find it nor do
i know whether it's the right thing or not.
T. Edison Jr.
Hi,
When I try to start MySQL, I get alerts from my personal firewall that MySQL
is trying to access the internet...why would this happen?
I'm currently using (or trying to use) Abriasoft's Merlin desktop, which
includes apache. I would have thought that if I'm running a apache on my
own
Hi,
I have a question regard the table locking.
Let say there is a table ,mytablename type=MyISAM in my database.
And lets say there are 2 users who are currently log in.
First user locks a table write:
mysql lock tables mytablename write;
Query OK, 0 rows affected (0.00 sec)
Then,second user
if you need table or datarow locking , why don't you use innodb table type
with transactions ?
bye, thomas
First user locks a table write:
mysql lock tables mytablename write;
Query OK, 0 rows affected (0.00 sec)
Then,second user wishes to query something from mytablename.
mysqlselect *
Hi,
I have a problem. I tried finding a proper solution, but could not.
1) The query create table if not exists temp2.t1 select * from temp1.t1; does not
copy the primary key details etc. It copies everything else. Any work around for this
?
2) What is the best way to check if a table
MySQL question:
If I use UPDATE LOW_PRIORITY will the client then have to wait for the
update to finish or is UPDATE LOW_PRIORITY the same as INSERT DELAYED ?
-
Before posting, please check:
http://www.mysql.com/manual.php
How can I grant a privilege to a specified user to a specific DB?
If I grant
Host=%
User=joe
in the user table, joe can access a l l DBs on the server - even the
mysql-DB.
Thanks for help
Klaus
-
Before posting,
MySQL Question
I run sql version 3.23.42.
LOAD DATA INFILE /usr/lists INTO TABLE lists;
ERROR 1062: Duplicate entry '1' for key 1
Please how do i run this successfully. Ive tried the REPLACE option without
any luck.
-
Before
Pada Mon, 29 Jul 2002 11:47:30 +0200
KSausW [EMAIL PROTECTED] menulis :
How can I grant a privilege to a specified user to a specific DB?
If I grant
Host=%
User=joe
in the user table, joe can access a l l DBs on the server - even the
mysql-DB.
grant set_of_privileges on db.table
Jeffrey,
Sunday, July 28, 2002, 8:14:43 PM, you wrote:
JAK Could you help me understand how to correct this error:
JAK Error 1148: The used command is not allowed with this MySQL version
JAK I have looked in the online manual under this section for help:
JAK 4.2.4 Security issues with LOAD
VINOD,
Saturday, July 27, 2002, 6:57:04 AM, you wrote:
V Subsequently I have loaded above codings
V (post_data.php) on the web and the product.txt file
V into the /tmp directory which is available on web.
V This /tmp directory is having read, write, delete,
V execute permissions. Now the
toby,
Saturday, July 27, 2002, 10:21:50 AM, you wrote:
t i ve a lil problem
t i run this query n get a result set
[skip]
t what should i do ?
I think your question is more suitable for php mailing list.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Erick,
Monday, July 29, 2002, 3:58:36 AM, you wrote:
EP i have a couple of questions about my SQL query.
EP 1. if i want all rows in table 1 that may or may not have a counterpart
EP row in table 2, i use LEFT JOIN. this is HORRIBLY slow! why? if i make it
EP a simple join (i.e., without the
KSausW,
Monday, July 29, 2002, 12:47:30 PM, you wrote:
K How can I grant a privilege to a specified user to a specific DB?
K If I grant
K Host=%
K User=joe
K in the user table, joe can access a l l DBs on the server - even the
K mysql-DB.
Table 'user' stores global privileges. For
Hi,
Are you sure that is trying to access the internet. It
may be trying to open the port, remember that MySQL
needs 3306 (by default) to communicate with the
server.
I think if you just open that port, everything will be
ok.
Bye and Good Luck.
--- Matthew K. Gold [EMAIL PROTECTED] wrote:
Hi,
Heikki ,
Thanks for your reply. So what should I do in the mean time. Is there a
work around.
1. Can I put in the connect string?
like
DBI-connect(DBI:mysql:database=devdb;host=localhost,
{'RaiseError' = 1, 'AutoCommit = 0});
This does not work.
2. Should I use
i get this error in mysql 3.23.51 with snortreport
(http://www.circuitsmaximus.com/download.html)
is this an mysql error or snortreport error ?
regards, bart
-
Before posting, please check:
http://www.mysql.com/manual.php
Yes, it is most certainly because mysql wants to open port 3306.
If it's zone alarm, it probably says it's trying to access 127.0.0.1.
-Original Message-
From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 7:26 AM
To: Matthew K. Gold; MySQL
Subject: Re: why
Ben,
- Original Message -
From: Ben Goswami [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 29, 2002 4:40 PM
Subject: Re: how to set autocommit
Heikki ,
Thanks for your reply. So what should I do in the mean time. Is there a
work around.
Thank you for your fine bug report, thanks to which, I was able to fix
a problem.
Final fix will come up in 4.0.3, but this is a patch that fixes it
temporarily :
= /mnt/work/mysql-4.0/sql/sql_delete.cc 1.80 vs edited =
*** /tmp/sql_delete.cc-1.80-1656Tue Jul 23 18:31:17 2002
Hello everyone,
The mysql documentation about replication is great at describing
how to replicate fomr one master server.
If i want to replicate many db servers to one replication server is
there a way I can edit the my.cnf file to do this. Or would it be
better to have another conf
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE
thanks, everyone for your answers. It was trying to access 127.0.0.1, and I
now know that this is the same thing as localhost.
best,
Matt
- Original Message -
From: Dan Vande More [EMAIL PROTECTED]
To: Francisco Reinaldo [EMAIL PROTECTED]; Matthew K. Gold
[EMAIL PROTECTED]; MySQL
lorenzo.kh,
Monday, July 29, 2002, 11:59:49 AM, you wrote:
lk I have a question regard the table locking.
lk Let say there is a table ,mytablename type=MyISAM in my database.
lk And lets say there are 2 users who are currently log in.
lk First user locks a table write:
lk mysql lock tables
ilya,
Friday, July 26, 2002, 3:43:20 PM, you wrote:
Description:
i It is impossible to create column having ENUM() type. Not sure if
i it is a bug as it doesn't make too much sense but at least error
i message is very wrong.
How-To-Repeat:
i mysql create temporary
Jacob,
Monday, July 29, 2002, 12:19:14 PM, you wrote:
JFL MySQL question:
JFL If I use UPDATE LOW_PRIORITY will the client then have to wait for the
JFL update to finish or is UPDATE LOW_PRIORITY the same as INSERT DELAYED ?
It's not the same as INSERT DELAYED. Client will wait for the UPDATE
Prince,
Monday, July 29, 2002, 12:58:22 PM, you wrote:
PCA MySQL Question
PCA I run sql version 3.23.42.
PCA LOAD DATA INFILE /usr/lists INTO TABLE lists;
PCA ERROR 1062: Duplicate entry '1' for key 1
PCA Please how do i run this successfully. Ive tried the REPLACE option without
PCA any luck.
Hi - I'm having some problems with using MySQL,
MyODBC, and Coldfusion together, so I thought I'd post
here and see if anyone had any ideas on how to fix the
problems. I see other people have had similar issues,
so hopefully someone can help me out.
So, we've running on Solaris 2.7, with Mysql
Hello All,
I need help with MyODBC, I need to create a front-end for MySQL using Visual
C++ 6.0.
Have any one used MyODBC with Visual C++? I need a source code how to create
a ODBC connection using MyODBC drivers.
Please help,
Thanking in Advance...
Regards
Nitesh
I'm having a devil of a time installing mysql 3.23.51 on SuSE 8 from the
source
tarball. I did ./config, then make.
There are the last few lines from make:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer
A reviewer of a project using MySQL write that use of
MySQL auto_increment columns often breaks the rules
of normalisation and promotes poor table design. We
can't find anything suggesting that in the MySQL
documentation, or in our own experience with MySQL
auto-increment. Can anyone clarify?
Hello,
I am having trouble with a particular problem. I am trying to find a formulate
query that calculates the no of weekdays and no of weekend day in any given
month. I already have a method of generating the number of days in a given
month but at that point I am at a loss.
Any ideas?
I'm having a devil of a time installing mysql 3.23.51 on SuSE 8 from the
source
tarball. I did ./config, then make.
There are the last few lines from make:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer
In the last episode (Jul 29), Prince Chidi Ajuzie said:
MySQL Question
I run sql version 3.23.42.
LOAD DATA INFILE /usr/lists INTO TABLE lists;
ERROR 1062: Duplicate entry '1' for key 1
Please how do i run this successfully. Ive tried the REPLACE option without
any luck.
You probably
Hi,
I am trying to run a query that will check to see if a time field is less
than the the time in the field plus ten minutes. The field must also be
greater than 00:00:00. The query below executes without error but doesn't
return rows. Can I do this or is there a better way. I'm using MySQL in
I think this has something to do with the TIMESTAMP field people have been
talking about.
-
Jeff Rozyckihttp://www.Racquetman.com
Digital Publishers http://www.MvCool.com/digital
On Fri, 26 Jul 2002, Nathon
The setup command, at the command prompt type setup this will bring up a
configuration tool (Im running RH7.2), one of the choices is System
Services, under that you can adjust services to start/stop automatically
upon boot. This is done after an RPM install or installation upon OS
install.
This must be a regularly appearing problem, which is why i'm surprised I
can't find a webpage on it..
I have
$result = mysql_query(SELECT title, url, description, author,
date_format(date,'%D %M %Y') AS date FROM documents_tbl, url_tbl WHERE
documents_tbl.title_id = url_tbl.url_id ORDER BY
I am wondering if I can somehow have tables read only at the OS
level and still have MySQL work as normal (at least for SELECTs).
I can make the table files read only, but when I try to select something,
I get the error similar to your_table.MYD cannot be found. The funny
thing is if I change
Hi Jon,
Whatever you have suggested so far hasn't worked. I thought that maybe something
is missing in my stating the problem and implementing your suggested solutions.
So here is a more expanded picture of the queries:
$sth=$dbh-prepare(INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?));
Guys,
I know that version 3.23.51 of MySQL does not handle deleting data from
multiple tables directly. I am in a situation where i have to delete
millions of records from a dozen tables. The delete logic is not simple,
i have to check a number of tables before i can actually delete a row
from a
After many headaches, rantings, and emails, i have FINALLY figured out how
to get 64 indexes out
of MySQL tables.
There are 3 changes you need to make to the source code.
in file mysql_priv.h
change the line:typedef ulong key_map
to:typedef ulonglong key_map
in
Forgot to mention that all of my tables are of TYPE: MyISAM
Thanks
Sri
[EMAIL PROTECTED] wrote:
Guys,
I know that version 3.23.51 of MySQL does not handle deleting data from
multiple tables directly. I am in a situation where i have to delete
millions of records from a dozen tables.
I am porting a multi-threaded MySQL client application that is currently
working fine on my development Solaris box to multiple platforms.
For some reason that I cannot figure out, my autoconf script is
failing on Linux looking for the mysql_thread_init() function in
libmysqlclient_r. From the
Hello Andrew.
My apologies. I somehow completely mixed up my answer. This answer was
intended to a posting which asked why indexes are not copied on CREATE
... SELECT. Don't know how I managed to fit this answer onto your
posting without noticing. Day dreaming or something. :-(
Greetings,
That's a really weird problem. Perhaps someone else could reproduce it if
it's a bug in the most recent MySQL.
I can think of an immediate way to solve it; use the type (datetime?),
which is really a string 20020729. I don't see how this could be sorted
incorrectly, but check your types
I'm having a devil of a time installing mysql 3.23.51 on SuSE 8 from the
source
tarball. I did ./config, then make.
There are the last few lines from make:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer
Hi to all,
I changed Linux from version 7.2 to 7.3 and now when I try to load data
using LOAD DATA LOCAL INFILE I got the following error:
The used command is not allowed with this MySQL version. I
enable --local-infile=1 But I'm still getting the same error.
Any help, is greatly appreciate it
On Mon, Jul 29, 2002 at 01:13:30PM -0400, Aamer Rauf wrote:
Hi Jon,
Whatever you have suggested so far hasn't worked. I thought that maybe something
is missing in my stating the problem and implementing your suggested solutions.
So here is a more expanded picture of the queries:
Hi!!
Is ok that when I do a dump the memory utilized it is not released.
what can I do to solve this problem??
(mysql 2.23.37)
thanks
sandra
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Whatever you have suggested so far hasn't worked. I thought that
maybe something
is missing in my stating the problem and implementing your
suggested solutions.
So here is a more expanded picture of the queries:
$sth=$dbh-prepare(INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?));
Hi.
On Mon 2002-07-29 at 11:35:03 -0400, [EMAIL PROTECTED] wrote:
I am trying to run a query that will check to see if a time field is less
than the the time in the field plus ten minutes.
This does not make sense. This will always be true:
A A + 10 = 0 10 = true
The field must
Hi,
Change the alias to date_format(date,'%D %M %Y') AS
mydate, so you are sure that you sort by the date
field not my the formatted date. Be aware that if you
sort my the formatted string, MySql is going to treat
it as a string and therefore sort it as a string.
11th July 2002 2st July 2002
a string 20020729. I don't see how this could be sorted
incorrectly, but check your types.
On Mon, 29 Jul 2002, julian haffegee wrote:
Date: Mon, 29 Jul 2002 17:59:00 +0100
From: julian haffegee [EMAIL PROTECTED]
To: MySQL General List [EMAIL PROTECTED]
Subject: order by date
This must
Ya I ran them from the command line and they all work except for when I do
the EDIT_LOCK + INTERVAL 10 MINUTE. It actually returns NULL. Very Strange.
-Steve.
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 4:13 PM
To: Steve Bradwell
Hi.
On Mon 2002-07-29 at 14:56:42 -0400, [EMAIL PROTECTED] wrote:
Hi to all,
I changed Linux from version 7.2 to 7.3
There is nothing such as Linux 7.2 or 7.3. The current stable Linux
version is 2.4.18, the development version 2.5.29. What you are
probably referring to is some kind of Linux
Hi.
On Mon 2002-07-29 at 16:33:40 -0300, [EMAIL PROTECTED] wrote:
Hi!!
Is ok that when I do a dump the memory utilized it is not released.
what can I do to solve this problem??
(mysql 2.23.37)
Please be more specific. How do you notice, the memory is not
released. Please quote the
On Thu, Jul 25, 2002 at 12:07:48PM -0300, João Paulo Vasconcellos wrote:
Hello everybody,
someone can tell me the best FS to run MyISAM along with InnoDB tables ?
I don't know that there is a best one, but I use ReiserFS and it works
quite well. I'd stay away from a non-journaling
On 28 Jul 2002, at 17:56, Paul DuBois wrote:
At 14:34 -0700 7/28/02, Charlie wrote:
Is there any storage / performance penalty for specifying '' or 0 as
default values, as opposed to allowing null's in the table structure?
NULL values take less storage space. (One bit per NULL value in a
Hello
Just wnated to calrify something here.
If you define your id in a table to be a primary key, do you also need to
define it as 'NOT NULL' and 'UNIQUE'.
I've notice in some examples like the following off the mysql site:
CREATE TABLE animals (
id MEDIUMINT NOT NULL
From suggestions I received on this mySQL list I installed phpMyAdmin
from the Mandrake 8.2 CDrom, which is the system I am running.So I am
presuming that there are a number of members on the list using
phpMyAdmin.
When I use the following command in a browser, phpMyAdmin starts up and
then
On Mon, Jul 29, 2002 at 06:05:02PM -0400, Keith C. Ivey wrote:
On 28 Jul 2002, at 17:56, Paul DuBois wrote:
At 14:34 -0700 7/28/02, Charlie wrote:
Is there any storage / performance penalty for specifying '' or 0 as
default values, as opposed to allowing null's in the table structure?
Hi,
Were planning on buying more hardware soon and have been pondering the
machine configuration mentioned in Rasmus Lerdorfs Programming PHP book
(OReilly): a squid cache redirector sending traffic to multiple Apache
servers each running a MySQL slave which is replicated from a master
On Tue, Jul 30, 2002 at 01:05:18AM +, Jeremy Hiatt wrote:
Hi,
Were planning on buying more hardware soon and have been pondering the
machine configuration mentioned in Rasmus Lerdorfs Programming PHP book
(OReilly): a squid cache redirector sending traffic to multiple Apache
At 16:32 -0700 7/29/02, Desmond Lee wrote:
Hello
Just wnated to calrify something here.
If you define your id in a table to be a primary key, do you also
need to define it as 'NOT NULL' and 'UNIQUE'.
I've notice in some examples like the following off the mysql site:
CREATE TABLE animals (
Jon,
This is exactly what was needed. You are correct in that we're using the
mysql foo.sql syntax for our importing. It is the only way we can get
access to the hosting companies DB server. Except of course via PHP but that
isn't suited to mass importing remotely.
Thank you for your suggestion
Can you translate 100,000 users into database numbers? How many SELECTs
per second, UPDATEs per second, and so on? That'd help a lot.
I believe roughly 70% of our queries are SELECTs, 29% UPDATEs, and less than
a percent for both INSERTs and DELETEs.
MySQL on localhost (3.23.46) up
Dear Folks,
I'm not sure this is a bug or the SQL syntax.
I created a db named a-b that includes a hyphen.
% mysql a-b
mysql show tables ;
+-+
| Tables_in_a-b |
+-+
| a |
| b |
On Tue, Jul 30, 2002 at 01:45:59PM +0900, Takanori Ugai wrote:
Dear Folks,
I'm not sure this is a bug or the SQL syntax.
I created a db named a-b that includes a hyphen.
% mysql a-b
mysql show tables ;
+-+
| Tables_in_a-b |
+-+
Very sorry for my childish question, I'm just starting to learn about MySQL
Following is my procedure in fixing the problem of installation on Intel PC,
and Linux RH7.3.
1. RPM installation
2. When execute mysql, there is a message ERROR 2002: Can't connect to
local MySQL server through socket
On 29 Jul 2002, William Bradley wrote:
From suggestions I received on this mySQL list I installed phpMyAdmin
from the Mandrake 8.2 CDrom, which is the system I am running.So I am
presuming that there are a number of members on the list using
phpMyAdmin.
I am one of the developers of
Very sorry for my childish question, I'm just starting to learn about MySQL
Following is my procedure in fixing the problem of installation on Intel PC,
and Linux RH7.3.
1. RPM installation
2. When execute mysql, there is a message ERROR 2002: Can't connect to
local MySQL server through socket
Thank you all to answer me
Quotation.
mysql show tables from `a-b`;
It is working well.
In messasge [EMAIL PROTECTED],
Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Tue, Jul 30, 2002 at 01:45:59PM +0900, Takanori Ugai wrote:
Dear Folks,
I'm not sure this is a bug or the SQL syntax.
Sorry, I know nothing about it so I'm asking... (wasn't long ago I could get
MySQL installed and running. ;-)
I'm using Mac OS X (Server).
I installed MySQL... if ODBC is not included, does anyone know where or how
I get it for OS X and MySQL?
(I've read the MyODBC site but it doesn't seem to
hi guys
im stuck with check boxes now
n id b really gratefull if anyone d help plx
the thing is i cnt get the cheked value from a checkbox
input type=checkbox name=news_letter_subs sign me up fo weekly news letter
and updates/input
the processing for this is:
$isql = insert into
Toby,
This is not a MySQL question, it is an issue of PHP and would be best asked
on a PHP forum. But in any case, the value tag is missing in your checkbox
HTML.
Shashank
sql,query
-
Before posting, please check:
Hi.
On Mon 2002-07-29 at 14:41:30 -0400, [EMAIL PROTECTED] wrote:
Sorry to repost but I typed in the wrong sql statement in my previous post.
Ah. Okay.
For some reason the below statement is not working. Can anyone tell me why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10
I'm writing a web application in PHP to do referee scheduling for soccer
games. For each game (a single row in a table) I have a cell for
referee. The cell stores an integer that I can do a join on with another
table of people. I need a way to prevent people from being able to
schedule themselves
Steve,
For some reason the below statement is not working. Can anyone tell me
why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE
now()
AND ORDER_NO = '5' AND EDIT_LOCK 0;
-EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default
is
NULL.
If this
Jefferson,
I'm writing a web application in PHP to do referee scheduling for soccer
games. For each game (a single row in a table) I have a cell for
referee. The cell stores an integer that I can do a join on with another
table of people. I need a way to prevent people from being able to
Sorry to repost but I typed in the wrong sql statement in my previous post.
For some reason the below statement is not working. Can anyone tell me why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE now()
AND ORDER_NO = '5' AND EDIT_LOCK 0;
-EDIT_LOCK is a MySQL (ver
84 matches
Mail list logo