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 langu
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 th
messages, we need everyone's co-operation in ensuring that
only appropriate messages are sent to the list.
Please remember, the person reading your message may be your boss, your
future boss, your customer, your seminar instructor, your colleague, or
someone else that you work with today or may
messages, we need everyone's co-operation in ensuring that
only appropriate messages are sent to the list.
Please remember, the person reading your message may be your boss, your
future boss, your customer, your seminar instructor, your colleague, or
someone else that you work with today or may
time as the character 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
K, but a REPAIR TABLE reports an
>error '13 when fixing table' 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 Applica
002-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 cont
mysql-4.0.1-alpha-pc-linux-gnu-i686/share/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
. you can specify the data directory location as a configure option
>before compiling.<<
>
>Eventually, I will learn how to do this...but I opted for the RPM instead.
>I guess that is why I have these sort of configuration difficulties.
>
>Than
ere I have > 15GB free.
>
>How can I achieve this? Or is this the right approach? I think I
>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 W
mysql-4.0.1-alpha-pc-linux-gnu-i686/share/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
ne whether or not column can contain NULL values
>$info->{nullable} = ($row[2] eq "YES");
># get default value (undef represents NULL)
>$info->{default} = $row[4];
>
>return $info;
>}
--
Robert Alex
I did a test on mysql 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
Se
ysql 0 Dec 17 02:31 mandrake.pid
>-rwxr-xr-x1 root root 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 0
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.
we might not have to
>protect the emails beyond leaving them outside of static webpages:-)
That's 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!
Ha
bi-users@perl.org/msg06361.html
For an interesting exercise, you should try going to www.google.com,
or your favourite search engine, and doing a web search on your email
address and/or your phone number. The hits you get on that search are
the prime places where spambots are getting your email add
now, which gives me a
>basic intro.
The stuff 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
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 'between contracts' right now, I decided finally to
write one. I've actually been keeping an archi
e
record.
In the example above, you're specifically setting it to NULL or an empty string --
it's taking it's best shot, and filling the column with '0's. :>
HTH
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Databa
tml
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!"
-
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 Host
't know about the SourceForge site. I've always just
used the 'home' site.
Thanks,
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-659
t;The above one _is_ your site, isn't it?
>
>--
>Trond Eivind Glomsrød
>Red Hat, Inc.
The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try:
http://www.mysql.com/downloads/
HTH,
/Rob
~
Robert Alexander, Alpha Ge
>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,
?
MyPHPAdmin? :>
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!"
edit the elements of the array to be whatever you need, 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 PR
adir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking
>>>$err_log 2>&1
>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
m
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
~~~~~~
e and OS
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
iew"
in the manual.
If you've done all 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
command line tools, but I'm not sure which
>one[s] to use.
Not sure I understand this question. What do you mean by "create a
MySQL for my PHP?"
>Thanks.
>
>...Rene
Hope this helps,
/Rob
~
Robert Alexander, Alpha Geek, Workm
know what you need, 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]
"
ster:
>
>Create WITH indexes defined.
>Alter table 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.
~~
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
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
[opt
gt;ERROR 2002: Can't connect to local MySQL server
>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:[EMA
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 ...
le% in all of the available text fields.
>
> Any ideas about 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:[E
>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 Databa
much better 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 - bu
UND_ROWS col1, col2
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,
&g
to be working as the brief description would seem to indicate.
What am I missing?
Thanks!
/Rob
--
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
-
to be working as the brief description would seem to indicate.
What am I missing?
Thanks!
/Rob
--
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
-
, but I'm still interested in a solution 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
3.36 binary on an UltraSparc 1 with Solaris 8 (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
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 MyS
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 o
ge may be your boss, your
future boss, your customer, your seminar instructor, your colleague, or
someone else that you work with today or may find yourself working with
tomorrow. We do not want you to embarrass yourself by sending an
in
:>
Best,
/Rob
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:
|
| hash | int(11) | | PRI | 0
||
+---+---+--+-+
-+----+
~~~~~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database A
well, tingles sometimes...
>
>we all have our 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
~
ts. They're open-source, of course, so do with them what you will. :>
Best,
/Rob
Ob. MySQL: database, sql, query, table
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database A
27;d be a completely new, confusing, and
seemingly idiotic procedure for me. But I'm pretty sure I'd eventually get through 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. :>
/R
sr/local/lib is in the PATH and this file exist with mod = 555.
>
>
>Try "man ldconfig". Good luck!
>--
>Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
~
Robert
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 Gla
seems to step very carefully *around* mentioning that
MySQL is someone else's property.
Something like this doesn't happen by accident and, legal-babble aside, these are,
quite simply, not the actions of one who's respectful of other's work and property,
and not the actions o
[EMAIL PROTECTED]
Thanks for posting this, Don. I got a lot out of it.
Nothing like seeing a good example of commands actually being used. Much appreciated.
/Rob
~
Robert Alexander~~ Programmer/Analyst/DBA/Admin
WWW Database Applicat
help me with the making of this database or atleast
>guide me with the making of this..please.
>Thank You
good luck,
/Rob
~~~~~
Robert Alexander ~~ Software Designer/Analyst/Admin
WWW Database Applications~~http://www.ra1.net
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 postin
s for choosing MySQL instead of Microsoft SQL. (beside the
>fact that MySQL is free). (not for me but for my boss).
>
>It may sound silly but trust me I really need these reasons. So please help me with
>this.
>
>Thanks,
>Ciprian A.
~~~
61 matches
Mail list logo
