On 7/4/06, C K <[EMAIL PROTECTED]> wrote:
Thanks for your sugesstions. I tried to search this issue on
microsoft's website. and found that this problem is related with
timestamp fields. I have tried to connect from access 2k and 2003 to
mysql database. It works well for all the things. but gives
Thanks for your sugesstions. I tried to search this issue on
microsoft's website. and found that this problem is related with
timestamp fields. I have tried to connect from access 2k and 2003 to
mysql database. It works well for all the things. but gives above
error only when control jumps to subf
Try http://us2.php.net/manual/en/ref.mysql.php
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _
sharvan kumar wrote:
> Dear Sir/Madam
> I am working on a project where I am
> to use PHP as front end and MYSQL as backend.MySQL
> stand alone is working properly,but it is not
> connecting with PHP.Please tell me solution.
>
Connect it.
--
Daniel Kasak
IT Developer
NUS Consul
Dear Sir/Madam
I am working on a project where I am
to use PHP as front end and MYSQL as backend.MySQL
stand alone is working properly,but it is not
connecting with PHP.Please tell me solution.
__
Do You Yahoo!?
Tired of spam? Yaho
so i am doing a query on an enum field:
when i do this query:
select *, id as vid, user_id as uid from video where (file_complete =
'true') order by undt desc limit 0,10;
the results are 0.16 or 0.17 seconds.
instead of saying file_complete = 'true. if i say file_complete != to the
other 5 poss
GVIM is a great transition from vi to more 'modern' (read slower and
cumbersome!) editors.
It allows all the normal vi commands, but also 'standard' Windoze features like
Ctrl-C Ctrl-V for copy and paste, drag and drop selection etc.
Like all good editors, it takes time to get the most out of i
On 7/3/06, Jesse <[EMAIL PROTECTED]> wrote:
> There's GVIM for Windows, its the same program of Linux, I use it when
> there's no way but using Windows. Get it at www.vim.org ! Its a blast
> having the same (powerful, easy, fast and reliable) tool in windows
> and linux. But you'll find it kinda
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer usi
Oh, OK. I use MySQL Administrator frequently, but didn't realize that it
could selectively restore. I don't like to use it for backups, because it
doesn't get --routines and --triggers, and also doesn't backup in the format
that I use. But I'll consider that.
Thanks,
Jesse
- Original M
There's GVIM for Windows, its the same program of Linux, I use it when
there's no way but using Windows. Get it at www.vim.org ! Its a blast
having the same (powerful, easy, fast and reliable) tool in windows
and linux. But you'll find it kinda hard to learn at first, because of
the "command mode"
Jan Gomes wrote:
Pardon me, i think I din't express myself properly.
I did not only combining data elements.
My structure was:
Table_1{
id_table1 (int)
COLLUM 1 (int)
COLLUM 2 (int)
}
Table_2{
id_table1 (int)
COLLUM 1 (int)
COLLUM 2 (int)
}
Being a relationship between table
also, i would check that the user you are using for your mysql_connect in
php has the permissions to do the create table, etc.
On 7/2/06, Daniel Kasak <[EMAIL PROTECTED]> wrote:
Brian Menke wrote:
> MySQL version 5.0.16
>
> Windows XP
>
> PHP 5.
>
>
>
> I have this query that when I run it in
On 7/3/06, Jesse <[EMAIL PROTECTED]> wrote:
> --routines, -R
> and
> --triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
> 2) sometimes, I like to copy just a single table or so out of the backup
> file, and restore just that.
You might want to try out MySQL Administrator which can often be used to
restore backups from mysqldump. It can _selectively_ restore tables from a
backup file.
http://dev.mysql.com/doc/admi
--routines, -R
and
--triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
Change Editor ;-)
I personally use VIM and ne
Jesse wrote:
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe
a newer one wouldn't, but for the most part, it does a very good job for
me.
Ok never heard of multiedit... if your system is window
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
> I have very little knowledge of either PostgreeSQL or mySQL. Please advise
> me as to which of these two software package to use? I need some specific
> examples as to superiority of one package over the other. I prefer using
> the package wh
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe a
newer one wouldn't, but for the most part, it does a very good job for me.
try to use the --max_allowed_packet= option - afaik mysqldump will creat
On 7/3/06, Jesse <[EMAIL PROTECTED]> wrote:
I'm trying to determine the best way to back up my MySQL databases in such a
way that they can be easily restored, flexible, and complete. I've
experimented with physically copying the files (with disastrous results).
MySQLDump seems to be the way to g
Jesse wrote:
my editor forces a hard line break at column position 16384, which, of course, corrupts
the restore. I don't know if there are other text editors that will not do this,
Funny, i've never seen one that does? What system/editor are you using?
or even better, if there is a way to
On Mon, 3 Jul 2006, Stefan Hornburg wrote:
Duane Hill wrote:
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an er
I'm trying to determine the best way to back up my MySQL databases in such a
way that they can be easily restored, flexible, and complete. I've
experimented with physically copying the files (with disastrous results).
MySQLDump seems to be the way to go, but I've got two problems with that
whi
Hi All,
Thank you for u r valuable suggestions. I am trying to implement Sequence.
As i should not use AUTOINCREMENT, and Locking a table will slower my
application.
Thank you once again.
Duane Hill wrote:
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an error in the statement and to check the syntax.
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an error in the statement and to check the syntax. I know
it has som
Hi all,
I'm following the instructions [1] to convert character set. Unfortunately I get
warnings about truncated data for some rows in several columns. All the
truncated columns are text type.
Assuming the `col' column is text type and actually contains correct utf8 data
but has wrong character
28 matches
Mail list logo
