Tag: mysql

How to create/add a column in an SQL select query based on another column’s values?

I want to dynamically add another column hook_name, via an SQL select query, based on a condition. For example if hook_type = 0, table hook_name should have a value of OFFER, and similarly for hook_type = 1, hook_name should show “ACCEPT”. Below is a screenshot of the result: The select query is t…

Sum columns depending on another column value

mysql sql

I’m having trouble with summing the fields values based on another fields value. I need to SUM(activities.points) based on activities.activity_type if it’s used_points or added_points and put it in AS used_points/added_points. Table activities: Table subscriptions: What I need: What I tried : Whic…

MySQL select formatted date from millisecond field

date mysql sql time

I have a column in a MySQL database that contains a date as milliseconds (epoch). I want to build an SQL query that formats the date as something human readable (day, month, year, hours, minutes, …

Generate CREATE statements for all MySql Tables

information-schema mysql sql

I want All CREATE statements of MySql Tables in 1 query result. For example, INFORMATION_SCHEMA contains all table names,comments etc. but where are the CREATE statements are stored in MySql ? can it be retrieved in one query for all tables ? Currently i am retrieving TABLE ddl as below for 1 table. I have 10…

Foreign Key constraints missing after phpmyadmin export

foreign-keys key mysql phpmyadmin sql

I create a table in mysql using the following script: When I export the created table from phpMyAdmin, I obtain the following script So the question are: where is my foreign key constraints? does KEY refer to FK? Seems that the two tables utente and attivita are no longer referenced in the new generated scrip…

MySQL WHERE with conditions/priority condtion

mysql sql

This one is a weird one that I just can’t seem to wrap my head around. Basically I need to search based on a value that has an override. So there are 2 columns with essentially the same content. One …

SQL auto_increment behaviour

auto-increment database mysql sql

My first question is: Can I manually input ID into an auto_increment column of a table? For example: I have 10 records with ID from 1 to 10. Can I manually input the 11 record with the ID of 3 (yes, it’s a duplication!) My second question is: I assume that it’s possible to manually input ID number…

What does the ( ‘ > ) symbol mean in the command line in MySQL?

command-line database mysql sql

I’m new to sql and for some reason, the arrow symbol ( -> ) that I am used to seeing in teh command line, which mean it is ready for input, is now displayed as ( ‘> ) and it does not accept commands. What does it mean and how do I get back to ( -> ) ? Thanks

Conditional UPDATE in MySQL

mysql sql sql-update