http://www.google.com/search?hl=enq=Views+Mysql
...
MySQL Manual | 1.7.4.6 Views
... It is planned to implement views in MySQL Server around Version
4.1. Views are mostly
useful for letting users access a set of relations as one table (in
read ...
http://www.mysql.com/udmsearch/index.php?ps=10q=safe_mysqldps=20m=and
1. MySQL Manual | 4.7.2 safe_mysqld, the Wrapper Around mysqld MySQL Manual
[2162694]
MySQL Manual Search: Up Previous Next Chapters Sections Functions
Concepts
4.7.2 safe_mysqld, the Wrapper Around mysqld
The mysql.user table requires an entry corresponding to user@IP/hostname
corresponding to the XPwkst w/ODBC.
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:02 AM
To: [EMAIL PROTECTED]
Subject: MyODBC arrrgghh!
Alright, I'm feeling
', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
quit
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:26 AM
To: Andrew Hazen; [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP
', 'N', 'N',
'N', 'N');
insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y',
'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
quit
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:26 AM
To: Andrew
5.2.12 Other Optimisation Tips
http://www.mysql.com/doc/T/i/Tips.html
...
- Normally you should try to keep all data non-redundant (what is called 3rd
normal form in database theory), but you should not be afraid of duplicating
things or creating summary tables if you need these to gain more
About midway down the page...:
http://www.mysql.com/doc/S/t/String_functions.html
SUBSTRING(str,pos)
SUBSTRING(str FROM pos)
Returns a substring from string str starting at position pos:
mysql select SUBSTRING('Quadratically',5);
-
http://www.mysql.com/doc/W/i/Windows_vs_Unix.html
Can't open named pipe error
If you use a MySQL 3.22 version on NT with the newest mysql-clients you will
get the following error:
error 2017: can't open named pipe to host: . pipe...
This is because the release version of MySQL uses named
The web application is running in an environment *outside* of the server,
compared to your context, which may be 'root@localhost', for instance.
The browser's context, then, might be '[EMAIL PROTECTED]'; thus, you will
need to add an entry to m,ysql.user table.
C:~
-Original Message-
Check the documentation:
6.2.6.1 Storage requirements for numeric types
http://www.mysql.com/doc/n/o/node_365.html
C:~
-Original Message-
From: Son Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 6:30 PM
To: [EMAIL PROTECTED]
Subject: Range of MEDIUMINT,
To start MySQL, are you using, minimum, the following?
./safe_mysqld
2.4.2 Problems Starting the MySQL Server
http://www.mysql.com/doc/S/t/Starting_server.html
2.4.3 Starting and Stopping MySQL Automatically
http://www.mysql.com/doc/A/u/Automatic_start.html
C:~
Check the Contributed Software page:
Contributed software - http://www.mysql.com/downloads/contrib.html
APIs
Clients
Web Tools
Performance Benchmarking Tools
Authentication Tools
Converters
Using MySQL with Other
6.6.2 DESCRIBE Syntax (Get Information About Columns)
http://www.mysql.com/doc/D/E/DESCRIBE.html
... aka MySQL(homePage)-Search::subject.
C:~
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:04 AM
To: 'Chuck PUP Payne'; MySQL Mailing List
ERROR 1064 at line 1: You have an error in your SQL syntax near ' ' at
line 1
- perhaps you'd prefer the semicolon to complete your query -
C:~
-Original Message-
From: Jim Swanson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:07 AM
To: [EMAIL PROTECTED]
Subject: SQL
MySQL Manual | 4.1.2 my.cnf Option Files MySQL Manual [2621454]
MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts
4.1.2 my.cnf Option Files MySQL can, since Version 3.22, read default
startup options for the server and for clients from option files. MySQL
reads default
How about using the state transitions, i.e.
0 - 1 state changed, no error
0/1 - 0/1 state unchanged, no error
1 - 0 state changed, overflow
C:~
-Original Message-
From: Michael Zimmermann [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 12:07 PM
How precise a location were you seeking? That * is San Francisco, CA.
http://www.mysql.com/training/index.html
Scheduled Courses
Using and Managing MySQL
Hamburg 15-19 Apr 2002 2450 EUR Register now! Questions?
*San Francisco 15-19 Apr 2002 2450 USD Register now! Questions?
4.8.5 mysqldump, Dumping Table Structure and Data
Utility to dump a database or a collection of database for backup or for
transferring the data to another SQL server (not necessarily a MySQL
server). The dump will contain SQL statements to create the table and/or
populate the table.
Here are the 5 Rules of Data Normalization --
http://www.datamodel.org/NormalizationRules.html
Eliminate Repeating Groups
- Make a separate table for each set of related attributes, and give
each table a primary key.
Eliminate Redundant Data
- If an attribute depends on only
Perhaps, you could add the Free Oracle database myth, as well?
C:-
-Original Message-
From: Michael Bacarella [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 3:28 PM
To: [EMAIL PROTECTED]
Subject: MySQL Myths Debunked Revision 5
A new revision of MySQL Myths Debunked is now
Try a C:\my.cnf with just the following:
[mysqld]
datadir = C:/mysql/
tmpdir = C:/temp/
-Original Message-
From: Gregory Junker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:25 PM
To: Simon Tienery; [EMAIL PROTECTED]
Subject: RE: Error 1067: the process terminated
You should use mysqldump[.exe] to export/import, on the respective systems:
4.8.5 mysqldump, Dumping Table Structure and Data
http://www.mysql.com/doc/m/y/mysqldump.html
C:1
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002
Perhaps the rpm expects to perform a (forced) upgrade
Ç:
-Original Message-
...
Your problem is because your new compile (or binary install) is expecting
the layout previously used by mySQL v3.
...
If anyone can offer us more, please do!
LP
I have installed MySql 3.23.49, PHP
The following may assist: (three-fifths down)
http://www.mysql.com/doc/G/r/Group_by_functions.html
Note that if you are using MySQL Version 3.22 (or earlier) or if you are
trying to follow ANSI SQL, you can't use expressions in GROUP BY or ORDER BY
clauses. You can work around this limitation
MySQL: DATETIME vs. INT
http://forums.devshed.com/showthread.php?s=threadid=29754forumid=4
C:heers!
-Original Message-
From: DL Neil -- Sent: Tuesday, February 05, 2002 1:28 AM
Checking the MySQL manual (6.3.4 Date and Time Functions)
UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)
...returns
MySQL: DATETIME vs. INT
http://forums.devshed.com/showthread.php?s=threadid=29754forumid=4
C:heers!
-Original Message-
From: DL Neil -- Sent: Tuesday, February 05, 2002 1:28 AM
Checking the MySQL manual (6.3.4 Date and Time Functions)
UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)
...returns
Try:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
C:heers!
-Original Message-
From: Cindy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: mysql.sock
Sorry, I know this is documented somewhere, because I've seen it,
but
Sounds like we just need a table to keep track of LAST_INSERT_ID per table.
C:heers
-Original Message-
From: jds [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 7:05 AM
To: [EMAIL PROTECTED]
Cc: David T. Anderson
Subject: triggers, stored procedures, and views
I am
update user set Password = PASSWORD('mypassword') where User = 'myuserid';
http://www.mysql.com/doc/P/a/Passwords.html
C:ya
-Original Message-
From: Yuxia Li [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Change password
Hi:
The
You can place your statements into a file, e.g. numuser.sql, and redirect
this into mysql client:
use mysql;
select count(User) from user;
F:\MySQL\binmysql -uroot numuser.sql
count(User)
4
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09,
F:\MySQL\binmysql -uroot -e select distinct count(*) from user \G mysql
*** 1. row ***
count(*): 4
Xi2 ('sE-'tü)
-Original Message-
From: Ilic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 5:54 AM
To: [EMAIL PROTECTED]
Same here:
F:\MySQL\binmysql -uroot -e select count(distinct Host) from user \G
mysql
*** 1. row ***
count(distinct Host): 2
F:\MySQL\binmysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server
This will help, it seems: http://www.mysql.com/articles/wizard/page3.html
Xi2
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 10:11 AM
To: [EMAIL PROTECTED]
Subject: mysql query
I am trying to write a query that gets the name of
The syntax is: SELECT DISTINCT
http://www.mysql.com/doc/S/E/SELECT.html
Xi2
-Original Message-
From: Ilic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 9:48 AM
To: [EMAIL PROTECTED]
Subject: count(distinct
SELECT count(distinct ip) FROM pole_voti
It does'nt work. Why ?
Here is a select statement, as example:
mysql -e select * from user \G mysql
Add user and password as required.
Xi2 ('sE-'tü)
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 8:57 AM
To: [EMAIL PROTECTED]
Subject: Updating tables
PROBLEM
there is NO SYSTEM DSN offered to add under the add button under the
SYSTEM DSN tab
After clicking the Add button under the System DSN tab,
you scroll to and select MySQL then continue.
Xi2
-Original Message-
From: Peter Reck [mailto:[EMAIL PROTECTED]]
Sent: Friday, December
36 matches
Mail list logo