select first then insert (same table)

Guys, How do i select and insert a data from 1 table to another with same table fields. mysql select * from cardv2_data where refcode = '10-44'; Is it like this?? mysql select * from cardv2_data where refcode = '10-44'; insert into * copy this to this table. Please help! -- Louie Miranda

Re: telnet localhost 3306 Connection refused

] -- Louie Miranda http://www.axishift.com -- under development

Re: Embedded MySQL for Symbian ?

Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Louie Miranda http://www.axishift.com -- under development

Re: Embedded MySQL for Symbian ?

I mean, much faster to other db that are currently on the symbian platform. On 6/15/05, Louie Miranda [EMAIL PROTECTED] wrote: that looks like a good idea, and im hoping it will be much faster. but, how can it ran on a symbian platform? On 6/15/05, AJIT SADASIVAN [EMAIL PROTECTED] wrote

show duplicate entries

how to show the duplicate entries i have on that table. Pls help! -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

detect rows that has zero values

(if fieldvalue1,fieldvalue2,fieldvalue3 = 0 (do not display)) order by country; -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

field name (1 and 2) causes error

version for the right syntax to use near '1,2) values (.5,10.4,17.33,19.64,21.42,22.58,24.26 How do we insert properly something on a field with that the name is numbers? or that aint right, im wrong. -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http

Re: field name (1 and 2) causes error

oh, ok. thank you! On Thu, 4 Nov 2004 01:16:21 -0600, Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Nov 04), Louie Miranda said: I did create a table and a fieldname of 1 and 2. when i did enter this query to insert on my sql, it causes error. insert into rates_fedex

match a fulltext search with a - dash, can't match if - exist

... | ++---+---+ my search the title with a - code mysql select * from fullsearch where match (title,body) against ('018-E'); Empty set (0.00 sec) it returns an empty set, is it possible to also search with - dash? chars? -- Louie Miranda http://www.axishift.com -- MySQL General

storing international char, like (Arabic, Russian) on mysql

Is it possible to store foreign language characters like arabic, russian, etc on mysql? when a user send out data via the web? where should i start? -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: storing international char, like (Arabic, Russian) on mysql

? -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http

using max() on update

