visit this site :
http://www.daniweb.com/forums/thread119197.html
--- On Tue, 8/3/10, Marc Guay marc.g...@gmail.com wrote:
From: Marc Guay marc.g...@gmail.com
Subject: Re: from excel to the mySQL
To: HaidarPesebe haidarpes...@gmail.com
Cc: MySQL Lists mysql@lists.mysql.com
Date:
Error: Duplicate entry '0' for key 'PRIMARY'
how can i fix it ?
, 2009, 1:58 PM
Easy. Ensure that all in the primary key have unique values.
With that said, it would be more useful to have a ddl and the query causing the
problem.
--Original Message--
From: sam rumaizan
To: mysql@lists.mysql.com
ReplyTo: samc...@yahoo.com
Sent: Mar 2, 2009 12:56 PM
that all in the primary key have unique values.
With that said, it would be more useful to have a ddl and the query causing the
problem.
--Original Message--
From: sam rumaizan
To: mysql@lists.mysql.com
ReplyTo: samc...@yahoo.com
Sent: Mar 2, 2009 12:56 PM
Subject: Error: Duplicate entry '0
2, 2009, 2:32 PM
Are you trying to do an Insert On Duplicate Key? Do ou want to insert
a new row if it doesn't already exist or update one if it does?
On Mon, Mar 2, 2009 at 4:09 PM, sam rumaizan samc...@yahoo.com wrote:
Are you talking about Length/Values1
--- On Mon, 3/2/09, Gary Smith g
How do I insert data from a drop down menu (select box) to a table
How can I select (retrieve) the last updated cell (field). Basically I need to
pull the new information only.
I'm using for updating my database:
UPDATE table SET column = CONCAT_WS ('column,' . $column.') WHERE column=
value;
I need to select data:
SELECT * FROM table WHERE
I'm just a php beginner.
So please be patient with my stupid questions.
What am I missing in this code that causing the function cant update the
textarea?
Update button erase the old information from mysql database and replace it
with nothing. Basically it cant read what is
Is there a function in mysql to view the index number of a specific
cell/field?
For example if I want the index number for info4 or info7. Is it possible?
Column 1 Column 2 Column 3 Column 4 Column 5
Info1 Info2
Can someone show me the mysql query statement to update the Text Area (the
Text Area is populated with information from mysql) basically I want to allow
the user to change or add information to the original data.
scroll down to read the code. The text area I need to update is red font.
Is there such thing call Object-Oriented database for mysql? Basically can I
store an item as an object in myql?
-
Looking for earth-friendly autos?
Browse Top Cars by Green Rating at Yahoo! Autos' Green Center.
I have created table in mysql with 12 fields
Field1Field2 Field3 Field4
Field12
I have an excel sheet with 12 columns and 150 rows.
My question is how can I import all of the columns from the excel sheet to my
table without losing any information.
I have a question if you don't mind.
The update statement will replace the existing information. What if I
have Textarea instead and I want to add information to the field
without erasing previous information. Basically append information
-
Can you help me please?
1-I have created a while loop to populate the list box with the information
of column1.
2-I need to update (insert data) in to column2, column3, column4 base
on the selection of the list box.
echo'form';
$query = SELECT column1 FROM table;
I have to two different fields Last_Updated and Story. I want whenever Story
Field got updated (modified) the time and date of the modification get recorded
(insert) in Last_Updated Field
-
No need to miss a message. Get email on-the-go
with Yahoo! Mail
15 matches
Mail list logo