Timestamp is a session variable, so it must have been set to something
other than 0 (1372228034 epoch is the date you're showing) in your current
session.
mysql> set timestamp = 1372228034;
Query OK, 0 rows affected (0.00 sec)
mysql> select now(), sysdate();
+-+-
n, this is currently set globally - no matter what connection to
>the database, it all comes up with this value. Which means that all my
>time-based queries no longer work correctly.
>
>Does your message suggest that setting it to 0 might clear the problem?
>
>
>
>On 6/27/13 10:31
On 4/9/13 1:54 PM, "Joe Kosinski" wrote:
>Hi,
>
>I am trying to connect to a MySql database and I keep getting the
>following:
>
> Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network
> Failed to connect to Unix socket '/var/run/lirc/lircd'
> No such file or
Nope. That's just granting replication privileges so it can read updates
on all tables on all databases. It cannot select anything.
Why are you trying to connect with a replication slave user?
On 4/2/13 1:47 PM, "Richard Reina" wrote:
>I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'19
Assuming you copied and pasted the error, it looks like the host made a typo in
the config file:
'/var/lib/myswl/mysql.sock'
Should probably be mysql, not myswl.
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Monday, March 18, 2013 3:32 PM
To: Patrice Olivier
OP's first question: " I am not able to create a table on my own. what
privileges I need to create and modify tables in this database?"
The answer to that question is that he/she needs CREATE to create tables and
ALTER to alter them.
-Original Message-
From: Reindl Harald [mailto:h.rei
This might help with that task:
mysqlbinlog binary_log_file_name.01 --start-datetime="2013-02-25 16:45:00"
--stop-datetime="2013-02-25 16:50:00" | grep 'DELETE\|ALTER TABLE\|PARTITION'
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, February 26
Are you actually querying the table (select count(*) from table_name), or just
the stats (show table status)? Is the table Innodb?
If you're using Innodb and aren't doing a select count (or other select query)
on the table, then yes you'll have varying results. This is because unlike
MyISAM, I
I definitely agree with using replication. As for delayed replication, this is
actually a built in feature of MySQL 5.6 (coming soon). 5.6 has numerous
improvements to replication. Definitely worth checking out:
http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html
Scroll d
In the past when I used mysqldump, I used a slave database for backups and
periodically testing restores.
My process for testing:
- Stop the slave process (so the db doesn't get updated).
- Run the backup.
- Create restore_test database.
- Restore the backup to the restore_test database.
- Use my
By default, the mysql users/privileges tables are MyISAM, not ndbcluster.
ndb_mgm backup won't backup anything other than ndbcluster tables. The
--restore-privilege-tables only works if you've converted those user and
privileges tables to ndbcluster.
>From the manual:
>http://dev.mysql.com/do
I stand corrected and apologize. Numerous multi-master setup descriptions I've
read have said to set this (including the one linked in the original question).
However, as you said, the entry in the manual clearly says it defaults to 0.
Learn something new every day. Thanks Shawn.
On Sep 24, 2
log
entries with its own server ID.
From: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
Sent: Monday, September 24, 2012 10:39 AM
To: Stillman, Benjamin
Subject: Re: Doubt Regd. Circular Replication In Mysql
Yes I fixed , but i solve the issue by enabling log-slave-updates only
Why we use the be
Sounds like you're missing the following in your my.cnf on server B (probably
all of them):
replicate-same-server-id = 0
log-slave-updates
While you're checking, might as well as make sure your auto-increment settings
are in there and correct also.
-Original Message-
From: Adarsh Sh
I think this will get you there:
SELECT LEAD, COUNT(*) FROM ORDERS GROUP BY LEAD;
It'll give you something more like:
| LEAD | COUNT(*) |
| F | 44 |
| S | 122 |
| R | 32 |
-Original Message-
From: Richard Reina [mai
I just realized I shouldn't be reading these first thing in the morning before
my first cup of coffee.. That says node id 10, then the IP. Sorry about
that.
-Original Message-
From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
Sent: Wednesday, August 08, 2012 8:56
Unable to connect with connect string: nodeid=10,172.17.3.66:1186
There's a comma between 10 and 172 instead of a period.
-Original Message-
From: Aastha [mailto:aast...@gmail.com]
Sent: Tuesday, August 07, 2012 6:20 PM
To: mysql@lists.mysql.com
Subject: Error starting data node
Helo,
http://bixsolutions.net/forum/thread-18.html
-Original Message-
From: Elim Qiu [mailto:elim@gmail.com]
Sent: Monday, August 06, 2012 5:42 PM
To: mysql@lists.mysql.com
Subject: trouble with perl
To populate table for a perl forum, I got the following error:
aMac:mwf elim$ perl instal
, Benjamin [mailto:bstill...@limitedbrands.com]
Sent: Monday, August 06, 2012 2:05 PM
To: 'Fred G'
Cc: mysql@lists.mysql.com
Subject: RE: DECIMAL datatype automatically makes blank become 0
I don't believe this is limited to Workbench. I saw the same behavior using
LOAD INFILE and a
I don't believe this is limited to Workbench. I saw the same behavior using
LOAD INFILE and a pipe-delimited file. There's a bug report that's been open
since November of 2006 about this: http://bugs.mysql.com/bug.php?id=23212
-Original Message-
From: Fred G [mailto:bayespoker...@gmail.
7.2 introduces geographic clustering:
https://blogs.oracle.com/MySQL/entry/synchronously_replicating_databases_across_data
http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2.html (section
titled: Enhancing Cross Data Center Scalability: Multi-Site Clustering)
Data nodes can be located
As far as I know, a B-tree index can be used by LIKE as long as the string
doesn't begin with a wildcard. " LIKE 'X%' " should be fine to use an index on
the name column. The index only includes results in the search base which start
with X.
That said, I probably wouldn't use a subquery, either
age-
From: brian [mailto:mysql-l...@logi.ca]
Sent: Tuesday, July 03, 2012 1:47 PM
To: mysql@lists.mysql.com
Subject: Re: alternative to slow query
On 12-07-03 01:13 PM, Stillman, Benjamin wrote:
> I don't see an index for expression.id.
>
mysql db_lexi > s
I don't see an index for expression.id.
-Original Message-
From: brian [mailto:mysql-l...@logi.ca]
Sent: Tuesday, July 03, 2012 12:28 PM
To: mysql@lists.mysql.com
Subject: Re: alternative to slow query
On 12-07-02 09:33 PM, yoku ts wrote:
> Hello,
>
> add index to expression1_id and exp
By recent security breach, do you mean the issue with passwords? If so:
http://www.dbasquare.com/2012/06/11/a-security-flaw-in-mysql-authentication-is-your-system-vulnerable/
for i in `seq 1 2000`; do mysql -u USERNAME --password=INCORRECTPASSWORD -h
HOSTNAME ; done
If you get in using that, yo
You shouldn't have to flush the logs manually. I have been flushing binary
logs using this expire_logs_days for some time with no other intervention.
One thing to keep in mind is that if you have limited disk space, and an
usual spike in updates your binary logs can still grow and consume all
ava
I currently have a MySQL server in production and am considering protecting
it with DRBD. The kicker is that it is a production database and so I can't
take it offline, or can take it offline for only a very (several minutes
max) short period of time. Is it feasible to get this working without
much
With 5.1 you have more control over general query log and the slow query log
- enable or disable at runtime, output to file or DB table.
As of MySQL 5.1.6, the server can write general query and slow query entries
to log tables, log files, or both. For details, see Section 5.2.1,
"Selecting Genera
not possible cause of the huge size of the
database. Hard-core copy of db-files causes a downtime of up to 8 hours
so it would be possible.
Or does somebody has another (hope better) solution?
With best regards,
Benjamin Schmidt
Hartleigh Burton wrote:
Hiya,
I was backing up a 95GB
_stack = 128K
query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
set-variable = max_connections=1000
max_allowed_packet = 64M
...
As I wrote above, it worked this way a very long time. And it should
work again ;)
Does anyone know this problem or has an idea?
Many thanks in adva
I recall there is a command that will display suggested optimal columns
types for a given table based on the data stored in the table, but I haven't
been able to figure out what it is.
Help!
Thanks.
Ben Wiechman
Wisper High Speed Internet
[EMAIL PROTECTED]
hi, if anybody wants to reach me please try this account - [EMAIL PROTECTED]
or call me on 0044 750 408 9783
=
Weather Almanac, Weather Folklore Books
Buy Eric Sloane weather almanac, books on weather vanes & more today.
http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=5e9d5c58760ae9512db1d28
Hi, I work for a mobile technology company in London.
We are looking to recruit a MySQL DBA.
The world of the enterprise DBA is changing, be part of it. Like it or
not, open source technology is making serious inroads into the
enterprise environment. Justifying the purchase of a heavyweight RDBM
hi everyone,
i am looking to find a MySQL guru to come work full time at a passionate mobile
technology/ communications company in the heart of London.
This truly is the place to be!
They have global footprint - everyone in the company are technically competent
and extremely passionate about
Hi, I am looking to hire a permanent MySQL Database Administrator to take
control of our companyś database architecture and overall data held
within. We are a passionate company at the forefront of our marketing -
innovative mobile communication. We have a superb office location overlooking
L
son_id
and B.product_type = "Product B"
;
Give it a try !!!
- Original Message -
From: "Benjamin Ventura" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Thursday, August 2, 2007 1:22:00 PM (GMT-0500) America/New_York
Subject: Complex query
I have a databas
I have a database tracking registrations of software products with two related tables, "registered_products" and "people". I need to pull a list of email addresses from the people table BUT I only want to pull people records who own very specific combinations of products from the registered_produc
Not to ask a perhaps silly question, but are you specifically trying to use
mysqldump, or just get a backup copy of your databases?
If you just want to back them up download MySQL Administrator -> GUI = fun &
easy... :)
http://dev.mysql.com/downloads/ (Download MySQL GUI Tools - about half way
s.
Anyone get me in the right direction?
Thanks in advance
Regards Benjamin Bittner
-
Was ist Glück? Schlafen Fische überhaupt? Die Antworten gibts auf Yahoo!
Clever.
i don't know the proper place to send this and i didn't see any
mention of it in the list archives. there is a really small problem
with the configure script in 5.1.11 (and other versions, perhaps, but
i haven't looked) that prevents building with openssl support. patch
below.
thanks,
he python MySQLdb module if built
against the client-only install of mysql. I'm not sure which party is
to blame, so I have to start somewhere. :) Thanks,
--
Benjamin Rutt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hi,
I host a big french website including forum (phpbb), search engine (mnogo),
album (smartor), blogs... around 780Mo in MySQL
Everything work fine with my old configuration :
- One SQL/mail server bi-Xeon, 2.6Ghz, 3Go :
FC4, MySQL 4.0, Postfix-Mysql, Courier-imap Mysql
- One front serve
database all
> > JM> trying to write to the same table. With MyISAM each one will lock
> > JM> the entire table, and only one will execute at a time, making it
> > JM> very slow. In InnoDB each one will only lock the rows it is
> > JM> modifying and they can all
bd-mysql-0.6.5-5
> mysql-3.23.58-1
> perl-DBD-MySQL-2.1021-3
> mysql-devel-3.23.58-1
> mod_auth_mysql-20030510-1.ent
> php-mysql-4.3.2-8.ent
> MySQL-python-0.9.1-6
>
>
>
> -Original Message-
> From: Benjamin Arai [mailto:[EMAIL PROTECTED]
> Sent: Mo
ql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Benjamin Arai
http://www.cs.ucr.edu/~barai
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dev.mysql.com/doc/mysql/en/Installation_layouts.html I am still a bit
> unsure of my next move.
> Can some please help me out with directions on how to check the system
> to verify whether or not MySQL is installed, and how to download and
> install MySQL on this server.
>
> Many thanks and best wishe
eparator.
> >
> > Will I always get a 3 . separated string? ie: X.XX.XX ? Or could I sometimes
> > get X.XX?
> >
> > Thanks,
> > Matthew
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:h
specify the lock for each query?
> And what about temporary tables?
> If anybody has a simple explanation or a link on a doc
> thanks,
> Melanie
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http:
post it.
>
> Thanks
>
> ___
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
the command line, not the mysql
> program. Anyone have any ideas? I have looked and couldn't find the
> answer i was looking before. Its running from a shell script, from my
> backup machine. Its currently setup to shut down the server, however i
> don't want to have to do th
nnoDB dbase with Mysql on a linux
> > system and the file is over 60 GIGS in size!
>
> Great!!! So, I don´t need to worry about it... :-)
>
> Thanks Dan,
> Ronan
Benjamin Arai
Araisoft
Email: [EMAIL PROTECTED]
Website: http://www.araisoft.com
ry clean and a
bit heavy (especially if there are lots of parents).
Any idea?
Thank you
Benjamin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ef PRIMARYPRIMARY 4child.p_id 1 Using index
---
I'm using MySQL 4.0.13 and MyISAM tables. I'm using keys and Indexes.
Thank you very much.
Benjamin
--
MySQL General Mailing List
For
>
> > > > Thanks,
> > > >
> > > > Matt
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > >
> >
> >
--
Benjamin Arai <[EMAIL PROTECTED]>
Araisoft Corp.
iciency is 99.54%.
maybe it has something to do with the database files size?
bye.
*
Benjamin KRIEF * Directeur Technique * IGUANE Studio
*
--
MySQL General Mailing List
For list arch
e to
redirect part of the queries to the master =)
bye,
Ben.
*****
Benjamin KRIEF * Directeur Technique * IGUANE Studio
Tel:01.56.55.54.20 * 5-7-9 passage des Cloys
Fax:01.56.55.54.24* 7
hi , and thanks for your answer,
> On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote:
>> the problem is that it's quite impossible to fine tune the load between
>> the servers , and my slave is a bit too busy , so the replication thread
>> is becoming ver
ct the sql requests on the slave or on the master , but this
time , i could fine tune it , and input for instance 0,3 for the slave ,
so that 3 requests out of 10 would go to the slave.
maybe stg similar already exists ?
thanks for your attention,
*
hi all , and thanx for your help on my weird_indexes problem.
no that i've created the indexes , the things are going a bit better but
it's still not so fast : here's some output from mytop :
-
Queries Total: 442,666Avg/Sec: 7.74 Now/Sec: 16.27 Slow
Y (id);
Hope that helps.
Matt
- Original Message -
From: "Benjamin KRIEF"
Sent: Sunday, August 31, 2003 7:40 PM
Subject: spaces in index name
hi all ,
i'm trying to improve performance of a quite big and heavily used
mysql
set of tables.
i want to create some i
hi all ,
i'm trying to improve performance of a quite big and heavily used mysql
set of tables.
i want to create some indexes on this table , but before this , i'd like
to remove the ones created by my predecessor , which are sometimes
duplicate , and somtimes useless.
here is an output from s
check out http://www.phpbuilder.com
thay have a lot of things and that is one off them.
--
eschew obfuscation.
-Original Message-
From: Digital Directory USA [mailto:[EMAIL PROTECTED]
Sent: 29 June 2003 19:28
To: [EMAIL PROTECTED]
Subject: inserting images to mysql - is it possible?
I
Hello all
I am having trouble with joining tables i will explain.
I have four tables Cat - CatFile - File - User. thay are related in the
order. I need to join them around the file table. i tryed 'SELECT cat.name,
catfile.catid, file.fileid, user.name FROM cat RIGHT JOIN catfile ON
catfile.catid=
ut they did not.
> Any explanation of effect?!?
A bug. It is listed as fixed in the change history for the next (not
yet released) version 4.0.13 in the online manual.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
ersion.html
(especially the second half)
HTH,
Benjamin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d to use VARCHAR instead. But there is a known
bug with MySQL (see above and http://www.mysql.com/doc/en/Open_bugs.html).
As the bug description implies, use a TEXT type like TINYTEXT instead.
HTH,
Benjamin.
PS: Btw, the BINARY keyword only influences sort behaviour, n
files in the data directory. Same
> result. Then I recompiled again adding the option --with-debug and it
> started ok creating all necessary files.
>
> What is wrong here?
Such a config change requires to do a full recompile (make distclean
or whatever), wh
atever
the reason is, I strongly suspect that it will influence the answer.
All what you described works fine with SETs and there is a chance that
MySQL will optimize accesses to them better.
Benjamin.
--
[EMAIL PROTECTED]
w.mysql.com/doc/en/libmysqld.html
should answer most of your concern. Basically it boils down to an
additional call to mysql_server_init() and mysql_server_end() and
compiling with libmysqld instead of libmysqlclient. The rest is the
same with the client library.
HTH,
r all other rows where number<=>NULL).
As I said, this is not an issue in your current case.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h_names | uniq -c
in the shell (I presume you have shell access because you used grep
before).
HTH,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
nough for
general public testing. So, in a way, just wait with testing until
they invite by publishing it.
HTH,
Benjamin.
PS: In case you are not aware of it: There is an own section how to
get and compile the 4.1 source version:
http://www.mysql.com/doc/en/Installing_source_
on junk_test to junk ;
> Query OK, 0 rows affected (0.02 sec)
> mysql> quit
> Bye
> bash-2.05a$ mysql -ujunk -pjunk
> Welcome to the MySQL monitor. Commands end with ; or \g.
> mysql> use junk_test ;
> ERROR 1044: Access denied for user: '[EMAIL PROTECT
sk read unnecessary.
The situation is actually far more complex - I only wanted to show an
example why the seemingly slower configuration can be faster: due to
limited system resources, configurations which use available resou
; transactions capability yet?
MySQL 3.23 is declared stable since Jan 2001, i.e. more than two
years, and had transactions support even longer.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
g support to give back a bit.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
#x27;t you? BA_DATE is a
timestamp, not a number of days.
Aside from that, it prevents use of indexes, which is always bad. :-)
How about
BA_DATE LIKE '2003-02-25%' instead?
HTH,
Benjamin.
--
[EMAIL PROTECTED]
-
which will happily use an index on inetAdr.
> and it is a little cleaner, although as I'm going to be doing this in a
> PHP script, cleanliness isn't all that important.
>
> So I guess I have 2 questions:
>
> 1] Which should I use?
My version. ;-)
> 2] Is this
atements and save the data for
> later due to the unique format of the reports. But perhaps there
> are some optimizations I can make to help.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
little step away (and only delayed by
what could be called bad luck) or is there a more general issue I am
missing?
As I said, a summary of the current state and your thoughts on next
releases would be fine; I don't expect any binding statements. :)
TIA,
Benjamin.
ith a
normalized design, you usually shouldn't need such a query. In other
words, if you find yourself needing to do such queries regularly, you
may want to re-evaluate your database design.
Depending on the context, a look at FULLTEXT indexes may be helpful,
too.
HTH,
Benjamin.
--
[EMA
I saw as a misconception of yours. If anything of that sounded
offensive to you, I apologize, as that was not my intention. Blame it
on me not being a native speaker, if you want.
Hope you have a nice day,
Benjamin.
--
[EMAI
ind buying support is not about
having support, but about given some money in order to "pay back", if
you think that would be the right thing to do. That you also have
official support this way is just an added benefit.
In other words: it would be just a gift in order to say thanks. (Wit
On Tue 2003-02-18 at 16:11:11 +, [EMAIL PROTECTED] wrote:
> Benjamin Pflugmann wrote:
[...]
> There is also some middle ground here. Which is the overlap of the two.
No. Either the way you distribute your software is GPL-compliant or
not. If it is not, you need a commercial license,
be : conduct your own experiences... and
> see for yourself.
Absolutely. Seconded.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
l and it's simplicity
> of use, because for somebody who knows the 2 databases, features wise,
> robustness wise and speed wise, interbase is far ahead of mysql.
I give you features wise. The other two, robustness and speed wis
L AB can hand out a commercial license is because they are also
the Copyright holders, which you aren't even after forking.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.co
ion of MySQL
- more fine grained privileges (with GRANT)
- dynamic server variables (change the configuration on the fly)
- rewrite of replication with new features
- and some other stuff
HTH,
Benjamin.
--
[EMAIL PROTECTED]
--
SQL package, which contains
everything else needed, not only the standard mysqld.
HTH,
Benjamin.
PS: Please start a new thread when you start a new subject (i.e. do
not use a unrelated message and reply to that). Else, most mail
readers will show it belonging to the post you
,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]&
your
original post about the problem to the end. As I said, that is a list
of volunteers and your attitude surely doesn't help you to get answers.
Bye,
Benjamin.
> - Original Message -
> From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
> To: "Ja
f they want to search the
manual.
So please, if you must, keep the reply to the original author only.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
nd now for a while (AFAICT it
started End of January and got worse since then).
Bye,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Hi,
I've seen there's a problem with the mysql binaries on linux, does anyone
know if this also affects FreeBSD?
I cannot get access to the database via jdbc. I am using the
mysql-connector-java-2.0.14-bin.jar, mysql version 3.29.49, on freebsd 4.5,
and get the following stacktrace:
java.sql.SQL
to enable use of indexes:
ON c.company = p.company AND
c.firstName = SUBSTRING_INDEX( p.name, ' ', 1 ) AND
c.lastName = SUBSTRING_INDEX( p.name, ' ', -1 )
HTH,
Benjamin.
--
[EMAIL PROTECTED]
--
operates on a number, not a string, so there is
no way to pass the leading zeros trough.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
that work the
> same on different platforms...?
Hm. Write your on mysqldump? (That's not as hard as it sounds, because
you don't have to start from scratch, but only modify the existing
one.)
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---
t from? The only 4.0 change entry mentioned CHECK
is for 4.0.6 (which you don't have) and explictly tells that it is
still not implemented:
http://www.mysql.com/doc/en/News-4.0.6.html
And the CREATE TABLE section explains the same:
http://www.mysql.com/doc/en/CREATE_TABLE.html
R
On Sat 2003-02-01 at 10:35:46 -, [EMAIL PROTECTED] wrote:
> Hi Benjamin,
>
> Wow, that sure sorted that problem out... I had to rejig it slightly to
> get it to work,
Oops... too much copy&paste by me :-)
> but this is the final working version:
Glad it worked out.
Bye
marks when creating sql code
See above, --quote-names is supposed to do that. If it doesn't for
you, please provide a repeatable example.
Bye,
Benjamin.
> Release: mysql-3.23.54 (Source distribution)
> System: Linux x.com 2.4.18-19.7.x #1 Thu Dec 12 09:00:
1 - 100 of 822 matches
Mail list logo
