>Open MY sql server
>Click on Server Menu
>Click on Data Import
> Click on Import from self-contained file
> Click on 3 dot and than select sql file
>Select Default Target Schema(Dropdown) and select blank database name
> Click on Start Import button
Missing expression. (near "ON" at position 25)
MYSQL
SET FOREIGN_KEY_CHECKS = ON;
Add this line in settings.php
$config['system.image']['toolkit'] = 'gd';
uncomment this line(for showing error log )
$config['system.logging']['error_level'] = 'verbose';
Customize below code
$databases['default']['default'] = array (
'database' => 'rni_web', //write data base that is blank, for new installation
'username' => 'root',
'password' => '',
'prefix' => '',
'host' => 'localhost',
'port' => '3307',
'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',
'driver' => 'mysql',
'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',
);
1) write data base that is blank, for new installation ( 'database' => 'rni_web', )
2) after next , you will get errors of gd than see below link
https://kapooryash.blogspot.com/2026/04/error-while-starting-my-sql-or-appache.html
3) if drupal new install than use it with that database, if website already modified or given by some other person than change database name with backup database(replace ( 'database' => 'rni_web', ) with other database)
https://webolute.com/blog/programming/this-may-be-due-to-a-blocked-port-missing-dependencies/
and for My sql, use below steps
Open the XAMPP Control Panel and click Config next to MySQL, then select my.ini.
Find the lines port=3306 (usually in two places) and change them to port=3307.
next step
If going to localhost:8000 get error than change the config.inc.php, enter the password in string $cfg['Servers'][$i]['password'] = 'root';
and change
$cfg['Servers'][$i]['controluser'] = 'pma'; to $cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';$cfg['Servers'][$i]['controluser'] = 'root';
INSERT INTO new_registration
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
-- 1. Change the statement delimiter
DELIMITER $$
DROP PROCEDURE IF EXISTS insert_data_loop;
-- 2. Create the stored procedure
CREATE PROCEDURE insert_data_loop()
BEGIN
DECLARE i INT DEFAULT 1; -- Declare a variable for the loop counter
DECLARE max_value INT DEFAULT 50; -- Set the loop limit
-- Start the WHILE loop
WHILE i <= max_value DO
-- 3. The INSERT query inside the loop
SET i = i + 1;
INSERT INTO new_registration
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
`Address`,
`DOB`,
`Upload_DOB_Certificate`,
`GST_No`,
`Upload_GST_Certificate`)
VALUES
(
'Individual',
1,
'News Paper',
'Indian',
'Yash Kapoor','45YYH87Y','Documents/test1.jpg',
457851,'test@test.com',
110022,'Haryana',
'Sonepat','Sonepat','Jangpura, Delhi',
' 15/01/1945', 'Documents/test1.jpg' ,
'JHJDFHJDF8787DF',
'Documents/test1.jpg');
-- Increment the counter
END WHILE;
END $$
-- 4. Reset the delimiter
DELIMITER ;
-- 5. Call the procedure to run the insert loop
CALL insert_data_loop();
-- Optional: verify the results
SELECT * FROM new_registration;
Note:- You cannot use for loop without Creating stored procedure.
NOW()
CURRENT_DATE
CURRENT_TIMESTAMP
in Default/Expression Column
INSERT INTO `test`.`new_registration`
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
`Address`,
`DOB`,
`Upload_DOB_Certificate`,
`GST_No`,
`Upload_GST_Certificate`)
VALUES
(
'Individual',
1,
'News Paper',
'Indian',
'Yash Kapoor','45YYH87Y','Documents/test1.jpg',
457851,'test@test.com',
110022,'Haryana',
'Sonepat','Sonepat','Jangpura, Delhi',
' 15/01/1945', 'Documents/test1.jpg' ,
'JHJDFHJDF8787DF',
'Documents/test1.jpg');
Right Click on Table(New_Reg_Table)
>Click on Send to SQl Editor
> Click on Create Statement
> To install MY SQL, below link to install
https://dev.mysql.com/downloads/workbench/
Click on Go to download page
or click on below link
> Click on https://dev.mysql.com/downloads/windows/installer/8.0.html
select IF(0 > 0, 'True', 'False') as message;
create DATABASE IF not EXISTS test2;
drop DATABASE IF not EXISTS test2;
Select * from table1 t1 inner join table t2 on t1.id = t2.id
Here t1 and t2 are called alias.
DELIMITER $$
CREATE PROCEDURE new_procedure_procedure_name()
BEGIN
SELECT *
FROM test.new_table t1
LEFT JOIN test1.table1 t2 ON t1.id = t2.id;
END $$
DELIMITER ;
===============================
CALL new_procedure_procedure_name();
> First open My SQL workbench
>Than click on Database menu and click on Connect to database
> Than in navigator , Select Schemes tabs
> Right click in navigator and click on Create schema
> and Type name and click on apply and click on apply and click on finish
> First download MySql Workbench
> Than click on Database menu and click on Connect to database.
> Than click on OK button
> Than click on Schemas tab.
> Than write query
For Creating database
Create Schema test or Create Database test;
private string conString = @"server=localhost;database=stamppaper;port=3306;username=root;password=;SslMode=none";
private void BindGrid()
{
using (MySqlConnection con = new MySqlConnection(conString))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM Stamp", con))
{
cmd.CommandType = CommandType.Text;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
grdStamp.DataSource = dt;
grdStamp.Columns[0].HeaderCell.Value = "Sr. No.";
