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. Plea

Re: telnet localhost 3306 Connection refused

> inet addr:10.10.10.1 <http://10.10.10.1> > Bcast:10.255.255.255<http://10.255.255.255>Mask: > 255.255.255.0 <http://255.255.255.0> > > > -- > 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 -- 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

Re: Embedded MySQL for Symbian ?

fun online and more. Check it out! > http://discover.yahoo.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 -- under development

show duplicate entries

t i dont know 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

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]

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

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 Mi

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

MySQL ... | ++---+---+ 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 Mir

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

gt; > 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

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: using max() on update

in field list is ambiguous mysql> - 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.

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

er Caine <[EMAIL PROTECTED]> 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 : Inv

using max() on update

: 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:/

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 PROTEC

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

Re: how to select last date by current time?

ubject: 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 "mo

how to select last date by current time?

AC/PA' 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: updating/altering each field on a table

an see, 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

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

Re: deleting a data of fields on a table

> table so 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 Mir

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]

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]

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

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: 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? > Pro

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

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

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.

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 pr

select some part, but excluding something.

| | | depleted | 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.c

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

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://lis

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

Re: auto increment

lly, when its 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

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 t

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]>

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

reading packet from server: Binary log is not open (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) ---

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 - Bef

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 PROTEC

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

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

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

--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) http:

--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) http://

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 > Li

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 ser

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 L

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 mysq

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

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... --

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

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 TABL

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: Ins

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