Getting the Parent Table for Returned Columns in a Relational Search

I am new to the list and glad to joining the MySQL community. I am trying to ascertain the table to which each column in a MySQL record set belongs in a relational search query. There may well be duplicate column names across tables. How can I query MySQL to tell me the parent table for each co

Ann: New article at www.vbmysql.com

Hi All; I would like to take a moment to announce that I have finished work on a new article at vbmysql.com! The latest article, titled "The VB-MySQL Tutorial - Part 1", covers the basics of application and database design, covering subjects such as entity design, relationships, and the creation o

Re: Can't connect to MySQL server

Roger and Johannes, The default did have the "skip-networking" on. I commented that out as you advised, and it worked like a Charm!! I'm pretty excited to be able to have that working now. I really really appreciate the prompt reply and the consideration that you both took in your replies.

Re: Can't connect to MySQL server

* Aaron Gerber > I'm new to the list, hope this is the correct mailing list. It is. :) > I have a new installation of MySQL 4.0.16. Default binary installation > (apt-get). It's running on linux (morphix .4). > > Locally, I can connect to the MySQL server > > mysql -h localhost -p You are not

Re: Can't connect to MySQL server

* Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]: > Locally, I can connect to the MySQL server [...] > but I can't connect if I put in the IP address (locally or remotely) Maybe mysqld is configured to listen on its unix domain socket only? This is the default for Debian. Remove the li

Re: mysql database, user table, two root accounts

On 10 Jan 2004, at 17:47, Michael Stassen wrote: Eg. if you've two host entries; one '192.%' and the other '192.168.%' - and you connect from 192.168.100.12, which row gets chosen? As I understand it, 192.168.% is more specific than 192.%, so 192.168.100.12 would match 192.168.% My thoughts ex

Re: Text fields

* Segis-Eresmas > I have a table with a Text field (with texts) and Fulltext index. When > I search a word (...) f.e. 'with match...against...', How can i do it to > see the line and the line number of the text in that text-field? There is no such functionality in mysql, you would have to impleme

Can't connect to MySQL server

I'm new to the list, hope this is the correct mailing list. I have a new installation of MySQL 4.0.16. Default binary installation (apt-get). It's running on linux (morphix .4). Locally, I can connect to the MySQL server > mysql -h localhost -p I can also connect through phpmyadmin (remotely or

Automatic Updating of Timestamp

Hi, I've just found out by accident, that MYSQL will update TimeStamps automatically, that saves a lot of coding timestamps etc. http://www.mysql.com/doc/en/DATETIME.html TIMESTAMP behavior when not running in MAXDB mode The TIMESTAMP column type provides a type that you can use to automatical

Date query question

I don't have much experience working with dates in Mysql; I've always prefered to manage dates in code, so bear with me. I've got the following definition (yes, no indexes right now): CREATE TABLE se_t ( datestamp timestamp(14) NOT NULL, remote_addr char(16) NOT NULL default '', request_ur

Re: Automatic conversion from `char` TO `varchar`

Hi, > The manual says > > > The following problems are known and will be fixed in due time: > > [...] > > All string columns, except BLOB and TEXT columns, automatically have > > all trailing spaces removed when retrieved. For CHAR types this is okay,

Re: Automatic conversion from `char` TO `varchar`

The manual says The following problems are known and will be fixed in due time: [...] All string columns, except BLOB and TEXT columns, automatically have all trailing spaces removed when retrieved. For CHAR types this is okay, and may be regarded as a

Re: mysql database, user table, two root accounts

Steve Folly wrote: On 9 Jan 2004, at 22:43, Michael Stassen wrote: As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table, each with its own password and privileges, they are 2 separate root accounts from mysql's perspective. You could choose to think of them as t

Text fields

Hi: I have a table with a Text field (with texts) and Fulltext index. When I search a word (...) f.e. 'with match...against...', How can i do it to see the line and the line number of the text in that text-field? Think's Segismundo -- MySQL General Mailing List For list archives: http://list

Re: Mysql Problem...

Did you stop and restart the server while you had the client up? This will break the client's connection and force it to try and re-establish it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DST

* Hassan Shaikh > Thank you for your informative coverage regarding the captioned. > According to your recommendations I've created a separate location > table which contains time zone difference in (+/-) minutes. As per the > server, my assumptions is that it's located somewhere in California, > U

Re: Strange reply

A way for the postmaster to convey that the recipients email address has changed. So the admin of [EMAIL PROTECTED] is going to go in and change the subscribed email of Person X to the new email advertised in this email To quote Homer Simpson "Yeah Right!" Regards, -Martin - Original Message --

Re: Strange reply

It looks like a broken auto-reply from the administrator of someone subscribed to the list. Michael Clayburn W. Juniel, III wrote: When I send mail to [EMAIL PROTECTED], I get the following reply: From: [EMAIL PROTECTED] Subject: AutoReply Reminding Message: "Java Java mysql.

Re: Time Zone

* Harald Fuchs [...] > > You could also store the number of halfhours. > > Nope. Chatham Island has an offset of +12.75 hours. Yeah, and Kathmandu is +5.75 hours. Better avoid customers from Chatham Island and Kathmandu, then... ;) Seriously, I have implemented a timezone system once, but we on

