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
24 matches
Mail list logo
