I think that offering some sort of feedback other than result sets would
be nice for debugging.
Peter Brawley wrote:
>I hope this isn't a silly question, or something covered in a FAQ. . .
>but is there any reason to not have at least some primitive print
>formatting commands in MySQL? Or a
I'd go the other way and use a trigger to validate the data, and roll
back the transaction if it isn't in valid format (assuming you are using
transactions). This way, ANY app that puts data in that field gets the
validation. An error in an application or typing by someone who has
direct table
I always go with REPLACE(REPLACE(STRING, '\n', ''), '\r', ''), since
depending on where your data came from there may be one or the other, or
both. Although if there is a shorthand/more efficient way I'd love to
hear it.
[EMAIL PROTECTED] wrote:
Ok.. I found the problem.. I needed to add a \
http://lists.mysql.com/[EMAIL PROTECTED]
that link ought to help you.
Jacques Brignon wrote:
Hi,
I keep receiving this message by several dozens each day, how can this
be stopped?
Regards
Jacques
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
Envoyé : jeudi
You should send that one to The Daily WTF... http://thedailywtf.com/
Jay Blanchard wrote:
[snip]
I recently last week Had and experience with an Very small Company,
where as
they had around 15 Machines all hooked "Star topology" and a central iis
ASP
Web server that only showed the date, and a
You can use the INFORMATION_SCHEMA.TABLES view to generate the GRANT
statements for you. Write a query along these lines:
SELECT CONCAT('GRANT SELECT ON test.', TABLE_NAME, ' to ''foouser'';')
FROM INFORMATION_SCHEMA.TABLES
WHERETABLE_SCHEMA = 'test'
AND TABLE_NAME LIKE 'foo_
There apparently isn't a PRINT or RAISERROR function like there is in
SQL Server, I've asked about this before.
I created a stored procedure to dump debug text into a table (which is
timestamped) and another to output the rows in there in a SELECT. It
isn't the same but it's something.
Dan
-SQL ones since that is what I get paid for).
I'm not here to discuss people's religious beliefs, I'm here to learn
what MySQL can and can not do.
Peter Brawley wrote:
Stephen Cook wrote:
There are such things as extensions to the standard, and many
languages besides BASIC tha
There are such things as extensions to the standard, and many languages
besides BASIC that have the ability to output a character string. No
need to be snippy.
I will look into the --silent option, thanks!
Peter Brawley wrote:
Stephen Cook wrote:
I appreciate it but SELECT isn't quite
of the columns is too narrow and some of the
information is truncated. For example the value shown for the second
variable name is shown as "birthdate_of_youngest_le" and the VALUE of
that variable is shown only as "1990", NOT the correct value, which is
"1990-05-11"
I've started using the SELECT with no other clauses but I am still
curious about a PRINT-like command. It is for SQL scripts.
Rhino wrote:
- Original Message - From: "Stephen Cook" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Sunday, May 07, 2006 3
Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)?
It would be handy to debug some scripts.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A commonly used example (at least at my last 3 jobs) would be a table of
demographics for people (whether they be employees, clients, whatever).
You can have one table and allow NULLs for some of the fields (id,
LastName, FirstName, MiddleInitial, Title, NameSuffix, AddressLine1,
AddressLine2,
;
> You then can manually update the dump files in a text editor.
>
> mysql db_name < db_name.sql
>
> recreates the dumped data with all tables.
>
> Andy
>
>
> Stephen Cook wrote:
>
> I am scripting out the creation of a database so I can make changes and then
&g
I am scripting out the creation of a database so I can make changes and then
run the script to generate a clean copy (by running it in MySQL Query
Browser).
The script DROPs all the tables, then CREATEs them again along with all the
indices and whatnot. However, if I run the script after having r
Maybe it is because I am a programmer, but (unsigned) 0 - 1 = 4294967295.
What's the big deal?
Gleb Paharenko wrote:
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
mysql 5.0.15-standard
UPDATE SET = -1
when the is 0 gives me
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my spam f
What's the deal with SPAM on the list?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You must not install 5.0 over 4.1, put it somewhere else.
Also, instead of naming the service "MySQL" both times, call it
something else (i.e. "MySQL41" and "MySQL50"). If you use the Windows
installer distribution, it is one of the options; if you are doing it by
hand then you already know ho
His answer was correct, and somewhat politer than "RTFM".
As for finding your "own damn answers", see again Mr. Green's original
reply.
Beauford wrote:
Sorry, but I don't take kindly to idiots. I don't care if he's gods gift to
MySQL. If there isn't enough info for him to give an informed an
MySQL is a relational database. XML is a text file.
the biggest difference is that MySQL will let you organize, sort,
match/link (joins), and otherwise manipulate the data you have. XML is
just text with tags in a heirarchy; anything other than reading it in a
text editor will take programming
it is because of the dollar sign that it works so much quicker.
Scott Hamm wrote:
I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to
MySQL to learn the migration process and executed the following:
SELECT
*
FROM
QA
LEFT JOIN
Batch
ON
Batch.QAID=QA.ID
LEFT JOIN
QAErr
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't l
depending on what you use this information for, you might want to keep
two tables, one with the current information, and one of the history. it
would keep the "current" one relatively small, but allow for looking up
historical data if necessary.
nephish wrote:
Hey there,
i have been messing
I've been running OPTIMIZE TABLE on a MyISAM table with an index on two
varchar type columns. The process status shows as "Repair with
keycache". The table has 73 million rows. OPTIMIZE TABLE has
been running for several days with constant disk activity but low cpu
usage and no way to estimate wh
record
last changed.
Any ideas would be very helpful.
Thank You
Jeff Cook
Network Administrator
Whatcom Educational Credit Union
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
After googling around and checking out the archives I still haven't found
the exact answer to my following question:
First off the goal is to give a family multiple quotes from different
companies for insurance based on several factors: age, length of coverage
and coverage limits. All the
How-To-Repeat:
Easy to repeat. simple follow the instructions in INSTALL. Similar problems
show up when I try to compile and install the source code as well.
>Fix:
>Submitter-Id:
>Originator: Brenda K. Cook
>Organization:
>MySQL support: [none | licence | ema
Hello-
I am in the early stages of setting up a website running mysql. The idea is
for the user to be able to compare insurance policies and choose the best
one. I want to give them the option of choosing several insurance plans and
compare them side by side. My question is would it be faster/more
When I tried to execute "Sun Solaris 2.7 Sparc static binary of MySQLGUI
1.6",
I get the error that it can't find, libstdc++.so.2.10.0. I thought this was
suppose to be a statically linked executable? I can fine the ".a" file
but not the ".so" file.
- Bob
--
tions as to how to set them up or get the connection
> going.
>
> Any help is appreciated
>
> Janet Cook
> CSDD
> NEC Australia Pty Ltd
> Ph +613 9264 3813
> Email: [EMAIL PROTECTED]
>
>
-
Bef
CC=gcc is an environment variabe for me):
./configure --prefix=/usr/local/mysql
and
`CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -
fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql -
-with-low-memory --with-extra-charsets=complex --enable-as
Hey all,
I'm fighting to get ColdFusion 4.5.1 SP2 to talk to a mySQL DB on Solaris 7
using unixODBC/myODBC.
anyone here tried this?
I've gotten to the point where I can see the myODBC mySQL Driver in the
CFIDE/adminstrator ODBC screen. I've added various entries to the
CFHOME/odbc/odbc.ini, CFHO
I'm attempting a source installation of mysql-3.23.40 on a Solaris 7 SPARC
server. the compile process completed without any errors. After reading
the various docs, I located the mysql_install_db script and executed it.
When running the mysql_install_db script, I recieve the following error
in case that makes any difference.
Ollie
--
Oliver CookSystems Administrator, ClaraNET
[EMAIL PROTECTED] 020 7903 3065
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ok, I'm running a Solaris 8 SPARC box, and I configure with:
./configure --enable-thread-safe-client --enable-shared --prefix=/usr2/mysql
--enable-user=acook
I then run make, use GNU make, and get:
ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o
rltty.o co
mplete.o bind.o
Is this still true in the latest version of MySQL? Is
this behaviour by design?
Cheers,
Ollie
--
Oliver CookSystems Administrator, ClaraNET
[EMAIL PROTECTED] 020 7903 3065
-
Before posting, please check:
/to/your/mysql/source/scripts directory
Ollie
--
Oliver CookSystems Administrator, ClaraNET
[EMAIL PROTECTED] 020 7903 3000 ext. 291
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
Is there any way to limit connections to
MySQL server on a per-host basis?
There are the:
max_connections and max_user_connections
options for mysqld on the command-line,
but I cannot see any way of limiting them
on a per-host basis?
Is there any way?
Thanks,
Ollie
--
Oliver Cook
>From my reading of the manual it seems that
for every time a new slave it to be added, the
master will need to be locked while the snapshot
is taken.
Is this really necessary? Can another slave be
somehow setup by taking the data from another
slave instead, thereby avoiding downtime on the
maste
TIA!
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
- Original Message -
From: "Peter Skipworth" <[EMAIL PROTECTED]>
To: "Nathan Cook" <[EMAIL PROTECTED]>
Cc: <[
Cook [ [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]&
down then machine B will
take all requests and then re-sync when machine A comes back online.
It seems like this is impossible without some sort of two way replication
available.
Any input is welcome. Thank You!
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administr
It seems like I have seen somewhere that load balancing and
fail-over-services are available for MySQL, to share the load and mirror the
data between two machines.
Is this possible and if so where can I read more about it?
Thank You,
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Net
LIMIT
0,10
I get the error: The table 'SQL4a5b_0' is full, Does this error mean a
temporary table is full?
What can I do to get this query to work.
Thank You
P.S. > The query works on an similar table with 10 fields 10,000 records.
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Syst
My bad... They aren't scheduled to come out until 3.24. Sorry.
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
- Original Message -
From: "tc lewis" <[EMAIL PROTECTED]>
Note: As of version 3.2.3gamma Mysql Supports Sub-Selects.
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
- Original Message -
From: "Scott Gerhardt" <[EMAIL PROTECTED]>
47 matches
Mail list logo
