Re: MySQL multiple query in php script. (newbie)

On Friday 25 July 2003 02:02 am, Fred van Engen wrote: > > $sql = "SELECT Realtor, HouseAddress, Bathrooms, > > Bedrooms, YearBuilt, Garage, Location, Basement, Info > > FROM properties WHERE Bathrooms =='".$a."'", "Bedrooms > > =='".$b."'", "Garage =='".$c."'", > >         "Basement =='".$d."'"; >

Re: How to export db or table structure?

One other question. I'm trying to see if I can get an application written in ColdFusion and using MyODBC to execute SHOW CREATE TABLE statements. The problem I'm having, though is that I can't figure out how to get CF to refence a column name containing a space. Is there any way to alias the nam

RE: How to export db or table structure?

Hi Jim - Thanks for the suggestion. It appears that show create table tablename may not be supported on the MySQL version I am running. However, someone else suggested mysqldump -d, which I used to do exactly what you mentioned - dump the create statements for all the tables in a db. Not sure w

Re: How to export db or table structure?

mysqldump --opt -Jackson On Friday 25 July 2003 10:39, Jim McAtee wrote: > > We have a very large MySQL database, and the designer of the database no > > longer works for us. I need to re-create the same table structure, but > > without the content, on a separate machine. > > > > I know I can d

Selecting unique values

I have two tables as below: CREATE TABLE domain_types ( type_id INT(4) NOT NULL AUTO_INCREMENT, name VARCHAR(10) UNIQUE NOT NULL, description VARCHAR(75), PRIMARY KEY(type_id) ) TYPE=INNODB COMMENT="Types of domains we store"; CREATE TABLE domains ( domain_id INT(6) NOT NULL AUTO_INCREM

Re: How to export db or table structure?

> We have a very large MySQL database, and the designer of the database no > longer works for us. I need to re-create the same table structure, but > without the content, on a separate machine. > > I know I can do a show tables on the existing db, and also a describe on > those tables, so I know w

Anomaly in resultset

Greetings I have a table with the following table structure - FieldType Collation NullKey Default Extra --- - - -- -- --- -- emailchar(75) latin1_swedish_ci is_sent e

MySQL shutdown error...

Hi gang Not sure if this is more for the RedHat list than here, but let's try... I've put MySQL on a RedHat by using the RPM ... haven't yet figured out if it actually works... but I had to make the thing start automatically on my own ... so I put mysqld and mysql on the startup list for runlev

How to export db or table structure?

Hi All - I'm a newbie to the database area, but have inherited a MySQL database to manage along with my development duties. We have a very large MySQL database, and the designer of the database no longer works for us. I need to re-create the same table structure, but without the content, on a se

LEFT() doesn't use index?

Hi, I was using a 4.0.13-server and wondering about why LEFT() doesn't take advantage of an index, the way .. LIKE "X%" .. does. I was wondering if there would be any effort in implementing this optimisation, or if people should just be encouraged to use LIKE (as bug #747 mentions)? -- - Peter B

Re: Can anyone stop this guy?

H, possibly a vacation message? "I am taking the sun" is the translation I got courtesy of http://www.freetranslation.com/. Correct me if I'm wrong, but I believe it's his mail servers (MTAs) that control how often the auto-reply is and the fact that it goes to lists. Best bet is probably

Re: FW: Relationships in Mysql

Nils, Thanks. I will code accordingly. Carlos > > Hi Carlos, > > I believe that would have to be 2 separated steps. > > 1) creating the value in the primary key and > 2) creating the foreign key value > > However you can use UNION to write both statements in one go. > > Best regards > > Ni

RE: large mysql/innodb databases

There's also netapp (www.netapp.com). I don't have much experience in some of these things, but I would stick with the same vendor that you use now or whomever they have a partnership with. I can't imagine that Sun,HP,EMC,Netapp,IBM have major differences in the quality of their solutions or even

RE: Aborted clients

Ken, Thanks for that info, the SHOW PROCESSLIST command was exactly what I needed. It shows we're running about 50 some odd connections which is just about right. mysql> show processlist; +-+--+-+--+-+---+--- ---

