Re: Recursive queries

Am Freitag, 13. Mai 2005 10.32 schrieb Marcus Bointon: I have a table that represents a tree structure via a self-join. I'd like to get hold of all parent records in a single query - is such a thing possible? e.g. given idparentid 10 21 32 42 51 64 There is

Re: LENGTH() and UTF-8

Am Montag, 9. Mai 2005 11.55 schrieb Andreas Steichardt: Hi! We are storing UTF-8 data in out mysql database and we need to get the length of the data. But length() doesn't return the number of characters but the pure number of bytes. SELECT LENGTH('köter') = 6 Currently we are doing

Re: [OT] client_IP

Am Freitag, 6. Mai 2005 02.10 schrieb [EMAIL PROTECTED]: Forgive me if this question has been answer in the past. How can you record IP address on your first page index.html? I am using my index.html to be index.lasso, and client_ip tag does not seem to work. It is picking up my server IP,

Re: Auto SQL

Hi Winanjaya Am Montag, 11. April 2005 09.50 schrieb Winanjaya: I am using MySQL 4.1, I have a database with more than 100 tables inside, is there any 3rd party tools that can help me to create a SQL statement of CREATE TABLE blah blah blah for each table in my DB . please advise Here's a

Re: Load data infile and text fields

Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]: First of all I hope you can be patient for my english I'm working with data import into mysql from a txt file. I'm using LOAD DATA INFILE command but I cannot correctly import a text column of 595 characters. I receive this (very

Re: insert data

Hi Gerald my last try... i'm not very lucky in helping in this list... This is the actual code except for the : [...] my $sth = $dbh-prepare( $sql ) or die $dbh-errstr if $dbh-err; Maybe this expression is the reason (combination of 'or' and 'if'). Example code: === my $no_error=0;

Re: insert data

Hi Gerald I am trying to insert data for the first time using MySQL. In Oracle I used the following: # my $sql = insert into bar( group_name, me, daily, item, unit, qty, amount, tax, total ) # values( ?, ?, ?, ?,?,?, ?, ?, ? ) ; my $sth

Re: insert data

club instead of database=club, and a hostname too. greetings joe [nothing new below] -Original Message- From: John Doe [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 6:37 AM To: mysql@lists.mysql.com Subject: Re: insert data Hi Gerald I am trying to insert data

$20 YEAR WEB SITE HOSTING / $9.95 DOMAIN

$20 YEAR WEB SITE HOSTING / $9.95 DOMAIN - Server based in U.S.A - 99.9% uptime - Pay monthly or Yearly by Credit Cards - 50MB Disk Space [more plans are available] - PHP, MySql, CGI, ASP and many more - POP3, SMTP, Forwarding and Auto Reply - Cpanel 4.7 - 1500MB Traffic per month - 9.95$

Stupid - I just can't get it (NOT IN or NOT EXISTS)

Simle query request: I want to display the ID for everyone in a table who is NOT in a second table. so this is what I have come up with SELECT student.SID, student.firstName FROM student WHERE student.SID NOT IN (SELECT msoccerroster.SID FROM msoccerroster) It comes up with an

Re: Stupid - I just can't get it (NOT IN or NOT EXISTS)

Well that is really dumb because on page: www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html it gives me a manual page oh the syntax of how to use it. However I think you are right and the manual is wrong. (congrats) J From: Nick Stuart [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL

columns no more

is there a way to delete a column from a table, without droping the whole table? If not is can I get sql to replicate the command to re create the table? and if I can't do that how can I transfer information to a dummy table while I create the table I want? PS, I only have command line access