MySQL is an open-source, relational database management system.
0
votes
0answers
4 views
how to embed video in laravel code
I am working on a project in which I store youtube video links in a database and then I retrieve those links and using blade template engine i try to embed them into page. I use a loop to put videos ...
1
vote
5answers
31 views
Check if user is logged in with session instead of database query
I'm wondering if it would be better to check if a user is logged into a website with his session instead of querying my database.
Isn't it a little bit too much to query the database on every ...
0
votes
2answers
21 views
getting images with while loop
I'm working on a school project where we need to make a website that can show images from a database. I'm trying to do this with the following piece of php code:
<?php
$table_name = ...
0
votes
4answers
37 views
Why is adding a column to an already-created table considered bad practice?
I was looking at the ALTER procedure to add a column to an already-created table and a lot of the answers specified that adding columns dynamically wasn't considered good practice.
I am trying to ...
1
vote
1answer
21 views
how to make several css buttons on the same line fit specified container width
I can't find the answer to this question but it must have been done before.
I have four lines of small images forming "keys" in a sort of kyboard layout (see link):
...
0
votes
0answers
15 views
Looking for most efficient method for retrieving records from fixed size DB
I am restoring Wikipedia's revision table which by the looks of it contains more than 200 million records. It takes along time to insert everything into a single db table. The total size of the sql ...
0
votes
0answers
14 views
Java and shadow copy databases/datasources
I trying to search in Google, Hibernate documentation, Spring Documentation some information:
How I can configure my data sources in Spring Framework for create additional shadow copy of my MySQL db?
...
1
vote
0answers
29 views
Alternative to Rand() for large database [duplicate]
I have this query
$sql = mysql_query("SELECT DISTINCT a, b FROM table ORDER BY RAND() DESC limit 15");
Which worked great when my table has only a couple of rows, now my table has thousands this ...
0
votes
0answers
14 views
Failed to read auto-increment value from storage engine. Cause?
I've got a table that suddenly started throwing up these errors on every insert statement.
I've solved the problem once, but now it's back and (due to management pressure) I need to know the cause ...
0
votes
4answers
33 views
can not word with the insert query to insert id using php
i have 2 tables
district
district_id
district_name
and village
id
village _name
district_id
i want to insert values to the table .. the query work well with insert the value of the village ...
0
votes
0answers
18 views
iframe navigation using parameter
I have a page called 'mas.php' where i retrieve values from database. An IFrame is present in mas.php page. It is defined as follows:
<iframe width="523" height="234" scrolling="No"
width="500" ...
0
votes
3answers
22 views
connect mysql database in webserver with c# program in windows
I have a website ,my database is mysql and now i want write a program with c# that the user can use this app too upload his file too my website
how i can connect a c# program in windows with mysql ...
0
votes
2answers
22 views
how to get file path of thumbnail created by orignal image in the directory
i'm using a function to store thumbnails of the original images which are stored in the directory, now i need to save the file path of that thumbnail in db.
How can i get that path of my thumbnails?
...
0
votes
0answers
12 views
Shard tags table strategy
I have a simple table in mysql called "tag" which has the columns: tag_id (PK), tag_name (unique), creation_time, I also have another table called tag_article which has article_id and tag_id.
the ...
0
votes
2answers
26 views
Insert string from char array in a mysql table
I created this table (results) in my sql database (test)
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `results` (
`number` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`temp` float NOT NULL,
...