Re: [Q] about AUTO_INCREMENT...

Write a Friend said: > When using AUTO_INCREMENT, is there a way to set the starting > value. > > Thanks, > Carlos Alter Table TABLENAME AUTO_INCREMENT=1 where TABLENAME is your table. Of course this resets it so the next use of auto increment will generate a 1 for the table. I use is right afte

Re: FW: Relationships in Mysql

Hi Carlos, I believe that would have to be 2 separated steps. 1) creating the value in the primary key and 2) creating the foreign key value However you can use UNION to write both statements in one go. Best regards Nils Valentin Tokyo/Japan 2003年 7月 26日 土曜日 05:20、Write a Friend さんは書きました: >

Re: MySQL 3.23.51 Reference Manual needed

Thanks Ken, I've found it. Great. Regards, Venelin Ken Menzel wrote: Hi Venelin, If you have the source code go into the ./Docs directory of the source tree and read the Makefile on how to build the format you want (PDF, HTML etc) if that is the machine you built on there may already be the

Re: select part of a field into another field

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select part of a field into another field

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access Denied

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

The GRANT command question

I have recently set up mySQL on a Mandrake release of Linux (Version 7 of Mandrake, I believe), using the binary 4.0.13 standard release. The set up and start up all were normal, as far as I could tell, with no warnings or error messages. In nearly all respects, the database appears to be running

Can anyone stop this guy?

Hi. Can anyone stop this guy and this message? I'm getting a ton of them. I might just direct his email to my delete bin. Thanks, Trina -Original Message- From: Info [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 10:01 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTE

query to find the closest result

Hi, I'm working on a PHP based website that loads custom pricing for users where they logon. I'm trying to write a query to find the custom price of an item. Here is the table with all the prices in it. mysql> DESCRIBE item_price; ++--+--+-+-+---+ |

Re: mysql setup problem

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Rewrite

Would table names still be case sensitive if the connection is done through odbc? Diana Soares wrote: Read the first item that appears in MySQL manual if you search for "case sensitivity": http://www.mysql.com/doc/en/Name_case_sensitivity.html -- MySQL General Mailing List For list archives: ht

Looking for fast MySQL components for Delphi 6/7

I'm on a trek looking for fast reliable (bug free) MySQL 4.1 components for Delphi 6/7 for accessing large MyISAM and Innodb tables. Can anyone make any recommendations? I've tried MySQLDAC from MicroOlap and unfortunately support is terrible. (No reply to any of my e-mails in the past 2 weeks)

LEFT JOIN limitations ??

Hello, I have a strange problem, maybe some of you will be able to explain me something. I use LEFT JOIN as a substitute for subselects. It's true that many subselects can be rewriten using LEFT JOIN. I have made a query which use LEFT JOIN statement and... when there are many LEFT JOIN's (over 3)

RE: Aborted clients

No, no changes to the max_connections. What we did discover is that although this is a master db and not a slave of any, it was trying to replicate to an unknown server (nothing in the master.info file) with user "test". Nobody here recalls doing anything to set this up... FYI Variables mys

Altering table and field names

I would like to copy the values from each record in the Program table to another table (tblPrograms). This is the syntax I came up with: select * from Program insert tblPrograms set ProgramCode=Location, ProgramName=Description; However, it fails without telling me why. Perhaps someone could c

Re: MySQL error code 1064

I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an applica

Fwd: MySQL error code 1064

I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Fwd: Re: MySQL error code 1064

I found a syntax error which caused the 1602 error and corrected it. I am now back to struggling with the '1064 - You have...' error. Unfortunately, I have been unable to find any reference to this particular error. --- Begin Message --- I streamlined the application so as to target the offending

Re: MySQL error code 1064

I found the following by performing a google search: 1602 Btree unpacked page size (from header) does not match size loaded from disk Not sure what this means, but still looking for a better error reference. The link found in the google search was: http://www.clarionmag.com/cmag/v1/v1n1tpserro

Re: MySQL error code 1064

I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. >>> "Kenneth Illingsworth" <[EMAIL PROTECTED]> 07/

Re: SQL Help...

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL Help...

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Selecting unique values

