Hi Philip,
> then mysqladmin -u root -p create sample_db
This is probably the best way to go, the password you created will
most likely be for the root user.
>>mysqladmin: connect to server at 'local host' failed
>>error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
>>Doe
have u set the pass or is it correct ?
usually mysqladmin -u root password newpassword
then mysqladmin -u root -p create sample_db
>= Original Message From "Philip McCarthy" <[EMAIL PROTECTED]> =
>Dear mysql
>
>
>
>I have just downloaded mysql 3.23 for Windows and I am running XP.
>
>
>
>
Dear mysql
I have just downloaded mysql 3.23 for Windows and I am running XP.
I have started the service ok and create a database. I thought I had
set my database password ok. I have been using the book 'Teach Yourself
MySQL in 21 days' by SAMS (Mark Maslakowski).
When I try the state
Hi,
I found obvious bug that causes segmentation fault while building
on sh-linux. Please apply.
Regards,
SUGIOKA Toshinobu.
--- mysql-3.23.54a.orig/sql/gen_lex_hash.cc Thu Dec 5 18:37:06 2002
+++ mysql-3.23.54a/sql/gen_lex_hash.cc Sun Mar 9 10:13:36 2003
@@ -274,7 +274,7 @@
fun
Hi,
I'm not sure what list this should go to, so I'm sending it to the general
list. It's not about sql or queries it's more of a webmaster problem.
Apologies to the offended.
After sending several messages to the list I started receiving strange
messages. It may be spam, it may be just a viru
> > >Description:
> > HAVING in SELECT is evaluated before WHERE. This is not the
> > correct behaviour as HAVING should deal with the remainder of the WHERE
> > selection (according to manual)
>
> I cannot understand how the following can show that "HAVING in SELECT is
> evaluated before WH
I think this is more of a Programming problem, but to get you started.
In your database add a field call it updated make it char(1) like
ALTER TABLE Hockey ADD Updated char(1) default NULL;
On the first page when you start processing the players put in a programming
line to update all the players
Hi,
I have a hockey database with players names in it and I want to be able to
update their stats one after the other. To be more clear - when the page is
first entered I want the first players name to automatically appear showing
his current stats (this will be in a form). Then you can update the
Hi!
On Mar 07, [EMAIL PROTECTED] wrote:
> >Description:
> HAVING in SELECT is evaluated before WHERE. This is not the
> correct behaviour as HAVING should deal with the remainder of the WHERE
> selection (according to manual)
I cannot understand how the following can show that "HAVING in
At 15:32 -0600 3/8/03, Darren Young wrote:
3.23.54 on Linux.
And it worked. Thx. Seems to be "not so random", but then with more
records to sample from the "randomness" would increase. True?
Probably. However, if you check the change notes in the manual for
3.23.56, you'll see that RAND() initial
In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
Com_select. The documentation for Com_select implies that they should be
there. Is this the intended behavior, or is it a bug?
- JD
-
Before posting, plea
3.23.54 on Linux.
And it worked. Thx. Seems to be "not so random", but then with more
records to sample from the "randomness" would increase. True?
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 08, 2003 2:33 PM
To: Darren Young; [EMAIL PROTECTED]
Su
Open http://your.server.name/phpMyAdmin-2.*.*/Documentation.html#setup. If
you read the docs (#3 in the initial "Quick Install" section tells you that
the file you'll be editing is config.inc.php, in the phpMyAdmin root dir),
you'll just be stepped through a simple series of table creations and
ed
Anyone familiar with the GUI interface for MySQL/PHP called 'phpMyAdmin'?
I'm at a point in my intensive self-study via books, tutorials, and
exercises where one of the books I'm working with--trying to tie
together with my graphical HTML editor--Dreamweaver: PHP
Development--suggests phpMyAdmi
At 12:33 -0600 3/8/03, Darren Young wrote:
I have a table called testimonials:
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-++
| id | tinyi
>Description:
With a stale login (idle for some time), I've experienced a repeated ability
to cause a seg-fault by attempting to get the status (\s). I have not tested this
thoroughly.
>How-To-Repeat:
Log into the database, verify functionality.
Leave the login idle for a
> That is the case. Without a GROUP BY, max() is supposed to apply to the > entire
> table.
Not true. Use of MAX in WHERE clause will show that MAX is applied to
filtered data set. To use my example data set:
mysql> select f2 from tt where f1=2;
+--+
| f2 |
+--+
|3 |
+--+
1 ro
At 19:09 +0100 3/8/03, PaT! wrote:
Hi,
I need to change a column name.
I wonder if there's any faster and simpler way to do it than:
ALTER TABLE table_name
CHANGE old_column_name
new_column_name create_clause;
No, that's how you do it.
Thanks for the support.
Patrizio Pino
Roma - Italia
sql
I have a web application that uses ConnectorJ to connect to a MySQL
database. When I had MySQL on windows, I never had a problem. However, now
that I'm running MySQL on a linux box, I get a weird problem:
If I have not logged in to MySQL through the mysql command-line utility in a
while, the we
I have a table called testimonials:
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-++
| id | tinyint(3) | | PRI | NULL| auto_incre
Hi,
I need to change a column name.
I wonder if there's any faster and simpler way to do it than:
ALTER TABLE table_name
CHANGE old_column_name
new_column_name create_clause;
Thanks for the support.
Patrizio Pino
Roma - Italia
sql
---
At 17:21 + 3/8/03, Andrew wrote:
come on guys I nedsome help here! MySQL Rocks
I have a set of drop downs I want to determine the dropdown menu by query?
I have:
mysql_connect("$DBHost", "$DBUser", "$DBPass") or
die("could not connect");
mysql_select_db("$DBName");
echo "";
$res
come on guys I nedsome help here! MySQL Rocks
I have a set of drop downs I want to determine the dropdown menu by query?
I have:
";
$result=mysql_query("SELECT County, CountyID FROM county ORDER BY County");
while ($row = mysql_fetch_array($result))
{
$county_id=$row['CountyID'];
At 9:45 -0600 3/8/03, Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Description:
It is unbelievable that the MySQL ver 4.0 have so many bug, I
have been reported 2 bugs just a few days ago.
Now, I have found a bug again.
The bug is :
When I execute
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Description:
It is unbelievable that the MySQL ver 4.0 have so many bug, I have been
reported 2 bugs just a few days ago.
Now, I have found a bug again.
The bug is :
When I execute "select * from old_topic where FID=4 and (
Gabriel TATARANU wrote:
I had some private e-mail suggesting that MAX functions should apply to
the full table - as it is the maximum value of the field-
That is the case. Without a GROUP BY, max() is supposed to apply to the
entire table.
and this is why
HAVING clause behaved in that manner.
When I go into the "Database" tab of my SQL Admin I don't see any databases? Should I
not see the ones that are in the datadir path?
---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---
This is my first post to the list. I could do with
some pointers please. I'm building a pupil assessment
record. I have these two tables:
table `pupil`
pupil_id name
1 jeff
2 fred
3 rita
table `reading_level`
record_id pupil_id week level
1 1
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Friday 07 March 2003 18:38, Mark Matthews wrote:
> Why not mysqldump --quote-names test
Because I might not actually _want_ quoted names in my output.
This is not about the mysqldump output. This is about the correctness of
the statemen
On Saturday 08 March 2003 03:06, Daevid Vincent wrote:
> If I create a table that uses REFERENCES in it, then mysqldump it, the
> REFERENCES isn't there
>
>
> Notice the `contact_dept_table_id` field in both of the below outputs:
>
> CREATE TABLE `contact_table` (
> `contact_id` mediumint(8) unsi
On Saturday 08 March 2003 02:27, Daevid Vincent wrote:
> Can I have multiple foreign keys in a table? Like this... I ask because I
> can't seem to get it to work. Errno: 150.
Yes, you can. Check that all tables are InnoDB, that columns have the same
type and so on ..
>
> CREATE TABLE `dept_tabl
On Saturday 08 March 2003 02:33, root wrote:
> >Description:
>
> Message indicates to use /usr/bin/mysqladmin to set root password
> at end of installation, but this is not included in the distribution
>
> >How-To-Repeat:
>
> RedHat 8.0 - rpm --install -p MySQL-3.23.55-1.i386.rpm
Why not use the binaries from mysql.com? We recommend them over making
your own binaries.
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
-
Before posting, please che
33 matches
Mail list logo