At 07:37 -0500 2005/01/15, Dave Merrill wrote:
I thought string concatenation w '+' was totally
standard SQL.
Hmmm, this is the first I've heard of + being used for
concatenation (in SQL). Then again, I've never used MS SQL Server.
:-)
Each language is going to have its own personality. If
At 18:04 +0100 2005/01/15, Jochem van Dieten wrote:
On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote:
Each language is going to have its own personality. If they all did
things the same way, we wouldn't have the wealth of different ones to
choose from.
DBMS's are not languages
of the list does.
Feedback is welcome and encouraged. Flames /dev/null :
Regards,
Robert Alexander
Maintainer of the MySQL Posting Guidelines.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com
/mysql/english/errmsg.sys'
011230 12:14:48 Aborting
011230 12:14:48 mysqld ended
So, the error is pretty obvious -- the mysql directory is named twice in the path. My
question: where do I go to change this? Any other suggestions?
Thanks all,
/Rob
--
Robert Alexander ([EMAIL PROTECTED
-01-02, Robert Alexander [EMAIL PROTECTED] wrote:
When I go to launch, it gives me the Starting mysqld daemon with
databases... etc. message. It then fails immediately with the message
mysqld ended.
Here's the content of the error file in the data directory:
/usr/local/mysql/bin/mysqld: Fatal
' and 'Operation Failed' as the final status.
Any ideas of what is going wrong?
[fletcher]
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
Searchable MySQL List Archive: http://archive.workmate.ca/myarchive
/mysql/english/errmsg.sys'
011230 12:14:48 Aborting
011230 12:14:48 mysqld ended
So, the error is pretty obvious -- the mysql directory is named twice in the path. My
question: where do I go to change this?
Thanks all,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http
understood that the server can be started up with a different --datadir
option, but I would like this to be more permanent in case of system
reboots.
Thanks,
Dennis Williams
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
Williams
Regards,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
Searchable MySQL List Archive: http://archive.workmate.ca/myarchive
-
Before posting
;
}
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
Searchable MySQL List Archive: http://archive.workmate.ca/myarchive
-
Before posting, please check:
http
on DevShed is generally quite good. It's a good resource.
Thanks a lot Rob,
Peter
Hope this helps,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
Searchable MySQL List Archive: http://archive.workmate.ca/myarchive
on that search are
the prime places where spambots are getting your email address from.
I truly believe we're safe, though I'd love to hear more comments.
All the best,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
my thinking...
At 12:16 -0500 2001/12/17, Etienne Marcotte wrote:
grr
e-may
my bad
meant e-bay
two keys beside.. I think I have the shake
sorry!
Having a bad spelling day, my friend? G
Etienne
Regards,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca
At 11:46 -0500 2001/12/17, Roger Karnouk wrote:
Is there a way to alter an index on a table without dropping it and
recreating it?
I don't think so.
See: http://www.mysql.com/doc/A/L/ALTER_TABLE.html
HTH,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW
2530 Dec 13 07:08 my.cnf*
drwx--x--x2 mysqlmysql4096 Dec 12 00:24 mysql/
srwxrwxrwx1 mysqlmysql 0 Dec 17 02:31 mysql.sock=
drwxr-xr-x2 mysqlmysql4096 Dec 17 09:17 test/
HTH
/rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http
to connect i get this error
Fatal error: Call to undefined function: mysql_connect() in
/var/www/html/test.php on line 3
HTH,
/rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
Searchable MySQL List Archive: http
Re: MySQLGUI
At 17:05 +0200 2001/12/14, Sinisa Milivojevic wrote:
Very soon there will be a new executable available.
Great news! Thanks very much, Sinisa.
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps!
-
Before posting, please check:
http
shot, and filling the column with '0's. :
HTH
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps
Hi everyone,
Just want to make a very brief announcement.
I've seen a few mentions in the recent past of the desire for a
searchable archive of the MySQL list. I've wanted one, too.
So, being ahem 'between contracts' right now, I decided finally to
write one. I've actually been keeping an
.
The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try:
http://www.mysql.com/downloads/
HTH,
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto
the 'home' site.
Thanks,
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps
I need to suuply an exact number of bytes in a database dump. When using VARCHAR(21)
and only using 18 characters, how do you fill in the rest with forced spaces?
Take a look at the LPAD() and RPAD() functions.
HTH
/Rob
~
Robert Alexander, Alpha Geek
=$pid_file --skip-locking
$err_log 21
011206 02:51:49 mysqld ended
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password
, and you should be fine.
HTH,
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps
is...
It's only available for Windows.
...Rene
For Mac Classic environment - MacSQL Monitor. Shareware and very good.
http://www.rtlabs.com/
For OS-X, any of a great variety of Unix/Linux tools. How about MySQL GUI?
MyPHPAdmin? :
HTH
/Rob
~
Robert
this stuff, then you may want to check for proper pathnames and
permissions.
HTH
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root
the actual query (formatted to be readable, please : )
There's not really enough info in your posting to hazard a guess on a solution.
Regards,
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
group is a reserved word, use groups as table name
That being the case, how do I drop or rename a table called group?
Try:
ALTER TABLE 'group' RENAME new_table_name
HTH,
/Rob
~
Robert Alexander, Alpha
disable indexes.
Load data.
Alter table enable indexes.
The 'enable' and 'disable' seem to be strictly a MySQL 4.0
command, which I didn't initially DL, so I'm setting that
up now.
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web
, and I'll provide it.
Thanks,
P
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps
by create a
MySQL for my PHP?
Thanks.
...Rene
Hope this helps,
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password
At 15:34 -0500 2001/11/24, Barbara Ferrell wrote:
it is a primary key..i did not assign either NULL or NOT NULL when i created
it. i tried all kinds of commands in the MYSQL books.. i am in Linux...
Try the most excellent documentation, either online at www.mysql.com or the one that
came with
through socket '/tmp/mysql.sock'
--
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps
At 04:38 -0500 2001/11/16, Jennifer Slis wrote:
when I type myisamchk my server claims command not found.
Check to see that myisamchk is in your path. Or go directly to the
/usr/local/mysql/bin directory (or where ever it's installed) and type ./myisamchk
[options]
HTH
/Rob
--
Robert
now. Hope you are, too.
Yours in fine malts,
/Rob
--
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps
Hi,
I have a query result with 50 register and i want to show them in 5 pages,
every page show 10 register.
Thanks , for your answers
Rhony
http://www.mysql.com/doc/S/E/SELECT.html
See 'LIMIT'
/Rob
--
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http
where I can look to set up a database optimized for
searching in this way?
--
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps
http://www.mysql.com/doc/G/e/Getting_unique_ID.html
HTH,
/Rob
I know that this is a old question, but
I really need to know how can I get the
number that Mysql use in a autoincrement field
of a record I just inserted ...
Is there any function like LAST_INSERTED or
something like that ...
--
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
-
Before posting, please check:
http://www.mysql.com
--
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
-
Before posting, please check:
http://www.mysql.com
FROM tbl
WHERE col2 2
LIMIT 10;
You'll get back 10 rows.
SELECT FOUND_ROWS();
You should get back a value of 32.
Note that there's no comma after SQL_CALC_FOUND_ROWS.
original question ---
At 11:21 PM -0500 10/31/01, Robert Alexander wrote:
Hi all,
In the 4.0 manual, section F.1.1
(patched to
2001/04 IIRC).
Any hints, ideas, suggestions? Any additional info I can provide?
Thanks much, everyone. I'll summarize.
Best,
/Rob
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http
to this problem.
Thanks all,
/Rob
At 15:05 -0500 2001/10/30, Robert Alexander wrote:
Hi all,
mysqld seems to 'hang' under certain circumstances when I'm doing a fairly large
ALTER TABLE -- adding or dropping an Index, repair etc. The server and client are
still 'alive' and I can do simple things like
Hi all,
I just found out, while looking for other things, that what seems to be the entire
content of the MySQL list is being published on the web.
I, for one, really don't like this idea. I have a reasonable expectation that what I
post here is for viewing by subscribers to this list, the
At 00:43 -0500 2001/10/21, Gordon Burditt wrote:
As near as I can tell, you DON'T pass *.MYD files to myisamchk, just
*.MYI files. What's wrong with the *.MYD file is that it is not
and never was an index.
--- original question ---
At 15:50 -0400 2001/10/20, Robert Alexander wrote:
Hi
to embarrass yourself by sending an
inappropriate or poorly thought-out posting.
Regards,
/Rob
Robert Alexander [EMAIL PROTECTED]
Proposed MySQL Posting Guidelines Maintainer
http://www.ra1.net http://www.workmate.ca
-
Before
Robert Alexander wrote:
- Replies are directed to the POSTER and not to the list. This keeps traffic
and clutter down.
At 22:12 +0100 2001/10/21, Mark Maunder wrote:
Other authors wont be able to participate in a discussion and there wont
be the public aggregation of viewpoints - just
||
+---+---+--+-+
-++
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting
natures, cultures, surroundings,
and, understanding and respecting, clears boundaries
and improve overall communicability.
my warmest regards to all
mauricio portasio
[EMAIL PROTECTED]
sao paulo - brazil
~
Robert Alexander~~ Programmer
it.
:
So dive in, get your hands dirty, read lots, and it'll start to make sense pretty
quickly.
Good luck. May the foo be with you. :
/Rob
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1
. MySQL: database, sql, query, table
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
://www.pobox.com/~erc
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
Hi Jay,
I'd definitely suspect Outlook (or LOOKOUT! as a few of my network support buddies
call it) as the source of the problem, rather than anything to do with Jeremy's emails.
I'm having no problems here -- but then again, I don't use any Microsoft products. :
Good luck,
/Rob
As Rob
who's respectful of other's work and property,
and not the actions of one who's dedicated to open communication and a win/win
partnership. I find it dishonourable.
It leaves a pretty bad taste in my mouth.
/Robert Alexander
Ob. MySQL content:
database, sql, query, table
.
/Rob
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
The edifice of civil rights has degenerated into a
naked spoils system
with the making of this..please.
Thank You
good luck,
/Rob
~
Robert Alexander ~~ Software Designer/Analyst/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
I give you this one
Hi all,
I'm looking for some pointers towards some good information on accessing and using
MySQL with Java/Javascript.
Can anyone point me towards a book you like, or some good web resources?
Thanks much,
/Rob
-
Before
58 matches
Mail list logo