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 friend,
friend
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 industry. No-one
. 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.mysql.com/mysql
To unsubscribe
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
and that is PBMS's sole purpose in life.
Barry
On 2/16/10 8:21 AM, Martin Gainty mgai...@hotmail.com wrote:
i agree with jerry
put date/timestamps on each record..(that way you know when the record was
created/modified)
Martin Gainty
__
Verzicht
.
For 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 daniele@googlemail.com
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 understanding
.
For 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
-
Barry Leslie
SNAP
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.
-
Barry Leslie
--
MySQL
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 'plus':
mysql SELECT *
- FROM
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]
, 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.com/mysql
To unsubscribe
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
--
MySQL
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]
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]
? 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/mysql
To unsubscribe:http
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,
on
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 ...).
:(
-afan
barry wrote:
I'm
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
--
MySQL General
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 archives: http://lists.mysql.com/mysql
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.mysql.com
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]
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 $100.
Barry Newton
--
MySQL General
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
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
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
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!
and the 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
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.com/mysql
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 General
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/[EMAIL
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/[EMAIL
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 Montable engine=memory
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 PROTECTED]
To: mysql
) 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]
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_Month from DatePaid
, was 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 list
?
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]
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
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
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 o(^_^)^ o(^_^o)
--
MySQL
;
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.com/mysql
To unsubscribe
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.com
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
or 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 (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General
the 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]
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 query for them
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 difficult is relative.
Did not misunderstood.
Barry
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 unsubscribe:http://lists.mysql.com
--
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 rule (cX.x)C
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
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, it shed a light :)
Barry
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 ;_;
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
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]
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]
-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]
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 (o^_^)o o
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)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
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
.
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]
?
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://lists.mysql.com/[EMAIL
# 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:http://lists.mysql.com/[EMAIL
of MySQL:
http://dev.mysql.com/doc/refman/5.0/en/optimization.html
Here you get a lot of helpful omtimizations for your queries.
それじゃ。
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
this collation.
Check your structures.
= `VnitrniCislo` char(15) character set latin2 default NULL,
shouldn it be
= `VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list
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
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives
such 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
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 his
cnf.
I
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.html
それじゃ :)
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me
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
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
password
Kaushal
encoding in your browser.
Otherwise here is a telephone number:
+1-208-514-4780 (14:00 - 01:00 UTC, Mon-Fri)
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
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]
which has the same
measures, so that the live project don't start acting weird.
And btw. the cnf files wrk with even bigger tables than you have.
Not optimal but okay.
Every special server needs special handling. there is no the one and
only you have to do it this way way
Barry
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
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
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)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o
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 be a problem with windows
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)
mysql SHOW WARNINGS
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:
?
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^_^)o o(^_^)^ o(^_^o
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 for me! ^(^_^)o (o^_^)o o
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 o(^_^)^ o(^_^o)
--
MySQL
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:
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 unsubscribe:http
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
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(^_^)^ o(^_^o
Barry schrieb:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: 87682next39857
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 like
Wolfram Kraus schrieb:
Barry wrote:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: 87682next39857
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
彭一凡 schrieb:
try this:
WHERE concated_field LIKE '87682%'
or
WHERE concated_field LIKE '87682next_'
would give me 876825 what i am not looking for.
And i were also looking for next87682.
So this doesn't work.
But thanks anyway :)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me!
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(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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 '187682next32876825'.
2. This doesn't sound like a good DB-Design, why don't you use two
seperated fields
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
Peter Lauri schrieb:
Best groupmember,
I run version 3.23.58 and need to use something similar to DATEDIFF and
TIMEDIFF to calculate difference between two a timestamp and
current_timestamp().
Is there any other function that is working for version 3.23.58 that do the
same job?
Best regards,
the database from one
server to other
But the servers are not the same, right?
This could be one problem.
The other problem might be missing indezies on your other server.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list
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]
av_id IN (1)
brNot 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 List
For list
1 - 100 of 231 matches
Mail list logo