Re: Complex Query
try this: select a.name, b.invitation_status, count(*) from stations a, invitations b where a.id = b.station_id group by a.name, b.invitation_status - Original Message - From: "Ahmed Farouk" <[EMAIL PROTECTED]> Date: Fri, 29 Nov 2002 22:50:34 +0200 To: <[EMAIL PROTECTED]> Subject: Complex Query > Hi, > I need help with a complex query that I can't figure it out myself. > > Suppose that I have the following tables > > 1) stations > -id > -name > 2) invitations > -id > -station_id > -invitation_status (confirmed, cancelled, postponed) > > I need a query that generate a report about each station with ther > corresponding number of invitations and a breaddown of inviations to show > total number of each invitation_status > > stations.name | # of invitations | # confirmed | # cancelled | # postponed > > - > station A|30|20 | 5 > |5 > > - > station B|25|14 | 3 > |8 > > - > station C|47|29 | 6 > |12 > > - > > what query should I use to get the previous output, and if I can't get these > results with a direct query how would I manage to generate this report. > > Thanks > Ahmed > > > - > 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: Too many mysqld-max processes!!
try 'show processlist' first to see what is actually running. [EMAIL PROTECTED] wrote: > > Hello, > I am running mysql on linux and I have too many mysqld-max processes running > at the same time. Why is that and what can I do about it apart from killing > the processes after every boot? > Thanks in advance, > Balteo. > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: temporary table
AFAIK, temporary table is session based. i.e. only the session creating the temporary table can manipulate the table. Wilbert Enserink wrote: > > hi all, > > i have this php script which queries a table. The results are stored in a > temprrary table > "CREATE temporary TABLE t1 SELECT .statements..."; > > when I query this table in the same script i can see that the results wore > indeed stored in t1. > > however when i call this table from a different script I get the error thet > t1 doesn't exists > > anybody knows why? (mysql 3.23) > > thx Wilbert > > - > Pas de Deux > Van Mierisstraat 25 > 2526 NM Den Haag > tel 070 4450855 > fax 070 4450852 > http://www.pdd.nl > [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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: undefined symbol: _dig_vec
very likely, /usr/local/lib is not in your library path. you could either create a symbolic of libodbcinst.so.1 under /usr/lib or configure /usr/local/lib/ using ldconfig. Hoa Doan wrote: > > So I ldd /usr/local/MyODBC/lib/libmyodbc.so and this is the result: > > libodbcinst.so.1 => not found > libz.so.1 => /usr/lib > etc... > > I did a find on libodbcinst.so.1 and found it in /usr/local/lib. > > What do I do from here? > > Hoa > > >From: Bhavin Vyas <[EMAIL PROTECTED]> > >To: Hoa Doan <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > >Subject: Re: undefined symbol: _dig_vec > >Date: Wed, 12 Jun 2002 18:15:53 -0700 > > > >if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do > >ldd /usr/local/MyODBC/lib/libmyodbc.so > >and see if all the dependencies are satisfied. > > > >Regards, > >Bhavin. > >- Original Message - > >From: "Hoa Doan" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, June 12, 2002 11:52 AM > >Subject: undefined symbol: _dig_vec > > > > > > > Hi, > > > > > > I'm using the unixODBC driver manager and MyODBC driver and trying to > > > connect to my clients database on the MySQL server. But it can't > >connect. > > > This is the message I get: > > > > > > "Can't open lib /usr/local/MyODBC/lib/libmyodbc.so" : undefined symbol: > > > _dig_vec > > > > > > How do I fix this? > > > > > > -Hoa > > > > > > _ > > > Join the world's largest e-mail service with MSN Hotmail. > > > http://www.hotmail.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 > > > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: date problem
-do you have any index covering this query? -this is not a good practice to have function call(s) in the where clause, since mysql will make the fucntion call for every rows scanned. select count(*) as c from users_table where user_regdate > "2002-06-01 00:00:00" -furthermore, in the where clause, >= is always better than >. select count(*) as c from users_table where user_regdate >= "2002-06-01 00:00:01" andy wrote: > > Hi there, > > I would like to count the users out of a mysql db who registered after a > certain date. > > The column I have in the db is a char and I do not want to change this > anymore. > This is how a typical entry looks like: May 29, 2002 > > This is how I tryed it: > > // while '10...' is unix timestamp june 1, 02 > SELECT COUNT(*) AS c > FROM users_table > WHERE UNIX_TIMESTAMP( user_regdate ) > '1022882400' > > Thanx for any help on that, > > andy > > query > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: Can't open file
try to do a search on google with the error message you posted here. i'm sure this will help. Liu Qianghua-qch1942 wrote: > > Hi, everyone, > > I am making use of mySQL to provide my client a solution. However, one of tables >often crash and produces the folloing error message when I try to use the table in a >query: > > mysql> select * from action; > error 1016: Can't open file: 'action.MYD'. (errno: 145). > > The record in this table is temporary, after I delete all record from action. >Everything is seem to ok. But it will repeat same problem soon. > > How can I fix it? > > Best Regards, > > Liu Qianghua -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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 timer
there is no such thing built in MySQL. you should use cron to have this job done. zygiz wrote: > > Hello, can somebody tell me, how to execute some actions automatically at the >specified time, on MySQL server? > > --- > Best Regards, > > zygiz > > <===> > Dalyvauk pasaulio futbolo cempionato totalizatoriuje! > Kiekviena rungtyniu diena - vertingi prizai. > http://www.delfi.lt/news/sport/fifaworldcup/article.php?id=1069515 > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: Query Problem
to make it easier for others to help you. you should have posted the create table statement, insert statement for a small set of data so that anyone of us could easier reproduce your problem. btw, are you sure you need 3 links between those 3 tables. please correct me if i'm wrong. i think 2 links should be enough. ie. artist <-> album <-> tracks. Jason Soza wrote: > > I'm trying to compile 75 playlists of 25+ songs each into a database > sortable by date the show was produced, track, album, and artist. I got > advice from someone as to how to layout the table structure, and basically > it was said that I should have a basic structure of 6 tables, one for > artists, one for albums, and one for tracks. These tables should contain > whatever info I want, i.e. song title, albums, etc., and a unique id for > each. I should have 3 more tables, each linking the unique id's of each > other table together. > > So, I have 3 tables as was suggested, one for songs, one for albums, one for > artists. Each has two columns, one being whatever information I'm entering, > and the other a MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY column. > > I have 3 other tables containing two MEDIUMINT columns, these link each of > the 3 others. I have: > artists_tracks > tracks_albums > albums_artists > > Each is setup so that the records represent 'links' - for example, > artists_tracks has artist_id and track_id columns. Each record is made up of > an artist_id and a matching track_id. > > My problem is, when querying some records are lost. But only on a certain > query. For instance: > SELECT tracks.tracks, artists.artists > FROM tracks, artists, artists_tracks > WHERE tracks.id = artists_tracks.track_id AND artists.id = > artist_tracks.tracks_id > > This works. It returns 614 records, each track mated with it's relative > artist. This same query works using albums and the tracks_albums table, > returning 614 records as well. Matching up albums to artists returns 413 > records, which is the correct number. > > However, the following query returns 451 instead of the expected 614 and I > can find no distinguishable pattern as to the records dropped: > SELECT tracks.tracks, albums.albums, artists.artists > FROM tracks, albums, artists, tracks_albums, albums_artists, artists_tracks > WHERE tracks.id = tracks_albums.track_id AND albums.id = > tracks_albums.album_id > AND albums.id = albums_artists.album_id AND artists.id = > albums_artists.artist_id > AND artists.id = artists_tracks.artist_id AND tracks.id = > artists_tracks.track_id > > I've tried LEFT JOIN as well, and have tried numerous other suggestions out > of the manual, but everything turns up 451 records. I haven't been able to > track down WHY records are missing - it seems almost random. If I sort by > album, sometimes all songs from an album have been listed, sometimes only 3 > of 5 or 7 of 10 are missing. > > Any help would be greatly appreciated. Thanks in advance. > > Jason Soza > > Jason Soza > '92 Twin Classic Red Miatae > Juneau, Alaska > http://www.phrog-net.com/sparkles/ > http://www.miatapix.net <--Is YOUR Miata here? > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: AW: Subselect or other way?
You've to do a self join to get this done. select a.id from table a, table b where a.id = b.id and a.nr=123 and b.nr=456; Spielberg Micha wrote: > > Thats right... > But I don't want all id's with nr=123 or nr=456. > I want all id's with nr=123 and nr=456 and only these id's. > > For Example: > > id nr > --- >1123 >1 456 >1 678 >2 457 >2 897 >2 123 >3 123 >3 678 >3 456 > > Id 1 and id 3 have only both numbers. > If I try your query i become id 1,2,3 and that's not that i want. I want > only id 1,3 > > regards Micha > > -Ursprüngliche Nachricht- > Von: Jonny Stendahl [mailto:[EMAIL PROTECTED]] > Gesendet: Mittwoch, 22. Mai 2002 08:27 > An: Spielberg Micha; [EMAIL PROTECTED] > Betreff: SV: Subselect or other way? > > OK! > > You can use SELECT DISTINCT: > SELECT DISTINCT id > FROM Table > WHERE nr=123 > OR nr=456 > > this gives you all uniqe id's with nr = 123 OR nr = 456 and that is id = > 1. > > // > Jonny > > > -Ursprungligt meddelande- > > Från: Spielberg Micha [SMTP:[EMAIL PROTECTED]] > > Skickat: den 22 maj 2002 08:13 > > Till: [EMAIL PROTECTED]; Jonny Stendahl > > Ämne: AW: Subselect or other way? > > > > I think my english ist too bad > > > > My table looks like this > > > > id nr > > --- > > 1 123 > > 1 456 > > 1 678 > > 2 457 > > 2 897 > > 2 123 > > > > > > I want to select in a query only these id that have nr=123 and nr=456. > > In the example its only id 1. > > > > regards Micha > > > > -Ursprüngliche Nachricht- > > Von: Jonny Stendahl [mailto:[EMAIL PROTECTED]] > > Gesendet: Mittwoch, 22. Mai 2002 07:53 > > An: Spielberg Micha; [EMAIL PROTECTED] > > Betreff: SV: Subselect or other way? > > > > > > This is a simple SELECT statement: > > > > SELECT id > > FROM Table > > WHERE nr=3D123 > > AND id = 3D456 > > > > this gives you probably one record, or you could use OR: > > > > SELECT id > > FROM Table > > WHERE nr=3D123 > > OR id = 3D456 > > > > this gives you all records with nr 3D123 OR id 3D456 > > > > // > > Jonny > > > > > > > -Ursprungligt meddelande- > > > Från: Spielberg Micha [SMTP:[EMAIL PROTECTED]] > > > Skickat:den 22 maj 2002 07:46 > > > Till: [EMAIL PROTECTED] > > > Ämne: Subselect or other way? > > > > > > Hi, > > > > > > i have a table like this: > > > > > > Fields: id,nr > > > I want now a query like this: > > > SELECT id FROM Table WHERE nr=3D123 and (SELECT id FROM Table > > > WHERE nr=3D456). > > > > > > Must i do this with a temp Table or ist there any other way to do > this > > > with Joins? > > > > > > I hope someone can help me.. > > > > > > regards Micha > > > > > > > - > > > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: HELP the poor programmer!
Before you voice out asking any question, you'd better go to http://www.mysql.com and take a good look and the documentation first. maxim wrote: > > Hi > > ... A problem in the following. > I do(make) the project for university. > A subject of the project: the Internet shop for small and average business. > At me 1 computer Cel 350 128/33.2 Win2000/php/Apache/MySQL Max (InnoDB). > The project creation of model of shop is stipulated. The database should have hot >reservation. > For this purpose will be used Master/slave. A problem: at university nobody uses >MySQL. > Hence there IS NO INFORMATION about master/slave (a principle of construction, > algorithms of the monitoring system, the organization of transactions in system >master/slave). > Where to find the theory of construction master/slave, monitoring systems... > >HELP the poor programmer! I unique at university who am engaged MySQL at such >level... >The problem that simply is not present at whom to ask. > > Beforehand thank > > -- > Best regards, > maximmailto:[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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: problem
HITESH PATEL wrote:
>
> respected sir/madam,
>
> i had to recently encounter of entering the movie
> files in a database using the blob datatype.
>
> the problems i faced are:
>
> 1) while creating the table how do i mention the size
> of the blob field. say..
>
> create table test (name varchar(8),movie
> blob());
>how to mention its size
[Sammy] In the manual (http://www.mysql.com/doc/B/L/BLOB.html), it said
"In most respects, you can regard a TEXT column as a VARCHAR column that
can be as big as you like.
In the manual (http://www.mysql.com/doc/C/R/CREATE_TABLE.html), in the
create table syntax, you can see you don't need to specify the size of a
blob column.
The max size of a blob column is defined in the manual
(http://www.mysql.com/doc/S/t/Storage_requirements.html)
> 2) i used the following command to insert a file
> ,though the query said ok but the select statement
> showed a null value.
>
> the command i used is...
>update test set
> movie=LOAD_FILE("/home/Hitesh/hitesh.txt") where
> name="hitesh";
>
> 3)what exactly is the max_allowed_packet and how to
> increase or decrease it.
[Sammy] In the manual
(http://www.mysql.com/doc/C/o/Command-line_options.html), you can see
the definition of max_allowed_packet.
>
>4) how to retrive the file from the database.
>
> i did go thru the entire manual but the specific query
> eluded me...like i got to know that a file locator is
> stored in the database which indirectly connects to
> that file and so on.
>
--
Sammy Lau
mailto: [EMAIL PROTECTED]
- Tell me what you want and I'll tell you how you can live without it.
-
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: Help with Tables Please
HINTS: tinyint - Original Message - From: "Soheil Shaghaghi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 9:59 AM Subject: Help with Tables Please > Hi all, > I have create the following mysql table, and when I try to add more than 128 > rows in the table, I get this error: > "Duplicate entry '127' for key 1" > I have no duplicate entries in there, and I can not figure out what's going > on! > > CREATE TABLE CMSHOWNREQUIREDFIELDS1 ( > FieldID tinyint(4) DEFAULT '0' NOT NULL, > FieldName tinytext NOT NULL, > ShownRegistration tinyint(3) unsigned DEFAULT '0' NOT NULL, > Required tinyint(4) DEFAULT '0' NOT NULL, > DisplayName tinytext NOT NULL, > DisplayNameFarsi tinytext NOT NULL, > ModifyFlag tinyint(3) unsigned DEFAULT '1' NOT NULL, > ShownProfile tinyint(3) unsigned DEFAULT '0' NOT NULL, > ProfileRequired tinyint(4) DEFAULT '0' NOT NULL, > ShownUpgradeAccount tinyint(3) unsigned DEFAULT '0' NOT NULL, > UpgradeRequired tinyint(4) DEFAULT '0' NOT NULL, > ShownMakeDonation tinyint(3) unsigned DEFAULT '0' NOT NULL, > DonationRequired tinyint(4) DEFAULT '0' NOT NULL, > FTPAllowed tinyint(3) unsigned, > Price tinytext, > PRIMARY KEY (FieldID) > ); > > 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 > > - 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: MSQL mysql-3.23.45 on Solaris 2.6 - not charset at configure
you need to set LD_LIBRARY_PATH. MySql Dba wrote: > > Hello > > I am trying to configure mysql on solaris 2.6 > > when I run the configure command I use > > ./conigure --with-prefix=/usr/local/mysql --with-exec-prefix=/usr/local/mysql >--enable-thread-safe-client --with-mysql-user=mysqldba > > configure reports back the following error > configure: error: No size for char type. > A likely cause for this could be that there isn't any > static libraries installed. You can verify this by checking if you have libm.a > in /lib, /usr/lib or some other standard place. If this is the problem, > install the static libraries and try again. If this isn't the problem, > examine config.log for possible errors. If you want to report this, use > 'scripts/mysqlbug' and include at least the last 20 rows from config.log! > # > > configure.log shows > > checking size of char... 0 > > which I understand means it cannot find a char set. > > can someone explain a little better what is going wrong and how to fix it. > > thanks, > > Matt > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: HELP ME!!!
Have you got your LD_LIBRARY_PATH set correctly? Andrea Soracchi wrote: > > Hello, > > I have a Sun Os 5.8 with gcc version 2.95.3. > > When i try to compile mysql with the following command: > > CC=gcc CFLAGS="-O6" CXX=gcc > CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti" > ./configure --prefix=/usr/local/mysql > > I have this result: > > [skip] > checking for inline... inline > checking for off_t... yes > checking for st_rdev in struct stat... yes > checking whether time.h and sys/time.h may both be included... yes > checking whether struct tm is in sys/time.h or time.h... time.h > checking size of char... 0 > configure: error: No size for char type. > A likely cause for this could be that there isn't any > static libraries installed. You can verify this by checking if you have > libm.a > in /lib, /usr/lib or some other standard place. If this is the problem, > install the static libraries and try again. If this isn't the problem, > examine config.log for possible errors. If you want to report this, use > 'scripts/mysqlbug' and include at least the last 20 rows from config.log! > > The library libm.a is on my server, I have checked > > What's the problem!?!! > > Thanks in advanced > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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 start the MySQL server
Check out http://www.mysql.com/doc/I/n/Installing.html. BTW, are you downloading the binary distribution or source distribution? Hammer wrote: > > Dear friends, > > I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my > /usr/local directory and uncompressed it. > > Now I can get the target directory but I don't know how to start the server. > > I tried: > ./bin/safe_mysqld --user=root & > but it doesn't work for me. > > Any help is warmly welcome. > > Regards, > Yao > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: Adding an index to a table
http://www.mysql.com/doc/C/R/CREATE_INDEX.html > > 1 - What command do I issue to add a simple index to one field in a > table. > 2 - Do I have to do anything special like stop requests to the > server while I add the index. > 3 - How safe is this to do? > > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: Mystery files
i believe you've the replication option turned on. see http://www.mysql.com/doc/R/e/Replication_Options.html for more details. mysql mailing list user wrote: > > Hi, > > I my mysql server database directory (that is the directory that holds the > .err and .pid files) so strange files have apeared. They look line > > -bin.001 > -bin.002 > etc > -bin.index > > Some of them are huge! They seem like binary files, but are full readable > SQL commands that could be from my applications. > > What is going on can I delete them? > > Cheers > > Howard Miller > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: newbie : Help with C api for mysql
jim and lois flaherty wrote: > gcc analysis.c > > analysis.c:6:19: warning: extra tokens at end of #include directive > analysis.c:7:19: warning: extra tokens at end of #include directive > /tmp/ccsKk2GG.o: In function `main': > /tmp/ccsKk2GG.o(.text+0x14): undefined reference to `mysql_init' > /tmp/ccsKk2GG.o(.text+0x40): undefined reference to `mysql_real_connect' > collect2: ld returned 1 exit status > > What Am I doing Wrong ?? > you need -lmysqlclient. check http://www.mysql.com/doc/C/C/C.html for more details. -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: Problem with ordering select
Michal, > /dev/hda8 256667256667 0 100% / looks like your root partition is full. 'show variables' tells you where Mysql is putting the temp table for your "order by" query. i believe it is sitting under your root partition. -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: processes stuck in "Opening table" state
hi all, since i haven't got any suggestion to the following problem, i'm wondering if anyone could point me to a source where i could seek help (i can't get my boss to pay for the support contract...) thanks a lot. Sammy Lau wrote: > > hi all, > > i've got a mysql server running around 100 queries per sec for most of > the time. > i got only 1 table in MyISAM format. > i got only around 6000 updates to this table per day. > max_connection is set to 600 > thread_cache is set to 600 > table_cache is set to 600 (there is NO join operation) > > everything seems fine, right. > my problem is, sometimes, i see a lot of processes (200+) got stuck in > "Opening table" state. at the same time mysqladmin status tells me the # > of open table is 583. this number never reaches the max setting. > > anyone got an idea why i'm seeing this behavior. please let me know if > i'm missing any information here. > > thanks a lot. > > -- > Sammy Lau > mailto: [EMAIL PROTECTED] > - Tell me what you want and I'll tell you how you can live without it. > > - > 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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
processes stuck in "Opening table" state
hi all, i've got a mysql server running around 100 queries per sec for most of the time. i got only 1 table in MyISAM format. i got only around 6000 updates to this table per day. max_connection is set to 600 thread_cache is set to 600 table_cache is set to 600 (there is NO join operation) everything seems fine, right. my problem is, sometimes, i see a lot of processes (200+) got stuck in "Opening table" state. at the same time mysqladmin status tells me the # of open table is 583. this number never reaches the max setting. anyone got an idea why i'm seeing this behavior. please let me know if i'm missing any information here. thanks a lot. -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: GETTING STARTED !!
"Suresh R. Soni" wrote: > > Hi All, > I have good Sybase experience and I have installed > MySQL in a Linux box. Can u please answer my following > queries: [Sammy] I like Sybase very much as well. =) > 1. When I run safe_mysqld I get "Starting mysqld > daemon with database from /var/lib/mysql 020314 > 17:00:01 mysqld ended" do this mean a successfull > start or failure ? [Sammy] it is a failed startup. for a succesful startup, you should see: 020117 08:05:22 mysqld started /libexec/mysqld: ready for connections > 2. How to check if mysql server is up ? [Sammy] trying to connect the mysqlserver is the best way to do the job. > 3. Is there any startup log-file generated (Sybase > generates one ). [Sammy] yes. the path is specified in /etc/my.cnf [safe_mysqld] err-log=/var/lib/mysql/mysqld.log > 4. Is there any default user created when the mysql is > installed ( in saybase it sa with null password) [Sammy] AFAIK, only 'root' is there. I hope this will help. -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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
Checking if table empty
as you said, the table is empty. mysql_fetch_object should return NULL.
that's why the block in the while statement doesn't got executed.
while (($row = mysql_fetch_object($result))){
if($row->team_id == "$team_id"){
echo "It is in there";
}else{
echo "We will need to add it to the table";
}
}
i guess this is what you're trying to do:
$searchStmt = "SELECT 1 from division1rank where team_id = $team_id"; //i'd
prefer using bind variable here
... snipped ...
if ($row = mysql_fetch_object($result)) {
echo "It is in here";
} else {
echo "We'll need to add it to the table.
}
i hope this will help
-
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 installation. Help!
gt; > > >> To: <[EMAIL PROTECTED]> > > >> Sent: Sunday, March 10, 2002 10:01 AM > > >> Subject: Mysql installation. Help! > > >> > > >> > > >>> Hi all, > > >>> I got this error message when trying to connect to mysql at the shell > > >>> command: > > >>> > > >>> Error 2002:Can't connect to local MySql server through socket > > >>> '/var/lib/mysql/mysql.sock > > >>> > > >>> > > >>> There is no mysql.sock in the /var/lib/mysql directory. Did I miss > >some > > >>> thing in the mysql installation? Where could I find the mysql.sock? > >I > > >>> install mysql that came with redhat 7.2. Thank for the help. > > >>> > > > > > > > > > > > > > > > > > > > > > > > > > > > ----- > > > 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 > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: Multiples instances of MySQL
use --socket instead of -P would solve your problem. without -h, socket file is used for connection. since you've not specified the socket file, the default socket file path is used (in some case, /tmp/mysql.sock). that's why you're always shutting down the first one. Happy new year. On Mon, Dec 31, 2001 at 12:08:20PM +0200, Emmanuel van der Meulen wrote: > Hello all, > > I'm in a spot, I'm managing to successfully run several instances of MySQL, > say on port=3306 and port=3308. > > When I use shutdown, the instance which started first shuts down. > > To shutdown the instance started on port 3306, I use; > mysqladmin -P 3306 -u root -p2000 shutdown > > And to shutdown the instance started on port 3308, I use; > mysqladmin -P 3308 -u root -p2000 shutdown > > However, the instance which started first is always the instance which shuts > down, irrespective of the port number I provide. > > Could someone please advise and/or point me. > > Thank you provisionally for any assistance. > > Kind regards > Emmanuel > > > - > 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 -- Sammy Lau mailto: [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: how to setup Mysql multiple instances
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Multiple_servers - Original Message - From: "Li, Robert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, December 29, 2001 5:58 PM Subject: how to setup Mysql multiple instances > Hi,all MySQL teams: > > First let me wish you all happy new year! > Wish Mysql win more victories in DB area. > > I am a programmer in CA. I know Mysql supports > multiple instances. One way is to install different servers, > on each server, runs an instance. The other way is to > use one server, one installation to run multi instances. > Now i can setup the environment in the first way. > I want to know how to setup in the second way. > > Would you pls kindly help me to solve this problem? > Thank you very much! > > Regards > > Robert Li > Computer Associates > Programmer, R&D Beijing (China) > Tel: +86 10 65611136 ext 852 > Fax: +86 10 85298979 > [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
getting permission denied error intermittently
Hi all, Both of the DBI client and C client are getting permission denied error intermittently to a mysql database. When I see this problem, I do a 'flush privileges'. It comes back to normal for a random period of time and the problem happens again. I cannot reproduce this problem at will. Anyone seeing the same problem? Please let me know if there is any missing info I can provide. Any help would be highly appreciated. Thanks a lot. Linux 2.4.6 #2 SMP MySQL Ver 3.23.36 for redhat-linux-gnu on i386 -- Sammy Lau mailto: [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