I have two tables as below: CREATE TABLE domain_types ( type_id INT(4) NOT NULL AUTO_INCREMENT, name VARCHAR(10) UNIQUE NOT NULL, description VARCHAR(75), PRIMARY KEY(type_id) ) TYPE=INNODB COMMENT="Types of domains we store"; CREATE TABLE domains ( domain_id INT(6) NOT NULL AUTO_INCREM

RE: Function to extract difference in Minutes from DateTime variables

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: What is a good benchmark?

I have only a G3 400 Mhz machine while not that fastest around I discovered something interesting. Here's numbers for a 20 run average using different terminal applications: Apple Terminal.app 2.8145 sec X-11 xterm 2.597 sec. The X-11 terminal was consistently faster than Apple's Te

Re: Function to extract difference in Minutes from DateTime variables

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL error code 1064

On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: > I cannot seem to find this in the MYSQL Reference. Are there other places I > should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. > The message text in my

Re: MySQL 3.23.51 Reference Manual needed

> I am looking for the Reference Manual for MySQL 3.23.51 (or the latest of > the prior ones). Can anyone help me? You should find the manuals etc at: http://www.mysql.com/documentation/index.html HTH! David P -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: Problems with MySQL, Windows 2003, IIS6, ASP?

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help with DELETE and a subquery

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with MySQL, Windows 2003, IIS6, ASP?

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Crash on mysql_real_connect on FreeBSD 4.7

Hi, has your problem solved ? Would u post the code here ? Matt Davies wrote: Thank you for your direction. I posted on both lists under the hope that I could find someone out there with experience using the API - whether the C api or the C++ - and who may have encountered a similar problem.

Re: InnoDB locking: Different behavior on 3.23.55 and 4.0.13

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB locking: Different behavior on 3.23.55 and 4.0.13

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication process?

Hi First at all ... sorry for my poor english. I have the following process: I have a Primary PC that acquires data from an external device. This data is stored in a local database. This external device is sending information all the time. There is a Secondary PC that copies the data from the

RE: Index Field

> Just a quick question on whether I need both fields to > be indexed. > > The table is as below.. I'm wondering if I need to have these > 2 fields -> > fa_id & serial_no > > fa_id would be a 7 character int like "001", "002" > serial_no would be like "WMACK001", "WMACM121" >

Re: two masters replicating to a single slave

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: two masters replicating to a single slave

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql stops processing

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql stops processing

Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Aborted clients

Hi Jeff, Just a quick guess did you change the max_connections variable up from the default of 100? You did not provide a show variables so I can only guess. >From the [mysqld] section of /etc/my.cnf set-variable= max_connections=500 Ken - Original Message - From: "Jeff McKeon" <

Re: MySQL 3.23.51 Reference Manual needed

Hi Venelin, If you have the source code go into the ./Docs directory of the source tree and read the Makefile on how to build the format you want (PDF, HTML etc) if that is the machine you built on there may already be the HTML format document there. Hope this helps, Ken - Original Messag

Re: Aborted clients

Hi Jeff, The two telling line for your aborted clients are > *** 39. row *** > Variable_name: max_connections > Value: 100 and > > > | Max_used_connections | 100| This means that you hit the limit. Are saying you don't believe yo

what do you think of speed

Hi, I did a complex query (long) query and I calculated the time it took to process and put it in a file was about 7.046557 seconds and just do execute the statment it was 4.794579 seconds so 3 seconds to put the results in a file. Now I really please with the results because I am a complete ne

Re: FW: Relationships in Mysql

I am a newbie to db. I have a few tables, one that I define the primary key. CREATE TABLE member ( memid INT(6) UNSIGNED ZEROFILL DEFAULT '002000' NOT NULL AUTO_INCREMENT, last VARCHAR(20) DEFAULT '' NOT NULL, first VARCHAR(20) DEFAULT '

[Q] about AUTO_INCREMENT...

When using AUTO_INCREMENT, is there a way to set the starting value. Thanks, Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

importing access.mdb

Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from the windows server to

Lock records

I need to know how to lock single records in a table. I have multiple users logging on to a web site. I need to keep them from changing data on a record at the same time. Thanks in advance... /T

bulk load of geometry type?

I am trying to use the geometry data types introduced in version 4.1-alpha and the spatial indexing seems to work well. But I have a large volume of data to load, and from the documentation all I can see is that I have to load using a set of INSERT (or UPDATE) commands, which are rather verbose, a

rights to create table, select, then drop table..

I have a need to get data from the db that requires me to 1) do a select and create a new table with the results 2) run a query against that new table 3) drop the new table I have a script on my server that does this using the root account that has all on *.* for the db. It works fine. I no

