Newbie question: UPDATE

lation? If it is special, where can it be found? Thank you for your help. Joe. -Original Message- From: Joe Herman [mailto:[EMAIL PROTECTED] Sent: Sunday, November 27, 2005 12:21 AM To: mysql@lists.mysql.com Subject: Newbie question: How to import data into a table? Hello folks,

Newbie question: How to import data into a table?

Hello folks, What is the best way to import an excel spreadsheet, or text file for that matter into a table? Is there a way to do this with PHPMyAdmin? Thank you so much for your kind help. Joe

Sub Query

Hi Could anyone help perhaps tell me why the following simple query containing a sub-query gives a syntax error. select 1 from messages where not exists ( select 1 from message_push_notifications where message_id = messages.id) Thanx Herman

FW: What development environment?

Hello, I am a website designer and am committed to learning how to create database driven websites. Currently I am thinking about using php with MySql, but was wondering if there were any more compelling development environments such as visual studio.net, asp, and or java. Based on the experience

Innodb?

Hello, I am just starting with MySQL and PHP, but this discussion about innodb has rather piqued my interest. Can someone please give a brief explanation as to what it is. Cheers, Joe.

RE: Can't figure out how to get it running

rom: Eric Mynes [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 12:35 PM To: Joe Herman Cc: mysql@lists.mysql.com Subject: Re: Can't figure out how to get it running The way I could tell that mysl is running is to (assuming that you are running windows): Click Start Click Run

Can't figure out how to get it running

ll me what I need to do to get MySQL to work? Right now I am just trying to set things up so that I can start learning PHP. Please help. Thank you. Joe Herman New York City -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Foreign key error

I tried to create a foreign key using: ALTER TABLE msg_recipients ADD CONSTRAINT msg_recipient_member_fk FOREIGN KEY (recipient_member_id) REFERENCES members (id); and got this error: Can't create table '.\wapmagic\#sql-c50_48.frm' (errno: 150) Any ideas

Creating primary and foreign keys for MySQL

Hi All I am MySQL newby with an Oracle background. Is the following syntax suported? alter table members add primary key (id); alter table members add constraint members_uk unique (name); Thanx Herman __ Do you Yahoo!? Yahoo! Mail Address

RE: multi-table select (not a join)

Jesse Sheidlower wrote: > How do you get the table name returned as part of the query > results? Or am I misunderstanding how one would work with the > results? Try: SELECT *,'TABLEA' FROM TABLEA UNION SELECT *,'OTHERTABLE&

MyODBC and .NET (C#)

Hi All, I'm having problems connecting to MySQL with C# via MyODBC 3.51.02; the DSN I created is called 'MySQL1'. The error I am receiving is: "The 'MySQL1' provider is not registered on the local machine". This is what my connection string looks like: string strConn = "Provider=MySQL1;DNS=MySQL

Fulltext truncate

I've read the TODO list regarding the fulltext search and noticed that it doesn't include any more options for truncating. I'm in need of a database which supports pre-truncating - masking would be great too :) It would be great if my favourite database would get full pre-truncation :) Q: Will pr

Creating database

p;' or '\h' for help. Type '\c' to clear the buffer mysql> create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql> \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? with kind regards,