l Message-
From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
Sent: Wednesday, February 16, 2011 6:33 AM
To: mysql@lists.mysql.com
Subject: Insert data in one table from Another Problem
Dear all,
Today I am puzzled around a problem of inserting data into new table in
new format. I hav
Dear all,
Today I am puzzled around a problem of inserting data into new table in
new format. I have a table named *user_news* as :
We have four rows with respect to each record_id.
fore.g : I have listed main columns as
*record_id field_name field_value*
572SOI
At 12:09 AM 11/28/2009, Krishna Chandra Prajapati wrote:
Hi Mos,
In the below two command does 1 is faster than 2.
1. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;
2. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet LINES TERMINATED
BY '\r\n' enclosed by '"';
Thanks,
Krishna
Hi Mos,
In the below two command does 1 is faster than 2.
*
1. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;*
2. *LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet* *LINES
TERMINATED BY '\r\n' enclosed by '"';*
Thanks,
Krishna Ch. Prajapati
On Sat, Nov 28, 2009 at 3:50 AM, mos
At 07:40 AM 11/27/2009, Krishna Chandra Prajapati wrote:
Hi Experts,
load data local infile and insert into are the two methods of
inserting data into a mysql table.
Out of the above two method. Is there any faster method of inserting data
into mysql tables.
No. Load Data is the fastest meth
Hi Experts,
load data local infile and insert into are the two methods of
inserting data into a mysql table.
Out of the above two method. Is there any faster method of inserting data
into mysql tables.
Thanks,
Krishna Ch. Prajapati
Hi,
On Fri, Feb 13, 2009 at 4:52 PM, PJ wrote:
> I am trying to create a php-mysql page to POST new records to several
> tables from one php page and I have to retrieve records from several
> (like 4 to 8) tables in one query.
> Being quite new to php & mysql, I am wondering what is the best way
I am trying to create a php-mysql page to POST new records to several
tables from one php page and I have to retrieve records from several
(like 4 to 8) tables in one query.
Being quite new to php & mysql, I am wondering what is the best way to
go about this. My tables consist of
* Structure
ou want an
update. Anywhere you can check the manual for sintax issues.
Carlos
sam rumaizan wrote:
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 ba
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: sam rumaizan [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 03, 2007 6:51 AM
> To: mysql@lists.mysql.com
> Subject: inser
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'';
$query = "SELECT col
John Trammell
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; Gerald Preston
Subject: Re: insert data
Right. First, I think the logic is flawed. We should successfully
prepare() or die. Period. If the call to prepare() failed ($sth is undef),
we should not making dying conditional on yet anot
Right. First, I think the logic is flawed. We should successfully
prepare() or die. Period. If the call to prepare() failed ($sth is undef),
we should not making dying conditional on yet another value.
More to the point, this line is actually the cause of the problem. (Sorry I
didn't see i
Gerald Preston wrote:
David,
I read them and installed 4.1.10 and I am back to square one:
I used the following code:
my $dbh=DBI->connect( 'dbi:mysql:club', 'gjwpp88', 'x' ) or die
"\n$DBI::errstr\n";
You do not specify the host, so you are connecting to the default, which is
"localhos
Gerals Preston wrote:
[snip]
> my $sth = $dbh->prepare( $sql ) or die $dbh->errstr if $dbh->err;
[snip]
Regardless of other problems you may be having, I think you're not
doing what you want to do here. How about instead:
my $sth = $dbh->prepare($sql);
$sth || die "Error preparing sth from '$sql
Gerald Preston wrote:
[...]
I get "DBI connect<'club','gjwpp88',..> failed; Client does not support
authentication protocol requested by server"
Check this:
http://dev.mysql.com/doc/mysql/en/old-client.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
x27;)
WHERE Host = 'local_host' AND User = 'gjwpp88';
SET PASSWORD FOR 'gjwpp88'@'local_host' = OLD_PASSWORD('x');
SELECT 'local_host', 'gjwpp88', Password FROM mysql.user
WHERE LENGTH('x') > 16;
FL
8408 4259 - Fax
-Original Message-
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 1 March 2005 10:10 AM
To: 'William R. Mussatto'; mysql@lists.mysql.com
Subject: RE: insert data
William,
I tried " GRANT ALL ON *.* " and got error " 1064 <420
Hi Gerald
my last try... i'm not very lucky in helping in this list...
> This is the actual code except for the "":
>
> [...]
> my $sth = $dbh->prepare( $sql ) or die $dbh->errstr if $dbh->err;
Maybe this expression is the reason (combination of 'or' and 'if').
Example code:
===
my $no_e
William,
I tried " GRANT ALL ON *.* " and got error " 1064 <4200>: You have an error
in your SQL syntax " ??
Jerry
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: Monday, February 28, 2005 3:25 PM
To: mysql@lists.mysql.com
Subjec
d make sure that each
of your execute parameters have some value prior to the
execute.
Eamon Daly
- Original Message -
From: "Gerald Preston" <[EMAIL PROTECTED]>
To: "'Michael Stassen'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>;
Sent
re. I have been writing code on a SUN Oracle systems for
> over five years.
>
> Regards,
>
> Jerry
Did you 'grant' user "" access to all the tables in database club?
>
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTEC
---
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, February 28, 2005 9:29 AM
To: Gerald Preston
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: insert data
From perldoc DBD::mysql
use DBI;
$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
',
'a_password',
{RaiseError=>1,
AutoCommit=>1})
or die "$0: $DBI::errstr"; }
So, try using "club" instead of "database=club", and a hostname too.
greetings joe
[nothing new below]
-Original Message-
From: John Doe [
ame';
my $port ='1234';
$dbh=DBI->connect("DBI:mysql:$db:$host:$port",
'a_username',
'a_password',
{RaiseError=>1,
AutoCommit=>1})
or die "$0: $DBI::errstr"; }
So, try using "club" instead of "d
'a_username',
'a_password',
{RaiseError=>1,
AutoCommit=>1})
or die "$0: $DBI::errstr"; }
So, try using "club" instead of "database=club", and a hostname too.
greetings joe
[nothing new below]
> -Original Me
, ?, ? ) ";
my $sth = $dbh->prepare( $sql );
die $dbh->errstr if $dbh->err;
What am I ding wrong?
Thanks,
Jerry
---Original Message-
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 5:13 AM
To: 'Logan, David (SST - Adelaide)'; '
treet,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Monday, 28 February 2005 8:41 AM
To: Logan, David (SST - Adelaide); mysql@lists.mysql.com
Subject: RE: insert data
D
David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 3:27 PM
To: Gerald Preston; mysql@lists.mysql.com
Subject: RE: insert data
Hi Gerald,
The only thing I can think of is that you have a syntax error in your
SQL that hasn't showed up in translation to email. Are
ECTED]
Sent: Monday, 28 February 2005 7:49 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: insert data
The object used:
my $dbh=DBI->connect( 'DBI:mysql:database=club', 'xxx, 'x', {
PrintError => 0} ) or die $DBI::errstr;
Jerry
-Original Messag
The object used:
my $dbh=DBI->connect( 'DBI:mysql:database=club', 'xxx, 'x', {
PrintError => 0} ) or die $DBI::errstr;
Jerry
-Original Message-
From: John Doe [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 6:37 AM
To: mysql@lists.mysql.c
Hi Gerald
> I am trying to insert data for the first time using MySQL. In Oracle I
> used the following:
>
> # my $sql = "insert into bar( group_name, me, daily, item, unit, qty,
> amount, tax, total )
>
> #
David,
Still the same error!.
Jerry
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 5:49 AM
To: Gerald Preston; mysql users
Subject: RE: insert data
Hi Gerald,
Try something like
my $sth = $dbh->prepare("ins
Logan, David (SST - Adelaide); 'mysql users'
Subject: RE: insert data
David,
The actual code is uncommented:
my $sql = "insert into bar( group_name, me, daily, item, unit, qty,
amount,
tax, total )
values( ?, ?, ?, ?,?,?, ?, ?, ? )
";
rald Preston [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 5:13 AM
To: 'Logan, David (SST - Adelaide)'; 'mysql users'
Subject: RE: insert data
David,
The actual code is uncommented:
my $sql = "insert into bar( group_
e) [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 5:09 AM
To: Gerald Preston; mysql users
Subject: RE: insert data
Hi Gerald,
If this is copied out of your perl code then you haven't put anything
into the $sql variable. Try uncommenting the 2 lines above.
Regards
David
8 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Sunday, 27 February 2005 9:33 PM
To: mysql users
Subject: insert data
Hi!
I am trying to insert data for the first time using MySQL. In Oracle I
used
the following:
# my
Hi!
I am trying to insert data for the first time using MySQL. In Oracle I used
the following:
# my $sql = "insert into bar( group_name, me, daily, item, unit, qty,
amount, tax, total )
# values( ?, ?, ?, ?,?,?, ?,
?, ? ) ";
Should mysql version 4.0.20 support the "Insert data from a textfile into table" which
is shown at the bottom of the page while in phpmyadmin with a database and table
selected? I am getting this error:
#1148 - The used command is not allowed with this MySQL version.
Thanks for any
eries hitting this table. Maybe someone else has a better
solution.
John A. McCaskey
-Original Message-
From: Grant Giddens [mailto:[EMAIL PROTECTED]
Sent: Monday, June 21, 2004 4:59 PM
To: [EMAIL PROTECTED]
Subject: Insert data if not duplicate based on order
Hi,
I have a table that has
Hi,
I have a table that has many rows. I want to be
able to insert a new row only if has a unique field of
the last 20 rows when I sort them by date.
Currently before I insert a new row, I will select a
specific field for 20 rows and run a for loop in php
looking for a match with the data I'm
"adrian Greeman" <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 1:47 AM
Subject: Re: ERROR ON INSERT DATA FROM FILE
Hello Adrian.
I'm not very experienced with MySQL, but I believe that you need special
privileges to
load data from a file.
Normally, other than the root user
"adrian Greeman" <[EMAIL PROTECTED]> wrote:
> I just tried to load edited data from a text file separated by |
> characters into a table in a simple data base
>
> I was using PhpMyAdmin version 2.5.6 and MySQL 4.0.18 running on Windows
> XP - I thought it was all set up right and configured prope
I just tried to load edited data from a text file separated by |
characters into a table in a simple data base
I was using PhpMyAdmin version 2.5.6 and MySQL 4.0.18 running on Windows
XP - I thought it was all set up right and configured properly
- and earlier was able to populate the table with
ED]
> Subject: Re: Inserting data into table1 should insert data
> into table2's FK ???
>
> "Paul Fine" <[EMAIL PROTECTED]> wrote:
> >
> > If I have two tables with the first table containing a
> field which is FK of
> > table 2, when I inse
"Paul Fine" <[EMAIL PROTECTED]> wrote:
>
> If I have two tables with the first table containing a field which is FK of
> table 2, when I insert a value into this field, should it not automagically
> insert a value into that PK in the second table?
>
No, it shou
Du
If I have two tables with the first table containing a field which is FK of
table 2, when I insert a value into this field, should it not automagically
insert a value into that PK in the second table?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
hi,
the MySQL syntax said:
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ((expression | DEFAULT),...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
or INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(co
At 15:09 28.10.2003 -0600, gerald_clark wrote:
Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status,
Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status, creation_date,
last_login_date) values ('35F7A
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I have
problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status, creation_date,
last_login_date) values ('35F7A660096411D89BC0D1907F
ctober 10, 2003 1:07 PM
> To: [EMAIL PROTECTED]
> Subject: Shell Script to Insert Data
>
>
> I am trying to create a script that will insert data. Right
> now I am just using something simple to test this out, but I
> can't get it to work. Here is what I have.
>
Mike Tuller wrote:
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES ("valu
t the file through a pipe to mysql.
Mike Tuller wrote:
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_
Put the full path to mysql in the script...
Jeff
> -Original Message-
> From: Mike Tuller [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 10, 2003 1:07 PM
> To: [EMAIL PROTECTED]
> Subject: Shell Script to Insert Data
>
>
> I am trying to create a scri
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES ("value");
After I
On Wed, 24 Sep 2003 14:23:04 -0500
"Dan J. Rychlik" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a question about INSERTing data into 2 different tables with one statement.
> Can you do this?
>
> INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ','
> USERPHONE') AND tab
Hello,
I have a question about INSERTing data into 2 different tables with one statement.
Can you do this?
INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ',' USERPHONE')
AND table2 (name) VALUES( ' USER ');
-Dan
this, in my opinion.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "CM Miller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, 11 June, 2003 08:04
Subject: RE: Can'
On Tuesday 10 June 2003 22:49, CM Miller wrote:
>
> globals >back to ON.
>
> Sorry, but I am a bit behind on MySQL digest, but
> isn't turning Register Globals 'on' for php a security
> risk?
Yes. He needs to take a look at the documentation on the PHP website. I also
sent instructions on how t
[snip]
Sorry, but I am a bit behind on MySQL digest, but
isn't turning Register Globals 'on' for php a security
risk?
[/snip]
We recently had this discussion on the PHP-General list and the upshot
is that having register_globals 'on' is only a security risk if the code
is sloppy. PHP allows this
>I started troubleshooting the code and discovered the
>problem was the
>new
>register globals which is defaulted to off in PHP
4.22. >The PHP
>wasn't
>holding session and wasn't inserting the records into
>the mySQL
>database.
>I got it working now by switching the register
globals >back to
er globals back to ON.
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 08, 2003 1:35 AM
Subject: Re: Can't insert data from Apache/PHP
> So the next step would be to provide us with the
[EMAIL PROTECTED]>
Sent: Sunday, 08 June, 2003 01:55
Subject: Re: Can't insert data from Apache/PHP
Yep...figured that out.
Thank You
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 07, 2003 6:48 PM
Yep...figured that out.
Thank You
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 07, 2003 6:48 PM
Subject: Re: Can't insert data from Apache/PHP
> That points to a fault in your coding becau
9
Subject: More: Can't insert data from Apache/PHP
It looks like I can insert data through phpMyadmin without issue. The only
place I can't insert data is through PHP running via the web server.
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 07, 2003 5:03 PM
Subject: Can't
It looks like I can insert data through phpMyadmin without issue. The only
place I can't insert data is through PHP running via the web server.
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 07, 2003 5:03 PM
Subject: Can't insert data from Apache/PHP
> I've had to re
I've had to reinstall Linux/Apache and mySQL. The databases are restored,
the data looks to be there, the permissions look to be there. However, I
can't seem "INSERT" data into the tablesits the only thing I can't
do...and I don't see a problem with the permiss
**
-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]]
Sent: December 14, 2002 22:11
To: MySQL List
Subject: Re: Connecting M. Access Forms to insert data into mysql
I've installed about 12 client gui's and here's my conclusion.
DBQwikEdit
- has the best editor for Da
dly. Is using Access the way to
go or is there a product I'm missing?
- Original Message -
From: "Grant Cooper" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, December 14, 2002 6:49 PM
Subject: Connecting M. Access Forms to
I am trying to find a package to insert data. And was wondering if I can use
odbc drivers to connect Access to mysql in real time?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
VINOD wrote:
> I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table
>"count". I have installed Apache Server on 98 machine and try to execute the
>following PHP script to insert the data. I was not able to post the data and got an
>error
>
>
> Method Not Allowed
>
>
I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table "count".
I have installed Apache Server on 98 machine and try to execute the following PHP
script to insert the data. I was not able to post the data and got an error
Method Not Allowed
The requested method POST is
Also check out http://www.mysqlfront.de.
No disrespect intended to MySQL. :)
Regards,
Kevin Smith
-Original Message-
From: Victoria Reznichenko <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Tue, 26 Feb 2002 11:14:01 +0200
Subject: Easy way to insert data in MySQL DB
> Ad
d to use Sql language to
AA> insert data. Any software or tools like Microsoft Access or Lotus Approach
AA> which can make ppl who are not familar to MySQL can insert data very easy??
AA> And they are free?
Take a look at MyCC. See in the manual:
http://www.mysql.com/downloads/gui-
Hi,
Thx for all your help, I can export the tables in exportSQL scripts.
But how to make the procedure of inserting data more easy instead of
using mysql daemon od MySQL GUI?? Both of them need to use Sql language to
insert data. Any software or tools like Microsoft Access or Lotus Approach
Hello all. This is a snippet from my JavaBean that I'm using to insert data
into MySql database.
The bean is working perfectly alright but I can't insert data into the user
table. Please help and do tell what I'm doing wrong here.
This is the code:
public String sav
77 matches
Mail list logo
