http://www.mysql.com/udmsearch/index.php?ps=10&q=safe_mysqld&ps=20&m=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
http://www.google.com/search?hl=en&q=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 ...
www.m
D]
Subject: RE: MyODBC arrrgghh!
Here's the basics for MySQL database access (seven lines total:
use mysql;
create database myDB;
insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER',
'Y','Y','Y','Y','N&
Y', 'Y', 'Y', 'Y');
insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password
('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N&#x
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 pret
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 spee
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 pipe
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);
-> 'ra
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 P
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 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,
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-
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 S
6.6.2 DESCRIBE Syntax (Get Information About Columns)
http://www.mysql.com/doc/D/E/DESCRIBE.html
... aka MySQL(homePage)->Search::.
C:~
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:04 AM
To: 'Chuck "PUP" Payne'; MySQL Mailing List (E-ma
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 o.
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.
I
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 a
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 p
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 unexpect
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 2:
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 4
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 by
MySQL: DATETIME vs. INT
http://forums.devshed.com/showthread.php?s=&threadid=29754&forumid=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 I
MySQL: DATETIME vs. INT
http://forums.devshed.com/showthread.php?s=&threadid=29754&forumid=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
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 buildin
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 adm
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\bin>mysql -uroot < numuser.sql
count(User)
4
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2
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 eve
Same here:
F:\MySQL\bin>mysql -uroot -e "select count(distinct Host) from user \G"
mysql
*** 1. row ***
count(distinct Host): 2
F:\MySQL\bin>mysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server
F:\MySQL\bin>mysql -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]
Su
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 ?
P
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, Dec
36 matches
Mail list logo
