Lee Zelyck wrote:
Greetings all,
I have taken it upon myself to try and learn MySQL
management this weekend! No more using root for
everything anymore! However, I cannot seem to do
anything but create a login.
I have tried to build an extrmely simply Forum
using MySQL and PHP. I can creat
Nowhere have i seen that it tells u to do this ?
mysql> INSERT INTO user
VALUES('localhost','ForumUser',PASSWORD
('forum123'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
for a forum i would do
GRANT SELECT,INSERT,UPDATE ON *.* TO [EMAIL PROTECTED]
identified 'somepass'
>
Greetin
Greetings all,
I have taken it upon myself to try and learn MySQL
management this weekend! No more using root for
everything anymore! However, I cannot seem to do
anything but create a login.
I have tried to build an extrmely simply Forum
using MySQL and PHP. I can create the DB and TABLE
In case anyone else encounters this particular symptom, it turns out the
problem was gcc using some orphaned headers for mysql 3.23.56 sitting in
/usr/include/mysql rather than the correct mysql 4.0.17 ones residing in
/usr/local/include/mysql, thus yielding all the strange behaviour.
M.
On Sat,
Possibly veering off topic, but I have a strong urge to comment on this, and
shall!
I am a M$ .NET developer (primarily ASP.NET with SQL Server), and have
recently embarked on a project at home, and wished to apply the same sort of
principles that I use at work - for example, keeping all 'system l
At 16:45 -0600 3/20/04, Matt W wrote:
Hi Jim,
Unfortunately you do have to use the CONCAT() function to make sure it
works on all MySQL installations. The operator used in other DBs, and
which can be used in MySQL when running in ANSI mode, is ||, not +:
SELECT firstname || ' ' || lastname AS ful
Hi Laphan,
(I'm sending this to the general list too, since this isn't Windows
specific and more people will see it.)
MySQL 5.0, which is an early Alpha, does now support stored procedures.
http://www.mysql.com/doc/en/Stored_Procedures.html
And MySQL also supports transactions with the InnoDB (m
Hi Jim,
Unfortunately you do have to use the CONCAT() function to make sure it
works on all MySQL installations. The operator used in other DBs, and
which can be used in MySQL when running in ANSI mode, is ||, not +:
SELECT firstname || ' ' || lastname AS fullname
FROM customers
But if MySQL i
Hi,
The only utility I know about that does this kind of thing is mysqldiff
which can be found at:
http://freshmeat.net/projects/mysqldiff/
I haven't used it myself but it comes quite highly rated on freshmeat.net
A quote from it's description:
"mysqldiff is a Perl script which compares the d
I have 3 tables to join when the last one is a Full-Text table (ft_table)..
I do the next join:
SELECT id,title FROM table1 LEFT JOIN table2 USING (id) INNER JOIN ft_table
USING (id) WHERE ...
But MySQL selects the primary key (id) to join the ft_table, which makes the
query run a lot of time and
Had my brain been in gear, I would have typed the 'AND Latest.TimeStamp =
S.TimeStamp' which you will also need on that join..
Cheers,
Matt
-Original Message-
From: Matt Chatterley [mailto:[EMAIL PROTECTED]
Sent: 20 March 2004 19:51
To: 'motorpsychkill'; 'mysql'
Subject: RE: retrieving
Making the assumption that you are running a version of MySQL which supports
subqueries, I believe you could use:
SELECT Login, TimeStamp, IP
FROMSessions S
INNER JOIN (
SELECT MAX(TimeStamp) TimeStamp, Login
FROMSessions
Well, it's up to you of course.
Personally, I think what you need is pretty easy if you can get someone with
the right skill set to give you a hand. Unless there are a lot of
requirements that you haven't mentioned yet, someone like me could load your
database, build your queries, and write your s
I think this is getting abit over my head here. I'm not a programmer and
don't have much interest in becoming one. Maybe I'll just settle for an
existing CMS even if it goes way beyond what is required for this. I've
added a few comments below.
Cheers,
Phil
-Original Message-
From: Rhin
Andre MATOS <[EMAIL PROTECTED]> wrote:
>
> I tried it, but it didn't work.
>
> ERROR 1217 at line 3483: Cannot delete or update a parent row: a foreign
> key constraint fails
>
> I am using InnoDB... that's my problem...
Add to the beginning of the dump file:
SET FOREIGN_KEY_CHECKS=0;
and
S
If I've understood you what I want, then MySQL time functions can help.
It is always possible to substract time with MySQL. So if you substract
the value of your column "TIMESTAMP" from current time, you will get all
records that are older than now. I can't try it now, but I believe
something in th
Hi
I'm looking for a tool (program, library), which given a file
describing the structure of the tables in a database, could update
the structure of those tables, i.e. create new table, add fields and
change field size.
Such a tool (especially as a dll library) would be very useful
because i
"Mike R" <[EMAIL PROTECTED]> wrote:
>
> Thanks for responding! :)
>
> "UPDATE sites SET start_date = '$MySQLDate', domain = '$host_edit',
> host_plan = '$host_plan_edit', ssl = '$ssl_edit', fp_ext = '$fp_ext_edit',
> username = '$username_edit', password = '$password_edit', fp_password =
> '$fp_
Hi,
I've succesfully connected to MySQL from a VB .NET application using a
MySQLDriverCS, I'm now looking for the same thing but on a Visual Basic
6 environment.
For a number of reasons ( the first is that the application should
start from a cd without installation ), I don't want to use ODBC.
t
Hi,
I've succesfully connected to MySQL from a VB .NET application using a
MySQLDriverCS, I'm now looking for the same thing but on a Visual Basic
6 environment.
For a number of reasons ( the first is that the application should
start from a cd without installation ), I don't want to use ODBC.
t
20 matches
Mail list logo
