MySQL is an open-source, relational database management system.
-5
votes
0answers
22 views
What resources would be best to use to prepare for the MySQL 5.1 Cluster Database Administrator Certified Expert Exam? [closed]
I would like to prepare for the Oracle Certified Expert, MySQL 5.1 Cluster Database Administrator Certified Expert exam. However, the website does not provide any resources other than their practice ...
2
votes
1answer
73 views
Having a generic data type for a database table column, is it “good” practice?
I'm working on a PHP project where some object (class member) may contain different data type. For example :
class Property {
private $_id; // (PK)
private $_ref_id; // the object ...
-2
votes
0answers
35 views
delete,update,insert child rows when updating parent [closed]
I am using MySQL DBMS.I have Document table and Order table.The relationship between them is one to many.On edit form user can delete orders,add new orders and update orders.Is there
way that to ...
1
vote
1answer
111 views
Sharing a database while we work on local copies?
A friend and me are working on a webapp. We're using git so each of us has a local copy of the app. But the problem is the database. We want to be able to see the latest changes the other person made. ...
-2
votes
0answers
50 views
how to upload & preview multiple images at single input and store in to php mysql [closed]
This is nilesh , i am newcomer in this field , i need the script for when i click the upload button then uploaded images it should preview and store into db like wise i want to upload 10 images ...
1
vote
0answers
57 views
new project; entire node.js app [closed]
I have been looking into Node.js, express and Nowjs and love how easy it is to have real time interactions between clients. My background is mostly from CodeIgniter MVC using PHP and MYSql. I want to ...
-3
votes
1answer
122 views
Convert to BLOB in C# [closed]
I want to go from point A to point B.
A: Data in C#'s listview, like
string filename_of_image, string description
B: SQL-File containing blob information of the image and the description in plain ...
2
votes
4answers
242 views
Is it possible to keep only one Database for both web and desktop applications?
I'm experiencing a trouble with my business model, let me explain better.
I'm developing a software for 1 year and few months, it's for the food industry, more exactly a software to: Delivery, Take ...
-1
votes
1answer
95 views
How to check for null in most sql's - “column is null” or “column = null” [closed]
I'm not sure of the right syntax to use.
Is it
select * from tlb
where flag is NULL
or
select * from tlb
where flag = NULL
Is the answer the same for oracle, sqlserver and Postgres?
4
votes
1answer
185 views
Is mysql_* deprecated after PDO was introduced?
I have been noticing for a long time on Stack Overflow that most users recommend to use PDO instead of mysql_*, because PDO is more secure than mysql_*. But my question is if websites which are ...
4
votes
2answers
271 views
What to learn after standard C++? [closed]
I switched to C++ a few months ago, learning its syntax, the main features
of the STL and what you can usually find in a "learn C++" manual.
Now I would like to go further. What would be your ...
8
votes
4answers
471 views
Are there any conceptual drawbacks to building a web app with C++ and MySQL?
I've inherited a pretty interesting project where there is a good opportunity to take an existing piece of software and turn it into a SaaS web app. As the project is inherited, the code base/ ...
0
votes
2answers
143 views
Breaking up a large PHP object used to abstract the database. Best practices?
Two years ago it was thought a single object with functions such as $database->get_user_from_id($ID) would be a good idea. The functions return objects (not arrays), and the front-end code never ...
3
votes
4answers
339 views
My father wants to learn PHP-MySQL to port his application. What I should do to help?
My father is a doctor/physician. About 15 years ago he started writing an application to handle his patient's medical records in his clinic at home. The app has the ability to input patient's medical ...
2
votes
1answer
146 views
Is it safe to use LAST_INSERT_ID() in a system like Point of Sale
Is it safe to use LAST_INSERT_ID() in a system using MySQL like Point Of Sale when there are multiple users using the system at the same time?
