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
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 d
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 serve
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
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 (v
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_e
'a_username',
'a_password',
{RaiseError=>1,
AutoCommit=>1})
or die "$0: $DBI::errstr"; }
So, try using "club" instead of "database=club", and a hostname too.
greetings joe
[nothing new below]
> -Original Me
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( ?, ?, ?, ?,?,?, ?,
> ?, ? ) ";
>
$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$
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
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 erro
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
ok I have (for now) three tables all with the same ID, however I want
to be able to change the ID if I need to. But I don't want to do it
with 3 statements (ie, update table01 set id=2 where id=3;update
table02 set id=2 where id=3;update table03 set id=2 where id=3) what I
would rather have is a
13 matches
Mail list logo