Strange reply

When I send mail to [EMAIL PROTECTED], I get the following reply: From: [EMAIL PROTECTED] Subject: AutoReply Reminding Message: "Java Java mysql.list" <[EMAIL PROTECTED]> domain changed as @Cathaybk.com.tw Date: January 09, 2004 17:00:58 MST To: [EMAIL PROTECTED] Original Subject: Re

Re: Automatic conversion from `char` TO `varchar`

Hi, > No, it´s not strange. > Look the manual at http://www.mysql.com/doc/en/Silent_column_changes.html Yes, it's documented. But it still is strage. CHAR should, according to the SQL specification, pad any value smaller than the defined number of characters with spaces when it returns the value

Re: Automatic conversion from `char` TO `varchar`

On Sat, Jan 10, 2004 at 05:06:56PM +0500, Hassan Shaikh wrote: > It's really strange but when I execute the following statement, all my char(10) > columns turn into varchar(10). My other tables are ok and I've tried create dummy > table also. Problem seems to be associated with this table only. >

Re: Automatic conversion from `char` TO `varchar`

No, it´s not strange. Look the manual at http://www.mysql.com/doc/en/Silent_column_changes.html Best Regards --- Luciano Barcaro Depto. Informática - Laboratório Alvaro Hassan Shaikh wrote: Hi, It's really strange but when I execute the following statement, all my char(10) columns turn into varch

DST

Gentlemen, Thank you for your informative coverage regarding the captioned. According to your recommendations I've created a separate location table which contains time zone difference in (+/-) minutes. As per the server, my assumptions is that it's located somewhere in California, U.S. (my hostin

Automatic conversion from `char` TO `varchar`

Hi, It's really strange but when I execute the following statement, all my char(10) columns turn into varchar(10). My other tables are ok and I've tried create dummy table also. Problem seems to be associated with this table only. CREATE TABLE `offer` ( `SVID` int(11) NOT NULL auto_increment,

Mysql Problem...

Hello All, When I try to execute query on mysql prompt I get following error before the query is been executed. MySql is running. mysql> select * from temp where username='tom' and ondate='2002-02-03'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id: 515

Re: Certification Question

Hello Aman, For instructions on taking the exam in India goto the URL: http://www.vue.com/mysql/ and click on "test center" of "To register for exams in India, please contact the test center directly. This will bring you a window containing all the Pearson VUE Test Center in India. Good luck!

Re: mysql database, user table, two root accounts

On 9 Jan 2004, at 22:43, Michael Stassen wrote: As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table, each with its own password and privileges, they are 2 separate root accounts from mysql's perspective. You could choose to think of them as the same accoun

Re: ON UPDATE CASCADE

Morten, http://www.innodb.com/ibman.php#InnoDB_foreign_keys " A deviation from SQL standards: if ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update a table for which there already is an update operation in the stack of cascaded operations, it acts like RESTRICT. In plain English this means

Re: foreign key contraints, on delete cascade not working?

Andrew, please check with SHOW VARIABLES LIKE '%innodb%'; that you really have InnoDB enabled. I tested the script below on Linux with 4.0.8 and 4.0.18, and it worked ok. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL I