;t see the
> supposed logic error i've made,i'm stuck,anyone there to help me?
>
> thanks
Have you flushed the privileges after changing the tables?
FLUSH PRIVILEGES
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query
table2 on table1.id=table2.id
left join table3 on table2.id1=table3.id2 and table2.id2=table3id2
left join table4 on table3.id3=table4.id3
left join table5 on table3.id4=table5.id4
left join table6 on table3.id5=table6.id5
left join table7 on table3.id6=table7.id6
On Monday 19 November 2001 16:25, behrens wrote:
> first a thank to Ian Barwick,his tip saved my day.
> But now the next newbie Question! I want to insert users into the
> usertable of the mysql Tables
> how do i login?
> haven't found an answer sofar.
> Does anyone kno
bably haven't created a MySQL user 'behrens'.
Try
mysqladmin -uroot -p create BIBLIOS;
to connect as the existing root user.
Note: there is no correspondence between MySQL users and local system users.
HTH
--
Ian Bar
ly as intended.
It would not be a good idea to convert the \n to
before insertion into the database, because these will
then appear in any fields.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a
anual)
-> http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
;-)
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
--
l_users.id = sumUsr.id
Take a look at the manual pages on www.mysql.com.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
---
0
as you're using Linux, try
tar xzf DBI-1.18.tar.gz
which will unzip and unpack the whole caboodle into a directory called
DBI-1.18
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp G
) you
are storing, and what method(s) you are using to store and retrieve it, it's
hard to provide a solution...
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in
On Thursday 13 September 2001 19:16, g g wrote:
> Hi.
>
>
> Is anyone aware of any tool to convert a mysql
> database to an oracle database?
see:
http://www.mysql.com/news/article-57.html
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de
On Thursday 13 September 2001 15:36, Frank Fisher wrote:
> Ian Barwick wrote:
> > In Windows you can probably do something involving the mouse and some
> > icon-thingies, or maybe a simple DIR at the command line.
>
> Right-click on the MySQL database folder, selecting "
look for 'datadir'.
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
-
Before p
it for the first time and
maybe one which could be pointed out more prominently on the relevant manual
pages:
http://www.mysql.com/doc/U/P/UPDATE.html
http://www.mysql.com/doc/D/E/DELETE.html
(although I see that mulitple-table delete will be supported from 4.0)
HTH
Ian Barwick
--
Ian Barwick -
E.html
has the answer (but not very clearly).
The AUTO_INCREMENT parameter is set on a per-table and not a per-row basis,
so the definition comes after the row definitions, e.g.:
CREATE TABLE mytable(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY)
AUTO_INCREMENT=1000;
HTH
Ian Bar
se contains the names of all tables you reference in the query,
not just the ones you select)
(...)
HTH
Ian Barwick
--
Ian Barwick - Developer [EMAIL PROTECTED]
http://www.akademie.de
"Luncheon meat tables with MySQL data"
CT
which would provide you with the first 10 results as well as the total number
of rows. This is however a pretty messy way of doing things and I would stick
with two SELECT statements.
BTW a simple COUNT(*) without a WHERE clause is optimized in MySQL.
HTH
Ian Barwick
--
Ian Barwick - Dev
e that there is only
> a value in table three.
>
> The output could be
>
> id one.value two.value three.value
> x1 233 2342 NULL
> x2 NULL 998NULL
> x3 33 232 23
>
> Clear enough?
A couple of LEFT JOINs should probably do t
On Tuesday 28 August 2001 13:55, Harald Fuchs wrote:
> In article <01082813314101.11299@redgrave>,
>
> Ian Barwick <[EMAIL PROTECTED]> writes:
> > You mean using SELECT LAST_INSERT_ID() ?
> >
> >> and praying no other query was run at the same
> >
LAST_INSERT_ID() and release the lock. This should prevent another
insert being carried out before you retrieve the ID.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a M
umn2 AS table2_column2 FROM table1,table2
but then you would need to know which columns to alias.
Or how about using fetchrow_arrayref()? That would remove the duplicate hash
key problem, although you would have to extrapolate the column names yourself.
Hope your system has lots of memory to
27;...Is
> this possible and if so how?
Ouch! This is possible - that's what databases are here for ;-). However,
you'll want to think about normalizing your database structure.
Hint: you'll need three tables.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PR
WHERE ca.ca_c_id = c.c_id
The table abbreviations end up doubled :-( but this guarantees the
application gets unique table names and avoids the hassle of aliases.
HTH
Ian Barwick
(*) Disclaimer: example code, may not be accurate, use at own risk ;-)
--
Ian Barwick - Developer - [EMAIL PROTE
uilt date formatting wotsits.
In SQL (at least MySQL, database developers also believe tmtowtdt ;-) you can
use the DATE_FORMAT function, see:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
HTH
Ian Barwick
[EMAIL PROTECTED]
On Monday 20 August 2001 18:02, pc wrote:
> Hi peop
m user where
> x.depart_id = 10 and x.user_id = y.user_id);
>
>
> Any Ideas would be appreciated.
Err, RTFM ? ;-)
http://www.mysql.com/doc/C/o/Compatibility.html
Especially:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTE
omatically be selected too. Really every record should have a unique key
to avoid this.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
ndividually using Bidder as the selection criterium.
HTH in some way.
(If there is a more elegant solution to this problem in MySQL I'd love to
hear it)
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akad
group by gname)
Alas no subselects yet in MySQL (see:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html )
HTH in some way anyway
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is m
n any way necessary, save yourself the trouble they might cause...
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
SELECT CONCAT(vat, '%') AS vat_pc
FROM price
You could of course keep a copy of the numeric value with an added %-sign in
a seperate text field, but I'm sure that would only complicate things further
;-)
Now if only MySQL supported VIEWs ... (*)
HTH
Ian Barwick
(*) S
d the examples
> at the bottom of http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
> and they got the same error.
>
> am i missing something easy here? is this a known issue? perhaps a version
> thing? i am running 3.22.32.
Definitely a version thing, works fine on 3.23.37 (but does
30 matches
Mail list logo
