SQL QUERY help joining three tables

SQL QUERY question I have three tables: students has student_id and student_name parents has parent_id and parent_name parentlog has student_id and parent_id I want to search the parentlog WHERE student_id = some_id GROUP BY parent_id (This will bring back two rows when there are two parents)

Re: 404 on search function on mysql.com

The good news is it works from here. :o) I guess for you that's also bad news. :o( On Fri, 15 Mar 2002 14:57:20 -0600, Steve Suehring wrote: >Hi, > >For some reason I get a 404 error when I click on 'search' in the Quick >links section at http://www.mysql.com/documentation/mysql/bychapter/. >

RE: password special character muck up (I think)

1. If you can view "blahblah;;" in the password field of the user table, then the password wasn't encoded in the first place. That leads one to conclude the change was accomplished using UPDATE and the field was set to "blahblah;;" and not to PASSWORD('blahblah;;'). What mysql stores in t

Re: mysql++ patch for GCC 3

Did anybody build mysql++1.7.9 with RedHat Linux 7.2 and gcc 3.0.4? Any known magic to do it? Thank you for any hints. Vlad. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

How do I get a binary distribution of mysql to run?

>Description: Downloaded recently & installed via RPM. Ran mysql_install_db Executed safe_mysqld, but fails. Below is an excerpt from log file. 020315 09:25:31 mysqld started 020315 9:25:31 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020315 09:25:31 m

Re: Is the new MySQL table cache implemented in InnoDb? #

At 14:20 15/03/02 -0600, BD wrote: Hi! >The eWeek article http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp >that benchmark the various databases including MySQL stated: > >"MySQL's great performance was due mostly to our use of an in-memory query >results cache that is new in MySQL 4.0.1

Re: it cannot inititate downloads

At 11:17 15/03/02 -0500, alan4100 wrote: Hi! >I am trying to download mysql for my windows XP but this url site: Open the URL below: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win.zip Select a mirror site and download it. Unzipped the file and run the setup.exe file. Regards, Mig

Re: Script for Data base backup and recovery : Very essential

This has been covered here a number of times before ... a search of the archive avoids the need to repeat the same info. That being said ... We use a cronjob (root) that calls a shell script at 3am daily. The line in the cronjob is: * 3 * * * /usr/local/bin/dbbakup.sh username password The she

Re: Foam King

On Fri, Mar 15, 2002 at 05:30:57PM -0700, Kelly Grainger wrote: > Dave, > > I'm being pressured by Don at the Foam King to get things working asap. Any >progress? > Here is what I get. Script started on Fri Mar 15 18:52:36 2002 doctor.nl2k.ab.ca/~$ mysql       dir *.ansi sh: d

RE: Fetching an optional array from an optional column

By the way.. YOu must use LIKE for it to work.. GEOGRAPHIC= won't work it has to be GEOGRAPHIC LIKE .. Thanks, Gurhan -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 7:37 PM To: [EMAIL PROTECTED] Subject: RE: Fetching an optional array from an

RE: Fetching an optional array from an optional column

Hi :) Rewrite your query statement as: $sql = "SELECT * FROM links WHERE (SUBJECT1='$formatted_subject' OR SUBJECT2='$formatted_subject') AND GEOGRAPHIC='".$geographic."%' ORDER BY ORGANIZATION ASC"; I think it looks like a $geographic% variable:) Let me know if it does or does

FW: Fetching an optional array from an optional column

Thank you for the hint. I've tried further, and still came up short. This time, if I use the % - it returns nothing. Here's the sample code I'm using: Organization: http://$url\";>$organizationGeographic Region: $geographicDescription: $descriptionURL: http://$url\";>$urlSubject1: $subject1Sub

RE: Fetching an optional array from an optional column

Hi, Since you are using a form to query the table i assume the subject1, subject and geographic will be variables. So, you could do something like: SELECT * FROM links WHERE (subject1='$sub1' OR subject2='$sub2') AND GEOGRAPHIC like '$geo%' In this way, if the user enters no value for the var

RE: drop down list using php and mysql

