easy way to do it.
On Wed, Apr 16, 2008 at 5:30 PM, Arun Kumar PG <[EMAIL PROTECTED]>
wrote:
> hi,
>
> is there any other best way add a new column to an existing table having
> 60+ million records. alter is taking more than 1.5 hours.. what are the best
> practices around thi
hi,
is there any other best way add a new column to an existing table having 60+
million records. alter is taking more than 1.5 hours.. what are the best
practices around this. quick help will be appreciated.
--
cheers,
- a
I just want to see the original insert statement which failed, so that I can
do a search on it.
Is there any option for seeing the insert statement that gets executed and
the error line next to next.?
On 10/5/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Arun wrote:
> > I
see last run errors, like some errors that
are saved in the buffer. As I know this is the last sql statement that gets
executed.
On 10/5/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Arun wrote:
> > I have a large batch of insert sql statements, of which some of them are
>
I have a large batch of insert sql statements, of which some of them are
failing. I want to know which one is failing exactly.
Is there anyway I can debug it and which statement went wrong. I have only
4 or 5 out of 200 statements that are failing.
--
Thanks
Arun George
great. thx!
On 4/17/07, Daniel Kasak <[EMAIL PROTECTED]> wrote:
Arun Kumar PG wrote:
> Guys,
>
> I know this is a stupid thing but I wanted to know if we have an index
> on a
> column "X" and if i have a query having 1 OR conditions on the
> field e.g.
&g
Guys,
I know this is a stupid thing but I wanted to know if we have an index on a
column "X" and if i have a query having 1 OR conditions on the field e.g.
where X=10 OR x=12 OR x=13 OR x=15.. so on then will it give any
benefits in terms of speed?
thx
- A
But this slave can not have direct access to the master. Is
there a way I can achive this?
If the slave cannot have access to Master how can we call it as a Slave. I
would rather call that as a server where you want to dump the mysql/data
directory of the Master. better write a nightly shell scr
http://www.mysql.com/products/tools/migration-toolkit/
There is a video presentation as well here for ORacle to MySQL migration.
Thanks,
- Arun
On 3/12/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Friends,
Does any body know of any tool available for migrating data from oracle to
SELECT * FROM Dog GROUP BY FooId HAVING FooId = 1;
This should also work.
On 1/5/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi,
> dog
> fooID int
> size int
> id int
>
> dog
> fooIDsizeid
>1 2 1
>2 5 2
>1 5 3
>
> if i do a query
> sel
= 1)
---
[I do not want to use autoincrement fields or anyother MySql feature because
the application will have to work with Oracle or MySql :( ]
Thanks,
Arun N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
w, but it failed.
Could some one help me out here?
Create Function nvl(fieldVal INTEGER(10)) RETURNS INTEGER(10)
BEGIN
If fieldVal==null Then
return 1;
else
return fieldVal;
END
Regards,
Arun N
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.
Arun
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 18:38 -0800 12/27/02, Arun Kumar wrote:
> >Dear All,
> > I have a table 'X', I want to d
Dear All,
I have a table 'X', I want to display the record
in this table 'X' which has occupied the maximum
number of bytes, i.e i want a query/queries to
display the record with maximum size. I would also
like to print the
record size as well.
Any help in this front w
lso
> > like to print the record size as well.
> >
> > Any help in this front would be great.
> >
> > In anticipation.
> > Arun
> >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plu
I want to run mysqldump through a batch process, in
order to do that what prive do i need to give to the
user. It will be running as a cron job, i don't want
to give any creation or deletion authorization. Your
help will be greatly appreciated.
Regards
hi all,
my question is very simple
following is my code:
while($row=@mysql_fetch_array( $result1 ) )
{
$SrNo=$row["SrNo"]; echo $SrNo;
echo "
".$row["SrNo"]."
".$row["Company"]."
";
if ($SrCk=="on" )
mysql> load data infile "pet.txt" into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql> load data infile "pet.txt" into table pet;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 4
mysql> select * from pet;
+--++-
mysql> load data infile "pet.txt" into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql> load data infile "pet.txt" into table pet;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 4
mysql> select * from pet;
+--++-
hello everybody,
i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with
Apache 1.3.24 .
i have encounter following error for load data local infile when i
tried to use an example on mysql site's documentation file :
mysql> use test;
Database changed
mysql> show tables;
++
20 matches
Mail list logo