this: mysql update dCOPY set status = '1' where max(dateposted); ERROR : Invalid use of group function mysql But as you can see, it returns an error for an invalid group function. -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: [PHP] Re: select * on all current?

] wrote: Louie Miranda wrote: now its working, i was wondering if we can do max(dateposted) on update? mysql update datafiles set status = '1' where max(dateposted); ERROR : Invalid use of group function WHERE dateposted = max(dateposted); Perhaps ( works in Firebird

Re: using max() on update

- Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tue, 27 Jul 2004 09:17:44 -0400 Subject: Re: using max() on update To: Louie Miranda [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Here's how I handle these situations. If I need all of the data from the row that contains

select * on all current?

I have a couple of fields: - office - dateposted - filename now, im having trouble selecting all current dateposted per office? i have tried.. sql select * from datafiles where dateposted current(); And i think its wrong, i could not find how to get it. -- Louie Miranda http

Re: select * on all current?

Is it also possible to use this? http://dev.mysql.com/doc/mysql/en/example-Maximum-row.html SELECT MAX(dateposted) FROM table; But instead do select all max(dateposted) on office? have tried it, but syntax errors occured. On Tue, 27 Jul 2004 11:13:43 +0800, Louie Miranda [EMAIL PROTECTED

Re: how to select last date by current time?

: Re: how to select last date by current time? To: Louie Miranda [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Louie, Do you want just the most recent date? You could run : SELECT MAX(dateposted) FROM datafiles WHERE office='AC/PA' OR if you want just the most recent record: SELECT dateposted

how to select last date by current time?

' order by dateposted desc limit 10; -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: deleting a data of fields on a table

Also i can use this: update users set password = ''; =) -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: deleting a data of fields on a table

that a particular column no longer exists or if you are just wanting to delete the data in a field (eg. set it to or NULL). Can you give a more specific example? Lachlan -Original Message- From: Louie Miranda [mailto:[EMAIL PROTECTED] Sent: Thursday, 8 July 2004 3:46 PM To: [EMAIL

updating/altering each field on a table

done echo $random for update in $random do echo update dump set random= '$random' limit 1|mysql -uroot insert done ## end of script ### -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: updating/altering each field on a table

, it updates the whole random field on the table. What i would like to do is, update each and everyone of it. using a random program, which i have. Its on my first email. On Thu, 8 Jul 2004 16:18:06 +0800, Louie Miranda [EMAIL PROTECTED] wrote: Im trying to work on a program that can update each

deleting a data of fields on a table

? -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What does this sql query mean?

shopcart.cookieId = '4bfa673ee4c544d4352e2c70a78b70b5' order by iip.itemName asc Thanks -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What does this sql query mean?

Great David, many thanks. I just solve another problem with the code. Thank you very much for the information. Now the iip is not an alias of items, the past programmer type it wrong. I was able to get all of the errors out too. Thanks -- - Louie Miranda http://www.axishift.com - Original

field = order, data not inserting?

I have a field named order i think im missing something obvious, but i cant find it. When i insert something on the field order via PHP, no data on all of my fields are being inserted. But when i tried to change the field name to orders data are now being inserted. Its weird. -- - Louie Miranda

Re: field = order, data not inserting?

well, that explains it. Many thanks! -- - Louie Miranda http://www.axishift.com - Original Message - From: Terry Riley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 3:35 PM Subject: Re: field = order, data not inserting? Probable cause: 'order' is a reserved

how do you update all data on table?

I have one table named Category under that all values contains Books How can i make all Books into Stocks? Im not familiar with the command -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Can't create/write to file './pricelists/iiptest.frm'

What is wrong with this? im just trying to copy the table to another table? ## MySQL said: #1 - Can't create/write to file './pricelists/iiptest.frm' (Errcode: 28) ## -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

select some part, but excluding something.

| varchar(255) | | | 0 | | +--+--+--+-+-+---+ 7 rows in set (0.00 sec) How can i do that? -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: select some part, but excluding something.

got it, tnx anywayz -- - Louie Miranda http://www.axishift.com - Original Message - From: Louie Miranda [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:02 PM Subject: select some part, but excluding something. select product_code,title,language,issue

Can't create/write to file

mysql alter table os_bcard drop mobile; ERROR 1: Can't create/write to file './rpcweb/#sql-1c6_23.MYI' (Errcode: 28) mysql anyone got any ideas what is this? -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Can't create/write to file

answer: http://www.mysql.com/doc/en/Cannot_create.html -- - Louie Miranda http://www.axishift.com - Original Message - From: Louie Miranda [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 12, 2004 2:39 PM Subject: Can't create/write to file mysql alter table os_bcard

does mysql supports russion language or any other language?

Hi, i have this form that goes directly.. to a database. I have some clients who dont use english. If they enter on a form a special russion or chinese character will mysql translate it properly? -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http

auto increment

I have a id_entry field that is doing auto increment on that field. Now, when i try to delete the numbers it still continues to count from where it left. ex: i have entrys 1|one 2|two once i deleted 1|one on the field or even 2|two it still counts to 3|three and so on And is it also possible

Re: auto increment

live. And also changing increment numbers by date or similar. -- - Louie Miranda http://www.axishift.com - Original Message - From: Quentin Bennett [EMAIL PROTECTED] To: Louie Miranda [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:00 AM Subject: RE: auto

Re: phpMyadmin

I think not. As long as you have mysql and apache/php running it can run on any unix os i think. -- Thank you, Louie Miranda ([EMAIL PROTECTED]) - Original Message - From: Michael G. Tracey [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:59 PM

mysql replication (Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000)

(read_errno 0,server_errno=2000) Im doing mysql replication, i cant figure this error Binary log is not open ? -- thanks, louie miranda chikka asia, inc. noc +63-2(7535000-511) - Before posting, please check: http://www.mysql.com

mysql - replica problems

020920 20:32:39 Slave thread: error connecting to master: Unknown MySQL Server Host '' (2) (107), retry in 60 sec Im havint this errors when i start my master server, any info on this would be great!! -- thanks, louie -

MySQL inserting into db (used load data)

I got the file using load data infile (transfer) [root@atsome host]# mysql -uroot db file.sql ERROR 2006 at line 1: MySQL server has gone away When i try to do this command it issues this error, whay is that? I also tried doing integritycheck on my db. No problem actually. Thanks, Louie...

Re: mysql 4.0.2 problems

Add the mysql lib path on /etc/ld.so.conf and type ldconfig. :) = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20

plan: moving mysql db to a fresh server! (help?)

and moving it all */var/* to my new server's */var/* directory. What do u think? = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Before posting, please check

Re: plan: moving mysql db to a fresh server! (help?)

salamat kabayan!! thnx! = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:02 AM Subject: RE

--skip-locking options!

http://www.mysql.com/doc/C/r/Crash_recovery.html Is this very reliable? Coz im planning to remove the --skip-locking options. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual)

--skip-locking options!

http://www.mysql.com/doc/C/r/Crash_recovery.html Is this very reliable? Coz im planning to remove the --skip-locking options. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: How to add the max_connections

Yes, thanks a lot. I still have a question though. Up to how many connection can mysql handle? Thanks, Louie... - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 3:29 PM Subject: Re: How to add the max_connections Liu,

Re: Database Error

Uhm, get a bigger HD stop and move all DB/Files to that and edit your my.cnf file and restart? :) - Original Message - From: [EFR]The HEAD [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 5:38 PM Subject: Database Error Hi, the harddisk of the mysql server ran

Re: installation problem

folders = /var/lib/mysql - db tables i think.. commands will be on bin* dir, i think 2. louie. - Original Message - From: mandar m pohnerkar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 1:49 PM Subject: installation problem Dear Sir, I have R.H Linux 7.2

does my mysql/os version affects stability of my DBFiles?

MySQL Version: 3.23.48-log OS/RedHat 7.2 / gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Hi, this are the versions of my mysql and OS, i compiled them thru source. I am aware of the problem that exists on mysql ver 3.23.49 and w/ gcc version 2.96. So i de-graded by only 1 version of

Locking TABLES for myisamchk, please help!!

Hi, i was thingking about locking the tables first so no connection could write so i can do myisamchk. Is this process safe? Procedures: 1. lockdb 2. run myisamchk -r or -o 3. unlock db Btw, mysqld is running. I want to off it but i can't its a production server. Hope anyone could give me more

Locking TABLES, help.

Hi, I have a scenario.. I lock this mysql table and then a query/insert came in one of my script's. the table is locked, what will happen to that query? Will it retry again to insert on that table or no, it will not. ty, louie...

MySQL Query/rows question.

Hi, i was just wondering... i have inserted 1 row on my table, how come when i did lock table. Mysql did not see one of my insert. Please check mail below, thanks. mysql select * from louie2; ++---+ | id | firstname | ++---+ | 1 | louie | ++---+ 1 row in

how to create a table and a column..?

i know this is easy for some of you guys, im just starting making some tables and column.. and can't figure out how, ive read the manual and can't seem to understand it yet fully. just want to try this but can't seem to work.. i tried creating a table and a column.. like.. mysql CREATE

Re: Installing MySQL on Linux 7.1

rpm -i mysql.rpm ? louie miranda (axishift.ath.cx) --- Security is not a product - It is a Process - Original Message - From: Alan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 10, 2001 3:45 PM Subject: Installing MySQL on Linux 7.1

mysql w/SSL support howto?..

=../openssl-ver# make make install am i correct? or better yet try and download the mysql 4 ? hehe, hope someone could help me out here.. ty louie miranda --- (axishift.ath.cx) PGPID: 0xDABA60C7

how to delete a database table?

how can i delete a database table? ty louie miranda --- (axishift.ath.cx) PGPID: 0xDABA60C7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http