doesn't start mysql

Hi every one: I have the followin error just after mysql starts: "/usr/bin/safe_mysqld: line 280: 17018 Killed $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 030725 16:5

Re: Help with DELETE and a subquery

Hey, Thanks for the help. I dont think this is possible, because MySQL will not let you delete from the same table you are reading. Is there an alternative way to do this using a subquery, you think? >ignore both previous posts. Both don't work as wanted. I just realized that >and I will come ba

MySQL error code 1064

I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statemen

Aborted clients

Ver 3.23 on RH Linux. We came in this morning and were greeted by our DB server rejecting connections to the db from our application. There seems to be a high number of Aborted_clients. How can we tell what clients/connections are causing this? mysql> show status; +--+--

MySQL 3.23.51 Reference Manual needed

Hi, I am looking for the Reference Manual for MySQL 3.23.51 (or the latest of the prior ones). Can anyone help me? Kindest regards, Venelin Arnaoudov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Updating a record with MAX(value)

Vikram Vaswani <[EMAIL PROTECTED]> wrote: > > Is there a way to update the record with maximum value in a table with > another value? > > I am trying this: > > mysql> update services set sfee = 1 where sfee = max(sfee); > Query OK, 0 rows affected (0.06 sec) > Rows matched: 0 Changed: 0 Warnin

Re: Access Denied

Vidhya CS <[EMAIL PROTECTED]> wrote: > hi , > I installed MySQL-server-4.0.14-0.i386.rpm > MySQL-client-4.0.14-0.i386.rpm > > when I give mysqladmin -u root > it is asking for password . The doc says that initially the password is > empty and we just need to press enter . > I read the mailing lis

Command "Show Column"

Hi again, I know that "Show Column" query shows the name of all variables with their characteristics. I want to know if there is a command that ONLY shows the name of the varibales of a column (without characteristics). Thanks a lot. eli _

Re: MySQL 4.013 - How to set innodb_fast_shutdown?

Eddy, - Original Message - From: "Eddy Muljono" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, July 25, 2003 11:48 AM Subject: MySQL 4.013 - How to set innodb_fast_shutdown? > I am using MySQL 4.013 (Win2000 Prof). > How to set innodb_fast_shutdown to OFF in My.ini

R: R: Replication stopped without reason

After 60~120 secs the replication stopped. Setting the parameter Connect-rety to 30 secs doesn't change the situation: the slave lose the connection and the replication is stopped. Massi -Messaggio originale- Da: Egor Egorov [mailto:[EMAIL PROTECTED] Inviato: venerdì 25 luglio 2003 10

Re: output from mysqlbug

amg <[EMAIL PROTECTED]> wrote: > >>Description: > mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; > generates the following error msg: > ERROR 1148: The used command is not allowed with this MySQL version >> >>How-To-Repeat: You can find answer

Re: R: Replication stopped without reason

"trashMan" <[EMAIL PROTECTED]> wrote: > YesThe replication stopped in the next 60 secs. > > I've tried to change connect-retry to 30 secs without result. > What do you mean "without result"? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is spons

Re: Relationships in Mysql

el [DATE], [NAME] en [ADDRESS] escribió: Thank you for your help and for the lesson. Eli > I would just add a few words to Nils' excellent reply: > > In the most general sense, a foreign key is just a primary > key value that occurs outside of its native table (i.e. in > a "foreign" table, get

replication

Hi all, I would like to replicate some tables from a database once a week. The slave server will dial-in to the master server. The tables type is InnoDB. - How could I know if the slave has finished the replication process? - How is the best way to recover data, if the connection broken while doin