Apologies - pls ignore my email below.
On 2/12/11 1:01 PM, Barry Morris wrote:
Simon
Thanks for your note. It sounds like you're having an interesting time.
We're having a lot of fun with NimbusDB. It is one of those
revolutionary architectural re-thinks that changes an indust
nsactional database. We're
not talking about it openly yet, but sign up for the mailing list
athttp://www.nimbusdb.com if you want more tech detail.
As relates to your request, give me a call. I think the timing will work.
Regards
Barry
On 2/12/11 4:46 AM, USAFlorist.com wrote:
Dear
rebuild your tables. As a result, this file cannot contain binary
data and so BLOBs must be converted to hex. If you know your BLOBs are just
text then you can get away with out the "hex-blob" option.
Barry Leslie
--
MySQL General Mailing List
For list archives: http://lists.mys
java connector has been updated and is now working
again.
- The PrimeBase Media Streaming web site has been updated and the
documentation has been made more user friendly.
If you have any questions or comments feel free send them directly to me.
Barry
at is PBMS's sole purpose in life.
Barry
On 2/16/10 8:21 AM, "Martin Gainty" wrote:
>
> i agree with jerry
>
>
>
> put date/timestamps on each record..(that way you know when the record was
> created/modified)
>
> Martin Gainty
> ___
a full list of changes please have a look at my BLOG posting
http://bpbdev.blogspot.com/
If you have any questions or comments feel free send them directly to me.
Barry
-
Barry Leslie
SNAP Innovation Softwareentwicklung
BLOG
http://bpbdev.blogspot.com.
Good luck on your project.
Barry
On 7/13/09 5:08 AM, "Daniele Development-ML"
wrote:
> Hello,
> I'm developing a web application that requires to store large files in a
> MySQL database. The files can range up to 2Gb.
>
> In my
a full list of changes please have a look at my BLOG posting
http://bpbdev.blogspot.com/
If you have any questions or comments feel free send them directly to me.
Barry
-
Barry Leslie
SNAP Innovation Softwareentwicklung
: the PrimeBase BLOB streaming engine's name
has been changed from "MyBS" to "PBMS" which stands for "PrimeBase Media
Streaming".
If you have any questions or comments feel free send them directly to me.
Barry
----
d a very generic function that
takes a structure similar to that used by schema plug-ins and generates the
required 'frm' file. Implementation is contained in the file BSDiscover.cc
and you can see how it is used in ha_mybs.cc.
----
on't return anything since the result set isn't that relevant.
Brent Baisley
Systems Architect
On Apr 11, 2008, at 8:08 AM, Barry wrote:
I am confused ( nothing new there), what I thought was a simple
search is proving not to be so,
Can anyone tell me why this query for the word &
+--+-+
| 134 | Linux | Prentice Hall | Embedded Linux Primer: A Practical,
Real-World Approach | Christopher Hallinan | 2006 |
+-+--+---+-+--+-+
1 row in set (0.00 sec)
and as you can see it came up with the correct result.
Thanks for looking
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Shawn Cummings schrieb:
If I have (2) tables. Like
GROUP , CODE
GRP1, AA
GRP1, AB
GRP1, AC
GRP2, BA
GRP2, BB
GRP2, BC
And;
USER , UCODE
ME, AA
ME, AC
YOU, AA
What's the best way to query to find out if "ME" has all codes in either of
the groups?
In other words
oup_concat, but that didn't worked :(
Anyone has an idea how to store multiple ids into one VAR ?
Thanks for reading!
Best wishes
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql
Hmm. Speaking of Navicat, does anybody out there have an easy way to
scrub the control coding from scripts developed under Navicat? I expect
that they're there mostly for coloration on displays, but it's kind of
obnoxious when you want to do anything else with them.
--
Barry
ects of MySQL when I remember
that Sun is a major sponsor of open source application software.
--
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ning about performance? On the face
of it, it sounds like you/'re letting the public beat hell out of that
machine, and maybe it needs a little help.
--
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OK, never mind. I finally found the 'locate' function. I knew it had
to be there somewhere!
--
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t. Any
suggestions? I'm completely open to various possibilities of delimiters
in the namelist.
Obviously this would let me reuse the query over and over, just changing
the one line.
--
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
I'm talking about the Linux (ubuntu) version.
On Sun, 2007-12-02 at 10:00 -0600, Afan Pasalic wrote:
> hi barry,
> this is on Linux version of MySQL Query Browser. I need the same on Win
> version. But, there is no such a solution (Tool > Option > ...).
> :(
>
>
I'm assuming you're talking about the Mysql Query Browser?
You can change the number of records under Tools-> Preferences and
changing the "Max Rows For Generated Queries" to whatever you want, set
to zero removes the limit entirely.
On Sat, 2007-12-01 at 15:17 -0600, Afan Pasalic wrote:
> Hi,
I'd rather do it in a sql statement rather than using a scripting language.
I'm thinking you might be able to do one select, accumulating 5
siubstring counts (a,e,i,o,u) into 5 variables, and then sum the
counts? I'll leave the testing to you. . .:-)
Barry Newton
-
e MS Windows, it would be absolutely possible to
configure 3-5 high speed printers and knock out 100,000 bills per
hour from an Intel single CPU box. You really have no appreciation
of how much power you actually have at your disposal.
Barry Newton
--
MySQL General Mailing List
For list archive
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 am I missing something blindingly obvious?
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysq
possible that the old IP address
is no longer the one assigned to the machine? DHCP? Just a thought.
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that as long as you're willing to pay *something*, there's probably a
lot of room for negotiation. It's distinctly not in their interest
to eliminate collateral development efforts. And there are already
several products out there which do connect with MySQL and cost <
Dušan Pavlica schrieb:
Barry napsal(a):
Hello Everyone!
I am having a big problem with counting inserting rows.
This is my Query:
SELECT MAX(id) INTO @maxid FROM table1; // @maxid is now 44
INSERT INTO table2 (orderid, someothervars)
SELECT @maxid +1, blahvar FROM table3;
try
select
Barry schrieb:
Hello Everyone!
i forgot i am using MySQL 4.11
Greetings
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
that?
I think it works somehow with SET @maxid = @maxid +1
But i fail combining it with INSERT SELECT :/
Any help is greatly appriciated =)
My best wishes
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list
Thibaud Hulin schrieb:
Hi!
I'm a beginner with phpmysql, and after an installation, I can't access
to my page http://localhost/phpmysql on Debian Etch.
Is a problem of restarting mysql ?
Thanks for help,
Thibaud.
Errors, warnings, logs?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)
tables have now the updated
structure.
Anyone know any tools or a way to do that?
Many thanks for any help :)
Regards
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ments are disturbed,
but you can now use the single old-style userid to connect with DBD4, and
keep your production users as secure as possible.
I've just done this on Win XP, and it works very nicely.
Barry Newton
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
g the subquery 2000 times for the 2000
records in your company file.
And will run 500,000 times when you go to production data. Somebody with
better math than I should try to project that.
His prep query runs once, and his update query runs once. Scales very nicely.
Barry Newton
--
MySQL Ge
er my
specification was being ignored in favor of some default--with no error
indication, or somebody forgot to document a new feature.
This has only been tried by me on Win XP.
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
und conventions that people
personally liked but no standards.
Thanks for any help :)
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
;m not ashamed to be educated.
Barry
* Compquery.sql -- Compare Current Year Reg Numbers and Money to Prior Year */
/*
*/
/*
*/
/* ACCUMULATE DATA BY MONTH FOR BOTH
YEARS*/
Drop Table If Exists Montable, Montable2;
Create Temporary Table Mo
At 04:15 PM 8/3/2006, Brent Baisley wrote:
You might look into WITH ROLLUP. That could easily give you cumulative
totals for the year, but off the top of my head I can't think of a way to
get it for the months.
- Original Message - From: "Barry Newton" <[EMAIL PRO
At 11:10 PM 8/2/2006, Peter Brawley wrote:
Barry
>It would make life easier if I could also show a column
>with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Mont
ons,
Extract(Year_Month from DatePaid) Monindex
From capclave2005reg
where year(DatePaid)=2005 and (amount > 0 or Dealer = 'Y')
Group by Monindex;
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not my intention. Thinking about it, this behavior in mysql
makes perfect sense, so thats not the issue.
If this is a one-time operation, it would seem easier to rename the
columns. In some cases, even if it's a little more frequent than that.
Barry
--
MySQL General Mailing List
For
?
thanks
-winn johnston
Do you really mean 100Gb RAM? Is that actually possible today?
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that can't connect etc.
thanks,
Jeff
For me it reads like "i want to replicate bananas but want to shape them
like melons. The customers are confused that the melons taste like bananas"
Am i correct with this?
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o
Chris White schrieb:
Normally I try to be as descriptive as possible with subject lines but.. not
quite sure what else to call it.
So basically, I was given ALL access by our sysadmin to a particular database.
Now, somehow I was able to create a database and use it! It's my
understanding th
Peter Lauri schrieb:
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English
d') = 2004;
return no rows. I can extract any piece of that date I want in a SELECT,
but can't seem to use it in a WHERE clause at all. There has to be
something really obvious that I'm missing?
Barry Newton
--
MySQL General Mailing List
For list archives: http://lists.mysql
for logging every query.
You can add a script to your service/software that does this.
but as far as i know, there is no logging option for this.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql
with NOT NULL using 0 and '' as defaults?
Depends on what you need!
But Both is okay.
"NULL" woudl just give you more free space since "NULL" don't add any
bytes to the column.
Greetings
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (
closes
it with the task manager then the table remains locked.
Regards
InnoDB and edit the MyCnf with your preferred values.
Greetings
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http
/doc/#ndbapi
Regards,
Stefan
Good work :)
Keep it up !
You guys are really doing great ;D
With high regards
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
elped him at
all, too.
Yes, I know my post didn't answer the question either :) I mailed because I
thought you might've misunderstood the original question and thought it was
just about how to concatenate two strings, rather than the more difficult
joining part.
Well more dif
Rob Desbois schrieb:
Sorry but you want me to write the whole SQL query?
He has to use his brain.
Grouping and joining the tables.
I'm not here for doing your or his work!
Barry,
I agree that it's often better to point someone in the right direction rather
than just writing the quer
tables.
I'm not here for doing your or his work!
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nolan Rumble schrieb:
mm.. I'm not sure what you're trying to achieve here?
Why do you want an array in there? I'm pretty sure it's not possible
(correct gang?), but I'm wondering why you'd want that.
What you *can* do is just store a serialized array in a textfield.
What i'm trying to do is
--
site1, XYZ, (M,P)
site2, RSQ, (Q,Y)
where all the related column data in the second table is placed in another
column. How can I do this? Is there a function that can group these values
into one variable or array?
Thank you
CONCAT_WS(', ',siteID,name,data)
Barry
--
Smileys ru
Jad madi schrieb:
Same here
On Mon, 2006-06-26 at 06:46 -0300, João Cândido de Souza Neto wrote:
I read that message and had no feelings.
<[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
Please, read and let me know what do you feel
I feel sad. There was no message ;_;
_id
FROM adverticelink AS a1
LEFT JOIN adverticelink AS a2 ON (a1.c_id=a2.c_id AND a2.aa_id=6)
WHERE a1.aa_id=4 AND a2.aa_id IS NULL
That should work in 3.23.
Yeah i know where you want to go to.
This looks really good, never thought about rejoining the table.
Thanks for that reply,
Barry schrieb:
Hello everyone!
I have a problem with matching in grouped rows.
I have:
- one DB with customers
- one DB with advertisement articles
- one DB that holds what customer got which article
the linked DB looks like:
CREATE TABLE adverticlelink (
c_id int(11) NOT NULL,
aa_id int
f you are luck it is an old one and easy restoreable.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jørn Dahl-Stamnes schrieb:
Is it possible to get mysqldump to include rights that has been GRANTED to a
database or to tables in the database that is being dumped?
Dump the Grant tables?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing
Database |
+--+
| test |
| test1|
+--+
2 rows in set (0.00 sec)
Bing
database test itself has Grants that it shows itself to everyone.
You have to set this in the table database.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
M
into the archive to find my last
question (which no one answered by the way :) )
Well yes. The list will kick you out after some time when you stop
sending mails to it.
I don't know how long it takes but the list do it.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o
-functions.html
good luck
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AS latest_date_on_order, SUM(amount) FROM table GROUP BY date
is it that what you looked for?
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e but that looked really false.
Thanks for any replies :)
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
full-time work?
How much money do you get for that?
Who don't ppl ever tell? I don't get it.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
this before?
Thanks,
James
# perror 13
Error code 13: Permission denied
Sure the own and group os mysql??
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
ror: Illegal mix of collations (latin2_general_ci,IMPLICIT)
and (latin2_czech_cs,IMPLICIT) for operation '='
I don't know where latin2_general_ci collation comes from.
Well one table or the column has this collation.
Check your structures.
=> `VnitrniCislo` char(15) character set
ends on the process.
There are processes where multiple SQL queries come in handy.
> 4.Is there any other effective SQL statement I can get better
> processing efficiency?
The beast way would be to start reading the optimization of MySQL:
http://dev.mysql.com/doc/refman/5.0/en/opt
uld be updating the table first
UPDATE workers SET impartance = importance + 1 WHERE importance > 1
This would raise every importance by one where the importance is bigger
than 1.
Now you could insert john with the importance of "1".
Is it that what you have been looking for?
Barry
-
Vitaliy Okulov schrieb:
Здравствуйте, Paul.
Вы писали 13 июня 2006 г., 17:13:52:
At 14:09 +0200 6/13/06, Kim Christensen wrote:
On 6/13/06, Barry <[EMAIL PROTECTED]> wrote:
Kaushal Shriyan schrieb:
Hi
I have a situation here how can i decrypt the mysql database userrs
pa
Kaushal Shriyan schrieb:
Hi
I have a situation here how can i decrypt the mysql database userrs
password
Kaushal
Not possible.
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
use this statement for setting Host table?
>
> If I can, what SQL statement can I use?
>
> Otherwise, can I only insert the host table depended on db table?
>
Hello Takanobu-san!
This will surely help you:
http://dev.mysql.com/doc/refman/4.1/ja/connection-access.
Gaspar Bakos schrieb:
-- Forwarded message --
Date: Mon, 12 Jun 2006 11:39:11 -0400 (EDT)
From: Gaspar Bakos
To: Barry <[EMAIL PROTECTED]>
Subject: Re: my-huge.cnf quite outdated
Hello, Barry,
RE:
Guess we would answer to everyone on the list who wishes to optimize h
naming convention guidelines and best practices?
Nope. Since any name of a column has just to be syntactically correct.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ver needs special handling. there is no "the one and
only you have to do it this way" way
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
does get the work done.
How could I speed this up, or solve it in another statement?
Regards
Use INNER JOIN :)
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
exact error you get?
=> [EMAIL PROTECTED]
is this the email you see on the error?
If yes, then it could be because of your character encoding.
Use UTF-8 encoding in your browser.
Otherwise here is a telephone number:
+1-208-514-4780 (14:00 - 01:00 UTC, Mon-Fri)
Greetings
Barry
--
Smil
Kaushal Shriyan schrieb:
Hi ALL
I am faced with a issue of creating database , The issue is I am able
to enter to the MySQL Server with the password, but when i try to
create database I get Access Denied
Below are the details
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
Welcome to
Nenad Bosanac schrieb:
Hi all
I made mistake i n my last post so now
i make it true.
I have problem in MYSQL query tool.
Well i put on foreign key on delete no action
but next time when i edit that table
it said that is on delete is restrict.
Why is that ?
I use MYSQL Query tool and
Nenad Bosanac schrieb:
Hi
I have one problem that i can`t resolve.
still need advice or is it solved?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Ben Clewett schrieb:
Hi Barry,
This is what I get:
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affected (0.25 sec)
mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Empty set, 1 warning (0.00 sec)
m
Ben Clewett schrieb:
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Well my msql doesn't give me any errors using that query.
neither a warning.
This "might&quo
ists, can I
suggest MySQL accepts these values, at least for comparisons, a little
cleaner?
For what it's worth, and to help us C# coders...
Ben
When does this happen?
What query had you run?
A more insight might help fix the problem ;)
Barry
--
Smileys rule (cX.x)C --o(^_^o)
o you have?
An other way would be to convert the Dates into UNIX STAMPS
that way you could subtract them and you have then the seconds between
each date.
I don't think i have to tell you how to go on then.
Greets
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o
Peng Yi-fan schrieb:
> Hi,
>
> I would like to change the path of a database's log. Which command I should
> choose?
>
> Thanks.
>
> Peng
Change the config files ?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives
on the 20th January noone clicked
that link.
I think this have to be done with a procedure.
So that my query would give a 0 (zero) for the 20th January as clicks.
How would i do something like that?
Thanks for your time :)
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o
on the 20th January noone clicked
that link.
I think this have to be done with a procedure.
So that my query would give a 0 (zero) for the 20th January as clicks.
How would i do something like that?
Thanks for your time :)
Mysql version is: 3.23.54
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance
tutorial of mysql.
Also is there any certification of mysql, php etc.
What kind of cert you are talking about?
SSL certs or what?
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
YD (lotsof indexes).
Read the Optimization sections of the mysql docs.
More RAM will speed it up also.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Marcus Bointon schrieb:
On 9 May 2006, at 14:27, Wolfram Kraus wrote:
WHERE concated_field LIKE '%87682%'
No, because that would also match numbers that contain that sequence
like '18768232876825'.
2. This doesn't sound like a good DB-Design, why don't you use two
seperated fields for bo
ySql support this statement? And how I can solve it?
As far as i know you can only use JOINs with ON.
So this would likely not work.
If you tell what you want to be outputted we might help find a solution.
barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^
彭一凡 schrieb:
> try this:
> WHERE concated_field LIKE '87682%'
> or
> WHERE concated_field LIKE '87682_'
>
would give me 876825 what i am not looking for.
And i were also looking for 87682.
So this doesn't work.
But thanks anyway :)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o
Wolfram Kraus schrieb:
Barry wrote:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_fiel
Barry schrieb:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
Is something
in any way?
Or does something like that function exists?
Well in PHP you a function called in_array() which would work kind of
similiar what i want to do.
Any help is very appriciated ^_^
Many thanks for any replies
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_
That way the other servers can access this Database and get the Users
from it.
Greets
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nils Lastein schrieb:
After a disk crash I managed to save the *.frm, *.MYD and *.MYI-files
from the disk. When putting these files into another mysql server I get:
mysql> select * from validate;
ERROR 1033 (HY000): Table './mydb/validate' was created with a different
version of MySQL and canno
Johan Höök schrieb:
Hi Barry,
see: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
you cannot insert into a table you're doing select on
(same goes for update).
But i am doing it on a test server version 5.x and it works like a charm :)
--
Smileys rule (cX.x)C --o(^_^o)
Dance f
av_id IN (1)
Not unique table/alias: 'objektflyer_verknuepfung'
I use a very old Mysql. 3.2 or similiar.
Anyone knows that error and can give a helping hand?
Thanks, Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing Lis
ySQL that i could tell you how MySQL works
behind ALTER TABLE.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 242 matches
Mail list logo