how can i get a table array of a database

hello,sir; i do know i can use "show tables" to get the table names list.but i need get a table name array to use in my application.like the array i get by "select" function . how can i do it?thank you! yin du

MySQL set up plan

Hi All, Currently I have four websites using one MySQL server. The MySQL and the four websites each is placed on different server. However this MySQL server, I dont know why after running for a few days can stop responding that I have to restart the MySQL server. This caused my four websites also

Re: Restricted access to Mysql through a CGI script

At 20:41 14-02-2001 -0500, sachin shetty wrote: >Hello > >I am accessing a mysql database through a CGI script , but wouldnt like to >give the passwords in the script. Your web account probably contains two types of directories: Those accessible via the web and those that are not. As a rule, you

Get error message "Test" sometimes then daemon crashes

Hi all. Sometimes (usually after using MySQLFront) I get a Windows message box that says "Test", then the daemon crashes. Any ideas? Lee Jenkins General Operations DataTrak Business Solutions 910-326-4181 mailto: [EMAIL PROTECTED] (Email) http://www.datatrakpos.com

Re: trigger

Yes it is... thanks... but not really. I need a trigger that will execute a program if a particular row has been added to the table. Something like the trigger feature of postgreSQL. Dennis At 12:59 AM 2/15/01 -0300, Fábio Ottolini wrote: >Well... I have created a trigger using Perl and cront

how to know databases space information?

hello,sir i had created a database for user on my server,i want to know how much space of the database have been used,and how much left. in sql server i do it with some stored precedures, but i did not found same stored precedures in mysql,please tell me what to do and why to do like

