> 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 Windo
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 Windo
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, "star
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 MYSQL"BUT the
> server not started. It display an error message.
> C:\Users\PC> NET START MySQLSystem error 5 has occurred.
> Acces
2013/05/11 20:50 +0600, SIVASUTHAN NADARAJAH
I want to start the mysql from command prompt using "NET START MYSQL"BUT
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 star
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 ins
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:http://lis
NADARAJAH:
> Sorry 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 Q
Am 11.05.2013 16:50, schrieb SIVASUTHAN NADARAJAH:
> I want to start the mysql from command prompt using "NET START MYSQL"BUT
> 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
- Forwarded Message
From: MySQL Web Team
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 site at http
index 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
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
UNS
ble2
> 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 tab
l@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 UNSIGNED and the second is just
> INT.
>
>
> abdulazeez alugo wrote:
> > Table1 is as below:
>
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 T
mail.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 alugo wrote:
> >
> > Yeah I used the mysql_error
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
&g
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 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_st
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
> S
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){ print"Successful";}
else {print "Unsuccessful: ".mysql_error()}
abdulazeez alugo wrote:
Hi guys,
Please can anyo
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
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 ?
ell [mailto:[EMAIL PROTECTED]
Sent: 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 yo
> Sent: 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
ces if they had 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, U
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 like
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 plac
lace to go and I don't wanna go back. I'd just like to see it held someplace
new every year.
Thanks for replying to my comment
>>> Lenz Grimmer <[EMAIL PROTECTED]> 1/25/07 2:21 AM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Ed,
thank you for your message!
On
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
r 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? I would like to go this year but I didn't enjoy myself at the
> last one I went t
From: "bruce" <[EMAIL PROTECTED]>
To:
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 is going
> wrong... so, back to basics...
>
>
t instance;
resulting in,
1,2,1
Thanks
ViSolve DB Team
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To:
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
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
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
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 roo
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, wh
:[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 h
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 * fro
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 woul
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 = $dbh->pr
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?
>
> Th
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 sure
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
--
|..
[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 G
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
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 PROTECTE
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
Hi All,
Is anybody having interview point of questions on mysql ,
pl. let me know any other source..
-Aman.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just started working with mysql and I'm very novice
Created a simple database and programmed php to connect as follows...
$link= mysql_connect($hostname,$user,$password)or die ("_something is
whong");
mysql_select_db($db,$link);
$query ="SELECT * FROM projects";
$result = mysql_query($query);
$
--- Begin Message ---
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
0308
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 1
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
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 http:
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 myD
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:
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 databa
> 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 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.
For example, a perl script:
Select * from emp from a Progress database
Will write to a te
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 k
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:
Wi
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:
>
# [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
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 1
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:
h
vious" value of Topic from
the previous record, and only output the Topic part when it changes.
HTH,
Tore.
- Original Message -
From: "Mike Walth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 5:34 AM
Subject: PHP / MYSQL Question
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
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 Ltd
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 th
bject: RE: perl dbi and mysql 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; &#x
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
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 db
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::m
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, pl
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 us
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]
> Subje
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 my
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 the
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 technic
* 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
--
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
7;
Subject: 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
wing up everything.
If it doesn't work, simply remove the socket 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
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
>>MySQ
[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 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
cl
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 va
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, co
>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 shoul
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 [som
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&#
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
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 del
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 delet
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
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?
nstallation.html
Gurhan Ozen
MCI 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 PROT
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
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 softwa
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 Reco
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|
|
1 - 100 of 167 matches
Mail list logo
