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 http://www.axishift.com -- under development
Re: telnet localhost 3306 Connection refused
ps ax|grep sql if mysql is running. and if you telnet to that port (3306) and still you can't connect. check if you have blocked your port on your firewall. usually, firewall for linux are iptables and ipchains flush them first and try. HTH On 7/7/05, Daevid Vincent [EMAIL PROTECTED] wrote: What is causing me to have this problem in mysql Ver 12.22 Distrib 4.0.24 , for pc-linux-gnu (i686). I am running shorewall, but that shouldn't affect localhost should it? My firewall, web, and mySQL server are the same machine. # telnet localhost 3306 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused I've tried to comment, uncomment and change to * this 'bind-address' line in /etc/mysql/my.cnf # keep secure by default! #bind-address = 127.0.0.1 http://127.0.0.1 #bind-address = * port = 3306 Of course, I can't connect from any of the other IP addresses that my mySQL server is assigned either: # telnet 192.168.1.1 http://192.168.1.1 3306 Trying 192.168.1.1... telnet: Unable to connect to remote host: Connection refused # telnet 10.10.10.1 http://10.10.10.1 3306 Trying 10.10.10.1... telnet: Unable to connect to remote host: Connection refused # ifconfig eth1 Link encap:Ethernet inet addr:192.168.1.1 http://192.168.1.1 Bcast:192.168.1.255http://192.168.1.255Mask: 255.255.255.0 http://255.255.255.0 lo Link encap:Local Loopback inet addr:127.0.0.1 http://127.0.0.1 Mask:255.0.0.0 http://255.0.0.0 wlan0 Link encap:Ethernet inet addr:10.10.10.1 http://10.10.10.1 Bcast:10.255.255.255http://10.255.255.255Mask: 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 ?
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: Hi, I am new to this group...Just wanted to findout whether Embedded MySQL library is available for Symbian ( Series 60 platform).Any effort going on in this direction..? Any idea about the rough memory footprint.. With Regards Ajit.S __ Discover Yahoo! Use Yahoo! to plan a weekend, have 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
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: Hi, I am new to this group...Just wanted to findout whether Embedded MySQL library is available for Symbian ( Series 60 platform).Any effort going on in this direction..? Any idea about the rough memory footprint.. With Regards Ajit.S __ Discover Yahoo! Use Yahoo! to plan a weekend, have 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 -- Louie Miranda http://www.axishift.com -- under development
show duplicate entries
mysql select count(*) - count(distinct username,email) as 'duplicate names' from users; +-+ | duplicate names | +-+ | 2 | +-+ 1 row in set (0.00 sec) I got this select syntax to count how many duplicate entries i have. But 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
Im trying not to list the rows that has zero values. this is my current select statement: select id,country_city from rates_ocean order by country_city The fields that i have to detect are: fieldvalue1 fieldvalue2 fieldvalue3 how can i do this on mysql, ex: select country from rates (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
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 (weight_kg,a,b,c,d,e,f,g,h,1,2) values ** error: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server 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://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 error. insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,1,2) values ** error: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server 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. Put backtics around any table or field name that might be misparsed by mysql. This lets you use numbers, spaces, or even reserved words: insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,`1`,`2`) values If you look at the queries generated by myodbc, you'll see this a lot (it plays safe and quotes everything) -- Dan Nelson [EMAIL PROTECTED] -- 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]
match a fulltext search with a - dash, can't match if - exist
this is a working example i found on mysql.com this is my example of fullsearch mysql desc fullsearch; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(10) unsigned | | PRI | NULL| auto_increment | | title | varchar(200) | YES | MUL | NULL|| | body | text | YES | | NULL|| +---+--+--+-+-++ 3 rows in set (0.00 sec) my data: mysql select * from fullsearch; ++---+---+ | id | title | body | ++---+---+ | 1 | MySQL Tutorial| DBMS stands for DataBase ... | | 2 | How To Use MySQL Well | After you went through a ... | | 3 | Optimizing MySQL | In this tutorial we will show ... | | 4 | 1001 MySQL Tricks | 1. Never run mysqld as root. 2. ... | | 5 | MySQL vs. YourSQL | In the following database comparison ... | | 6 | 018-E | Test for Title Item COde search language, etc | | 7 | MySQL Security| When configured properly, 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 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]
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://lists.mysql.com/[EMAIL PROTECTED]
Re: storing international char, like (Arabic, Russian) on mysql
thank you very much On Tue, 3 Aug 2004 20:08:51 -0500 (CDT), [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello, I have made apresentation at MySQLs UC2004 about using Japanese character sets with MySQL. You may find this a good starting point. Links are below: http://dev.mysql.com/doc/mysql/en/Charset.html http://www.be-known-online.com/mysql I hope you find this information useful Best regards Nils Valentin 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://lists.mysql.com/[EMAIL PROTECTED] -- 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]
using max() on update
Just recently post a problem on how can i see all max(dateposted) on all of my records by doing this.. select datacount,office,filename,status, max(dateposted) from dCOPY group by office; now, i was wondering if i can use max() on update to update all my current records only.. i tried 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 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP] Re: select * on all current?
mysql update dCOPY set status = '1' where dateposted = max(dateposted); ERROR : Invalid use of group function mysql not working.. :( o btw.. i just opened another email topic, so it will be divided by topic already. thanks On Tue, 27 Jul 2004 08:04:01 +0100, Lester 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 : Invalid use of group function WHERE dateposted = max(dateposted); Perhaps ( works in Firebird :) ) -- Lester Caine - L.S.Caine Electronic Services -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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: using max() on update
Hi, i was able to try your suggestion. But error seems to show up when updating already... +---++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---++--+-+-+---+ | datacount | int(255) | | | 0 | | | office| varchar(255) | | | | | | filename | varchar(255) | | | | | | status| enum('0','1') | | | 0 | | | maxdate | varchar(10) binary | YES | | NULL| | +---++--+-+-+---+ 5 rows in set (0.00 sec) mysql update dCOPY d inner join tmpupdateme tum on tum.office = d.office and tum.maxdate = d.dateposted set status = 1; ERROR 1052: Column: 'status' 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. If I need all of the data from the row that contains the maximum of an unindexed column: SELECT @maxval := MAX(column_name) FROM tablename; SELECT * FROM tablename WHERE column_name = @maxval; For the same thing but for an indexed column SELECT * FROM tablename ORDER BY column_name DESC LIMIT1; To get all of the rows that contain the MAX() value of column2 for all values of column1, I need to use a temporary table: CREATE TEMPORARY TABLE tmpMax SELECT column1, MAX(column2) as maxval FROM tablename GROUP BY column1; SELECT * FROM tablename t INNER JOIN tmpMax tm ON tm.column1 = t.column1 AND tm.column2 = t.column2; Now for your case. You need to update all of the rows that have the most recent dateposted for each office value. CREATE TEMPORARY TABLE tmpUpdateMe SELECT office, MAX(dateposted) as maxdate FROM dCOPY GROUP BY office; UPDATE dCOPY d INNER JOIN tmpUpdateMe tum ON tum.office = d.office AND tum.maxdate = d.dateposted SET status = 1; You should only need to wrap the 1 with quotes (like '1') if you are trying to insert it into a character-based field. You do not need quotes on any numeric value being assigned to a numeric column. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Louie Miranda [EMAIL PROTECTED] wrote on 07/27/2004 03:04:27 AM: Just recently post a problem on how can i see all max(dateposted) on all of my records by doing this.. select datacount,office,filename,status, max(dateposted) from dCOPY group by office; now, i was wondering if i can use max() on update to update all my current records only.. i tried 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 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- 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]
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://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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] wrote: 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://www.axishift.com -- 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: how to select last date by current time?
thanks! this is what i had been looking for. the last example you had, is not working on my mysql version. btw, im using 4.0. does not have nested select still. thanks, Louie - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Fri, 16 Jul 2004 09:11:39 -0400 Subject: 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, filename FROM datafiles WHERE office='AC/PA' ORDER BY dateposted desc LIMIT 1; OR you could also ask for that same record this way (depending on your MySQL version): SELECT dateposted, filename FROM datafiles d INNER JOIN (SELECT MAX(dateposted) as maxdate FROM datafiles WHERE office='AC/PA') as mx ON mx.maxdate = d.dateposted WHERE office='AC/PA' Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Louie Miranda [EMAIL PROTECTED] wrote on 07/16/2004 03:11:02 AM: List, How can i issue a query that can select last dateposted (FIELD)? My table: - dateposted, format: -MM-DD This is my current sql query which catches in desc order for dateposted and list only 10 sql data. select dateposted, filename, description from datafiles where office = '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] -- 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]
how to select last date by current time?
List, How can i issue a query that can select last dateposted (FIELD)? My table: - dateposted, format: -MM-DD This is my current sql query which catches in desc order for dateposted and list only 10 sql data. select dateposted, filename, description from datafiles where office = '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: 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
sorry for the confusion, but i did found another way. which is the update syntax. all is working fine now, thanks! On Thu, 8 Jul 2004 16:18:31 +1000, Lachlan Mulcahy [EMAIL PROTECTED] wrote: Louie, Can you please clarify if you are wishing to change the structure of the 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 Miranda [mailto:[EMAIL PROTECTED] Sent: Thursday, 8 July 2004 3:46 PM To: [EMAIL PROTECTED] Subject: deleting a data of fields on a table Is it possible to delete only a specific field on a table? lets say i have. table: dump field: - countid - random - name countid, is an auto increment field random, is a random words, etc name, is a field for specifiying where they belong. Now, how can i delete a specific data on each field? -- 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] -- 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
updating/altering each field on a table
Im trying to work on a program that can update each field and insert a random value on it. But when i run this program it only updates the whole random field. Can anyone help me? Im pretty clueless how to work this right. :/ ### #!/bin/sh -x for random in `pwgen --no-capitalize -N1` do sleep 0 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://lists.mysql.com/[EMAIL PROTECTED]
Re: updating/altering each field on a table
Btw, here are the sample database i have. mysql select * from dump; +-+--+--+ | countid | random | name | +-+--+--+ | 1 | theeyahs | randpass | | 2 | ciuwaise | randpass | | 3 | ciuwaise | randpass | | 4 | ciuwaise | randpass | | 5 | ciuwaise | randpass | | 6 | ciuwaise | randpass | | 7 | ciuwaise | randpass | | 8 | ciuwaise | randpass | | 9 | ciuwaise | randpass | | 10 | ciuwaise | randpass | +-+--+--+ 10 rows in set (0.01 sec) mysql As you can 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 a program that can update each field and insert a random value on it. But when i run this program it only updates the whole random field. Can anyone help me? Im pretty clueless how to work this right. :/ ### #!/bin/sh -x for random in `pwgen --no-capitalize -N1` do sleep 0 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 -- 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
Is it possible to delete only a specific field on a table? lets say i have. table: dump field: - countid - random - name countid, is an auto increment field random, is a random words, etc name, is a field for specifiying where they belong. Now, how can i delete a specific data on each field? -- 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?
Hi, Im just a new comer on mysql and i was in the middle of debugging some codes that aint mine. I was stuck here. I could not figure what does this select do? Its complicated.. Can anyone help me out? select * from shopcart inner join items on shopcart.itemId = iip.itemId where 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 Message - From: David Griffiths [EMAIL PROTECTED] To: Louie Miranda [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 04, 2004 3:44 PM Subject: Re: What does this sql query mean? Louie, The inner-join is just joining the two tables, shopcart and items. I think iip is an alias for items, but the alias would normally come after the name of the tiems table. Another way to write the query is (assuming iip is an alias for items), SELECT * FROM shopcart, items iip WHERE shopcart.itemID = iip.itemID AND shopcart.cookieId = '4bfa673ee4c544d4352e2c70a78b70b5' order by iip.itemName asc The inner-join is just an alternative to what's above. I read on some site that there were two advantages: 1) Kept the the WHERE-clause a bit simpler 2) Was a bit faster, as the tables were pre-matched; I doubt this, and the source wasn't particularily trustworth. The MySQL manual doesn't mention any performance gains from using the INNER-JOIN functionality Here's the relevant MySQL manual page: http://dev.mysql.com/doc/mysql/en/JOIN.html The relevant section: INNER JOIN and , (comma) are semantically equivalent in the absence of a join condition: both will produce a Cartesian product between the specified tables (that is, each and every row in the first table will be joined onto all rows in the second table). By comma, they mean the comma seperating the two tables in the FROM clause, as I've written it above (FROM shopcart, items). David Louie Miranda wrote: Hi, Im just a new comer on mysql and i was in the middle of debugging some codes that aint mine. I was stuck here. I could not figure what does this select do? Its complicated.. Can anyone help me out? select * from shopcart inner join items on shopcart.itemId = iip.itemId where 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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? Probable cause: 'order' is a reserved word in MySQL (as used in 'order by'). Terry --Original Message- 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 http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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://lists.mysql.com/[EMAIL PROTECTED]
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 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select some part, but excluding something.
select product_code,title,language,issue,category,cost from iip_t_cp where language = 'english'; I do this when selecting my database tables. But i would like to exclude one table depleted i have not included it on the select option but it is listed under language. Here are the tables mysql desc iip_t_cp; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | product_code | varchar(255) | | PRI | | | | title| varchar(255) | | | | | | language | varchar(255) | | | | | | issue| varchar(255) | | | | | | category | varchar(255) | | | | | | cost | varchar(255) | | | | | | 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.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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,category,cost from iip_t_cp where language = 'english'; I do this when selecting my database tables. But i would like to exclude one table depleted i have not included it on the select option but it is listed under language. Here are the tables mysql desc iip_t_cp; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | product_code | varchar(255) | | PRI | | | | title| varchar(255) | | | | | | language | varchar(255) | | | | | | issue| varchar(255) | | | | | | category | varchar(255) | | | | | | cost | varchar(255) | | | | | | 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.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 to change the values, to 2003-01 and so on.. Im tired just using the numbers from 1 and so on.. - Louie 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: auto increment
When i exported the data, i found an option on the lower part of the sql code. ) TYPE=MyISAM AUTO_INCREMENT=0 ; I tried to make a table again, and when i entered it resets to whatever options i last type it on the AUTO_INCREMENT=0 value. I still didnt see how to reset it manually, 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: Thursday, September 25, 2003 11:00 AM Subject: RE: auto increment Hi, Check the behaviour of auto_increment in the change logs - it changed from using the highest available number to carrying on from where it left off some time ago, but I believe there is a was to reset it manually. Hope this helps. Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net -Original Message- From: Louie Miranda [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 September 2003 2:58 p.m. To: [EMAIL PROTECTED] Subject: 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 to change the values, to 2003-01 and so on.. Im tired just using the numbers from 1 and so on.. - Louie http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Subject: phpMyadmin Quick one... is this program just for Linux? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql replication (Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000)
021009 12:56:49 mysqld started /usr/sbin/mysqld: ready for connections 021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021009 12:56:49 Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000) 021009 12:56:49 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 021009 12:56:49 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 021009 12:56:49 Error 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) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, 2002 12:23 PM Subject: mysql 4.0.2 problems Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My problem is that when I go to connect to it I get the error: error while loading shared libraries: libmysqlclient.so.11: cannot open shared object file: No such file or directory Actually (just fixed it). All I had to do was and a soft link the the /lib directory. Anyone know if this is normal or not? -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
plan: moving mysql db to a fresh server! (help?)
Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for pc-linux-gnu (i686) my db(var) resides in /usr/mysql/var/. I have this new server which i have mysql too. Now what im thingking about is, instead of dumping all database/tables on my old redhat server. Compressing 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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: plan: moving mysql db to a fresh server! (help?) I think its...okey R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No. (Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: louie miranda [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:37 AM To: [EMAIL PROTECTED] Subject: plan: moving mysql db to a fresh server! (help?) Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for pc-linux-gnu (i686) my db(var) resides in /usr/mysql/var/. I have this new server which i have mysql too. Now what im thingking about is, instead of dumping all database/tables on my old redhat server. Compressing 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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, Monday, June 17, 2002, 8:33:46 AM, you wrote: LQq Please tell me how to add the max_connections of mysql. Please give me a example. max_connections is a mysqld variable. You can't add\drop max_connections, you can only increase\decrease its value. If you want to change default value (100), you can specify new values in my.cnf file in the [mysqld] section: [mysqld] set-variable = max_connections = # or start mysqld with -O max_connections=# options. LQq Best Regards, LQq Q.H Liu -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 out of space. As it did so somebody tried to write into some tables via the forum. Now there are three tables marked as still in use. Everything we tried did not work - they are definitely not in use any more. Even the debug mode we could do nothing to fix it. Is there a way to cut off the data in the end of the tables? Or a program we can use to get some of the data out of it? If anybody got another suggestion how to fix this problem just tell straight away :) c'Ya Timo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 and i have installed mysql MySQL-client-3.23.49a-1.i386.rpm .But now i m confused that how should i proceed?how to start the database and afterinstallation where r the folders/files created? Is there any manual for basic step on installation and starting the database and further proceeding ? Thanking You, mandar, India. _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 mysql, Is this advisable?. Your help is very much appreciated. ty, louie... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 info. ty, louie... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 set (0.00 sec) mysql lock table louie read; Query OK, 0 rows affected (0.00 sec) ty, louie... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 TABLE tableone; it has error.. how can i make a table w/ column? hmm.. thanks louie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? Thanks! Please send me the solution. E-mail : [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql w/SSL support howto?..
Is it possible for mysql 3.23.40 to support SSL. hm, how? i guess.. i will download, openssl? first. then ./configure -- etc make make install then, download the mysql source. then.. ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldfla gs=-all-static --with-ssl=../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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php