Can`t connect to local MySQL server...

Hi, start the sqfe_mysqld which will be in the /bin directory where mysql is installed. regards, S.Chitra

Re: ERROT:2002:Cann't connect to local MySQL Server throught socket'/var/lib/mysql/mysql.sock' (111)

Connection refused, maybe mysqld is not running. for general trouble shhoting, try perror --ilham-- On Thu, 15 Feb 2001, mik wrote: > ERROT:2002:Cann't connect to local MySQL Server throught socket >'/var/lib/mysql/mysql.sock' (111) > [EMAIL PROTECTED] > > > ---

Re: ERROT:2002:Cann't connect to local MySQL Server throught socket '/var/lib/mysql/mysql.sock' (111)

我中文不好 你還沒開mysql server. 你看中文mysql說明 Cheers Rolf - Original Message - From: "唐海雄" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 15, 2001 10:30 Subject: ERROT:2002:Cann't connect to local MySQL Server throught socket '/var/lib/my

Re: Simple Query

Perfect! Thanks... http://www.bustdustr.net Home Of Radio Free BD > SELECT * FROM tableA left join tableb on tablea.prod_id = tableb.prod_id > where tableb.prod_id is NULL; > > -Original Message- > From: BD [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 15 February 2001 15:16 > To: [EMAIL

RE: Simple Query

SELECT * FROM tableA left join tableb on tablea.prod_id = tableb.prod_id where tableb.prod_id is NULL; -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 February 2001 15:16 To: [EMAIL PROTECTED] Subject: Simple Query For a database cleanup project... Table A: pr

Re: trigger

Well... I have created a trigger using Perl and crontab (Linux). But I could use C, C++, PHP and so on... Is that relevant to your question? - Original Message - From: "Dennis B. Manlangit" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 10:34 PM Subject: tr

ERROT:2002:Cann't connect to local MySQL Server throught socket '/var/lib/mysql/mysql.sock' (111)

ERROT:2002:Cann't connect to local MySQL Server throught socket '/var/lib/mysql/mysql.sock' (111) [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

ERROT:2002:Cann't connect to local MySQL Server throught socket '/var/lib/mysql/mysql.sock' (111)

ERROT:2002:Cann't connect to local MySQL Server throught socket '/var/lib/mysql/mysql.sock' (111) --- 163µç×ÓÓʾ֣¬¸øÄú¸üÍêÃÀEmail·þÎñ£¡ http://www.163.net - Before posting, plea

RE: Restricted access to Mysql through a CGI script

Hi, Make an include file with your connection function and set the proper permission and call it in your cgi script. If you want to restrict table to users it can be done with a simple mysql stmt. It would look something like: GRANT previleges_you_want_give ON db_name.table_name TO your_user_na

Simple Query

For a database cleanup project... Table A: prod_id, prod_desc Table B: prod_id, prod_price, (and various other fields) Would like to come up with a query that will give me a list of all rows in Table A that don't exist in Table B... I've tried several different ways, but can't seem to come up wi

Linking problems.

I am unable to link libmysqlclient staticlly. I have tryed everything I could have thought, please look at the linking below, I tried to look for the file my_compress.o and my file system and I was unable to find it. gcc -g -Wall -O6 -static -o webchart.cgi -L../../mieutils/linux/lib ../../mie

Is there any API to pass in SQL stmt in meeting-pro db?

Hi All, Does anyone know if there is any API in DBI or PHP that will allow to connect and pass in sql statements in meeting-pro database? Thanks in advance for any suggestions. James R. Butzen NEBIS Tech http://www.nebis.com

Re: ...import access into MySQL...

Below is from a previous posting. It may help you. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 15, 2001 6:27 Subject: ...import access into MySQL... > Hi: > > > i am currently running a MySQL db on an Apache server and i was wondering,

trigger

Hi, All, Does anybody know if mysql support triggers? If not, is there a way to have a trigger in mysql? Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: how do I delete using a join in mySQL?

Yeah, I can educate you. Wait for the future version that will support such queries. See the "things to do" list in the manual. - Original Message - From: "Daevid Vincent" <[EMAIL PROTECTED]> To: "James R. Butzen" <[EMAIL PROTECTED]>; "mySQL Database" <[EMAIL PROTECTED]> Sent: Thursday,

Restricted access to Mysql through a CGI script

Hello I am accessing a mysql database through a CGI script , but wouldnt like to give the passwords in the script.The functionality involves restricting access to tables in the database for different users.Is there a way through which restricted view to the tables can be given via a configuration

RE: error in running mysql - this is after vigorous searching that im sending this email

Hi Srihari, I think the was a problem with your installation. Make sure you are installing proper version that is compatible with your hardware. Following steps works for me Pentium 3: ..]# tar zxf mysql-xx...tar.gz ..]# cd mysql-xx.. ..]# ./configure ..]# make ..]# make install ..]# cd /usr/loca

RE: how do I delete using a join in mySQL?

Hi, Unfortunately, I think you have already found the 'correct' way to do it in MySQL. At the moment, Deletes involving joins or sub-selects are not supported. Regards Quentin -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 February 2001 14:26 To:

RE: how do I delete using a join in mySQL?

> If I recall it right the statement should be following: > > DELETE FROM Contract_Table, Client_Table WHERE contract_client_id = > client_id > AND client_contact = 'corricello' AND contract_percent = 0; I made a copy of the database and tried this one, but it caused an error. I'm thinking someth

RE: error in running mysql - this is after vigorous searching that im sending this email

Well, since you're running a P4, I don't think you should be using this: mysql-3.23.33-unknown-linux-gnu-alphaev6 That's for Alpha processors. Instead, get this: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.33-pc-linux-gnu-i686.ta r.gz Compile the above. It should work better for you.

Re: error in running mysql - this is after vigorous searching that im sending this email

I can see your command line problem right now... ./mysqladmin is what you need to do, or add the mysql/bin dir to your path - Original Message - From: srihari suthamally To: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 4:36 PM Subject: error in running mysql - this is

RE: error in running mysql - this is after vigorous searching that im sending this email

Hi Srihari, Did you installed MySQL from the source or RPM? James R. Butzen http://www.nebis.com -Original Message- From: srihari suthamally [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 4:36 PM To: [EMAIL PROTECTED] Subject: error in running mysql - this is after vigoro

RE: how do I delete using a join in mySQL?

Hi, If I recall it right the statement should be following: DELETE FROM Contract_Table, Client_Table WHERE contract_client_id = client_id AND client_contact = 'corricello' AND contract_percent = 0; Thanks, James R. Butzen [EMAIL PROTECTED] NEBIS Tech Support http://www.nebis.com -Origina

error in running mysql - this is after vigorous searching that im sending this email

Hi   i have a dell pentium 4 computer i have both windows 2000 and linux-mandrake installed in my computer iits a dimension 8100 system   I am trying to run mysql in my linux machine i have mandrake version 7.1 installed for my linux machine   for the version and name of linux this is what i

SV: Here you have, ;o)

Well, you're probably lucky. My mail-gateway hasn't virusprotection at all, but thats pretty safe cause almost all anti-virus programs uses "chck for well known signatures" so common sence does it better... Does it check for inline messages?? --start 'Vbs.OnTheFly Created By OnTheFly Execute e7i

how do I delete using a join in mySQL?

hey, how do I DELETE all these Contract_Table records in mySQL? SELECT contract_id, client_contact, contract_percent FROM Contract_Table, Client_Table WHERE contract_client_id = client_id AND client_contact = 'corricello' AND contract_percent = 0; I see this page, but didn't know if it was da

Re: mySQL/php query help

> ok, here is the code that runs after the submit button is clicked. i now > suspect that it has something to do with my "if" statements. I haven´t really been following this from the beginning, but you seem to have forgotten something in the first elseif. $CuisineTemp = 'ALL' should be $Cui

general purpose database cleanup tools (design patterns or Python)?

A side effect of people using the Mojam and Musi-Cal web sites is that a fairly complex MySQL database gets built. There are several tables in the database (venues, concerts, cities, etc) that can accumulate errors fairly rapidly because the system allows anyone with concerts to publicize to add

Re: Table timestamps?

You might be able to use this, depending on your needs: from http://www.mysql.com/doc/D/A/DATETIME.html [snip] Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. The c

Re: taxes

Wound't you just set a table with an id, state_abrev, & tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: > does anyone know how to calculateg taxes for a shop cart that would set the > tax depending on the state that they select when filling

Re: Here you have, ;o)

My Outlook Express 5.0 shows that message have attachments, but it doesn't. - Original Message - From: Maciek Uhlig <[EMAIL PROTECTED]> To: Carsten Gehling <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 1:22 AM Subject: RE: Here you have, ;o) > Isn't it poss

Re: Help please: getting the total from the results of SUM

Did you try select count(*), sum(amount) from table1; you also can use ... count(if(field=value,1,NULL)) ... - Original Message - From: jerome auza <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 2:49 AM Subject: Help please: getting the total from the resu

You should do a make install before executing this script!

Can someone tell me what is the problem with this message when i tried to create teh MySQL grant tables by running mysql_install_db? When I type in make install, the system cannot find make. What should I do beside setting up my path to include "make"? Is this a known problem? --

Re: Can anyone do this ?

Hi Bob/ All, I cannot get the creation of the TEMPORARY Table to work: The select statement works fine: mysql> SELECT table1_id, Count(date) as c FROM Table2, Table1 -> WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" -> AND Table2.table1_id=Table1.id -> GROUP BY Table1.id HAVI

attached CGI to remove special characters.

Hello List, I mentioned that I'd fixed my problem with the special characters. Everybody had some great tips... I like to use Adobe Go Live to design web pages and it has a text editor that leaves file in the right format... so I just used it to save the files. If you use NOTEPAD or many others..

SELECT help

Can someone help me combine this statement ... SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON d.domain_id=b.domain_id WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C' GROUP BY domain_name with this statement ... SELECT sum(ammount_due) FROM bil

...import access into MySQL...

Hi: i am currently running a MySQL db on an Apache server and i was wondering, is it possible to import an access db into MySQL. If yes, what steps are necessary? Any support you can provide will be greatly appreciated. Thank you, marlon nelson Web Developer Born Infinite Designs http:/

Re: taxes

On Wed, Feb 14, 2001 at 01:32:24PM -0700, LDL Enterprise wrote: > > does anyone know how to calculateg taxes for a shop cart that would > set the tax depending on the state that they select when filling out > their contact information? Thanks. Using MySQL? -- Jeremy D. Zawodny, <[EMAIL PROTECTED

Table timestamps?

Hey all, Is there a way to quickly obtain the last time a table was updated/touched? In my app I am caching queries so long as the table data has not changed. I'd like a quick check to see if a table has changed since the query was first executed. My perusal of documentation plus a few searche

Re: Replication Bug in 3.23.33

On Wednesday 14 February 2001 12:58, Matt Hahnfeld wrote: >Wow, that was fast! Thanks!! We mean what we say - the better the bug report, the quicker the fix :-) > >--Matt > >On Wed, 14 Feb 2001, Sasha Pachev wrote: > >> On Wednesday 14 February 2001 09:19, Matt Hahnfeld wrote: >> >After do

MysqlDump again

mysqldump dia a wrong dump. it had problems dumpping fields filled with a lot of ' " : ( ' the strange point is that I redo the dump and it worked. --- Tenha uma conta de email Grátis no ACBusca! --

Problem with mysqldump - Segmentation Fault

cerveja:/var/lib/mysql# mysqldump -e -l -F -h champagne velop > champagne.velop.20010214.dump Segmentation fault cerveja:/var/lib/mysql# :/ --- Tenha uma conta de email Grátis no ACBu

Re: It keeps hanging it's self, so I killed it :)

HI, I am a newbie. Whew, it felt good to say that and get it off my chest. AS for MySQL, to be fair, I don't know if it was the source of my system crawling to the tune of taking 4-9 minutes just to open a terminal, any file managers, applications, etc. However, what did open most spritely was t

taxes

does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | |> || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.com ---

RE:FIXED - special characters messing me up

On Tue, 13 Feb 2001, John W Ford wrote: > Thanks everybody for helping me out... I got the scripts loaded and am > talking to mySQL via DBI now. > Good John, Which method did you use? Please let us know so we can add it to our list of fixes ... Regards Peter [EMAIL PROTECTED] -- It is as sp

Re: Replication Bug in 3.23.33

On Wednesday 14 February 2001 09:19, Matt Hahnfeld wrote: >After downgrading to 3.23.30, replication worked fine without the problem >posted below. This appears to be a bug in the newest version (3.23.33) >only. > >The failed tests were run under mysql-3.23.33-pc-linux-gnu-i686 (binary >distribut

Re: Data modeling tool

On Wed, 14 Feb 2001, Dave Rolsky wrote: > One feature I've been considering for Alzabo is to be able to somehow > process dia's XML and generate a schema from it. > > Alzabo will (sometime soon, I hope) be able to read/write DBML, an XML > language Barrie Slaymaker is working on (with some input

Re: Help with extremely slow queries - PLEASE!

You may be looking too far for your problem... Your join_buffer and sort_buffer are probably a little large if you have man concurrent users. Must you use an old version of mysql? You should analyize or post EXPLAIN of your query so that you/we can see that it is properly indexed.. you should

RE: Disk usage

> What is the maximum data size MySQL can handle? Please let me know if > anybody knows the answer to this question. http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq ---

Re: mysql/php

Hi! - Original Message - From: "Martin Cloutier" <[EMAIL PROTECTED]> To: "LDL Enterprise" <[EMAIL PROTECTED]> Cc: "*MySQL mail list" <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 8:58 AM Subject: Re: mysql/php > Try this: > > $RESULT_SET = mysql_query("SELECT * FROM $table wh

RE: ODBC drivers???

Hi, The latest ODBC Drivers are always available at www.mysql.com Regards Quentin -Original Message- From: Gary Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 February 2001 08:15 To: [EMAIL PROTECTED] Subject: ODBC drivers??? I am running mySQL 3.23.32 with ColdFusion 4.5 on a

RE: mySQL/php query help

ok, here is the code that runs after the submit button is clicked. i now suspect that it has something to do with my "if" statements. $db=mysql_connect("localhost", "**", "***"); mysql_select_db("***", $db) OR DIE ("died at connect"); if ($AreaTemp == 'ALL' && $CuisineTemp != 'A

It keeps hanging it's self, so I killed it :)

Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not u

Re: get_lock()

It is just a string. It does not lock anything in the database. It sets a semaphore to be tested by other programs. You need to make sure ALL programs updating your database use the string locks, and that the stringlock will be unique for every record. you could youse something like database-table

Help with extremely slow queries - PLEASE!

Hi all, I've a bit of an issue with mysqld -- errr is it? Here's the configuration Dell PowerEdge 6300 - 1GB ram (actually 2GB but no bigmem support at the moment - I'll get to that) - RH linux 6.1 running 2.2.12-smp (needs updating, I know - but hard to find good 'down time') - 4 10gig UW-

show command not working properly 3.23.32?

Is anyone else having similar problems with 3.23.32 and the show commands? Only one that seems to work properly is 'show processlist;' mysql> show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | |

Restart MySQL after rebooting Linux

I have been reading the mysql book by Dubois and trying to figure out how to implement his restart methods on a SUSE Linux 7.0 Box. Has anyone done this and can give me information how to do it? - Before posting, please check:

RE: get_lock()

It's purely advisory locking. You aren't locking anything other than a certain value within the server itself. The benefit comes only if all clients agree to use the same advisory locking schema. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissing

Indexing

Dear Assisitor, Trouble with indexing. The team that is using MySQL for a project consisting of capturing information from the internet. I believe that they are indexing every word in the english language, which in turn is slowing down the search to turtle speed. What could one do to avoid suc

Re: phpMyAdmin

phpwizard.net [EMAIL PROTECTED] wrote: > > I was reading through the list and found numerous mentions of phpMyAdmin. Since > I am a newbie (hoping not to be) at mysql and php, but soon will be using both, > I started looking for it on my Linux box. I have both php3 and 4 on the system > and mys

Disk usage

What is the maximum data size MySQL can handle? Please let me know if anybody knows the answer to this question. Thanks in advance, Aruna. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Data modeling tool

On Mon, 12 Feb 2001 [EMAIL PROTECTED] wrote: > Moving back and forth is a manual process, which is a bit frustrating. > Since dia stores everything in XML, I'm considering what it would take to > make some sort of syncronization. > > I've been planning on looking into Alzabo too, which was alread

freelance web developer available - perl/php/mysql/c++/linux

hey- If anyone is looking for a freelance web developer check me out. I have recently become available. We're talking perl/php/mysql/c++/linux and a bs degreee. jeff -- Jeff Saenz ([EMAIL PROTECTED]) Perl/PHP/SQL/Unix Consulting http://www.planetoid.net --

Re: phpMyAdmin

Muchas gratias. I now know why everyone keeps referring to this little jewel. thanks again to you and to all replying. Scott Baker <[EMAIL PROTECTED]> on 02/14/2001 12:17:45 PM To: Lad Gaal/MarconiMedical@Marconi, [EMAIL PROTECTED] cc: Subject: Re: phpMyAdmin http://www.phpwizard.ne

Re: auto_increment problem with mysql 3.23.32

On Wed, 14 Feb 2001, Sinisa Milivojevic wrote: > Date: Wed, 14 Feb 2001 16:21:31 +0200 (EET) > From: Sinisa Milivojevic <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: auto_increment problem with mysql 3.23.32 snip.. > > Hi! > > The above is actually documente

Re: phpMyAdmin

At 11:08 AM -0500 2/14/01, [EMAIL PROTECTED] wrote: >I was reading through the list and found numerous mentions of >phpMyAdmin. Since >I am a newbie (hoping not to be) at mysql and php, but soon will be >using both, >I started looking for it on my Linux box. I have both php3 and 4 on the system

RE: phpMyAdmin

http://www.phpwizard.net/ you gotta download it... it's seperate from php and mysql. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:08 AM To: [EMAIL PROTECTED] Subject: phpMyAdmin I was reading through the list and found nu

Re: phpMyAdmin

Hi, > I started looking for it on my Linux box. I have both php3 and 4 on the system > and mysql seems to be working fine. However, I could not find phpMyAdmin. So > how > do I get it and how do I put in on this box?? Here it is: http://www.phpwizard.net/projects/phpMyAdmin/ Regards,

Re: phpMyAdmin

http://www.phpwizard.net/projects/phpMyAdmin/ At 11:08 AM 2/14/2001 -0500, [EMAIL PROTECTED] wrote: >I was reading through the list and found numerous mentions of phpMyAdmin. >Since >I am a newbie (hoping not to be) at mysql and php, but soon will be using >both, >I started looking for it on

Re: mySQL/php query help

No, this does not help. All you have provided was the code that does work. From your original description, you are able select the various items from the list. That means you are actually selecting items in a list. Now, if you said that the only item in either or both lists was ALL then you wo

Re: mysql/php

or you can try the following code $result=@mysql_db_query($db_name,$query,$link); $num=@mysql_num_rows($result); if($num<=0): echo "No records found"; endif; Martin Cloutier wrote: > Try this: > > $RESULT_SET = mysql_query("SELECT * FROM $table where description LIKE > '%$keyword%'"); > >

get_lock()

When using getlock what goes in the str in the following syntax GET_LOCK(str,timeout) is the the primary key of the row that you would like to lock? the manual isn't very specific on that Thanks randy - Before

Replication of now()

>Description: I had a master and a slave server that had their clocks set to different times, and I noticed my slave server kept crashing shortly after midnight with queries that involved the now() function. I am using a date column as a unique identifier, so it wasn't able to perform a

Re: Re[2]: Serious MySQL internal deadlock

OK, the problem doesn't occur with --skip-locking. Still, I don't believe this to be a lockd problem as the partition mysqld is working on is a local ext2 fs. lockd isn't even running on the test system (no nfs). So, this leaves either (in no particular sequence): 1. a mysql problem 2. a glibc 2.2

re: installation layout

Is there way to change the installation layout (of directories) of mysql3.23.33. I am compiling mysql3.23.33 on Solaris on a ultr10. Which file is it that controls the layout? Thanks Ubaidul Khan Senior System Administrator Library System and Tec

Re: cronjobs crash with libmysqlclient in PAM-modules

Hi! > "Jan" == Jan Lukoschus <[EMAIL PROTECTED]> writes: Jan> On Mon, 6 Nov 2000, Michael Widenius wrote: >> >> Hi! >> >> > "Jan" == Jan Lukoschus <[EMAIL PROTECTED]> writes: >> >> >> Description: Jan> Operating system: SUN Solaris 7 or 8 Jan> MySQL: 3.22.32 or 3.23.27-beta >> Jan>

phpMyAdmin

I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not

Re: /tmp/mysql.sock disappearing?

On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote: > I couldn't fine this mentioned in the archives, so I hope someone has seen > this before: > > I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. > > There is still server process (sleeping), and there is still

Re: mysql/php

Try this: $RESULT_SET = mysql_query("SELECT * FROM $table where description LIKE '%$keyword%'"); if(!$RESULT_SET){ $RESULTS = "No records found"; } else { do whatever needs to get done! } ...or something similar... (although I did not try it!) Martin C. LDL Enterprise wrote: > How can

RE: mySQL/php query help

hey rolf-- everything works fine if the user chooses "ALL" in both pop-up menus and also works if they choose "ALL" in at least one of the pop-up menus. But if the user does not choose the "ALL" option in both pop-up menus, it does not work properly. i stuck a couple echo statements in the code

Reserved words in MySQL update

>Description: Upgrading from 3.22 to 3.23 with a field having a reserved name ALTER TABLE barfs and doesn't let me do ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL; cos of the reserved word "when". >How-To-Repeat: Have a field called "when" in 3.22, upgrade to 3.23 >Fix: Manually edite

My problem with ucase (and lcase too)

Hi everybody, ucase behaviour :-( mysql> select ucase('déjà vu'); +--+ | ucase('déjà vu') | +--+ | DÉJÀ VU | +--+ 1 row in set (0.01 sec) is there a way to make it answer 'DEJA VU' instead of 'DÉJÀ VU' Thanx for your help... -- Franco

Re: can I use aCC..

On Wed, Feb 14, 2001 at 06:59:04PM +0200, Ragupathi P wrote: > hi, > > basically i am reframing my earlier question. > > i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2 > to compile and link my small C code with libraries available > from mysql-3.23.32-hp-hpux10.20-hppa1.1 . >

Re: MySQL and Mosix

Fabio Berbert de Paula wrote: > > Hello, > > Did anybody perform MySQL in a cluster of > machines using Mosix? Which was the result? > > Did MySQL uses shared memory? > > Or MySQL can't upgrade your perform in > a cluster? No, MOSIX can't run MySQL and because threads. At least this was in th

Log File Reporting

Hi all, I'd like to be able to analyse the log files that my MySQL server produces. Basically, I want to find out how many logins every account is doing, how many queries are being performed against each database (although not necessarily per-table) and how many slow queries each account is doing

RE: Concurrent insert/select with BDB

I thought that by using Berkeley tables, concurrent insert/select locks were based on a page lock. I have seen the same locking with two clients as you noted in your email. What I thought was happening is that since my tables are small, I was getting the locking behaviour mentioned because rows

Re: Cannot load connection class 'java.sql.SQLException problem !

Hello Jan-Aage In my example I have replaced the real username/password with a "username"/"password". Iin the real code I use real username and password. Actually early I thought the username and password I use are not correct, but I log with them using mysql shell. I have grant all GRANTS to thi

RE: mysql/php

?How can I output "no records found" when there is no record found? This is ?the query I am using. ?SELECT * FROM $table where description LIKE '%$keyword%' ?Is there a sql statment that will return a string if no record exists? ?Thanks in advance. An easy way, is to use PHP for this. For exam

Re: auto_increment problem with mysql 3.23.32

On Wed, Feb 14, 2001 at 04:21:31PM +0200, Sinisa Milivojevic wrote: > Hi! > > The above is actually documented behaviour. I've just realized that it's true (checked). But it was supported by older mysql versions and now I'm getting stuck with the old tables (MyISAM). > > Entering negative valu

multiple databases performance

Hi all, glad to be back in the list :) I have a question related with a huge project, i could have these 2 schemes: 1) just one database with several tables database | tables DB_1 | user, profile, supplier, dept, etc... a lot of tables 2) several databases with few tables

Re: Tr: Concurrent insert/select with BDB

Philippe, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the select has placed a page level lock on the page where you try to insert. Then it is correct behavior of the database that your

Re: auto_increment problem with mysql 3.23.32

Gábor Lénárt writes: > On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote: > > Hi! > > > > I have just tested your case on my Linux and it worked just fine. > > > > What OS is that and are you using our binaries. If not, please do. > > OK, I will (but it takes some time

Re: mysql hangs on client start (and mysql_install_db)

Check permissions. The var directory anad all subdirectories and files must be accessible by the user under which MySQL runs. The directory containing the mysql.lock file must be readable and searchable by everyone. Drew Degentesh wrote: > > >Description: > mysql hangs. This is really frustrati

NULL and 0 values when reading from MERGE table while INSERTing

>Description: I have some tables (authentication0106 through authentication0108) for which I create a MERGE table (authentication). Some Perl script is adding records to authentication0107 as fast as it can. While it is doing this, I run the mysql client and issue

  1   2   >