Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
16.3, a powerful GUI frontend for Windows that allows you to generate
feature-rich CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
http://demo.sqlmaestro.com
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
15.12, a powerful GUI frontend for Windows that allows you to generate
feature-rich CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
http://demo.sqlmaestro.com
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
14.10, a powerful GUI frontend for Windows that allows you to generate
feature-rich CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
http://demo.sqlmaestro.com
During a recent system software upgrade (CentOS) on the front-end of our
computing cluster, the mysql area was upgraded without our realizing that it
was going to be. Now, php and mysql do not communicate well with one another.
The version of mysql on the system after the upgrade is 5.1.61
Hi,
I need help, I'm working on a project that need time query in Mysql. I want to
display a time in php page, that took mysql to execute 100 000 records
Sent from my BlackBerry® wireless device
-Original Message-
From: ratlhaga...@yahoo.com [mailto:ratlhaga...@yahoo.com]
Sent: September 18, 2012 7:31 AM
To: mysql@lists.mysql.com
Subject: [Possible Spam]Php programmer
Hi,
I need help, I'm working on a project that need time query in Mysql. I
want
to display a time
...@bytesmiths.com
To: mysql@lists.mysql.com
Sent: Tuesday, August 21, 2012 10:33 PM
Subject: Re: ANN: PHP Generator for MySQL 12.8 released
Gentle reminder: PLEASE note somewhere in your postings that this is a
Windows-only executable that is useless to pure UNIX/Linux shops.
You don't even note
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
12.8, a powerful GUI frontend that allows you to generate feature-rich
CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
http://demo.sqlmaestro.com/
PHP
Gentle reminder: PLEASE note somewhere in your postings that this is a
Windows-only executable that is useless to pure UNIX/Linux shops.
You don't even note that requirement on your website, until one has gone to the
trouble to register for the download, only to discover a huge, useless .EXE
Greetings,
I have a site that I am developing and I am looking to partner/
developer with great php/mySQL skills (for share of potential profits)
to assist me in finishing this site. I am looking for someone who can
invest (like myself) their time and skills to complete the site
try this within PHP... I can't get it to work at all. I assume
that the SET is the issue, but I am not 100% sure.
I use the PEAR MDB2 class, and I have tried it in 1 statement, but it
failed, and I tried it with 2 statements, it didn't puke on it, but it
didn't work either.
?php
# db
` = (@var_name := @var_name +1);
Now, when I try this within PHP... I can't get it to work at all. I assume
that the SET is the issue, but I am not 100% sure.
I use the PEAR MDB2 class, and I have tried it in 1 statement, but it
failed, and I tried it with 2 statements, it didn't puke
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: February 22, 2012 11:07 AM
To: Steven Staples; mysql@lists.mysql.com
Subject: Re: MySQL Session Variables with PHP
On 2/22/2012 9:47 AM, Steven Staples wrote:
Good [insert time of day here] all
- Original Message -
From: Steven Staples sstap...@mnsi.net
You're asking the wrong question, though. WHY do you want to do that? You
should never, ever ever rely on auto_increment for stuff like record insert
order. Did I mention NEVER?
Autoincrements can get reset for a variety of
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
11.12, a powerful GUI frontend that allows you to generate
feature-rich CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
http://demo.sqlmaestro.com/
PHP
On Mon, Sep 19, 2011 at 04:00, Hank hes...@gmail.com wrote:
I agree with Brandon's suggestions, I would just add when using numeric
types in PHP statements where you have a variable replacement, for instance:
$sql=INSERT into table VALUES ('$id','$val');
where $id is a numeric variable
On Mon, Sep 19, 2011 at 07:47, Reindl Harald h.rei...@thelounge.net wrote:
what ugly style - if it is not numeric and you throw it to the database
you are one of the many with a sql-injection because if you are get
ivalid values until there you have done no sanitize before and do not here
(it is).
But sometimes calculated values or bugs in PHP code end up with a null
variable field. I was just suggesting the choice between two errors -- one
syntax which will generate a hard failure of the query and likely whatever
page, or a soft logical error, which won't. In either case, I have error
the data wasn't sanitized (it is).
But sometimes calculated values or bugs in PHP code end up with a null
variable field. I was just suggesting the choice between two errors -- one
syntax which will generate a hard failure of the query and likely whatever
page, or a soft logical error, which
. Actually, an array wrapped in an
object could perform the escaping itself, making me doubly sure that
some other dev didn't forget to escape while playing with the code.
By the way, I've never gotten a godd explanation about why to wrap the
variables in PHP MySQL queries with curly brackets. I don't
Best of both worlds:
$username=$_POST['username'];
// do some stuff with username here
$M=array(); // Array of things to be inserted into MySQL
$M[username]=mysql_real_escape_string($username); // Everything that
goes into $M is escaped
$query=INSERT INTO table (username) VALUES
On Tue, Sep 20, 2011 at 01:11, Hank hes...@gmail.com wrote:
Best of both worlds:
$username=$_POST['username'];
// do some stuff with username here
$M=array(); // Array of things to be inserted into MySQL
$M[username]=mysql_real_escape_string($username); // Everything that
goes into $M is
Am 20.09.2011 00:39, schrieb Dotan Cohen:
On Tue, Sep 20, 2011 at 01:11, Hank hes...@gmail.com wrote:
Best of both worlds:
$username=$_POST['username'];
// do some stuff with username here
$M=array(); // Array of things to be inserted into MySQL
I want to be sure that all variables in the query are escaped. I don't
trust myself or anyone else to do this to every variable right before
the query:
$someVar=mysql_real_escape_string($someVar);
But you're doing exactly that right before the query anyway with:
On Tue, Sep 20, 2011 at 02:09, Hank hes...@gmail.com wrote:
I want to be sure that all variables in the query are escaped. I don't
trust myself or anyone else to do this to every variable right before
the query:
$someVar=mysql_real_escape_string($someVar);
But you're doing exactly that
On Tue, Sep 20, 2011 at 01:48, Reindl Harald h.rei...@thelounge.net wrote:
i would use a samll class holding the db-connection with insert/update-methods
pass the whole record-array, lokk what field types are used in the table
and use intval(), doubleval() or mysql_real_escape-String
so you
By the way, the database connection is include()ed from a file outside
the webroot. This way if Apache is ever compromised or for whatever
reason stops parsing the PHP, the resulting code returned to the
browser won't have the daabase info (especially the password).
--
Dotan Cohen
http://gibberish.co.il
(), doubleval() or mysql_real_escape-String
By the way, the database connection is include()ed from a file outside
the webroot. This way if Apache is ever compromised or for whatever
reason stops parsing the PHP, the resulting code returned to the
browser won't have the daabase info (especially
= 'Test';
UPDATE mytable SET datetime_field = '2011-09-18 00:00:00' WHERE id = 3;
If you are using PHP you may need to escape the single quotes if your php
string is in single quotes:
$query = 'UPDATE mytable SET varchar_field = \'Test\' WHERE id = 3'
But if you are doing interpolation and your
On Sun, Sep 18, 2011 at 17:44, Brandon Phelps bphe...@gls.com wrote:
Personally I don't use any quotes for the numeric types, and single quotes
for everything else. Ie:
Thanks, Brandon. I understand then that quote type is a matter of
taste. I always use double quotes in PHP and I've only
then that quote type is a matter of
taste. I always use double quotes in PHP and I've only recently
started putting ticks around table and column names. I'll stick to
your convention of no quotes around numerics and single quotes around
everything else.
I agree with Brandon's suggestions, I would just add
Am 19.09.2011 03:00, schrieb Hank:
I agree with Brandon's suggestions, I would just add when using numeric
types in PHP statements where you have a variable replacement, for instance:
$sql=INSERT into table VALUES ('$id','$val');
where $id is a numeric variable in PHP and a numeric field
timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2), uniqueid(idlog) );
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '(idlog) )' at line 1
This is by no means a PHP
server version for the right
syntax to use near '(idlog) )' at line 1
This is by no means a PHP question, and should not be asked on the
PHP General mailing list. Please ask questions in the appropriate
place; for this, the MySQL General list is the correct forum, and
they've been CC'd
.
On 28 Apr 11, at 18:02, mysql-digest-h...@lists.mysql.com wrote:
From: Sharl.Jimh.Tsin amoiz.sh...@gmail.com
Date: 26 April 2011 18:33:04 PDT
To: SQL Maestro Team sql.maes...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: PHP Generator for MySQL 11.4 released
very useful tool
To: SQL Maestro Team sql.maes...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: PHP Generator for MySQL 11.4 released
very useful tool,is it free?
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
Almost all absurdity of conduct arises from
of PHP Generator for MySQL
11.4, a powerful GUI frontend that allows you to generate feature-rich
CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
http://demo.sqlmaestro.com/
PHP Generator for MySQL comes in both Freeware
: Re: PHP Generator for MySQL 11.4 released
very useful tool,is it free?
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2011/4/26 SQL Maestro Team sql.maes...@gmail.com:
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
11.4, a powerful GUI
- Original Message -
From: walter harms wha...@bfs.de
maybe but what is mysql 11.4 ?
A parsing error :-)
the release of (PHP Generator for MySQL) 11.4
That should make more sense, I think.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
11.4, a powerful GUI frontend that allows you to generate feature-rich
CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
http://demo.sqlmaestro.com/
PHP
very useful tool,is it free?
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2011/4/26 SQL Maestro Team sql.maes...@gmail.com:
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
11.4, a powerful GUI frontend that allows you to generate feature
This must be a newbie question!
I'm not sure if this is either PHP / MySQL / Apache problem, so any help is
appreciated. I have a XAMPP setup in my PC.
Shortly, I have a two seperate codes as the following,
Code_A.php - looping code. this may take several minutes
Code_B.php - a quick simple echo
This is mysql-independent
If your php-scripts using sessions the session.file
is locked until end of the request, so if there
are multiple requests (as sample framesets) you
have to decide the point where are no wirtes
into the $_SESSION-Array are expected and use
session_write_close()
Directly
On 20 January 2011 19:20, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 19:21, Richard Quadling rquadl...@gmail.com wrote:
That is terrific, at least the first half. The second half, with the
Venn diagrams, is awkward!
When you get heavily nested data, the adjacent list
(relatively easy today with high
level languages such as PHP or C#) I need to decide how to organise
the data.
What do you want to sense and what do you want to display(not to say
I'm an expert, but I like to think in CS)?
The application will pull calendar records by category: entertainment
If you are doing this often, you could leave spaces in the left and right
values so that you could minimize the number of rows that need to be
updated. The article makes every leaf use x and x+1 for left and right which
forces another update to add a child. If instead you used x and x+20 you'd
Yes, and an edge list model may perform better in other respects too:
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
Thanks. I am currently reading Trees and Hierarchies in SQL for
Smarties by Joe Celko,
On Fri, Jan 21, 2011 at 12:29, Richard Quadling rquadl...@gmail.com wrote:
Changing data in a database is the role of the database engine. It is
much more efficient to have the cost on the insert than it is on the
select.
Agreed. On insert I could even delegate the operation to another
thread
On Fri, Jan 21, 2011 at 4:44 AM, Dotan Cohen dotanco...@gmail.com wrote:
Then I would have to check what values are available when inserting,
and possibly normalise every so often. I'll think about that, and when
I have enough data in the database I'll set up a test system to play
with the
TABLE tags (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
tagName VARCHAR(100),
items text,
);
This looks to be the best way from a MySQL data retrieval perspective,
but I do not know how expensive it will be to then split the items in
PHP. Furthermore, adding items to tags could get
On Thu, Jan 20, 2011 at 17:00, Richard Quadling rquadl...@gmail.com wrote:
I'd have my items table, my tags table and a join table for the two.
My join table is really simple. UniqueID, ItemID, TagID.
Yes, that is the first approach that I mentioned. It looks to be a
good compromise.
I'd
On Thu, Jan 20, 2011 at 18:20, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 17:00, Richard Quadling rquadl...@gmail.com wrote:
I'd have my items table, my tags table and a join table for the two.
My join table is really simple. UniqueID, ItemID, TagID.
Yes, that is the
On 20 January 2011 16:20, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 17:00, Richard Quadling rquadl...@gmail.com wrote:
I'd have my items table, my tags table and a join table for the two.
My join table is really simple. UniqueID, ItemID, TagID.
Yes, that is the first
I cannot agree more with the others about using a join table. While it's
tempting to go with your first solution due to fear of performance issues,
you can usually address performance issues with a technical solution.
Addressing problems that arise from a constraining design choice is much
more
Pseudo = Design Algorithm
Design Algorithm = Actual Code
Actual Code = Alterable db tables
Alterable db tables = manipulated data through the app interface with data
--
The lawyer in me says argue...even if you're wrong. The scientist in
me... says shut up, listen, and then argue. But the lawyer
On Thu, Jan 20, 2011 at 19:21, Richard Quadling rquadl...@gmail.com wrote:
That is terrific, at least the first half. The second half, with the
Venn diagrams, is awkward!
When you get heavily nested data, the adjacent set model (where you
have a parentid for every uniqueid), you very quickly
On Thu, Jan 20, 2011 at 20:50, David Hutto smokefl...@gmail.com wrote:
Pseudo = Design Algorithm
Design Algorithm = Actual Code
Actual Code = Alterable db tables
Alterable db tables = manipulated data through the app interface with data
--
The lawyer in me says argue...even if you're wrong.
Is this a troll? Am I about to be baited?
Baited to deploy what is designed to the consumer's specification?
Surely. From what is wanted to what is needed. Troll on that.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
The lawyer in me says argue...even if you're
On Thu, Jan 20, 2011 at 21:24, David Hutto smokefl...@gmail.com wrote:
Is this a troll? Am I about to be baited?
Baited to deploy what is designed to the consumer's specification?
Surely. From what is wanted to what is needed. Troll on that.
Actually, I'm the customer! But assuming that a
On Thu, Jan 20, 2011 at 2:26 PM, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 21:24, David Hutto smokefl...@gmail.com wrote:
Is this a troll? Am I about to be baited?
Baited to deploy what is designed to the consumer's specification?
Surely. From what is wanted to what is
On Thu, Jan 20, 2011 at 2:40 PM, Jerry Schwartz je...@gii.co.jp wrote:
-Original Message-
From: Dotan Cohen [mailto:dotanco...@gmail.com]
Sent: Thursday, January 20, 2011 11:25 AM
To: Jerry Schwartz
Cc: mysql.; php-general.
Subject: Re: Organisational question: surely someone has
On Thu, Jan 20, 2011 at 21:40, Jerry Schwartz je...@gii.co.jp wrote:
Thanks. I prefer the parent tag field, though, I feel that it is
more flexible.
[JS] I disagree. The method I proposed can be extended to any depth, and any
leaf or branch can be retrieved with a single query.
I suppose for
On Thu, Jan 20, 2011 at 7:00 AM, Richard Quadling rquadl...@gmail.comwrote:
I'd recommend using a nested set approach for the tags
(http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
gives a good explanation on the issues and methodology of nested
sets).
Thanks for the
On Thu, Jan 20, 2011 at 22:05, David Harkness davi...@highgearmedia.com wrote:
Thanks for the link. That article proposes an interesting way to organize
the categories. Have you implemented this in the wild? Clearly the design
would work as it's pretty simple, and I like that it removes the
On Thu, Jan 20, 2011 at 12:21 PM, Dotan Cohen dotanco...@gmail.com wrote:
I understood that. My concern is exactly with adding new nodes. There
is no incrementor (++i) in SQL, so knowingly coding a solution that
will require incrementing two fields in half the database rows seems
[JS] I disagree. The method I proposed can be extended to any depth, and
any
leaf or branch can be retrieved with a single query.
I suppose for retrievals this structure has advantages, but unless
MySQL has a ++ operator (or better yet, one that adds or subtracts 2
from an int) then it looks
My concern is exactly with adding new nodes. There
is no incrementor (++i) in SQL, so knowingly coding a solution that
will require incrementing two fields in half the database rows seems
irresponsible.
Yes, and an edge list model may perform better in other respects too:
On Wed, Dec 29, 2010 at 04:57, Hajo Locke hajo.lo...@gmx.de wrote:
Hello,
i want to talk from php to different mysql-servers with different versions.
is it a recommend way to compile php always against newest libmysqlclient or
not so important?
You should use the newest stable version so
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote:
Hi all,
Is there a list/form to get some help on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is no the
appropriate forum. Thanks ;-)
Yes.
For MySQL queries
on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is no
the
appropriate forum. Thanks ;-)
Yes.
For MySQL queries, write to the MySQL General list at
my...@lists.mysql.com. For PHP-specific database questions (for any
database backend
Debian squeeze, mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu
(i486) using readline 6.1, PHP 5.3.3-2 with Suhosin-Patch (cli) (built:
Oct 21 2010 18:58:27).
I'm not sure if this group or the php one is more appropriate but
thought I would try here first as it is perhaps a mysql setting I
Hi all,
I have to setup a new dedicated server for my job,
it will need to host some mysql databases with php accessing them,
for a number of reasons it need to be a Windows server ( 2008 )
the amount of data will not be very great ( the biggest table will contain
between 100.000 and 200.000
Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
10.8, a GUI frontend that allows you to generate high-quality PHP
scripts for the selected MySQL tables, views and queries for the
further working with these objects through the web.
http://www.sqlmaestro.com/products/mysql
pouvons accepter aucune responsabilité
pour le contenu fourni.
From: j...@bytesmiths.com
To: mysql@lists.mysql.com
Subject: Re: Why is MySQL always linked to PHP?
Date: Thu, 22 Jul 2010 22:23:50 -0700
On 22 Jul 10, at 21:01, Anirudh Sundar wrote:
SO ONE CANNOT COMPARE PHP WITH C
Jay,
PHP is a WEB based Server Side scripting Language.
Do not compare it with C. C is a middle -level System programming language.
Please stop comparing.
On Sat, Jul 17, 2010 at 10:03 PM, Jan Steinman j...@bytesmiths.com wrote:
From: Jay Blanchard jblanch...@pocket.com
You always have
[snip]
Jay,
PHP is a WEB based Server Side scripting Language.
Do not compare it with C. C is a middle -level System programming
language.
Please stop comparing.
[/snip]
The statements about C were not mine, it was just the way that the
thread was snipped together. Believe me when I say that I
On 22 Jul 10, at 01:25, Anirudh Sundar wrote:
Jay,
Actually, that was my comment.
Do not compare it with C. C is a middle -level System programming
language.
PHP's syntax is very much like C.
My point, which I guess wasn't clear, is that one of the reasons PHP
is popular (among
Jay,
I am not incorrect.
PHP and C work on different domains.
SO ONE CANNOT COMPARE PHP WITH C. PHP IS A FULLY EVOLVED OBJECT ORIENTED
SERVER SIDE SCRIPTING LANGUAGE.
JUST BECAUSE PHP SYNTAX RESEMBLES C, DOES NOT MAKE IT LESS POWERFUL OR
INFERIOR OR LESS SCALABLE.
PHP IS INDEED A SELF
On 22 Jul 10, at 21:01, Anirudh Sundar wrote:
SO ONE CANNOT COMPARE PHP WITH C.
I can compare anything I want to -- I took a poetry class in college!
(Her teeth were like the stars, 'cause they came out at night. :-)
If you STOP SHOUTING, people might take you more seriously
, at 21:01, Anirudh Sundar wrote:
SO ONE CANNOT COMPARE PHP WITH C.
I can compare anything I want to -- I took a poetry class in college! (Her
teeth were like the stars, 'cause they came out at night. :-)
If you STOP SHOUTING, people might take you more seriously
On Mon, 19 Jul 2010 10:36:40 -0600
Ashley M. Kirchner ash...@pcraft.com wrote:
mysql select * from table where id='1';
+---+-+-+---+
| 1 | 123 | 0.0 | C |
| 1 | 234 | 0.1 | D |
| 1 | 345 | 0.0 | D |
| 1 | 456 | 0.1 | C |
| 1 | 567 | 0.1 | G |
From: Jay Blanchard jblanch...@pocket.com
You always have to use the right tool for the job though. The question
is are we teaching the inexperienced programmers what the right tools
are?
I doubt it!
PHP looks a lot like C, and people are taught C in college.
So instead of working
[snip]
PHP applications are, for the most part, not that ambitious
and mysql is simply the most accessible database with the best
developed API.
[/snip]
I know that you said for the most part and you are absolutely correct.
I just want to point out that there are many corporations relying on PHP
-Original Message-
From: Jay Blanchard [mailto:jblanch...@pocket.com]
Sent: Friday, July 16, 2010 5:25 AM
To: Michael Dykman; mysql
Subject: RE: Why is MySQL always linked to Php?
[snip]
PHP applications are, for the most part, not that ambitious
and mysql is simply the most
I realize this is somewhat off-topic for this list but:
I too have extensive experience with PHP/MySQL used in large scale
projects but I have experience with other languages and frameworks as
well.
I merely wished to dispel the common, newb impression that PHP is the
only realistic choice
[snip]
I merely wished to dispel the common, newb impression that PHP is the
only realistic choice.
[/snip]
I don't think that is the impression but I think that the low barrier to
entry and extensive support community make PHP a widely acceptable
choice. I have seen many a newb turned off
Browsing the Web I've seen that usually companies look for developers working
on MySQL and Php. Why are the two things linked? I mean I've not found any
requests for just a MySQL developer or DBA (as for example it happens for
Oracle), but it's always requested a MySQL/Php expert.
I ask
At 09:00 AM 7/15/2010, alba\.albetti wrote:
Browsing the Web I've seen that usually companies look for developers
working on MySQL and Php. Why are the two things linked? I mean I've not
found any requests for just a MySQL developer or DBA (as for example it
happens for Oracle), but it's
MySQL and PHP go together very well in the web development world. Almost
all of PHP websites use MySQL as their database storage engine, as almost
all hosting companies have installed PHP and MySQL on their servers.
Maybe the jobs you're looking at, are for programmers/developers, who can
take
postgress was fully ACID and mysql wasn't, we had... REPLICATION...
(insert toy story *wow* here please)...
So, back in those years, when web was just as a emergin technology, a fast,
relaiable, easy to use and install database was Mysql. If I don't remeber
bad, even php support for mysql
-Original Message-
From: alba.albetti [mailto:alba.albe...@libero.it]
Sent: Thursday, July 15, 2010 7:00 AM
To: mysql
Subject: Why is MySQL always linked to Php?
Browsing the Web I've seen that usually companies look for
developers working on MySQL and Php. Why are the two
It's not so much that MySQL goes with PHP as much as PHP goes with
MySQL. PHP applications are, for the most part, not that ambitious
and mysql is simply the most accessible database with the best
developed API.
I have developed applications using MySQL as a back end under a huge
number
On Thu, Jul 15, 2010 at 7:00 AM, alba.albetti alba.albe...@libero.it wrote:
Browsing the Web I've seen that usually companies look for developers working
on MySQL and Php. Why are the two things linked? I mean I've not found any
requests for just a MySQL developer or DBA (as for example
On Fri, Jun 18, 2010 at 16:30, Dave deal...@gmail.com wrote:
SELECT * FROM contacts WHERE state = 'CA' and name = 'bob' or
name = 'sam' or name = 'sara'
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a
[
I have 2 tables. Table A containing 2 fields. A user ID and a picture ID =
A(uid,pid) and another table B, containing 3 fields. The picture ID, an
attribute ID and a value for that attribute = B(pid,aid,value).
Table B contains several rows for a single PID with various AIDs and values.
On Wed, 2010-06-16 at 08:59 +0100, Nigel Wood wrote:
I'd use:
drop temporary table if exists AttSearchMatches;
select pid as targetPid, count(*) as criteraMatched from B where
userId=35 and ( (b.aid=1 and b.value 50) OR (b.aid=3 and b.value
=4) ) group by pid having criteraMatched = 2;
drop
Hi!
Daniel Brown wrote:
[Top-post.]
You'll probably have much better luck on the MySQL General list.
CC'ed on this email.
On Tue, Jun 15, 2010 at 20:58, Jan Reiter the-fal...@gmx.net wrote:
Hi folks!
[[...]]
I have 2 tables. Table A containing 2 fields. A user ID and a
exactly a PHP question, but since mysql is the most popular
database engine used with php, I figured someone here might have an idea.
I have 2 tables. Table A containing 2 fields. A user ID and a picture ID =
A(uid,pid) and another table B, containing 3 fields. The picture ID, an
attribute ID
Hi all,
I have the following script:
Load data
Local infile myData.csv
Into table myTable
Fields terminated by ,
Enclosed by
Lines terminated by \r\n
(field1, field2,
)
When this is sourced directly from mysql it works fine, but when invoked
from php, I get the error
If you are using v4 of php this will never work
On Tue, Jun 1, 2010 at 10:24 AM, memo garcia mgar...@cistrans.cl wrote:
Hi all,
I have the following script:
Load data
Local infile ‘myData.csv’
Into table myTable
Fields terminated by ‘,’
Enclosed by ‘’
Lines terminated by ‘\r\n
1 - 100 of 2460 matches
Mail list logo
