questions.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
PROTECTED]
Thanks,
Thomas Taylor
17106 76th Ave
Maple Grove, MN 55311
[EMAIL PROTECTED]
--
Matt Silva
Empower Software Technologies, LLC
27851 Bradley Rd. Suite 120
Sun City, CA 92586
PH: (909) 672-6257
WB: www.storagecommander.com
EM: [EMAIL PROTECTED]
Regards,
--
Stefan Hinz
,
this is a document that deals with MySQL internals. It's not (yet)
available in HTML, but you can get it from the mysqldoc BitKeeper
tree. The procedure how to clone that tree is described on:
http://www.mysql.com/doc/en/Installing_source_tree.html
(near the bottom of that page)
Regards,
--
Stefan Hinz
mysql_free_result() from your
application? You might be able to set a timer in your app, calling
that function after, for example, 20 seconds.
http://www.mysql.com/doc/en/mysql_free_result.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany
, Performance). Most of those variables can
be set at server runtime by double-clicking them in MySQL
Administrator.
http://www.mysql.com/products/administrator/index.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon
In MySQL Control Center, you could use the Query window to create a
stored procedure (STRG+Q, or click on the button labeled SQL).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
to the countryside and
take up raising mangel-wurzels.
Good luck!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
Are binaries of MySQL 4.1.1 available or we need to
compile it from the source.
No, binaries are not available yet.
They will be available very soon, most probably this week (yes, I know
today's Thursday :-).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
.
Regards,
Stefan Hinz
--
Are you MySQL certified? http://www.mysql.com/certification/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Stefan Hinz [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL Documentation Team
/_/ /_/\_, /___/\___\_\___/ Berlin, Germany
/ANSI_diff_Subqueries.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http
to try to abide by the other 330
requirements for relational databases as well, but in most cases, NF 1
through 3 is sufficient:
http://www.aisintl.com/case/olais/pb96/biblio.htm#Codd74
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
/InnoDB_foreign_key_constraints.html
Also, remember that you cannot use foreign key constraints (in a
meaningful way) with MyISAM tables, but that you should use InnoDB
tables instead:
http://www.mysql.com/doc/en/Using_InnoDB_tables.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
a standard way of writing those entries
(using a .reg file or whatever).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing
for UTF-8 and other character sets. 4.1.1 will
be out as an Alpha version pretty soon. On National Character Sets and
Unicode, see the appropriate manual pages:
http://www.mysql.com/doc/en/Charset.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6
--xml
mysql SHOW TABLES FROM test;
?xml version=1.0?
resultset statement=SHOW TABLES FROM test
row
Tables_in_testbooltest/Tables_in_test
/row
row
Tables_in_testdaten/Tables_in_test
/row
...
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
--skip-grant-tables Fatal error:
Please read Security section of the manual to find out how to run mysqld as root!
Any ideas?
Try starting the MySQL server with the --user option, like this:
shell mysqld --user=anyone-but-not-root --skip-grant-tables
Regards,
--
Stefan Hinz [EMAIL PROTECTED
is stored, it's encrypted.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http
specify --port=portnumber.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
I am MySQL certified - are you?
http://www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Stefan Hinz [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer
/_/ /_/\_, /___/\___\_\___/ Berlin, Germany
___/ www.mysql.com +49 30 8270294-0
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
interested, please send a mail to [EMAIL PROTECTED] providing
some background on who you are, where you are located, and how much
experience you have with both MySQL and translations.
Regards,
--
Stefan Hinz
I am MySQL certified - are you?
http://www.mysql.com/certification
--
MySQL General
Unix guys on this list chuckling.)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http
to start the software program it's supposed to
start. For the MySQL server, that's done with the mysqld --remove
servicename command.
Hope that helps.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0
end up in
the
data files, to be collected later?
This sentence from the manual should make that clear: ALTER TABLE
works by making a temporary copy of the original table. You can find
details here:
http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED
understand client side programs, examples being: mysqladmin, mysqldump,
and mysqlimport. These are known as mysql client commands also?
Those are client (side) programs, not client commands. You use those
programs to issue (client) commands that are sent to the server.
Regards,
--
Stefan Hinz
user (with GRANT) or change an existing user's
password (e.g. with SET PASSWORD), and then try to connect as that
user with an older client (e.g. mysql from 4.0.13). Trying to connect
as that user from a new client should be no problem.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http
Is there a reason you are including the BLOBs in the database instead of just
linking via it? I know it's generally considered better practice to do the
latter.
Like always, that's true.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany
did). You can do
something like this:
C:\mysql\bin mysql
That client program called mysql (note: not mysqld!) connects to the
server and gives you a prompt. Good luck!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49
, there will be documentation for UTF8
support available in the manual. Thank you for your patience!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
,
i.e. for developers trying to find the cause of errors in a software.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General
any problem.
Apache is used as web server in both Linux and windows.
Regards.
Carlos Díaz
Stefan Hinz [EMAIL PROTECTED] wrote:
Carlos,
We have a hosting provider with a Linux box and an MySql database.
We have a local Mysql database.
In both machines I use phpMyAdmin.
On the startpage
MySQL 3.23.56-log
I'm giving up, sorry. I cannot see anything in the above that would
cause problems with Spanish characters when exchanging the data
between those two servers.
Does anyone else on this list see more than I do?
Stefan Hinz [EMAIL PROTECTED] wrote:
Carlos,
The character sets
,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
.
Please check out http://www.mysql.com/doc/en/mysqldump.html which
lists all the available options to mysqldump (don't panic, you'll need
only a few of those!). Moreover, that page has some good examples how
to use mysqldump (also in combination with mysql).
Regards,
--
Stefan Hinz [EMAIL PROTECTED
Gregory,
mysql started
/usr/libexec/mysqld: Can`t find file ' ./mysql/host.frm' (errno: 13)
mysqld ended
You forgot to run the mysql_install_db script that sets up the initial
grant tables:
http://www.mysql.com/doc/en/Post-installation.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
seems to be related to the driver, or to your JSP app.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list
as another user (like
root) and issue:
mysql FLUSH PRIVILEGES;
Then try to connect as postfix once again.
Good luck!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder
,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
|
| 57 | root | localhost | NULL | Query | 0| NULL | show processlist
|
++---++--+-+--+---+--+
Yes. It's a bug that's likely to be fixed in 4.0.13.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH
the big
table.
c) Use another filesystem that supports bigger files.
Hope that helps.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
otherwise use. So rewrite those parts (e.g. lang_id=1).
Another advice would be to try a LEFT JOIN of access and files.
And, of course, you could add some indexes, on the filename and the
file columns.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
machine),
and it's located in your MySQL data directory (e.g.
/var/lib/mysql/data/).
I hope this will help you track down your problem, and hopefully solve
it.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30
rows in set (0.00 sec)
As you can see, the NULL value is treated as a wrong value (because
the column is declared NOT NULL), so it is inserted as an empty string
(the special error value).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
and there must be an index where
the foreign key and the referenced key are listed as the FIRST
columns. InnoDB does not auto-create indexes on foreign keys or
referenced keys: you have to create them explicitly.
The example on that page, however, shows exactly how you'd do that.
Regards,
--
Stefan Hinz
TABLE, TRUNCATE, LOCK TABLES, UNLOCK TABLES, SET AUTOCOMMIT=1. The
CREATE TABLE statement in InnoDB is processed as a single transaction.
It means that a ROLLBACK from the user does not undo CREATE TABLE
statements the user made during his transaction.
Regards,
--
Stefan Hinz [EMAIL PROTECTED
. TINYINT will always need 1 byte.
http://www.mysql.com/doc/en/Storage_requirements.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
interpretation of that is you won't be able to identify individual
records that were skipped, just the total number of those.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter
(0.00 sec)
mysql SELECT MAX(i) FROM t;
++
| MAX(i) |
++
| 8 |
++
1 row in set (0.00 sec)
You can use both functions with a GROUP BY clause, too. Further
details:
http://www.mysql.com/doc/en/Group_by_functions.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect
MyCC have a known memory problem/issue?
Yep. It's still beta, and it's got some nasty memory leaks, at least
under Windows.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
in 4.0.12. Should be corrected really soon, probably
in 4.0.13 already.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General
were
granted as expected.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http
)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Sidar,
how do i create a user that can connect to any database from any host on my lan
mysql GRANT ALL ON *.* TO 'youruser'@'192.168.%' IDENTIFIED BY 'secret';
Assuming your network has IP addresses starting with 192.168.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http
the changelogs of 4.0.11 and 4.0.12 for a bugfix, but those
say nothing about that issue.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL
as to which line is causing the
error.
Nope. But, as I said, it doesn't look like it's a real syntax error.
Something (maybe due to the communications buffer size) sends only
part of that last INSERT command to MySQL, and that's what results in
an error.
Regards,
--
Stefan Hinz [EMAIL
that can be too
little). Check with a script containing just the phpinfo() call
(PhpMyAdmin has a file called phpinfo.php that contains that call).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before posting, please
, p.name, sp.name, SUM(t.time)
FROM t_user u
LEFT JOIN t_project p ON 1
LEFT JOIN t_subproject sp ON p.id = sp.project_id
LEFT JOIN t_time t ON ?? = ??
WHERE u.login = 'amg'
GROUP BY p.name
Where I'm not sure if you will need the WHERE clause at all.
Regards,
--
Stefan Hinz [EMAIL PROTECTED
those base tables at all. For all work
that is done, you only need to insert values into the lookup table.
Hope that helps!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
*/, World;
- ;
+---+
| Hello |
+---+
| Hello |
+---+
1 row in set (0.00 sec)
This is a lengthy answer for saying It's documented behaviour :)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0
on
that case with MySQL AB. From my experience, I can say the MySQL AB
people are open-minded enough to not expect you to pay $200 for each
copy of a software you sell at $50.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany
that bill payed?
Certainly not.
To give the MySQL AB sales people a good reason to sign a special
agreement with you, you should be able to make clear (and, as said,
hopefully, be able to give some kind of proof) that you are going to
sell 1,000 copies or more of your software.
Regards,
--
Stefan
;
etc.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before posting
,V5H 4M3,
For MySQL, that would simply be a syntax error.
Try to remove one line at the beginning of the dumpfile, and see if
the error occurs at the next line. If that's true, set the timeout
limit of your script higher.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http
=32M \dev_hotel_data.sql
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
(the new-line character that makes that line
break in TEXTAREA) by br/. If you're a maniac (like I am) you can
even do:
echo TD colspan=\3\ width=\532\P
.str_replace(nl2br($article),br/,/pp
style=\text-indent:10px\)
./P/TD;
Or something similar to that.
Regards,
--
Stefan Hinz [EMAIL
.)
You can accomplish the reload as you did above, but a more convenient
way would be:
mysql DELETE FROM user WHERE Host='localhost' AND User='';
mysql FLUSH PRIVILEGES;
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49
.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before posting, please
tables, etc.).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before
concerns are speed, stability, scalability, and ease
of use, you probably will be better off with MySQL. (I'm sure I forgot
to mention at least 100 important things in this discussion, and a
cross-post to the Postgre list would probably end up in a flame war ;)
Regards,
--
Stefan Hinz [EMAIL
/IP, by
connecting with the host specified, where host is something else but
127.0.0.1 or localhost; like this:
mysql -h machine_name
Where machine machine_name is the host name of your Windows machine.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6
Jasdeep,
Could you recommend me a book for learning MySQL for the beginner.
Have a look at a variety of books recommended by MySQL AB:
http://www.mysql.com/portal/books/index.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
will not overwrite its content.
tee does not work in batch mode, and you cannot use it together with
mysqlc.exe (for Win95/98).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter
Luca,
In Oracle I could create a view from the initial table, what about MySQL?
MySQL will support views as of version 5.1. I cannot find it in the
todo (http://www.mysql.com/doc/en/TODO.html) but I saw it elsewhere.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http
Win NT Start the Service
Make sure the server isn't up at the time you perform a) through c).
If it's running in the DOS window, kill it by closing the window.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30
group\apache2\htdocs\phpcatalog\admin
C:\mysql\bin\mysql.exe testcatalog createdb_mysql
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
installation, what they do is done / set up automatically.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
this is
documented somewhere, but didn't find it.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before posting, please
socket, and everything should be
fine.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
in the
import file (you would just specify which columns you want to fill
with data), but not the other way around.
My suggestions:
a) Put some dummy columns in your table.
b) As an alternative, filter out the fields you don't need with some
application.
Regards,
--
Stefan Hinz [EMAIL PROTECTED
: The used command is not allowed with this MySQL version
mysql SHOW VARIABLES LIKE 'local%';
+---+---+
| Variable_name | Value |
+---+---+
| local_infile | ON|
+---+---+
This is not the documented behaviour. So is it a bug?
Regards,
--
Stefan
sec
Threads: 2 Questions: 462 Slow queries: 4 Opens: 10 Flus
--
mysql SELECT 'ä' = '\\';
++
| 'ä' = '\\' |
++
| 0 |
++
1 row in set (0.00 sec)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6
would skip it).
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before
not a trivial problem, you should check in
my.cnf (on the target machine, I guess):
set-variable = max_allowed_packet=16M
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter
anothertablename(...)
[on_delete_and_on_update_actions]
Make sure the tables in question are all InnoDB tables.
And please read the appropriate manual section first:
http://www.mysql.com/doc/en/SEC455.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
:
TINYINT: maximum 255
SMALLINT: maximum 65535
MEDIUMINT: maximum 16.7 million
INT: maximum 4.2 billion
BIGINT: no maximum (I can't count up to this ;-)
Details: http://www.mysql.com/doc/en/Numeric_types.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6
option.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before posting
was enabled or not by issuing
this SQL statement:
SHOW VARIABLES LIKE 'max_allowed_packet';
This will show the communication buffer size in bytes.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49
:\mysql (or whatever your installation directory is)
or
[mysqld]
...
basedir=c:/mysql (note the slash instead of the backslash)
Hope it helps, and have fun with MySQL!
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49
forgot the quotes around your date.
You have quite some more ways to insert date and time values; check it out:
http://www.mysql.com/doc/en/Date_and_time_types.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30
Rob,
Are there any other characters with the same problem like #?
http://www.mysql.com/doc/en/String_syntax.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter
\data.
The error file ends with .err; under Windows, the name is mysql.err.
Last not least, here's my advice to read the manual :)
http://www.mysql.com/doc/en
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948
.
The most recent binary distribution is 4.0.10, just to make sure you
don't mix up version numbers ;)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql
,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before posting, please check
):
- max_question:number of commands user can send to server,
- max_updates: number of changes user can submit,
- max_connections: well, I let you guess ;-)
http://www.mysql.com/doc/en/User_resources.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6
it won't hurt
trying.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query
Melih,
Year(Date - BirthDate) - 1900
What you're looking for is in the manual. Check it out:
http://www.mysql.com/doc/en/Date_calculations.html
Have fun! :)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30
script):
LOCK TABLE tbl1;
FLUSH TABLES; --- Don't forget about this one!
... perform the myisamchk operation(s) ...
UNLOCK TABLES tbl1;
LOCK TABLE tbl2;
etc.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49
101 - 200 of 504 matches
Mail list logo