Yup Yup , you sure could.. Or you could also use while ($array_name=mysql_fetch_Array($result)) {..}but for some reason i always write at least a couple extra lines and use number of rows.. I guess it is because thats how i learned it first :)) Gurhan -Original Message- From: Nat

Fetching an optional array from an optional column

I'm working on a form that queries by selection in PHP, where a user selects a subject and an optional selection of geographic region to get information. Each database entry will have 2 subject fields, Subject 1 being the main subject and Subject 2 being the cross-subject, and a geographic field,

Re: Getting a text field in a table....

Dear Mad, Don't give a szie just this; ALTER TABLE tablename ADD fieldname LONGTEXT Hope this helps, Richard MadProfessor wrote: > Stupid newbie question, but why in the hell can't I get this damned TEXT > column added? I've specified it as size 254 and cannot get it to > work Someone plea

Re: drop down list using php and mysql

You could also bypass the num_rows entirely... ".$query); echo ''; for ($i=0; $row = mysql_fetch_assoc($result); $i++) { echo ''.($row["field"]).''; } echo ''; ?> # Nathan - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "mailing list" <[EMAIL P

RE: update mysql database via php form

Hi, didn't really understand what you are asking.. Can you please be more specific? What exactly you are asking? Gurhan -Original Message- From: Valerie Brooks [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 5:28 PM To: [EMAIL PROTECTED] Subject: update mysql database via php fo

RE: drop down list using php and mysql

A correction... for line has the greater sign wrong:) It has to be : for ($i=0; $numresult > $i; $i++) Sorry about that:) Gurhan -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 6:01 PM To: mailing list; [EMAIL PROTECTED] Subject: RE: drop d

RE: drop down list using php and mysql

Hi, This type of qustion should be forwarded to PHP-DB list. Its adres is: [EMAIL PROTECTED] . As for the answer to your question.. IF you'd like to create a dynamic drop-down menu.. You can just just query the table for the options to be displayed and loop through the result set and print them o

Access denied for user: 'root@localhost'

root login failing??? why? anonymus failing too?? I just installed the following on Win2k Server: Ver 8.23 Distrib 3.23.47, for Win95/Win98 on i32 Server version 3.23.47-max-nt Install goes seemingly ok. I test whether or not MySQL is working and have problem with this command below.

update mysql database via php form

Hi, I'm using php form to update mysql database, the form has several drop down menus to choose from. What would the best way of updating information in the database, update, as a function? Any help will be greatly appericated. Thanks. --

Re: insert and select

Hi No you can't. if you are using and AUTO_INCREMENT field as a key you could follow the INSERT with a select statement like: "SELECT * FROM tablename WHERE keyfield = LAST_INSERT_ID()" See the manual: LAST_INSERT_ID() http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Mis

ssl confusion

Hi All, I've been through the list archives and the documentation and have found no good discussion of getting ssl connetions working with mysql 4. My main question is how does one provide mysqld with a private key and certificate? Also, how is the --des-key-file command line arg used. I am gues

insert and select

Hi: how i can insert and select information at the same time. first i want to insert the information relative to the client and after that i need to select the same information on the same query. that is possible _ Do You Yahoo!? G

drop down list using php and mysql

Hello, I am trying to build a drop down list using php and mysql. Does anyone have any examples of this? Regards, Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql

stored procedure

Hi: Can anyone help about how can I create stored procedure to mysql? I took a look to mylua but it is just to Linux. My server is Windows 2000. In the MySql documentation I just see some examples in C, but I don't know how can I do it, and if I done it in C, how I would call it from php? Thanks i

Bad pthreads detection on Tru64 5.1a

