Hello Reindl,
On 5/11/2013 11:52 AM, Reindl Harald wrote:
... virtually
nonofy is using mysql on windows seriously as i have
not touched windows since 2006 at all
Your experience is not indicative of the population as a whole. Many
important and mission-critical installations exist on
why not answer the question another user made hours ago?
under which account do you try to start mysqld?
Agreed. Chances are good that if he goes into the Windows Services control
panel and gets the properties of the mysql service, he will find that it is
configured to start under a Windows
Am 11.05.2013 16:50, schrieb SIVASUTHAN NADARAJAH:
I want to start the mysql from command prompt using NET START MYSQLBUT
the server not started. It display an error message.
C:\Users\PC NET START MySQLSystem error 5 has occurred.
Access is denied.
could you please help me, how to
I could not understand your answer. please give me the step by step
guidance.
thank you so much...
Date: Sat, 11 May 2013 16:58:16 +0200
From: h.rei...@thelounge.net
To: mysql@lists.mysql.com
Subject: Re: NET START MYSQL QUESTION?
Am 11.05.2013 16:50, schrieb SIVASUTHAN NADARAJAH
On 11.05.2013 17:50, SIVASUTHAN NADARAJAH wrote:
C:\Users\PC NET START MySQL System error 5 has occurred.
Access is denied.
Run command window from elevated permission.
--
Mimiko desu.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Am 11.05.2013 20:04, schrieb Mimiko:
On 11.05.2013 17:50, SIVASUTHAN NADARAJAH wrote:
C:\Users\PC NET START MySQL System error 5 has occurred.
Access is denied.
Run command window from elevated permission
wow - you mean he *really* tried to start a service as
restricted user and instead
2013/05/11 20:50 +0600, SIVASUTHAN NADARAJAH
I want to start the mysql from command prompt using NET START MYSQLBUT
the server not started. It display an error message.
C:\Users\PC NET START MySQLSystem error 5 has occurred.
Access is denied.
could you please help me, how to start the
Am 11.05.2013 21:49, schrieb h...@tbbs.net:
2013/05/11 20:50 +0600, SIVASUTHAN NADARAJAH
I want to start the mysql from command prompt using NET START MYSQLBUT the
server not started. It display an error message.
C:\Users\PC NET START MySQLSystem error 5 has occurred.
Access is denied.
2013/05/11 22:58 +0200, Reindl Harald
why not answer the question another user made hours ago?
under which account do you try to start mysqld?
Well, I learnt something here.
When I had the problem of (under Vista) starting mysqld, from command prompt
I always did this, start mysqld -b...
- Forwarded Message
From: MySQL Web Team webmas...@mysql.com
To: christudas_...@yahoo.com
Sent: Wednesday, July 8, 2009 3:46:09
Subject: Re:General MySQL Question
Thank you for contacting MySQL,
You are likely to get a more detailed response to your question if you
ask on the forums
Yeah I used the mysql_error and it returned Can't create table
'.\website\table2.frm' (errno: 150). So what does that say?
Date: Tue, 7 Apr 2009 17:38:59 +0400
From: evge...@kosov.su
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: PHP-MYSQL Question
Perhaps you
:59 +0400
From: evge...@kosov.su
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: PHP-MYSQL Question
Perhaps you don't have permissions to create tables?
It would have been much clearer if your script was like this:
$result=mysql_query($your_create_table_statement);
if($result
that be the problem?
Date: Tue, 7 Apr 2009 17:48:16 +0400
From: evge...@kosov.su
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: PHP-MYSQL Question
# perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed
What does table1 look like?
abdulazeez
Perhaps you don't have permissions to create tables?
It would have been much clearer if your script was like this:
$result=mysql_query($your_create_table_statement);
if($result){ printSuccessful;}
else {print Unsuccessful: .mysql_error()}
abdulazeez alugo wrote:
Hi guys,
Please can anyone
@lists.mysql.com
Subject: Re: PHP-MYSQL Question
# perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed
What does table1 look like?
abdulazeez alugo wrote:
Yeah I used the mysql_error and it returned Can't create table
'.\website\table2.frm' (errno: 150
Hi guys,
Please can anyone tell me what I'm doing wrong with the code below? It keep
returning unsuccessful.
$result=mysql_query(CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY
AUTO_INCREMENT,
table1_id INT NOT NULL,
name VARCHAR(100) NOT NULL,
school VARCHAR(100) NOT NULL,
comment
Subject: Re: PHP-MYSQL Question
I suppose the problem is that table1.table1_id and table2.table1_id are
of different types. The first one is INT UNSIGNED and the second is just
INT.
abdulazeez alugo wrote:
Table1 is as below:
CREATE TABLE table1(table1_id INT UNSIGNED NOT NULL
but table2
remains unsuccessful.
Date: Tue, 7 Apr 2009 17:56:49 +0400
From: evge...@kosov.su
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: PHP-MYSQL Question
I suppose the problem is that table1.table1_id and table2.table1_id are
of different types. The first one is INT
I've done that but it still gives the same error message.
Date: Tue, 7 Apr 2009 16:25:15 +0200
Subject: Re: PHP-MYSQL Question
From: spa...@googlemail.com
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
it is not the ENGINE as Eugene mentioned above, is that you need to use
UNSIGNED
and it returned successful. So that was
the problem all along.
Thanks for your suggestions.
Best regards
Alugo Abdulazeez.
From: defati...@hotmail.com
To: spa...@googlemail.com
CC: mysql@lists.mysql.com
Subject: RE: PHP-MYSQL Question
Date: Tue, 7 Apr 2009 15:32:25 +0100
I've done
hi
i need help regarding a sql query in my php app.
the query is :
$SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes'
LIMIT $startingID,$items_numbers_list;
i want to sort this query by the number of the repeated EMail counts.
can anyone help me with that please ?
Hmmm, using distinct email in a query where you want
to count email won't work.
select mail, count(mail) as mailcnt from guest
where voted='yes'
group by mail
order by mailcnt;
should do the trick.
On Tue, April 3, 2007 12:51, Me2resh Lists wrote:
hi
i need help regarding a sql query in my
Great idea! Tips on how to get around, good local restaurants (if you
like Vietnamese, San Jose is the place), and other things to do when you
need a break... There is really a great deal just a short distance
away, but you have to know how to get there. It's possible there was
something
one
in a nice place like Panama City (in Panama, not in Florida).
Thanks,
Michael
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Mon, 29 Jan 2007 4:57 PM
Subject: Re: General MySQL Question: Ed Reed (CA, United States
: Tuesday, January 30, 2007 3:02 AM
To: Mike Wexler
Cc: Ed Reed; mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Re: General MySQL Question: Ed Reed (CA, United
States ofAmerica) Medium
Great idea! Tips on how to get around, good local
restaurants (if you
like Vietnamese, San Jose is the place
: Tuesday, January 30, 2007 3:02 AM
To: Mike Wexler
Cc: Ed Reed; mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Re: General MySQL Question: Ed Reed (CA, United
States ofAmerica) Medium
Great idea! Tips on how to get around, good local
restaurants (if you
like Vietnamese, San Jose
Contact Form with a
General MySQL Question:
Can someone tell me you folks are going to hold all future User Conferences
in Santa Clara? I would like to go this year but I didn't enjoy myself at the
last one I went to in Santa Clara in '05 and I don't wanna go back. If you
folks plan to hold all
On Monday 29 January 2007 12:57, Ed Reed wrote:
I just didn't enjoy the location. When it was in Orlando a few years ago,
it was great. There were plenty of things to do and see; different places
to eat every night. I had a really good time. Then the following year I
went to Santa Clara and
PROTECTED] 1/25/07 2:21 AM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Ed,
thank you for your message!
On Thu, 18 Jan 2007, Ed Reed has filled out the MySQL Contact Form with a
General MySQL Question:
Can someone tell me you folks are going to hold all future User Conferences
in Santa Clara
The area by the Santa Clara convention center is pretty dead, but you
can take the light rail to downtown San Jose and there is a pretty
lively nightlife there, lots of interesting restaurants, The Tech Museum
and other things depending on you interests.
Also there are lots more interesting
;
resulting in,
1,2,1
Thanks
ViSolve DB Team
- Original Message -
From: bruce [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, January 04, 2007 6:07 AM
Subject: mysql question regarding distinct/group by...
hi...
i've asked something similar before.. but it appears something
6:07 AM
Subject: mysql question regarding distinct/group by...
hi...
i've asked something similar before.. but it appears something is going
wrong... so, back to basics...
i have the following test tbl.
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
hi...
i've asked something similar before.. but it appears something is going
wrong... so, back to basics...
i have the following test tbl.
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
2 5 2
1 5 3
if i do a query
select * from
In the last episode (Jan 03), bruce said:
i've asked something similar before.. but it appears something is going
wrong... so, back to basics...
i have the following test tbl.
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
2 5 2
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Dear there,
I have some problems when installing mysql under rpm. Hope some people
can give me help.
I install MySQL-server-4.1.12-0.i386 package and
MySQL--client--4.1.12-0.i386 package
under root
Dear there,
I have some problems when installing mysql under rpm. Hope some people can
give me help.
I install MySQL-server-4.1.12-0.i386 package and MySQL--client--4.1.12-0.i386
package under root account. Under the root account, I can start the mysql and
it seems working fine. However,
:[EMAIL PROTECTED]
Sent: mardi 26 avril 2005 06:20
To: mysql@lists.mysql.com
Subject: Re: Python related MySQL question
Hi!
I am porting a function library app I wrote in PHP to Python. At work
they only use Python. I've researched how to connect to a MySql
database using Python, and how
Hi!
I am porting a function library app I wrote in PHP to Python. At work they
only use Python. I've researched how to connect to a MySql database using
Python, and how to retrieve rows. However, I am wondering how to do the
following:
I can do this in Python = $da=MYSQL_QUERY(select * from
Dear MySQL Developers and Enthusiasts,
when I run these lines of code :
my $T_NO = 12569;
use DBI;
my $dbh =
DBI-connect(DBI:mysql:database=carr_search;192.168.0.1,user,password);
my $q = CREATE TABLE IF NOT EXISTS CS_? (
ID_NO MEDIUMINT,
NAME VARCHAR(30),
TYPE CHAR(1)
);
my $sth =
Hey,
The placeholders (?) are safely escaped by the DBI library -- your
query that gets submitted to the server actually looks like:
CREATE TABLE IF NOT EXISTS CS_ 12569 (
ID_NO MEDIUMINT,
NAME VARCHAR(30),
TYPE CHAR(1)
)
I think it puts the space in, but it might actually be quoting it.
I
Is the MySQL Reference Manual, by Widenius and Axmark (the one to which
there is a link on the Documentation page of the mysql website, for sale by
Barnes and Noble) the same reference manual that you can download?
The PDF version has 1310 pages, the softcover book has 712 pages, and I'm
not
On Wed, Aug 04, 2004 at 02:46:50PM -0500, rdo mail list address wrote:
Is the MySQL Reference Manual, by Widenius and Axmark (the one to which
there is a link on the Documentation page of the mysql website, for sale by
Barnes and Noble) the same reference manual that you can download?
The
4.0.18 is the latest stable!
On Tue, 2004-03-23 at 19:08, [EMAIL PROTECTED] wrote:
Hi,
A quick question, which is the most stable version of mysql to run on a very busy
and commercial website(s)?
4.0 or is 4.1 stable enough?
Thanks,
-R.A
--
Hi,
A quick question, which is the most stable version of mysql to run on a very busy and
commercial website(s)?
4.0 or is 4.1 stable enough?
Thanks,
-R.A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
4.1 seems stable enough, been running it since it was released.
in production, busy, commercial, enterprise environment.
plus it fixes some bugs in 4.0 and adds some (could be potentially)
necessary functions
Dan.
On Tue, 23 Mar 2004 [EMAIL PROTECTED] wrote:
Hi,
A quick question, which is
[EMAIL PROTECTED] wrote:
Hi,
A quick question, which is the most stable version of mysql to run on a very busy and commercial website(s)?
4.0 or is 4.1 stable enough?
Thanks,
-R.A
4.0 is a released and stable version.
4.1 is a developement version which is alpha, but quite stable :)
--
MySQL
We are a developer of Point of Sale software and are launching a Linux based
product shortly. We wanted to know if there were any plans for MySQL to
support eSQL any time soon. Thanks.
Regards,
Blair M. Melton
Vice President, Grocery and Merchandise Division
Sweda Corporation
(416) 246-5487
I just started working with mysql and I'm very novice
Created a simple database and programmed php to connect as follows...
?php
include (webvars.inc);
// webvars file is this
//?php$user = ???;$hostname = ???;$password = pass;
//$db=cs?
$link= mysql_connect($hostname,$user,$password)or die
I forwarded your mail to the mysql list so that everyone who cares knows
what is going.
Bill Hernandez wrote:
The error log shows:
030810 14:52:48 mysqld started
030810 14:52:49 InnoDB: Started
030810 14:52:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
030810
---BeginMessage---
On 8/9/03 11:20 PM, Andreas [EMAIL PROTECTED] wrote:
Andreas,
Thanks for the help...
The error log shows:
030810 14:52:48 mysqld started
030810 14:52:49 InnoDB: Started
030810 14:52:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
030810
Hi,
I've been writing software on the mac since 1987, but am brand new at
unix/php/mysql, and that's where I'm headed so I'm reading everything I can
get my hands on, but like anything else there's going to be a learning
curve, that having been said...
I followed the install instructions at
Andreas wrote:
Bill Hernandez wrote:
I followed the install instructions at http://entropy.ch , and was
able to
get mySql php installed on my G4 - (OSX 10.2.6) last night. I
downloaded
Navicat and setup a password for the mysql user. I created a connection
called myDatabase_connection to a
Bill Hernandez wrote:
I followed the install instructions at http://entropy.ch , and was able to
get mySql php installed on my G4 - (OSX 10.2.6) last night. I downloaded
Navicat and setup a password for the mysql user. I created a connection
called myDatabase_connection to a database called
Has anyone written a perl script to get records from another database and
write it to a file on mysql's LOAD DATA INFILE format? I just need some
pointers in perl so a LOAD DATA INFILE will be read correctly.
For example, a perl script:
Select * from emp from a Progress database
Will write to a
Has anyone written a perl script to get records from another
database and write it to a file on mysql's LOAD DATA INFILE
format? I just need some pointers in perl so a LOAD DATA
INFILE will be read correctly.
You might want to check out Perl's DBI module at search.cpan.org
I use that all
Howell, Scott wrote:
Has anyone written a perl script to get records from another database and
write it to a file on mysql's LOAD DATA INFILE format? I just need some
pointers in perl so a LOAD DATA INFILE will be read correctly.
For example, a perl script:
Select * from emp from a Progress
are those warnings?
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: Howell, Scott [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 6:38 PM
Subject: Perl/mysql question
Has anyone written
PAUL MENARD [EMAIL PROTECTED] wrote:
I'm having an intermittent problem with a MySQL server that I have running on a
Windows 2000 Advance server systems. This issue occurs every few days depending on
the load of the system.
Here are the details.
MySQL version 3.23.42-nt (I know I
# [EMAIL PROTECTED] / 2003-06-23 11:11:28 -0400:
I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
attempted to run mysql_fix_privileges. This is the error I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
/tmp is:
Susan Ator [EMAIL PROTECTED] wrote:
I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
attempted to run mysql_fix_privileges. This is the error I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
/tmp is:
Hello All,
I'm having an intermittent problem with a MySQL server that I have running on a
Windows 2000 Advance server systems. This issue occurs every few days depending on the
load of the system.
Here are the details.
MySQL version 3.23.42-nt (I know I need to upgrade. Soon).
Machine:
I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
attempted to run mysql_fix_privileges. This is the error I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
/tmp is:
drwxrwxrwt6 root root 4096 Jun 23
I inadvertantly deleted the colonel's question, which I believe concerned
winmysqladmin.
Please give us more info. You should be able to see your databse(s) under the
database tab.
David
-
Before posting, please check:
Not sure if this can be done with just a MYSQL Query or if it needs to be
done in conjunction with a PHP script. What I am trying to do is build a
dynamic FAQ section with PHP. Here are the two tables
Topics
===
TopicID
TopicTitle
TopicDESC
FAQS
===
FAQID
Question
Answer
Topic
i am using perl dbi with dbd::mysql. i know that using the dbi function,
$dbh-tables (), will list all the tables in a database. is there a function
that will show all the databases on a server?
thanks,
shon
-
Before posting,
eureka! i found it!
@dbs = $dbh-func('_ListDBs');
-Original Message-
From: Shon Stephens [mailto:sstephens;corp.goamerica.net]
Sent: Friday, November 08, 2002 9:45 AM
To: '[EMAIL PROTECTED]'
Subject: perl dbi and mysql question
i am using perl dbi with dbd::mysql. i know that using
No clue of dbi/dbd but the query SHOW DATABASES does what it tells.
STIBS
- Original Message -
From: Shon Stephens [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 08, 2002 3:44 PM
Subject: perl dbi and mysql question
i am using perl dbi with dbd::mysql. i know
Of course, you could have also used:
$stmt = $db-prepare(show databases);
Peter
^_^
-Original Message-
From: Shon Stephens [mailto:sstephens;corp.goamerica.net]
Sent: Friday, November 08, 2002 9:50 AM
To: Shon Stephens; '[EMAIL PROTECTED]'
Subject: RE: perl dbi and mysql question
question
Of course, you could have also used:
$stmt = $db-prepare(show databases);
Peter
^_^
-Original Message-
From: Shon Stephens [mailto:sstephens;corp.goamerica.net]
Sent: Friday, November 08, 2002 9:50 AM
To: Shon Stephens; '[EMAIL PROTECTED]'
Subject: RE: perl dbi and mysql
In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.
So, if you are enforcing referential integrity you
can not delete data that is referred to by another
table or mess up the basic db structure... (think I
have
tmb wrote:
In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.
Read up on referential integrity and InnoDB tables in the online docs at
http://www.mysql.com/doc/en
--
Michael T. Babcock
C.T.O., FibreSpeed
I think you need to give us the SQL you are using to do the search - we'll
ba ble to see what your are trying to do better
Alan
-Original Message-
From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 15:37
To: [EMAIL PROTECTED]
Subject: a mysql question
I'm
Pada Thu, 17 Oct 2002 13:36:58 +0800 (CST)
µÑ ¶Ì [EMAIL PROTECTED] menulis:
I'm a chinese software engineer, and I has use mysql
for three years ago.Now,I get a matter from it.
recently,I'm deal big data use mysql first.every
table's data is one million,so user search the data
will use long
I'm a chinese software engineer, and I has use mysql
for three years ago.Now,I get a matter from it.
recently,I'm deal big data use mysql first.every
table's data is one million,so user search the data
will use long time.now ,if some user search one table
togeter,the table is dead , and I find
Sorry, but it is hard to understand what you are actually asking, but I'll
try.
If you are returning too large resultset, it is possibly a JDBC driver
problem, since it will retrieve all into Java objects, which could take
forever.
If you know your SELECT statement, just issue it in the
* David M. Gonzalez Salinas
Does anybody knoy what is equivalent stmt in MySQL?
select * from table1 where col1 in (select col1 from table2)
This is called a subselect, and it is explained in the manual:
URL: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
--
Roger
David,
Tuesday, October 08, 2002, 2:01:46 AM, you wrote:
DMGS Does anybody knoy what is equivalent stmt in MySQL? select * from table1
DMGS where col1 in (select col1 from table2)
You can re-write without subselects:
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
--
For
Hi everybody...
Does anybody knoy what is equivalent stmt in MySQL? select * from table1
where col1 in (select col1 from table2)
thanks in advance.
David.
-
Before posting, please check:
http://www.mysql.com/manual.php
Maybe someone else can come up with an answer for me on this question. I am
getting the following error when I try to run my index.php file. I think I
have configured it correctly, but obviously I haven't. And my host basically
told to go shove it.
Welcome to phpMyAdmin 2.3.1-rc1
Error
MySQL
information and lines from the
my.cnf file.
Jason
-Original Message-
From: Easton, William [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 12:55 PM
To: '[EMAIL PROTECTED]'
Subject: phpMyAdmin/MySQL Question
Maybe someone else can come up with an answer for me on this question
: phpMyAdmin/MySQL Question
Maybe someone else can come up with an answer for me on this question. I am
getting the following error when I try to run my index.php file. I think I
have configured it correctly, but obviously I haven't. And my host basically
told to go shove it.
Welcome to phpMyAdmin
I desire to configure MySQL in such a way that it will permit me to have two
different PHP/MySQL e-commerce applications running concurrently on my
development system. The table names and table structure are the same on both
applications(and databases). I have received a SQL backup from the new
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 September 2002 12:26
To: MySQL MySQL
Subject: Multiple concurrent MySQL question?
I desire to configure MySQL in such a way that it will permit me to have two
different PHP/MySQL e-commerce applications running concurrently on my
development system. The table
I have to do an insert and need to nest a select inside. I have tons of
documentation on a very simple version of this, however my requirements
are one step beyond that. Here is what I'd like to do in MySQL:
insert into
table1
(column1, column2)
values
(select column1a from table2 where
From my experince this is not possible.
Is there any reason why you can not simply do two inserts following each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something]
INSERT INTO table1(column2) VALUES(valueFromMemory)
(as if you didnt know that already) =D
There
At 17:16 -0700 9/10/02, Mark S Lowe wrote:
I have to do an insert and need to nest a select inside. I have tons
of documentation on a very simple version of this, however my
requirements are one step beyond that. Here is what I'd like to do
in MySQL:
insert into
table1
(column1, column2)
The optimization is understandable but I'm not sure how much it would
affect it if you did the select outside the insert statment vs inside.
Either way you are selecting the same thing but I dont know which way is
better.
Well just playing around with it for a bit I think I found something.
The
EXPLANATION:
here's the pertinent piece of my sql create statement:
ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
i have used this create statement numerous times without this problem. in the past,
let's say i inserted 3 entries: A, B, and C. their IDs were 1,2, and
3. then i delete
EXPLANATION:
here's the pertinent piece of my MySQL create statement:
ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
i have used this create statement numerous times without this problem. in the past,
let's say i inserted 3 entries: A, B, and C. their IDs were 1,2, and
3. then i
That is a difference in the behavior of
isam and myisam tables.
jason wesley upton wrote:
EXPLANATION:
here's the pertinent piece of my sql create statement:
ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
i have used this create statement numerous times without this problem. in the
On Thu, 27 Jun 2002, jason wesley upton wrote:
Date: Thu, 27 Jun 2002 14:05:34 -0500
From: jason wesley upton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql
EXPLANATION:
here's the pertinent piece of my sql create
Hi,
Could any of you help me in getting a Performance Comparison document for
MySQL on different architectures (Intel linux or S390 linux).
Regards,
prabha
-
Before posting, please check:
http://www.mysql.com/manual.php
WorldCom
Quality Assurance Team
[EMAIL PROTECTED]
ph: 703-449-4754
Vnet: 228-4754
1-800-PAGE-MCI pin: 1927052
AIM: Greywolf1923
-Original Message-
From: Lucia DeMeester [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 11:19 PM
To: [EMAIL PROTECTED]
Subject: MYSQL question - Urgent
Hi.
Sorry, but I beg to differ. I think it is not a good idea to recommend
to others to run the MySQL server as root. The manual explicitly
recommends otherwise.
On Mon, Apr 29, 2002 at 10:15:31PM -0600, [EMAIL PROTECTED] wrote:
Questions:
- Do I use root account to install the software?
I am an Oracle DBA and need to create a MYSQL database on Thursday.
Can you answer my questions? (I have not had chance to read the manual yet.
Just a quick search, I can not find my answer.)
I plan to use InnoDB and I find it is quite similar to Oracle. However, in
Oracle we install the
Questions:
- Do I use root account to install the software?
Yes to compile the source or do an RPM as seen below.
See http://www.mysql.com/doc/L/i/Linux-RPM.html
- What account do I use to create Innodb?
Same - I am guessing here but I do all installs as root then give the needed
permissions to
Luie,
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value
in the table.
If I have a form...
__
|Employee Record
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value in the table.
If I have a form...
__
|Employee Record Update|
|
-Original Message-
From: Peter Ruan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 4:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL question...not sure if this is the correct forum to
ask.
Hi,
Can the UPDATE statement have conditional check embedded in it? I
have
-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 11:10 a.m.
To: [EMAIL PROTECTED]
Cc: '[EMAIL PROTECTED]'
Subject: FW: [PHP] MySQL question...not sure if this is the correct
forum to ask.
-Original Message-
From: Peter Ruan [mailto:[EMAIL PROTECTED
1 - 100 of 155 matches
Mail list logo