Top "Mysql" questions

PHP salt and hash SHA256 for login password

I've made encrypting of the password in my register script and they are stored in the database, and I have …

php mysql hash salt sha256

ERROR: Error 1005: Can't create table (errno: 121)

I have troubles with forward engineering my MySQL database into WAMP server.. I was going to post an image of …

mysql

JOIN queries vs multiple queries

Are JOIN queries faster than several queries? (You run your main query, and then you run many other SELECTs based …

mysql database join query-optimization

Update date + one year in mysql

When I want setting numerical value +1 in mysql table, I use e.g.: UPDATE table SET number=number+1 WHEN ... How …

mysql date

What does the KEY keyword mean?

In this MySQL table definition: CREATE TABLE groups ( ug_main_grp_id smallint NOT NULL default '0', ug_uid …

mysql indexing

Invoking a PHP script from a MySQL trigger

Is there any way how to invoke a PHP page / function when a record is inserted to a MySQL database …

php mysql triggers

Storing SHA1 hash values in MySQL

I have a simple question which occured when I wanted to store the result of a SHA1 hash in a …

mysql database-design hash sha1

org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

I get below mentioned stack trace though the data gets inserted successfully. Hibernate: select attendee_.attendeeId, attendee_.attendeeName as attendee2_1_ …

java mysql hibernate mysql-error-1062

How do I Alter Table Column datatype on more than 1 column?

For example: ALTER TABLE webstore.Store MODIFY COLUMN ( ShortName VARCHAR(100), UrlShort VARCHAR(100) ); The above however does not work. I am …

mysql alter-table

ORDER BY date and time BEFORE GROUP BY name in mysql

i have a table like this: name date time tom | 2011-07-04 | 01:09:52 tom | 2011-07-04 | 01:09:52 mad | 2011-07-04 | 02:10:53 mad | 2009-06…

mysql sorting group-by sql-order-by