MySQL is an open-source, relational database management system.
0
votes
0answers
11 views
MySQLdb Python prevent duplicate insert [migrated]
I wrote this python script to import a specific xls file into mysql. It works fine but if it's run twice on the same data it will create duplicate entries. I'm pretty sure I need to use MySQL JOIN but ...
1
vote
1answer
37 views
Is there a performance difference using AS keyword in SQL?
I'm working on a project in which the previous programmer seems to have loved using the AS keyword in the SELECT part of queries. I really don't like how it's written but if there is no performance ...
5
votes
1answer
59 views
Is there any problem in checking PHP PDO connection this manner?
Is there any problem in checking PHP PDO connection this manner?
Is this way reliable?
function pdo_mysql()
{
$mysql_string = "xxxxxxxxxxx";
$mysql_user = "xxxxxxxxxxx";
$mysql_pass = ...
5
votes
1answer
86 views
Please critique my newbie PHP code
I'm a complete PHP beginner and would like some feedback on this registration page I've created. Now, the one thing I know right off that bat that's wrong with it is that there's WAY too much ...
5
votes
1answer
71 views
PHP Login Authentication with BCrypt
So I have a php authentication script and everything works fine. But I'm very unsure about the way I programmed it (i hardcoded some stuff) and I was hoping stack could look through this and point out ...
1
vote
2answers
44 views
How can I ascertain and test SQL injection vunerabilities on this login code?
I know about the "little bobby tables" scenario and was just wondering if this code is vulnerable to such SQL injections.
I am fairly new to PHP and am curious about this.
My code for a login ...
2
votes
2answers
71 views
My database schema
I'm not sure if this would be okay to put here since it doesn't have code to look at, but this is my database I'm trying to create for an online firearm store. I'm new to database design and ...
4
votes
1answer
42 views
MySQL Java Connection with my application
the following is my code for the Java class connection to mysql server, i need to see if there is any suggestion to make it better.
this class not making the connection, it just control transactions, ...
4
votes
1answer
83 views
Please review my PDO Database wrapper
The subject is this small project - PHP/MySQL Database wrapper
The three main goals of this projects are:
Easy way to map database columns to object properties
Simple solution to insert or update ...
4
votes
1answer
52 views
How to optimize a pipline for storing item in mysql?
I am using scrapy framework for data scraping and dumping item in MySQL database.
Here is my pipeline that is inserting output to MySQL, but its taking so much time. Any suggestions on how to ...
4
votes
2answers
127 views
moving from->to: mysql->pdo, md5->pbkdf2, procedural->oop
I'm upgrading/rewriting our online client portal and wondering if my log in page code looks okay so far. during this rewriting/learning process I am upgrading a number of things: PHP 5.2 to 5.3.5, ...
5
votes
1answer
101 views
MySQL: Drop User if Exists
I wrote this MySQL stored procedure to emulate DROP USER IF EXISTS ( not available in MySQL ).
DROP PROCEDURE IF EXISTS DropUserIfExists;
DELIMITER $$
CREATE PROCEDURE DropUserIfExists(MyUserName ...
4
votes
1answer
51 views
Is this MySQL database structure acceptable or can it be improved?
Recently I've tried to teach myself basic things about MySQL databases, however I received some help on stackoverflow with creating a good database structure trying to avoid redundancy as much as ...
1
vote
1answer
54 views
Mysql left joins last row
I am making a query in mysql to import users in our marketing system and need for this a lot of data like for example :
Date of last order
Date of last cheque created
...
This are all left joins ...
2
votes
0answers
55 views
Am I taking the right path? [closed]
I have a dynamic page and a user can create or view posts. As of right now all of the posts show, I want to organize my posts by categories. But once the user goes to the page all of the posts will ...