>Description: Tru64 5.1a is more strict than other versions of Tru64 when compiling a threaded program. extract of pthreads.h file on Tru64 5.1: /* * Enable reentrant errno.h. HOWEVER: this is here only to avoid breaking old * (and incorrect) code that assumes

Bad pthreads detection on Tru64 5.1a

>Description: Tru64 5.1a is more strict than other versions of Tru64 when compiling a threaded program. extract of pthreads.h file on Tru64 5.1: /* * Enable reentrant errno.h. HOWEVER: this is here only to avoid breaking old * (and incorrect) code that assumes

Remote access to MySQL

Hi! I want to access various databases on a MySQL server remotely. I've set up an entry in the "mysql.user" table to allow access to mysql for all hosts in subnet 10.2.107.0/255.255.255.0. First this worked fine. Then my server moved from address 10.2.107.24 to 10.2.107.204. Now I do not have ac

404 on search function on mysql.com

Hi, For some reason I get a 404 error when I click on 'search' in the Quick links section at http://www.mysql.com/documentation/mysql/bychapter/. It looks like it does some type of redirect so my browser could be broken too, but usually not so much with a 404. :) Steve -

tuning mysql

I have a fairly decent server who is handling lots of connections, but very simple SQL and I am looking for tuning advice. I have a pretty high number of simultaneous connections and the box is showing a few signs of stress, that I want to address before they become a problem. Any help will be g

Re: My JDBC does not work.

Jianping Zhu wrote: > Invalid authorization specification: Access denied for user: > 'jianping@chambleea' (Using password: YES) > I am just wondering, I do have a account 'jianping' which have all > privilege in global level. All priv at all hosts, including localhost or localhost.localdomain

Server Databases Clash

I read your article and found it to be interesting and overall, quite accurate. I do have one bone to pick with you however. I know the MySQL staffer who worked the MySQL portion of the test. I had occasion to meet him and talk briefly about the PC Magazine test in Houston the week following th

mingw, mysql c api, win2k cmd line error

I am having a heck of a time getting a simple c program up and running using mingw and the mysql c api. My makefile is simple enough I'm not sure what the -lm switch on the search compile line is for but I saw it in someone's makefile on the web so I through it in hoping it would work): # mak

SOLUTION: can't run mysql_install_db on Solaris 2.8

Found the fix! What happened to me is I had used Winzip to unzip and untar the files on a Win2000 machine, then copied those files to the server. However, I found GNU tar, installed it, deleted my old mysql directory, and used GNU tar to untar the file in /usr/local. After that mysql_install_db w

Is the new MySQL table cache implemented in InnoDb? #

The eWeek article http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp that benchmark the various databases including MySQL stated: "MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL'

Re: My JDBC does not work.

On Fri, 15 Mar 2002, Jianping Zhu wrote: > > I have spend three days try to get jdbc for mysql work, but failed. I am > very frustrated. I will > be appreciated if somebody can help me out. > > I have redhat 7.2 OS, I download the sever and client mysql .rpm files and > instaled it, i believe suc

Berkeley DB & 10,000,000 rows

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've got a small database (16 tables, a few thousand rows total) running 3.23.48-max w/ 3 of the tables Berkeley DB (for transactions) on Solaris 7/SPARC. One of these tables (the largest of the 3) has a little over 1,000 rows and occasionally somet

RE: My JDBC does not work.

Thanks for your advices. After I modified my code according to your advice i get following error message. Invalid authorization specification: Access denied for user: 'jianping@chambleea' (Using password: YES) java.sql.SQLException: Invalid authorization specification: Access denied for user:

RE: password special character muck up (I think)

I can access the client using other users, but none have mysql database access (ie. everything is fine except that I can't add users). If nobody knows the answer, I will restart with skip-grant-tables during off-hours. - Before

RE: password special character muck up (I think)

I don't see how to submit 'blahblah;;' using the quotes. I've tried mysql -u root and then typed all the conceivable combinations for password and mysql -u root --password=blahblah;; and mysql -u root --password='blahblah;;' What's worse is that I've looked at the raw table file and confi

RE: Slow query

Hi !! > -Original Message- > From: m.colurcio@ [mailto:[EMAIL PROTECTED]]On Behalf Of Massimo > Colurcio > Sent: Friday, March 15, 2002 1:59 AM > To: [EMAIL PROTECTED] > Subject: Slow query > > > Hi all. > > I'm using MySQL server 3.23.47 (client 3.23.44) on Windows 98 (...sorry) > acc

RE: joining 2 identical tables

Hi Christian, You can create a temporary table (see manual http://www.mysql.com/doc/C/R/CREATE_TABLE.html) with the same structure as prv or com and populate it with prv's and com's data by using INSERT INTO SELECT ... syntax (see manual http://www.mysql.com/doc/I/N/INSERT_SELECT.html) Gurha

UDFs (2nd Try)

Hello: I never received an answer to the first try, so I thought I might try again. Has anyone out there been able to successfully compile a UDF for Win32 and if so, do they have a simple example? I looked in the archives and there are plenty of questions, but no answers to this. Thanks, Cra

Re: joining 2 identical tables

Hi Christian, > i'm working on a project for managing used motorcycles. for security reasons > i setup two identical tables. both with the same attributes. > ID,UNIID,Manufacurer... one of the tables is named "Com" and the other > "Prv". > > till now i used to search either "Com" or "Prv". but i

cannot create Tables with MysqlGUI 1.7.5

Heya, I am quite new to all this intriguing stuff. I use mysql-3.23.47-win with MySqlGUI 1.7.5 I see my mysql database, but cannot create tables in it. Any ideas? Kind regards, Stefaan ___ http://www.vitamine-z.com/esse/

RE: password special character muck up (I think)

Perhaps the ; is not getting escaped correctly ( though it should if it is contained in the quotes ('blahblah;;;'). The ; is the end of line token. maybe it got confused. or maybe its a matter of the client acception the ;'s you changed your root password? does that mean you are unable to connect

RE: joining 2 identical tables

Depending on which version of mysql you are using you could use Union http://www.mysql.com/doc/U/N/UNION.html or you could use a Merge table http://www.mysql.com/doc/M/E/MERGE.html another option would be to place the results of both queries into a temporary table and query that. -Origina

Re: How MySQL handles variables

Hi GEORGE, > The typical way refers to the update syntax. Ideally, > I would like to be able to do something like that: > - read the value of the variable through a read > statement. > -Specify the value to be appended. > -Do the task. > > Could you please help me out with that? > > > I would li

RE: MySQL++ dll linkage warnings

Thanks again. -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 11:37 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL++ dll linkage warnings Thi Cao writes: > Sinisa, > > I downloaded and am currently using the binary

RE: MySQL++ dll linkage warnings

Thi Cao writes: > Sinisa, > > I downloaded and am currently using the binary version of 3.23.49. Are you > saying I should download the source version and build the > libmysqlclient.dll? Please clarify. Thanks for the quick response before. > > Thi No, you are OK. All you have to do is chan

Extending tablespace for innodb

Hello, How can I increase the size of the tablespace for innodb tables? Can you say if this is a correct procedure: 1. Dumping the database; 2. Stopping it; 3. Deleting innodb log files (ib_logfile0, ...) and innodb data file specified in innodb_data_file_path; 4. Changing size of data file in i

Re: Grants to a database table that doesn't exist yet

Luc, I think you have to do the manual inserts to make this work before the tables are there. I wrestled with this problem briefly, before writing a quick script. Scott Helms Director of Technology, ZCorum - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: "MYSQL-List

password special character muck up (I think)

I just had the brilliant idea of using a password for mysql root with semi-colons: password is blahblah;; this appears to have not worked in some way and now I'm stuck. I don't want to restart since that isn't very graceful (on a production machine). I've tried blahblah;;; and blahblah and bla

RE: MySQL++ dll linkage warnings

Sinisa, I downloaded and am currently using the binary version of 3.23.49. Are you saying I should download the source version and build the libmysqlclient.dll? Please clarify. Thanks for the quick response before. Thi -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTEC

Re: A problem with ROUND()

I think you misunderstood how this is going to work. The expression ROUND(rand()*100) is not a constant, so it is going to re-evaluate it and generate a *different* random number for each line in the table. Apart from anything else, this is going to be slow because it will have to scan the wh

How to use transactions

I would like to know how work transactions!! are there is mysql 3.23.49?? If there is, how can I use transaction with rollback and commit? I read about transaction, and exist other way to use. How can I use? Regards Alexander Curitiba/Pr/Brazil __

RE: replication through port forwarded firewall

>From what you are writing here it looks as though you are porting a database to the slave that has already been bin logging. If your master has been logging the database in question, and you are copying that database over to the slave, then of course when it reads the bin logs from the master th

Re: MySQL++ dll linkage warnings

Thi Cao writes: > Compiler - MSVC 6.0 > OS - Windows 2K > MySQL++ 1.7.1 > > Whenever I perform a build of my project and link against the static > mysql++.lib library, I often get the following warnings. Because I don't > want to disturb the mysql++ source code, is there anything I can do to > r

Re: cannot create Tables with MysqlGUI 1.7.5

- Original Message - From: <[EMAIL PROTECTED]> To: "Stefaan Contreras" <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 5:58 PM Subject: Re: cannot create Tables with MysqlGUI 1.7.5 > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter.

Replication: bin-log confusion and other

Hi, i'm setting up a rather simple replication setup but i'm not able to understand the behaviour of mysql (3.23.44) - one server is master, all update are on master - some of the databases on master should be replicated to some slaves; the others should not - create/drop database/table shoul

Re: A problem with ROUND()

Your problem, I _think_, is that your query works as follows: for i = 0 to table_name.rows { row <-- table_name.row[i] if row.count = ROUND(rand() * 10) then result += row } NOTE: ROUND(rand() * 10) is performed FOR EACH ROW in your table. You actually mean for it to b

Re: My JDBC does not work.

Hi, Jianping Zhu wrote: > > I have spend three days try to get jdbc for mysql work, but failed. I am > very frustrated. I will > be appreciated if somebody can help me out. snip > } catch (Exception e) { > System.out.println("StocksMy: JDBC exception"); > System.exit(1);

MySQL++ dll linkage warnings

Compiler - MSVC 6.0 OS - Windows 2K MySQL++ 1.7.1 Whenever I perform a build of my project and link against the static mysql++.lib library, I often get the following warnings. Because I don't want to disturb the mysql++ source code, is there anything I can do to resolve the dllexport implicit de

Re: replication through port forwarded firewall

> "Van" == Van <[EMAIL PROTECTED]> writes: Van> This means you need to re-initialize the slave; i.e. stop the Van> master and slave; copy the data dir to the slave; start the Van> slave (ensure the perms on the slave are correct first); Van> start the master. If the error ab

Re: it cannot inititate downloads

You should have been sent to another page that lists many of the mirrors to download from. Did this happen? http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.49-win.zip Somewhere on the page it says that you can also download from sourceforge.net http://sourcefo

A problem with ROUND()

I have database with table and 1 milions random characters. Key for searching each character is a counter from 1 to milion. when I execute statement: SELECT count, character FROM table_name WHERE count=ROUND(rand()*10); Example: count ||character || 1 dasarewr 2

My JDBC does not work.

I have spend three days try to get jdbc for mysql work, but failed. I am very frustrated. I will be appreciated if somebody can help me out. I have redhat 7.2 OS, I download the sever and client mysql .rpm files and instaled it, i believe succssfully. i use command like 'mysqladmin version' to t

joining 2 identical tables

hi, i'm working on a project for managing used motorcycles. for security reasons i setup two identical tables. both with the same attributes. ID,UNIID,Manufacurer... one of the tables is named "Com" and the other "Prv". till now i used to search either "Com" or "Prv". but i want to look for a m

it cannot inititate downloads

I am trying to download mysql for my windows XP but this url site: http://www.mysql.com/downloads/mysql-3.23.html has been unaccessible for over two weeks. I just could not initiate the download. My provider is Comcast Cable. What is the problem?

RE: Grants to a database table that doesn't exist yet

Hi Luc, I don't know if this will help you but you can do: GRANT DELETE,SELECT,UPDATE on qbslive.* TO . But this will give permission to ALL tables in qbslive database... Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 10:45 AM To

Re: Begin work

On Thursday, March 14, 2002, at 11:12 PM, Chris Stark wrote: > "This statement signals the successful end-of-transaction. A transaction > is > a group of SQL statements whose changes are logically connected and can be > made permanent or undone as a unit. All updates made during this > transa

mysql_num_rows/insert/3.23.41

Found a strange problem with a system here I'm wondering if anyone can help with. Got a v3.23.41 installation (source build) on RedHat 6.2 using BDB tables. A front end program uses this database via the C API. gcc on this system is egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) At one point

Re: Lost primary key from table

From: "Martin MOKREJŠ" <[EMAIL PROTECTED]> > OK, my question is: > > could someone imagine a way how such a thing could happen? The information about > KEY's is set when the table is created. I suspect more end-user problem then > mysqld problem, but could it happen that the whole information in

Grants to a database table that doesn't exist yet

Is there someway I can force a Grant to take if the database table doesn't exist yet? I have the database created, awaiting the data that is being dropped into it, but I want to set up privileges to it before it exists so its ready to go live in an instant mysql> GRANT DELETE,SELECT,UPDATE on q

Re: Please help - About doing a delete.

well i can do the select that way, but i was wondering how the following delete command would only pick up the rows in the select. isn't there a way of imbedding delete in the select statement? can anyone else help as well please? thanks sunny At 19:46 14/03/02 -0500, Jim Philips wrote: >To

Re: root user Access Denied

I've been watching this thread and wonder if not following instructions may be contributing to the present confusion. On Fri, 15 Mar 2002 14:38:02 +0200, Egor Egorov wrote: >>>Show me the output of the following: >>> SHOW GRANTS FOR 'username'@'hostname'; > >RQ> output: >RQ> mysql> show gra

RE: BLOB in MYSQ

Hi, First of all, download MySQL++ for VC++ at: http://www.mysql.com/downloads/download.php?file=Downloads/mysql++/mysql++-1 .7.1-1-win32-vc++.zip And there are working examples on how to load and retrieve binary data from blob columns using MySQL++ at: http://www.mysql.com/documentation/mysql++/

RE: Getting a text field in a table....

I don't believe you specify a size for a column of type TEXT. Only types CHAR and VARCHAR take a size. http://www.mysql.com/doc/B/L/BLOB.html says: "A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB differ only in

BLOB in MYSQ

hii all, I want to knowledge about blob. how can write or read blob to/from MYSQL database by using Visual C++. Can any body help me. Ibrahim Kivanc Cihan Anadolu University - Turkey - Before posting, please check: http:

Re: How MySQL handles variables

Hi GEORGE, > I would like to ask a simple question about the way > MySQL handles string variabels. Say i have a variable > whose value is foo and I want to change it to foobar. > > Instead of doing it the 'typical' way, I would like to > ask whether there is any mysql command that will allow >

Re: MYSQL,Linux & large threads number

Peter Zaitsev writes: > Hello mysql, > > Some time ago I wrote about slow down of mysql with large number of > threads, which is quite common in Linux-Apache-Mysql-PHP enviroment. > > The test was simulating the worst case of concurrency - all the > threads are modified global variable i

Getting a text field in a table....

MadProfessor, Friday, March 15, 2002, 2:51:07 PM, you wrote: M> Stupid newbie question, but why in the hell can't I get this damned TEXT M> column added? I've specified it as size 254 and cannot get it to M> work Someone please give me an example of a working create table M> statement with a

Re: mysql++ patch for GCC 3

:::... pjs ... writes: > > has anyone had trouble applying the patch to mysql++-1.7.9 > tx, > paul > This is simple. cd to directory immediately above mysql++ and do : patch -p1 < ... There is a better patch for GNU 3..., but not fully tested yet. I am sending it to you directly, so that you

MYSQL,Linux & large threads number

Hello mysql, Some time ago I wrote about slow down of mysql with large number of threads, which is quite common in Linux-Apache-Mysql-PHP enviroment. The test was simulating the worst case of concurrency - all the threads are modified global variable in a loop 500 times in total, u

Getting a text field in a table....

Stupid newbie question, but why in the hell can't I get this damned TEXT column added? I've specified it as size 254 and cannot get it to work Someone please give me an example of a working create table statement with a TEXT or LONGTEXT column? I've read through my book (MySQL) and checked the

Re: innodb or Berkeley DB default for mysql max

We have the same problem as Victoria, and the --default-table-type option does not work. - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 1:38 PM Subject: innodb or Berkeley DB default for mysql max > Kemp, > Thur

Creating tables in mysql

Uma, Friday, March 15, 2002, 2:10:50 PM, you wrote: UST>Now i am struck up with one problem...When i am trying to create a UST> table in the mysql database it is giving this error...Can anyone plese UST> help me how to rectify this problem.. UST> ERROR 1: Can't create/write to file './dbase/r

Re: Changing Default for Not Null to NOTHING

David, Thursday, March 14, 2002, 9:30:24 PM, you wrote: DMP> ok, more specific: DMP> here is a table: DMP> CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1) DMP> If I do an insert into the FOO table with the following: DMP> INSERT INTO FOO (foo1,foo2) VALUES (1,1) DMP> Everything

Re: root user Access Denied

Rob, Thursday, March 14, 2002, 10:15:54 PM, you wrote: >>Show me the output of the following: >> SHOW GRANTS FOR 'username'@'hostname'; RQ> output: RQ> mysql> show grants for 'root@localhost'; RQ> ERROR 1064: You have an error in your SQL syntax near RQ> 'grants for 'root@localhost'' at lin

Re: New MySQL user question: record security

Mike, Thursday, March 14, 2002, 7:27:32 PM, you wrote: MH> I have just recieved a request to build a database using mySQL and I have a MH> bit of a dilemma. MH> The database is to be used for relations between MH> politicians and their constituents, MH> and I have to have tables for constitue

innodb or Berkeley DB default for mysql max

Kemp, Thursday, March 14, 2002, 8:37:00 PM, you wrote: KRW> What is the default table engine used in the "binary" version of mysql-max -- KRW> innodb or Berkeley? If not innodb, how do I get the innodb to be the default? KRW> Can someone point me to the manual section? The default table type

Re: remote connect

Georg, Friday, March 15, 2002, 11:05:19 AM, you wrote: >> I can't connect to mysql remotely. I have added my hostname to the host >> table, i have the correct entries in user table,for localhost, my hostname, >> my ip, and even %. i can login locally through the shell, and the uname and >> pass i

Upgrading to InnoDB tables

Sanjay, Thursday, March 14, 2002, 11:23:27 PM, you wrote: SC> We have Mysql standard distribution (ver 3.23.32) for SC> Solaris and we just realised that we needed InnoDB SC> support. What would be the easiest way to add InnoDB SC> table type? Is it possible to do it without affecting SC> the ta

printing/Displaying Mysql Database layout

Hello all. I am running mysql 3.x on Redhat Linux, and Solaris 2.6 and 8 Most of the development work is done on these servers. I do have a couple of windows developers using tools like mysqlfront Is there way with mysql to print out table structure in a useable text format or maybe even a gr

Re: manip.cc

:::... pjs ... writes: > is anyone getting errors when trying to install mysql++, after > installing the patch for gcc3? > i've gotten a flood of errors which i've fixed, step by step, by adding > "std::" to various > variables. manip.cc is spitting out error messages like this one: > > manip.cc:

Creating tables in mysql

Hello, Now i am struck up with one problem...When i am trying to create a table in the mysql database it is giving this error...Can anyone plese help me how to rectify this problem.. ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13) My mysql database name is dbase and my t

Re: Creating tables in mysql

Hello, Now i am struck up with one problem...When i am trying to create a table in the mysql database it is giving this error...Can anyone plese help me how to rectify this problem.. ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13) My mysql database name is dbase and my ta

SELECT is using wrong key AND getting wrong results

Hi! > "Mike" == Mike Wexler <[EMAIL PROTECTED]> writes: >> Description: Mike> SELECT fullTextMatches.realname, fullTextMatches.address, Mike>fullTextMatches.address2, fullTextMatches.city, Mike> fullTextMatches.state, Mike>fullTextMatches.zip, fullTextMatches.country, Mike>

  1   2   >