RE: strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!

Jason, The possiblity exists that the issue is Apache. I only use 1.3 so I cannot give specific feedback. Is the PHP.ini file the same in production and as in development? Regards, Adam -Original Message- From: g4 [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 11:20 AM To: [

RE: select query syntax help [ANSWER]

This is a common question. The syntax looks like this: SELECT a.* FROM tbl_a AS a LEFT JOIN tbl_b AS b ON a.id = b.id WHERE b.id.id IS NULL; The idea is you're retrieving a recordset of the two tables where the rows are joined on the id. For tbl_b, the id field has no value (its null) so

RE: Insert ... Select question

Nikos, Yes. Use the following syntax: INSERT INTO db_name.tbl_name (col, col, col) SELECT col, col, col FROM db_name.tbl_name; Regards, Adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: Insert

RE: Online Tutorials for beginners

New to SQL or new just to MySQL? -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 10:54 AM To: [EMAIL PROTECTED] Subject: Online Tutorials for beginners Hi, Does anyone know of any good mysql tutorials online that would suit someone

RE: OS X - can't set root password

#x27;t use MySQL too much these days, but I'll be glad to tell you what I know. Regards, Adam -Original Message- From: Robert Lund [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: OS X - can't set root password Fortuno, Ada

RE: OS X - can't set root password

Robert, If I follow you're email correctly, it looks like you attempting to assign a password to the root user twice. The first statement you provide: > bin/mysqladmin -u root password ** Sets the password to whatever value you've set in-place of **. Then in the statement below you attem

RE: Anyone using MySQL 4.x on Apple's G5?

If memory serves, adjustments to the OS need to be made to take advantage of the 64-bit memory addressing. I know some changes have been made to OS X to run on a 64-bit chip, but I'm not certain they've made enough modifications to take advantage of the memory addressing. I'd be interested to see

RE: DB Design

Give this more thought. I think you have more options that the two you proposed. With really large tables, you can collect data in them for a fixed time period (monthly) then run a batch that removes the data for the time period after moving it to an archive table. Try making a staging table that

RE: Anyone using MySQL 4.x on Apple's G5?

Wow, new dual processor G5... drool How are the bulk operations performing? -Original Message- From: Gabriel Ricard [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 11:05 AM To: [EMAIL PROTECTED] Subject: Re: Anyone using MySQL 4.x on Apple's G5? I am currently testing this o

RE: ENCRYPT Syntax problem

First, don't use the word "table" in an insert into statement (e.g. `INSERT INTO tbl_nm (col_1, col_2, col_3) VALUES ('a', 'b', 3)` where tbl_nm is the name of a table in the database and col_1, col_2, etc. are names of columns in the specified table). Second, ensure the number of columns your inse

RE: deleting mysql users

That's how I do it. Take the user out of both the user and db tables. -Original Message- From: Alejandro Javier Pomeraniec [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 6:33 AM To: [EMAIL PROTECTED] Subject: deleting mysql users Hi !! Whenever i create a database user using G

RE: Setting root password on OS X

Shane, Maybe I can lend a hand. When you first install MySQL, there is (basically) only one user root. The root user exists without a password, which is why pretty much everyone recommends that you assign root a password immediately. You're first command: mysqladmin -uroot password Can you exp

RE: Which is the best MySQL book?

Cheap books -> http://www.bookpool.com -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 4:16 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: Re: Which is the best MySQL book? At 02:03 PM 10/9/2003, you wrote: >Is there one that's especi

RE: Error: "unable to execute query" - Problems using Win32 MySQL ODBC driver

Pako, That blows my theory. Regards, Adam -Original Message- From: Pakó Géza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:32 PM To: Fortuno, Adam Subject: Re: Error: "unable to execute query" - Problems using Win32 MySQL ODBC driver i dont use odbc. i

RE: Error: "unable to execute query" - Problems using Win32 MySQL ODBC driver

PM To: Fortuno, Adam Subject: Re: Error: "unable to execute query" instantly. if i execute inserts in loop, about 30 runs well, then comes the error. if i reconnect i can exec the next 30, and so on... - Original Message - From: "Fortuno, Adam" <[EMAIL PROTECTED

RE: Installation problem

H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:02 PM To: Fortuno, Adam Cc: [EMAIL PROTECTED] Subject: RE: Installation problem Adam, Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything special when I downloaded and installed the lates

RE: Installation problem

hwon -R mysql /usr/local/mysql/data Then try "mysqld_safe --user=mysql &" from the /usr/local/mysql directory. Got to run to lunch. Be back in about 45 min. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09

RE: Installation problem

and if not, I can tell you what I've done not to get it - make sense? Take a look at the error log and let us know what is says. Regards, Adam -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:15 AM To: Fortuno, Adam Cc: [EMA

RE: Installation problem

James, Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First question, are you running this on an X-Serve? So you're doing the following # (1) Going to the mysql directory. cd /usr/local/mysql # (2) Kicking off mysql using the mysqld_safe script. sudo -v sudo mysqld_safe -

RE: FW: MySQL not null vs MSAccess required

Are you serious? Its certainly a feature I can do without. Just one more idiosyncrasy to remember for another RDBMS. Regards, Adam -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 5:46 PM To: [EMAIL PROTECTED] Subject: Re: FW: MySQL not n

RE: Check (expr) Syntax and/or other fields checks

Miguel: First: Be more specific. Did you have an expression in mind? Second: Yes, use InnoDb tables to enforce referential integrity. See the URL (below) for information on InnoDb table usage. Regards, Adam InnoDb in MySQL -> http://www.mysql.com/doc/en/InnoDB.html

RE: MySQL not null vs MSAccess required

Arunas, Actually, I think you mean MySQL is the backend for MS Access. Don't assume columns that are NOT NULL must have a default value. You are welcome to define columns as NOT NULL without a default value. Doing this will force the client (the Access form's) to require a value before inserting

RE: Query help

Darryl, At first blush, I would try something like: DELETE faqcat FROM faqcat LEFT JOIN article ON faqcat.cat = article.cat WHERE article.cat Is Null; I vaguley remember MySQL implementing syntax permitting users to remove data from one or more tables. I think this might be your ticket. R

RE: printing reports

If you're going the ODBC route, StarOffice sounds like a cheap alternative (and a good suggestion); however, there are a ton of other tools at your disposal too - MS Access if you've got access to a Win32 workstation. Regards, Adam -Original Message- From: Christensen, Dave [mailto:[EMAIL

ODBC Error

All, Yo gang! Having a problem with the MySQL ODBC 3.51 driver. I've got a MySQL volume which has a user table (tbl_usr). I'm linking this table to an Access database on my workstation (via ODBC link). The account being used for the connection has select, update, and insert rights to all tables i

** Composit Key - Is it possible, and if so, what is the syntax?

All, I've got an InnoDb table that requires a composit key constraint. However, I'm not certain how to word the DDL syntax. Pretending for a sec this was SQL Server 2000 or Sybase ASE 12.5 I'd use the following. CREATE TABLE foo( pri_1 INTEGER NOT NULL, pri_2 INTEGER NOT NULL, pri_3 INTEGER

RE: Running a definition file from MS-SQL

Tormod, I feel your pain brother! Actually, I do this allot more than I'd prefer to admit. I assume when you say MS SQL you mean SQL Server 2000. When you say MySQL, you mean MySQL 4.0.x. Scripting the database/tables from query analyzer doesn't produce files, which are immediately executable in

RE: SELECT only unique records

SELECT DISTINCT(state_ID) FROM financial_master WHERE category_ID = '1'; OR SELECT state_ID FROM financial_master WHERE category_ID = '1' GROUP BY state_ID; -Original Message- From: Comcast [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 2:03 PM To: [EMAIL PROTECTED] Subject:

RE: how to do a random ORDER BY in a SELECT statement

Comcast, Simply order by the random function, RAND(). For example: SELECT aff.* FROM financial_affiliates AS aff WHERE aff.state = 'wa' AND aff.category = '3' ORDER BY RAND(); Regards, Adam -Original Message- From: Comcast [mailto:[EMAIL PROTECTED] Sent: Wednesday, Septemb

Configuration File Creation - Automatic or manual?

All, A little confused about what creates configuration (my.cnf) files. I'm running MacOS X 10.2 (Jaguar) running MySQL 4.0.x. I was looking for the global and server level configuration files in the following directories: Global -> /etc/my.cnf Server -> /mysql/data/my.cnf I was unable to locate

RE: MySQL SSL

Hong, I suggest reviewing the MySQL manual (sections 4.3.9.1 through 4.3.9.4 inclusive). As best I know, those are the manual sections dealing with SSL. 4.3.9.1 -> http://www.mysql.com/doc/en/Secure_basics.html 4.3.9.2 -> http://www.mysql.com/doc/en/Secure_requirements.html 4.3.9.3 -> http://www.

RE: SubQueries and IN

Andy: Sub queries are supported as of version 4.1 (see link #1). As for your query, double-check the syntax in the select piece. Specifically take out the 'sales.sale_id' and anything else from the 'sales' table. Then try again. Regards, Adam Link #1 - http://www.mysql.com/doc/en/ANSI_diff_Subqu

RE: Functions

Gustavo, Prefix them with 'SELECT ;' (e.g. 'SELECT VERSION();'). Regards, Adam -Original Message- From: Gustavo Castro [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 10:03 AM To: [EMAIL PROTECTED] Subject: Functions Hello, in order to call a native function do i have to add

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

Jerry, Don't forget that MySQL authenticates an entity, which is based on the user name and host. For example, on my MySQL boxes root can only login from the localhost. If I attempt to login with root from another host, I am denied access. Regards, Adam -Original Message- From: Jerry M.

2-Questions: Starting MySQL and Shutting Down on OS X

All: (1) I've got "/user/local/mysql/data" in my path, but when I attempt to run "mysqld_safe" I get a message reading: "Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe" Do I really need to be in the installation directory to ki

RE: Select statement

Darryl, The following query would return all rows in employee that existed in emp2 (**Assuming 'employee' and 'emp2' have a common field 'key'). SELECT e1.* FROM employee AS e1, emp2 AS e2 WHERE e1.key = e2.key; There is a great book that introduces SQL (SQL-1 and SQL-2 concepts) titled "The

RE: ISAM....the name sounds so familiar....

Chris, Wow, tell us how you really feel. Less age is getting the better of me ISAM (indexed sequential access method) tables are used by a few different DMS such as Informix. ISAM was original developed by IBM. It allows data access sequentially or randomly via indices. Anyway, are you asking if

RE: How can I select the column names?

I don't follow your question. Please elaborate. Cheers, Adam -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 1:46 AM To: Mysql Subject: How can I select the column names? I am trying to select the column names from a table to be displa

RE: HAVING column not in select_statement

Stefano, OOh! You're taking me back a few years. As best I remember, the 'HAVING' operator applies to the results returned by the query not in shaping the results to be generated. For example, if you have a table that stores trouble tickets per user. You select the user's last name, first name, an

RE: mysqlimport command question

uesday, September 02, 2003 5:10 PM To: 'Fortuno, Adam'; [EMAIL PROTECTED] Subject: RE: mysqlimport command question >To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] >Subject: RE: mysqlimport command question > > >Darryl, > >Provide a copy of the table&#

RE: mysqlimport command question

Darryl, Provide a copy of the table's details either with a describe table output or the table's definition and a sample of the input file's top 5-rows. Regards, Adam -Original Message- From: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 4:31 PM To: [EMAIL PROTE

RE: Show database problem

Albert, This may sound minuscule. You're certain that 'uma' is a user account and not a database or table? Normally, you use "SHOW GRANTS FOR ". See example: mysql> SHOW GRANTS FOR test_usr; +--+ | Grants for [EMAIL PROTECTED] +

RE: It is secure to access MySQL thru internet?

low-up with the documentation for your OS. If its not available through the OS, you'll need some sort of 3rd party utility. Regards, Adam -Original Message- From: Flavio Tobias [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 3:53 PM To: Fortuno, Adam; [EMAIL PROTECTED] Subject: Re: It

RE: listing all people who have the same firstname and lastname

Grant, Sure, anything's possible. Assuming you're table looks something like this: CREATE TABLE people ( id INT NOT NULL, fname VARCHAR(15) NULL, lname VARCHAR(20) NULL ) Type=InnoDB; With data something like this: INSERT INTO people (id, fname, lname) VALUES (1, 'John', 'Smith'); INSERT I

RE: Question about sub-query.

Greg, Since you're executing this from a perl script. Try saving the result of "SELECT MAX(cycle) FROM test.results WHERE snum = '$snum';" to a variable. Then use that variable in your embedded SQL statement. This alleviates that issue all together. If you're updating multiple rows, you're query s

RE: It is secure to access MySQL thru internet?

Sure. If you use a secured connection. A$ -Original Message- From: Flavio Tobias [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:11 PM To: [EMAIL PROTECTED] Subject: It is secure to access MySQL thru internet? I need to access a database thru internet. It is secure to do this